Creating a Data Source Name

Typically, after installing the Simba Google BigQuery 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 BigQuery.

  2. In the ODBC Data Source Administrator, click the Drivers tab, and then scroll down as needed to confirm that the Simba Google BigQuery ODBC Connector appears in the alphabetical list of ODBC drivers 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 Simba Google BigQuery ODBC Connector and then click Finish. The Simba Google BigQuery ODBC Connector 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. From the Encrypt Sensitive Data drop down list, select one:
    • To encrypt and decrypt the sensitive data by all the users on the system, select For All Users.
    • Or, to encrypt and decrypt the sensitive data only by the system user who encrypted them, select For Current User Only.
  2. Configure authentication using the options in the Authentication area. For more information, see Configuring Authentication.
  3. To allow the connector to access Google Drive so that it can support federated tables that combine BigQuery data with data from Google Drive, select the Request Google Drive Scope Access check box.
  4. Choose one:
    • To verify the server using the trusted CA certificates from a specific .pem file, specify the full path to the file in the Trusted Certificates field and leave the Use System Trust Store check box cleared.
    • Or, to use the trusted CA certificates .pem file that is installed with the connector, leave the default value in the Trusted Certificates field, and leave the Use System Trust Store check box cleared.
    • Or, to use the Windows Trust Store, select the Use System Trust Store check box and leave the Trusted Certificates field cleared.
  5. From the Minimum TLS drop-down list, select the minimum version of TLS to use when connecting to your data store.
  6. In the Catalog (Project) drop-down list, select the name of your BigQuery project. This project is the default project that the Simba Google BigQuery ODBC Connector queries against, and also the project that is billed for queries that are run using the DSN.

    7. Note:

    If you are not signed in to your Google account, then you are prompted to sign in.

  7. Optionally, in the Dataset drop-down list, select the name of the dataset the connector will query by default. For more information, see DefaultDataset.
  8. To configure a connection through a proxy server, click Proxy Options. For more information, see Configuring a Proxy Connection.
  9. To configure logging behavior for the connector, click Logging Options. For more information, see Configuring Logging Options.
  10. To configure advanced connector options, click Advanced Options. For more information, see Configuring Advanced Options.
  11. To test the connection, click Test. Review the results as needed, and then click OK.
  12. To save your settings and close the Simba Google BigQuery ODBC Connector DSN Setup dialog box, click OK.
  13. To close the ODBC Data Source Administrator, click OK.

Related topics