Creating a Data Source Name

Typically, after installing the Simba Google Ads ODBC Connector, you need to create a Data Source Name (DSN).

Alternatively, for information about DSN-less connections, see Using a Connection String.

To create a Data Source Name:

  1. From the Start menu, go to ODBC Data Sources.

    2. Note:

    Make sure to select the ODBC Data Source Administrator that has the same bitness as the client application that you are using to connect to Ads.

  2. In the ODBC Data Source Administrator, click the Drivers tab, and then scroll down as needed to confirm that the appears in the alphabetical list of ODBC connectors that are installed on your system.
  3. Choose one:
    • To create a DSN that only the user currently logged into Windows can use, click the User DSN tab.
    • Or, to create a DSN that all users who log into Windows can use, click the System DSN tab.

    Note:

    It is recommended that you create a System DSN instead of a User DSN. Some applications load the data using a different user account, and might not be able to detect User DSNs that are created under another user account.

  4. Click Add.
  5. In the Create New Data Source dialog box, select and then click Finish. The DSN Setup dialog box opens.
  6. In the Data Source Name field, type a name for your DSN.
  7. Optionally, in the Description field, type relevant details about the DSN.
  1. Configure authentication using the options in the Authentication area. For more information, see Configuring Authentication.
  2. In the Developer Token field, type the developer token associated the manager account that you use to grant access to the Ads API.

    3. Note:

    You can find your developer token by logging in to your Ads manager account and navigating to the Ads API Center. If you do not have a developer token or a manager account, set them up by going through the steps detailed in "Sign Up" in the Ads API documentation: https://developers.google.com/adwords/api/docs/guides/signup.

  3. To configure logging behavior for the connector, click Logging Options. For more information, see Configuring Logging Options.
  4. To test the connection, click Test. Review the results as needed, and then click OK.
  5. To save your settings and close the Simba Google Ads ODBC Connector DSN Setup dialog box, click OK.
  6. To close the ODBC Data Source Administrator, click OK.

Related topics