ノーコードでクラウド上のデータとの連携を実現。
詳細はこちら →30日間の無償トライアル
無償トライアルはこちら製品の詳細
Azure Data Catalog ODBC Driver
Azure Data Catalog ODBC Driver を使って、ODBC 接続をサポートするあらゆるアプリケーション・ツールからAzure Data Catalog にデータ連携。
Azure Data Catalog データにデータベースと同感覚でアクセスして、Azure Data Catalog データに使い慣れたODBC インターフェースで連携。
こんにちは！ドライバー周りのヘルプドキュメントを担当している古川です。
The CData ODBC Driver for AzureDataCatalog can be used from any platform or development technology that supports ODBC, including Sybase PowerBuilder. This article shows how to connect to Azure Data Catalog データ and execute queries from the Database Painter and controls such as the DataWindow.
Follow the steps below to use the Database Painter tool to create a database profile based on an ODBC DSN (data source name) for AzureDataCatalog. In the Database Painter, you can use wizards and the UI to work with Azure Data Catalog データ.
You can optionally set the following to read the different catalog data returned from Azure Data Catalog.
You must use OAuth to authenticate with Azure Data Catalog. OAuth requires the authenticating user to interact with Azure Data Catalog using the browser. For more information, refer to the OAuth section in the help documentation.
See the help documentation for a guide to creating a Azure Data Catalog DSN.You can use standard PowerBuilder objects to connect to ODBC data sources and execute queries. The following example shows how to retrieve Azure Data Catalog データ into a DataWindow. You can add the following code to the open method:
SQLCA.DBMS = "ODBC"
SQLCA.DBParm = "ConnectString='DSN=CData Azure Data Catalog Source'"
CONNECT USING SQLCA;
dw_tables.SetTransObject(SQLCA);
dw_tables.Retrieve();