ノーコードでクラウド上のデータとの連携を実現。
詳細はこちら →30日間の無償トライアル
無償トライアルはこちら製品の詳細
Azure DevOps ODBC Driver
Azure DevOps ODBC Driver を使って、ODBC 接続をサポートするあらゆるアプリケーション・ツールからAzure DevOps にデータ連携。
Azure DevOps データにデータベースと同感覚でアクセスして、Azure DevOps のAccounts、Approvals、Builds、Tests など多様なデータに使い慣れたODBC インターフェースで連携。
こんにちは！ドライバー周りのヘルプドキュメントを担当している古川です。
The CData ODBC Driver for AzureDevOps can be used from any platform or development technology that supports ODBC, including Sybase PowerBuilder. This article shows how to connect to Azure DevOps データ 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 AzureDevOps. In the Database Painter, you can use wizards and the UI to work with Azure DevOps データ.
To generate one, log in to your Azure DevOps Organization account and navigate to Profile -> Personal Access Tokens -> New Token. The generated token will be displayed.
If you wish to authenticate to Azure DevOps using OAuth refer to the online Help documentation for an authentication guide.
See the help documentation for a guide to creating a Azure DevOps DSN.You can use standard PowerBuilder objects to connect to ODBC data sources and execute queries. The following example shows how to retrieve Azure DevOps データ into a DataWindow. You can add the following code to the open method:
SQLCA.DBMS = "ODBC"
SQLCA.DBParm = "ConnectString='DSN=CData Azure DevOps Source'"
CONNECT USING SQLCA;
dw_builds.SetTransObject(SQLCA);
dw_builds.Retrieve();