ODBC Driver for TigerGraph

Build 23.0.8839

Windows DSN Configuration

Using the Microsoft ODBC Data Source Administrator

You can use the Microsoft ODBC Data Source Administrator to edit the DSN configuration. Note that the DSN is created during the installation process.

Complete the following steps to edit the DSN configuration:

  1. Select Start > Search, and enter ODBC Data Sources in the Search box.
  2. Choose the version of the ODBC Administrator that corresponds to the bitness of your application (32-bit or 64-bit).
  3. Click the System DSN tab.
  4. Select the system data source and click Configure.
  5. Edit the information on the Connection tab and click OK.

Note: For .NET Framework 4.0, the driver distributes Microsoft Visual C++ 2015-2022 Redistributable. For .NET Framework 3.5, the driver distributes Microsoft Visual C++ 2008 Redistributable.

Ensuring Registry Access

The driver stores connection information in the Windows registry. To ensure that the driver can write to the registry, perform either of the following actions:

  1. Run the calling application as an administrator.
  2. Connect via a User DSN instead of a System DSN.

Connecting to TigerGraph

This section documents how to authenticate and connect to your TigerGraph instance.

Authenticate to TigerGraph Server

To authenticate requests to TigerGraph Server, set the following properties:

  • AuthScheme: Set this property to 'Basic'.
  • User: Set this property to your TigerGraph user name.
  • Password: Set this property to your TigerGraph user password.
  • Url: Set this property to the domain name or IP of your TigerGraph instance.
  • Port: Set this property to the port of your TigerGraph server instance (14240 by default).
  • TigerGraphEdition: Set this property to 'TigerGraph Server'.
See this page for notes on configuring a TigerGraph Server account: Managing Credentials

Authenticate to TigerGraph Cloud

To authenticate requests to TigerGraph Cloud, set the following properties:

  • User: Set this property to your TigerGraph database user name.
  • Password: Set this property to your TigerGraph database user password.
  • Url: Set this property to the domain name or IP of your TigerGraph instance.
To configure a TigerGraph Cloud user:
  1. From the Cloud portal, go to Clusters.
  2. Find the cluster you want to create users for, and select Access Management
  3. From the Cluster Access Management page, click Database Access.
  4. Click Add new users and specify the username and password. Note: The password will not be visible again after leaving this page.
  5. Click Role Management, select 'superuser' from the 'Select a role' list, then select the created user and click Save.
See this page for additional notes on configuring a TigerGraph Cloud database user: Managing Database Users

Secret-Based Authentication

To authenticate using a Secret, set the following properties:

  • AuthScheme: Set this property to 'Secret'.
  • Secret: Set this property to your generated secret.
  • Url: Set this property to the domain name or IP of your TigerGraph instance.
  • Schema: Set this property to the graph name your secret has been generated for.
Secrets can be generated for a given graph in the TigerGraph Admin Portal.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839