The Connections page enables you to create and manage connections to your data sources.
Adding a Connection
To add a new connection, complete the following steps:
On the Connections page, click Add Connection. This action displays the Add Connection modal.
Select a data source from the list in the modal.
After you select a data source, the connection configuration page appears.
Configure the connection according to the instructions for the data source. You can access these instructions without leaving the connection page by clicking View Documentation in the upper right.
Click Save and Test.
If the connection succeeds, you are redirected to the Connections page and the new connection appears in the list. You can modify or delete a connection at any time by clicking the edit or delete icons in the list.
When you create or edit a connection, the Permissions tab displays a list of available users and allows you to assign permissions to each one. Permissions are described in the list below:
- Select: Enables you to select rows from tables in a connection.
- Insert: Enables you to insert rows into tables of a connection.
- Update: Enables you to update rows in tables of a connection.
- Delete: Enables you to delete rows from tables in a connection.
Execute: Enables users to execute stored procedures in a connection.
You can toggle the permissions in four ways:
- Click an individual box in the table to toggle that permission for a single user.
- Click the double check mark at the top of a table column to toggle that permission for every user.
- Click the double check mark at the right side of the table to toggle all permissions for a single user.
- Click the double check mark that is labeled All in the top-right corner of the table to toggle all permissions for all users.
Configuring Custom Reports
Some data sources support custom reports, which allow you to configure pre-defined reports that you can query as views within your connections. Each report has a unique set of required inputs, and you provide these inputs when you configure the report in your CData Connect Cloud account.
Custom reports are generally useful in two types of scenarios:
For ad or analytics data sources, they can be used to show aggregated reports on performance data by allowing you to pre-define a set of metrics and dimensions.
Other types of data sources let you pre-define parameters to create data reports. For example, an accounting API might allow you to create a general ledger report in QuickBooks.
Creating a Custom Report
If a data source supports custom reports, a Custom Reports tab appears on the connection settings page. Clicking this tab opens the custom reports interface, as shown below:
To add a custom report, follow these steps:
Click Add above the report table. A modal appears with a list of the custom reports available for your chosen data source.
Select the report you want to use and click Confirm. A list of required and optional fields appear for the custom report.
Enter the requested information, and then click Save to save the custom report to your account.
After you save a custom report, it appears in the list of tables for your connection. You can delete custom reports and add new ones as needed.
Note: Custom reports are not shared across multiple connections to the same data source. For example, if you have two separate connections to Adobe Analytics, both connections will have their own lists of custom reports.
Using a Custom Report
You can query saved custom reports by passing the name of the custom report in the table field for your query. For example, if you have a custom report called Customer Accounts List on your QuickBooks Online connection, you could select all of its results with this query:
SELECT * FROM [QuickBooksOnline1].[QuickBooksOnline].[Customer Accounts List]