Lyftrondata Accelo Provider
The Lyftrondata API Profile for Accelo allows you to query data from Accelo. The Accelo profile is a single file (i.e. accelo.apip) which is meant to be used with the Lyftrondata API Driver. The profile contains the table definitions and other Accelo specific metadata that the Lyftrondata API Driver uses to connect to Accelo.
To use the Accelo Profile set the Profile property of Lyftrondata API Driver to the path of the Accelo profile, as well as the other connection properties specified in the documentation below. Once the Lyftrondata API Driver has been configured, you can issue SQL queries to access data from any of the Accelo Tables.
Connecting to Accelo
To authenticate to Accelo, you can use the OAuth standard to connect to your own data or to allow other users to connect to their data.
Using OAuth Authentication
First you need to register an OAuth app with Accelo. This is done from your deployment under Configuration > API > Register Application.
After setting the following in the ProfileSettings connection property, you are ready to connect:
- 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.
- InitiateOAuth: Set this to GETANDREFRESH. The Lyftrondata API Profile for Accelo will automatically walk through the OAuth process in order to obtained the access token.