Using the Bing Ads Connection Manager
The Bing Ads Connection Manager is an SSIS connection manager that can be used to establish connections with Bing Ads.
To add a new connection, right-click the Connection Manager area in your Visual Studio project and choose "New Connection..." from the context menu. You will be prompted the "Add SSIS Connection Manager" window. Select the "Bings Ads (KingswaySoft)" item to add a new Bing Ads Connection Manager.
The Bing Ads Connection Manager contains the following two configuration pages which configure your connection to Bing Ads.
- General
- Advanced Settings
General Page
The General page allows you to specify connection properties and login credentials to Bing Ads.
- Instance Type
-
The Instance Type can be chosen from the drop-down. There are two options available:
- Sandbox
- Production
- Account Information
-
- Customer Id
-
The Customer ID for the Bing Ads instance can be specified here.
- Customer Account Id
-
The Customer Account ID for the instance you are trying to connect to can be specified here.
- Developer Token
-
The Developer Token for authentication to the Bing Ads instance. For more details regarding obtaining your developer token, please visit this Microsoft documentation page.
- Authentication
-
- Generate New Token File
-
This button allows you to log in to your instance and authorize your app to generate an OAuth token.
- App Type
-
- KingswaySoft
-
The Connection Manager will use the Client Id and Secret that is provided by KingswaySoft for your convenience when setting up the connection.
- My Own App
-
Selecting this option will allow you to use your own Client ID and Secret to connect to Bing Ads.
- App Info
-
- Client Id
-
The Client Id option allows you to specify the unique ID which identifies the application making the request.
- Client Secret
-
The Client Secret option allows you to specify the client secret belonging to your app.
- Redirect URI
-
The Redirect URI option allows you to specify the Redirect Url which was assigned to your app.
- Tenant ID
-
The Tenant Id option allows you to specify the unique ID which identifies the tenant you are connecting to.
- Sign In & Authorize
-
- Use Default Browser to Sign In
-
When this option is checked the Sign In & Authorize button will open your default web browser to complete the OAuth authentication. When this option is unchecked, the Sign In & Authorize button will complete the entire OAuth authentication process inside of the toolkit.
- Sign In & Authorize Button
-
This button allows you to log in to the service endpoint and authorize your app to generate a token.
- Test Connection
-
After all the connection information has been provided, click the "Test Connection" button to test if the user credentials entered can connect to the instance.
Advanced Settings Page
The Advanced Settings page on the Bing Ads Connection Manager allows you to specify proxy and miscellaneous settings for the connection.
- Proxy Server Settings
-
The Proxy Server Settings allows you to specify how you want to configure the proxy server.
- Proxy Mode
-
The Proxy Mode option allows you to specify how you want to configure the proxy server setting. There are three options available.
- No Proxy
- Auto-detect (Using system-configured proxy)
- Manual
- Proxy Server
-
Using the Proxy Server option, you can provide a proxy server to connect to Bing Ads.
- Port
-
The Port option allows you to specify the port number of the proxy server for the connection.
- Username
-
The Username option allows you to specify the proxy user account.
- Password
-
The Password option allows you to specify the proxy user’s password.
Note: Proxy Password is not included in the Bing Ads connection manager's ConnectionString property by default. This is done by design for security reasons. However, you can include it in your ConnectionString if you want to parameterize your connection manager. The format would be ProxyPassword=myProxyPassword; (make sure you have a semicolon as the last character). It can be anywhere in the ConnectionString.
- Misc
-
- Timeout (secs)
-
The Timeout (secs) option allows you to specify a timeout value in seconds for the connection. The default value is 120 seconds.
- Retry on Intermittent Errors
-
This is an option designed to help recover from possible intermittent outages or disruption of service. It prevents the integration process from stopping due to temporary issues. Enabling this option will allow service calls to be retried upon certain types of failure. A service call may be retried up to 3 times before an exception is fired. Retries occur after 0 seconds, 15 seconds, and 60 seconds.
Warning: We have designed our retry feature carefully such that the retry should only occur when it is deemed safe to do so; however, in some occasions, such retry service calls could result in the creation of duplicate data.