Connect to EDGAR Online Data from PowerBuilder

Ready to get started?

Download for a free trial:

Download Now

Learn more:

EDGAR Online ODBC Driver

The EDGAR Online ODBC Driver is a powerful tool that allows you to connect with live data from EDGAR Online, directly from any applications that support ODBC connectivity.

Access EDGAR Online data like you would a database - read, write, and update EDGAR Online Companies, Financials, Taxonomies, etc. through a standard ODBC Driver interface.



This article demonstrates how to use the CData ODBC Driver for EDGAR Online to connect to EDGAR Online data and execute queries in PowerBuilder.

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

Connect to EDGAR Online as an ODBC Data Source

If you have not already, first specify connection properties in an ODBC DSN (data source name). This is the last step of the driver installation. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.

  1. Navigate to https://developer.edgar-online.com/ and create an account.
  2. Register a new application and retrieve the AppKey. You should select one of the available Web APIs this application will use like HackPack, Insider Trades or Institutional Ownership.
    Note: HackPack is the most important Web API that an application can use since it supports a large number of endpoints. If you are getting the "Access Denied" error you must create a new app and select the correct Web API which supports the resource you are querying.
  3. After successfully creating a new app, you can access your keys through your "my account" area. Set the AppKey connection property value equal to the Key of your application.

Create a Profile for the ODBC Driver for EDGAR Online

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

  1. In PowerBuilder, click Tools -> Database Painter.
  2. In the Objects window in the Database Painter, right-click the ODBC node and click New Profile.
  3. On the Connection tab, enter a name for the profile and select the EDGAR Online DSN in the Data Source menu.
  4. To view and modify a table, right-click a table and then click Edit Data -> Grid.

Using EDGAR Online 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 EDGAR Online data into a DataWindow. You can add the following code to the open method:

SQLCA.DBMS = "ODBC" SQLCA.DBParm = "ConnectString='DSN=CData EdgarOnline Source'" CONNECT USING SQLCA; dw_subscriptions.SetTransObject(SQLCA); dw_subscriptions.Retrieve();