Connect to Act-On Data from PowerBuilder

Ready to get started?

Download for a free trial:

Download Now

Learn more:

Act-On ODBC Driver

Act-On ODBC Driver を使って、ODBC 接続をサポートする多様なツールからAct-On にデータ連携。

Act-On にDB と同感覚でODBC インターフェースでアクセスが可能に。

This article demonstrates how to use the CData ODBC Driver for Act-On to connect to Act-On data and execute queries in PowerBuilder.

The CData ODBC Driver for Act-On can be used from any platform or development technology that supports ODBC, including Sybase PowerBuilder. This article shows how to connect to Act-On data and execute queries from the Database Painter and controls such as the DataWindow.


Create a Profile for the ODBC Driver for Act-On

Follow the steps below to use the Database Painter tool to create a database profile based on an ODBC DSN (data source name) for Act-On. In the Database Painter, you can use wizards and the UI to work with Act-On data.

  1. If you have not already done so, create an ODBC DSN for Act-On. The DSN contains the connection properties required to connect to Act-On data. You can use the Microsoft ODBC Data Source Administrator to create and configure DSNs. This is the last step of installing the driver. Required connection properties are the following:

    ActOn はOAuth 認証標準を利用しています。OAuth を使って認証するには、アプリケーションを作成してOAuthClientIdOAuthClientSecret、およびCallbackURL 接続プロパティを取得する必要があります。


    See the help documentation for a guide to creating a Act-On DSN.
  2. In PowerBuilder, click Tools -> Database Painter.
  3. In the Objects window in the Database Painter, right-click the ODBC node and click New Profile.
  4. On the Connection tab, enter a name for the profile and select the Act-On DSN in the Data Source menu.
  5. To view and modify a table, right-click a table and then click Edit Data -> Grid.

Using Act-On Data with PowerBuilder Controls

You can use standard PowerBuilder objects to connect to ODBC data sources and execute queries. The following example shows how to retrieve Act-On data into a DataWindow. You can add the following code to the open method:

SQLCA.DBMS = "ODBC" SQLCA.DBParm = "ConnectString='DSN=CData Act-On Source'" CONNECT USING SQLCA; dw_images.SetTransObject(SQLCA); dw_images.Retrieve();