Connection String Parameters

Sisense uses connection strings to connect to some data sources and import data into the ElastiCube Manager.

Connection strings have the following structure:

jdbc:DataSourceName:Property1=Value1;Property2=Value2;

The following is an example of a Exact connection string:

jdbc:exactonline:OAuthClientId=xxxxxxxxxxxxx;OAuthClientSecret=xxxxxxxxxxxxx;Region=’United States’;Division=xxxx;InitiateOAuth=GETANDREFRESH;OAuthCallbackURL=localhost:12345;

This page lists the mandatory and optional parameters required by the data source you want to connect to. Mandatory parameters must be defined and included in your connection string whereas optional parameters are only recommended by Sisense.

In addition, some parameters are required by specific data sources. You can view these parameters by clicking the relevant link below:

Exact

Facebook

HubSpot

Quickbooks Online

ServiceNow

Xero

YouTube Analytics

Mandatory Properties

Optional Parameters

Switching between Accounts

When you connect to the Facebook data source, Sisense saves your OAuth values in the file OAuthsettings.txt file located at …\Users\xxx\AppData\Roaming\CData\Facebook Data Provider on your Sisense server. To connect to the Facebook data source with another user on the same machine, you must delete the OAuthsettings.txt file. Sisense will then generate a new file for that user.

Another option to support multiple users is to define the location and file name of an OAuthsettings file for each unique user in your connection string through the OAuthSettingsLocation parameter. When each user connects to the data source, Sisense generates the OAuth file with the file name you specify in the location you define. In the examples below, two users are allowed to access the Facebook data source and for each user, Sisense generates a file that contains that user’s OAuth values in the location defined in the string.

jdbc:facebook:OAuthSettingsLocation=C:\facebook\auth\john.txt;OAuthClientId=11276856774486;OAuthClientSecret

=064c70d78567jm2b7e7e4224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;

jdbc:facebook:OAuthSettingsLocation=C:\facebook\auth\sally.txt;OAuthClientId=11276856774486;OAuthClientSecret

=064c70d78567jm2b7e7e4224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;

In the example above, to OAuth files are created, one for John and one for Sally in the location C:\facebook\auth\.

This is useful if you support many users who each need to access the Facebook data source.

Data Source Parameters

This section lists parameters that are required to be inside connection strings

Exact

The following is an example of an Exact connection string:

jdbc:exactonline:OAuthClientId=xxxxxxxxxxxxx;OAuthClientSecret=xxxxxxxxxxxxx;Region=’United States’;Division=xxxx;InitiateOAuth=GETANDREFRESH;OAuthCallbackURL=localhost:12345;

Facebook

Rate Limitations

The following is an example of a Facebook connection string:

jdbc:facebook:OAuthClientId=xxxxxxxxxxxxxxx;OAuthClientSecret=xxxxxxxxxxxxxxxxxxxx;

InitiateOAuth=GETANDREFRESH;Version=2.8;CallbackURL=http://localhost/;Timeout=0;

Optional Parameters

HubSpot

The following is an example of a HubSpot connection string:

jdbc:hubspot:OAuthClientId=xxxxxxxxxxxxxx;OAuthClientSecret=xxxxxxxxxxxxxxxxxx;InitiateOAuth=GETANDREFRESH;

HubId=xxxxxxxxx;CallbackURL=https://localhost;Timeout=0;

Quickbooks Online

The following is an example of a Quickbooks Online connection string:

jdbc:quickbooksonline:OAuthClientId=xxxxxxxxxxxx;OAuthClientSecret=xxxxxxxxxxxx;CompanyId=xxxxxxxxxxxxxx;

CallbackURL=http://localhost/;InitiateOAuth=GETANDREFRESH;Timeout=0;

ServiceNow

The following is an example of a ServiceNow connection string:

jdbc:servicenow:InitiateOAuth=GETANDREFRESH;Instance=xxxxxxxxxx;OAuthClientId=xxxxxxxxxxxx;

OAuthClientSecret=xxxxxxxxx;Username=xxxxxxxxxx;Password=xxxxxxxxxxxxxxx;

Xero

The following is an example of a Xero connection string:

jdbc:xero:OAuthclientId=xxxxxxxxxxxxx;OAuthClientSecret=xxxxxxxxxxxxx;

InitiateOAuth=GETANDREFRESH;XeroAppAuthentication=PUBLIC;

YouTube Analytics

The following is an example of a YouTube Analytics connection string:

jdbc:youtubeanalytics:OAuthClientId=xxxxxxxxxxxxxxxxxxxxx;

OAuthClientSecret=xxxxxxxxxxxxxx;InitiateOAuth=GETANDREFRESH;CallbackURL=http://localhost;