Google Analytics and Google BigQuery connection settings
You need a valid Google account and must provide access to the database via the Google Developers Console. Proceed as follows:
▪ Open with https://console.developers.google.com/project the Google Developers Console
▪ Create a new project if there is none yet. By doing that a Project ID will be created. This value is needed for the connection settings.
▪ Go to Project name > Permissions and select "Add Member". Provide your email address and define the authorization (Is owner, Can edit, Can view). The new member now receives an invitation.
▪ Subsequently, this account must be authenticated using OAuth 2.0. Select "APIs & auth > Credentials" and create a new Client ID in the "OAuth" section by using the corresponding button. As application type select "Installed application" (Installed application type: Other). The Client ID and Client secret will be displayed afterwards. Both values are needed for the connection settings.
▪ Select "APIs & auth > Consent screen" and enter at least one email address and the product name. The consent screen will be shown to users whenever you request access to their private data using your client id.
Enter the corresponding values in the combit Report Server data source:
▪ ProjectID, Client ID and Client Secret
▪ Refresh Token: To set the Refresh Token, click on "Request Refresh Token". A dialog will be displayed where you can request a code. When clicking "Request code" the Google website will be opened in a new tab. Please login with your Google account and accept the access. Copy the generated code into the clipboard and return to the dialog. Paste the copied code into the input field. The code will be converted into a Refresh Token.
▪ Single Queries: Define at least one SQL query to limit the data, e.g. SELECT <col1>, <col2> FROM [<ProjectID>:<dataset>.<table>]
Google Sheets connection settings
You need a valid Google account and must provide access to the data via Google Sheets or the Google Developers Console. Proceed as follows:
▪ Table ID: For the table ID refer to the release link (see below).
▪ Sheet names: E.g. "Sheet1". Multiple spreadsheets that should be provided as tables can be specified comma-separated.
▪ Data source is published on the web: Publish a file in Google Sheets via "File > Publish to the web". The generated link contains the table ID, e.g.
https://docs.google.com/spreadsheets/d/<Table ID>/pubhtml.
If the data source is not published on the web, the data must be enabled to read via the Google Developers Console. For Client ID, Client Secret and Refresh Token see Google Analytics and Google BigQuery connection settings.
Connection settings Progress OpenEdge Server
▪ Server URL: URL Apache Tomcat REST Backend
▪ User name and password: User and password Apache Tomcat Rest Backend (optional)
▪ Service Name: ABL class name of the OpenEdge Service
▪ Prerequisite Progress OpenEdge Server
▪ Apache Tomcat
▪ Progress OpenEdge State-free AppServer
▪ ABL Backend on the AppServer in the Propath.
Connection settings Salesforce
You need a valid Salesforce Developer license. Access is via the Force.com Soap API.
▪ Server URL: https://login.salesforce.com/services/oauth2/token
▪ Username and Password