Configure a Connection Profile

From the CData ribbon, click Get Data and select From ADP connection/s to launch the CData Query window. To setup a new connection, you will have to click the New ADP Connection button. Here you can set the connection settings, test the connection, and save the connection profile.

Connecting to ADP

To connect to ADP, set the following properties:

• OAuthClientId: The client Id of the custom OAuth application you obtained from ADP.
• OAuthClientSecret: The custom OAuth application's client secret.
• SSLClientCert: The client certificate you created earlier (see Before You Connect).
• SSLClientCertPassword: The client certificate's password.
• UseUAT: The add-in makes requests to the production environment by default. If using a developer account, set UseUAT = true.
• RowScanDepth: The maximum number of rows to scan for the custom fields columns available in the table (default=100). Setting a high value may decrease performance.

Connection Properties

The Connection properties describe the various options that can be used to establish a connection.

Managing Connections

After successfully authenticating to ADP you will be able to customize the data you are importing. To learn more about this, see Managing Connections.

See Also

• Querying Data: Use the data selection wizard to pull data into a spreadsheet. You can also configure scheduled data refresh here.
• Using the Excel Add-In: Find other ways to interact with ADP data, such as using the available CData Excel Functions.