API Data Provider - Online Help

Connecting to InfoMart

The InfoMart API authentication use User,Password and OAuthClientId OAuthClientSecret for InfoMart.

Using InfoMart Authentication


In order to connect to InfoMart, You should create OAuth application and get OAuthClientId, OAuthClientSecret. To create OAuth application, You need to contact InfoMart support team.

Example Connection string

Profile=C:\profiles\InfoMart.apip;[email protected];Password=TEST_PASSWORD;OAuthClientId=YOUR_CLIENT_ID;OAuthClientSecret=YOUR_CLIENT_SECRET;

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 Basic or None.
Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT
CallbackURL Identifies the URL users return to after authenticating to API via OAuth (Custom OAuth applications only).
Environment Your Environment name of InfoMart API.
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, REFRESH, GETANDREFRESH
OAuthAccessToken Specifies the OAuth access token used to authenticate requests to the data source. This token is issued by the authorization server after a successful OAuth exchange.
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. (Custom OAuth applications only.).
OAuthExpiresIn Specifies the duration in seconds, of an OAuth Access Token's lifetime. The token can be reissued to keep access alive as long as the user keeps working.
OAuthRefreshToken Specifies the OAuth refresh token used to request a new access token after the original has expired.
OAuthSettingsLocation Specifies the location of the settings file where OAuth values are saved.
OAuthTokenTimestamp Displays a Unix epoch timestamp in milliseconds that shows how long ago the current access token was created.
OAuthVerifier Specifies a verifier code returned from the OAuthAuthorizationURL . Used when authenticating to OAuth on a headless server, where a browser can't be launched. Requires both OAuthSettingsLocation and OAuthVerifier to be set.
Password Your InfoMart API Password.
User Your InfoMart API Username.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655.0