Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]Azure SQL
 Login/Join
 
Martin vK
Platinum Member
posted
Our company wants to move much of the IT to Azure. Part of this is also moving from DB2 to Azure SQL.

Does someone already have experience with using Azure SQL from WebFOCUS?
There is not yet a native adapter for this, so what adapter would be best to use?

Up to now I have tried to use JDBC Generic. I can make a connection, and it can connect to tables and make synonyms.

I do have difficulties with using DataMigrator however. It is giving me errors writing to the tables. Next to this JDBC adapter does not seem to give me possibility of bulkload, which is essential to get some performance in most of my flows.

I appreciate any experience with Azure SQL you can share.

Martin.

This message has been edited. Last edited by: Martin vK,


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 168 | Registered: March 29, 2013Report This Post
BabakNYC
Virtuoso
posted Hide Post
What version of WebFOCUS are you running?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Frans
Guru
posted Hide Post
Do you mean Azure SQL datawarehouse? You can use the SQL server JDBC for that.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 454 | Location: Europe | Registered: February 05, 2007Report This Post
FP Mod Chuck
Virtuoso
posted Hide Post
Hi Martin

I found that there is an internal project to create a native adapter for Azure but it is not ready yet. It says you can use SQL Server ODBC to connect for read/write capability right now. This is not supported for Azure DW though..


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Martin vK
Platinum Member
posted Hide Post
Babak, Frans, Chuck, thanks for your replies.

Babak, I am using WF the latest WF 8201 version to test the Azure SQL connection.

Chuck, good to hear they already started programming on a native adapter for Azure SQL, I can not wait.... Do they have an expected date when it will be ready? I am also available for beta testing on this if needed.

I will soon try to use the SQL Server ODBC/JDBC adapter for connecting and let you know.

Has anyone already tried using Azure SQL as target in DM flows?

Martin.


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 168 | Registered: March 29, 2013Report This Post
FP Mod Chuck
Virtuoso
posted Hide Post
Hi Martin

I just found out the the Azure specific adapter is for Azure Data Warehouse and not Azure DB. So the SQL Server ODBC is a read write adapter and you should be able to use it as a target with DataMigrator.

This message has been edited. Last edited by: FP Mod Chuck,


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Martin vK
Platinum Member
posted Hide Post
Hi Chuck,

Thanks for the feedback. That is too bad. As I understand Azure Data Warehouse is more for OLAP processing, for which we already mainly use Hyperstage. Azure SQL DB is more for OLTP processing (and much cheaper!) and would be our aim for replacing DB2 in Azure.

When I read information on internet, it seems that Azure Data Warehouse is using Azure SQL DB in the background, so for SQL syntax there might not be much difference, but I do not know all technical details. So maybe this new Azure DW adapter might also be useable for Azure SQL DB or maybe not much work for specific Azure SQL DB adapter. I would appreciate if you can ask the specific product manager.

Concerning using ODBC/JDBC adapter in DataMigrator. It is indeed possible to use it as a target. But ODBC/JDBC adapter do not provide Bulkload possibility. For this I think I am dependent on a Native adapter.

So it seems currently Azure SQL DB is not suitable replacement for DB2 as long as I do not have a native adapter to work with.

Martin.


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 168 | Registered: March 29, 2013Report This Post
Martin vK
Platinum Member
posted Hide Post
Hi,

A surprise to me. the SQL Server ODBC adapter also provides a bulkload. I had not expected, but is does and it works also for loading in Azure SQL DB.

Martin


WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 168 | Registered: March 29, 2013Report This Post
priyanka vyas
Member
posted Hide Post
Hi All,
hope you all are doing well.
i just wanted to know one thing can we configure azure adapter in webfocus 8105M. is it possible or not and if yes , what are solution steps.


WebFOCUS 8
Windows, All Outputs
 
Posts: 11 | Registered: February 12, 2016Report This Post
FP Mod Chuck
Virtuoso
posted Hide Post
Priyanka

See BabakNYC's answer in your other post. Please don't keep asking the same question in multiple posts.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders