Creating a Data Source Name

Typically, after installing the Simba Apache Drill 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.

   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 Drill.

2. In the ODBC Data Source Administrator, click the Drivers tab, and then scroll down as needed to confirm that the Simba Apache Drill 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 Apache Drill ODBC Connector and then click Finish. The Simba Apache Drill 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.

8. Choose one:
• To connect to a ZooKeeper cluster, do the following:
  1. Select ZooKeeper Quorum.
  2. In the Quorum field, type a comma-separated list of the servers in your ZooKeeper cluster.
  3. In the Cluster ID field, type the unique name of the Drillbit cluster that you want to use.
• Or, to connect to a Drill server, do the following:
  1. Select Direct to Drillbit.
  2. In the field beside the Direct to Drillbit option, type the IP address or host name of the Drill server. The connector accepts both IPv4 and IPv6 addresses.
  3. In the field beside the colon (:), type the port on which the Drill server is listening.
9. If the server that you are connecting to requires authentication, then use the options in the Authentication area to configure authentication as needed. For more information, see Configuring Authentication.

   Note: If the Authentication Type drop-down list is set to No Authentication, the connector uses a default user name of "anonymous".

10. If operations against Drill are to be done on behalf of a user other than the one associated with the connection, then do one of the following:
    • If you configured Plain authentication, then in the Delegation UID field, type the name of the user to perform the operations.
    • Or, if you did not configure authentication, then do the following:
    1. From the Authentication Type drop-down list, select Plain.
    2. In the User field, type any value. The User option must be set, but the value is not used.
    3. In the Delegation UID field, type the name of the user to perform the operations.
11. In the Catalog list, select or type the name of the synthetic catalog that you want to use for the connection. For more information, see Catalog and Schema Support and Catalog.
12. In the Default Schema list, select or type the name of the default schema for the DSN to use.
13. Optionally, edit the string in the Advanced Properties field to set the time zone, timeouts, and schemas to exclude.
14. To disable support for asynchronous queries, select the Disable Async check box.
15. To configure logging behavior for the connector, click Logging Options.
16. To examine the data source and create SQL views based on the data source, click Drill Explorer.
17. To test the connection, click Test. Review the results as needed, and then click OK.

    Note: If the connection fails, then confirm that the settings in the Simba Drill ODBC Driver DSN Setup dialog box are correct. Contact your Drill server administrator as needed.

18. To save your settings and close the Simba Drill ODBC Driver DSN Setup dialog box, click OK.
19. To close the ODBC Data Source Administrator, click OK.