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 ensure optimal performance when using Devart ODBC drivers, it's recommended to fine-tune several key parameters: Connection Timeout — Set an appropriate timeout to avoid long waits on unresponsive connections. Data Fetching Size — Adjust the ...
Setting Up MongoDB Atlas and Connecting via Devart ODBC Driver
This article will guide you through the process of setting up MongoDB Atlas, creating a cluster, configuring access, obtaining the connection string, and connecting to MongoDB Atlas using the Devart ODBC Driver for MongoDB. 1. Creating a Cluster in ...
What SQL Syntax Can Be Used with Devart ODBC Drivers?
Devart ODBC Drivers internally rely on the SQLite engine to execute SQL queries. This means that all SQL statements executed through the driver must conform to the SQLite SQL dialect. The SQLite engine supports a wide range of SQL features including: ...
Using ODBC Drivers with Power BI Online
Power BI Online supports working with ODBC drivers, but to ensure proper functionality—especially for scheduled data refresh—you need to configure the setup correctly. Make sure the Power BI Data Gateway is installed on the same computer where the ...
Setting up a Connection to Power BI Online Using Devart ODBC Driver
In this guide, we will walk you through the process of setting up a connection to Power BI Online using the Devart ODBC Driver. This involves creating a DSN connection, setting up an on-premises gateway, and verifying Power BI report settings. Step ...