Connecting to Accelo

To authenticate to Accelo, and connect to your own data or to allow other users to connect to their data, you can use the OAuth standard.

Using OAuth Authentication

First you need to register an OAuth app with Accelo. This is done from your deployment under Configuration > API > Register Application. Additionally, you will need to set the Deployment, found in the URL of your Accelo account. For example if your Accelo portal is acmeinc.accelo.com, then the Deployment should be 'acmeinc'.

After setting the following connection properties, you are ready to connect:

AuthScheme: Set this to OAuth.

InitiateOAuth: Set this to GETANDREFRESH. The CData API Profile for Accelo will automatically walk through the OAuth process in order to obtained the access token.

OAuthClientID: Set this to the client_id that is specified in you app settings.

OAuthClientSecret: Set this to the client_secret that is specified in you app settings.

CallbackURL: Set this to the Redirect URI you specified in your app settings.

Deployment: Set this to your Deployment in ProfileSettings property.

Example connection string

Profile=C:\profiles\Accelo.apip;ProfileSettings='Deployment=acmeinc';Authscheme=OAuth;InitiateOAuth=GETANDREFRESH;OAuthClientId=your_client_id;OAuthClientSecret=your_client_secret;CallbackUrl=your_callback_url;

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

Property Description

AuthScheme The scheme used for authentication. Accepted entries are None or OAuth.
Allowed values are: BASIC, NONE, NTLM, OAUTH, OAUTH_CLIENT, APIKEY

CallbackURL The URL users return to after authenticating to API via OAuth.

Deployment Your Accelo deployment/hostname.

InitiateOAuth Specifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working.
Allowed values are: OFF, GETANDREFRESH, REFRESH

OAuthClientId Specifies the client ID (also known as the consumer key) assigned to your custom OAuth application. This ID is required to identify the application to the OAuth authorization server during authentication.

OAuthClientSecret Specifies the client secret assigned to your custom OAuth application. This confidential value is used to authenticate the application to the OAuth authorization server.

Property	Description
AuthScheme	The scheme used for authentication. Accepted entries are None or OAuth. Allowed values are: BASIC, NONE, NTLM, OAUTH, OAUTH_CLIENT, APIKEY
CallbackURL	The URL users return to after authenticating to API via OAuth.
Deployment	Your Accelo deployment/hostname.
InitiateOAuth	Specifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working. Allowed values are: OFF, GETANDREFRESH, REFRESH
OAuthClientId	Specifies the client ID (also known as the consumer key) assigned to your custom OAuth application. This ID is required to identify the application to the OAuth authorization server during authentication.
OAuthClientSecret	Specifies the client secret assigned to your custom OAuth application. This confidential value is used to authenticate the application to the OAuth authorization server.