Easysoft ODBC-Salesforce Driver User's Guide - Introduction

Introducing the Easysoft ODBC-Salesforce Driver

The Easysoft ODBC-Salesforce Driver is an ODBC driver for Salesforce. It lets ODBC-enabled applications access Salesforce databases from Linux, Unix and Windows platforms.

Chapter Guide

Overview

The Easysoft ODBC-Salesforce Driver connects ODBC-enabled applications on Linux, Unix and Windows to Salesforce.com, Force.com and Database.com. Example applications include:

The Easysoft ODBC-Salesforce Driver distribution includes two ODBC drivers: one which supports SQL and one which supports Salesforce's native query language SOQL.

The driver that supports SOQL contains "SOQL" in its name. For example on Windows, the driver is called the Easysoft Salesforce SOQL ODBC Driver.

If you want to use SQL to work with Salesforce data configure an ODBC data source that uses the standard Salesforce ODBC driver.

If you want to use SOQL to work with Salesforce data configure an ODBC data source that uses the Easysoft Salesforce SOQL ODBC Driver.

If you wnat to use both SQL and SOQL, configure two ODBC data sources, one for each driver.

For example, if your application is SQL Server and you want to use T-SQL, configure a linked server that uses the Easysoft ODBC-Salesforce Driver. This driver supports statements such as:

SELECT * FROM MYSALESFORCELINKEDSERVER.SF.DBO.Account

If your application is SQL Server and you want to use the SOQL, configure a linked server that uses the Easysoft Salesforce SOQL ODBC Driver. This driver supports statements such as:

SELECT * FROM OPENQUERY(MYSOQLSALESFORCELINKEDSERVER,'SELECT Account.Name, (SELECT Contact.LastName FROM Account.Contacts) FROM Account')

Product Status

The Easysoft ODBC-Salesforce Driver is currently available on Unix, Linux and Windows platforms. The most up to date list of Easysoft ODBC-Salesforce Driver platforms is available at:

http://www.easysoft.com/products/data_access/odbc-salesforce-driver/index.html

Software problems can be reported to support@easysoft.com by users who have either purchased support or registered at the Easysoft web site at http://www.easysoft.com and are evaluating Easysoft products.


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.