New in Devart ODBC Drivers: Support for OAuth 2.0 Authentication and SOQL Queries
Devart has released new versions of data connectors for ODBC data sources for Dynamics 365, Salesforce, Zoho CRM. Introduced OAuth 2.0 authentication for Dynamics 365 and Salesforce, and SOQL queries for Salesforce.
OAuth is an open standard for authorization that web applications like Dynamics 365 or Salesforce can use to provide client applications, such as our ODBC drivers, with secure access to certain resources over HTTPS. You need to login to the web application only once to authorize the driver to access your data and generate a refresh token. After that, the driver will use the token to authenticate itself to Dynamics 365 or Salesforce with each subsequent API call, and will not have to submit your username and password to the web application over the network. This approach is way more secure than the basic authentication scheme with username/password.
Also, Salesforce Object Query Language (SOQL) syntax is now available in ODBC driver for Salesforce to query Salesforce data. SOQL is an optimized version of SQL specifically designed for accessing the underlying Salesforce database. It does not support some of the SQL advanced features like wildcards and joins, but allows using filters along with the SELECT clause to return an optional set of data.
ODBC Driver for Zoho CRM updated with a new property called NonApprovedRecords that enables users to retrieve records that are pending for approval.
To learn more about the recent release, visit
Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.
For additional information about Devart, visit https://www.devart.com/