How to Set Up Devart ODBC Drivers for OAuth Authorization in Cloud Services

How to Set Up Devart ODBC Drivers for OAuth Authorization in Cloud Services

To connect to cloud databases like HubSpot, Zoho, or Salesforce using OAuth authorization, follow these general steps:

1. Register an Application
Start by registering your application in the cloud service you're connecting to (e.g., HubSpot, Zoho, or Salesforce).

2. Get OAuth Credentials
After registering the application, you’ll receive OAuth credentials, which you’ll need for the next step.

3. Configure the Devart ODBC Driver
Use the OAuth credentials you obtained in the previous step to configure the Devart ODBC driver settings.

For more detailed instructions, you can refer to the Devart documentation.

    • Related Articles

    • How to configure Devart ODBC drivers for optimal performance?

      To optimize Devart ODBC drivers, consider configuring parameters that influence the connection timeout, data fetching size, and logging level. Adjust settings based on the database you are using, especially for cloud connections like Salesforce or ...

    • what sql- syntax can be used when using ODBC Drivers?

      Please be informed, that Devart ODBC Drivers uses the SQLite engine to execute SQL queries, so in order to build queries with it you can use the syntax used in SQLite: http://www.sqlite.org/lang.html

    • [Devart][ODBC][Quickbooks Desktop] Could not start Quickbooks

      I am attempting to evaluate the Quickbooks Desktop ODBC Driver. When I set up the ODBC data source, link it to the company file and then click "Test Connection" I get the following error message: "[Devart][ODBC][Quickbooks Desktop] Could not start ...

    • Error: [Devart][ODBC][Netsuite] "Invalid login attempt"

      Make sure that your related integration has the TOKEN-BASED AUTHENTICATION enabled. You should check your audit trail detail in your NetSuite account, go to Setup > Users/Roles > View Login Audit Trail, check USE ADVANCED SEARCH, and be sure to add ...

    • Tableau cannot get quest tables and colums with ODBC Drivers

      Tableau cannot get quest tables and colums with ODBC Drivers In Tablеau, after selecting an ODBC source, to obtain a list of tables available to the driver and work with them, use the following button: Next, load the list of tables by clicking on the ...