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.

New SSIS Connection

Add SSIS Google Ads Connection

The Bing Ads Connection Manager contains the following two configuration pages which configures your connection to Bing Ads.

  • General
  • Advanced Settings

General

The General page allows you to specify connection properties and login credentials to Bing Ads.

SSIS Bing Ads Connection

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 login to your instance and authorize your app to generate an OAuth token.

SSIS Bing Ads Connectin Manager - Token Generator
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 HubSpot.

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 login 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

The Advanced Settings page on the Bing Ads Connection Manager allows you to specify proxy and miscellaneous settings for the connection.

SSIS Bings Ads Connection - Advanced Settings

Proxy Server Settings

The Proxy Server Settings allows you to specify how you want to configure the proxy server.

Proxy Mode

Proxy Mode option allows 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 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 allow 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.