Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\salesforce.27.01.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>The Salesforce Driver</title> <link rel="StyleSheet" href="css/salesforce.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;">21 The Salesforce Driver</div> <hr align="left" /> <blockquote> <div class="chap_title_2_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="chap_title_2_inner" style="width: 39.6pt; white-space: nowrap;">21 </div> </td> <td width="100%"> <div class="chap_title_2_inner"><a name="1222348">The Salesforce Driver</a></div> </td> </tr> </table> </div> <div class="Body"><a name="1515528">The DataDirect Connect XE </a><span class="forbody">for</span> <span class="APIbody">ODBC</span> and DataDirect Connect64 XE <span class="forbody">for</span> <span class="APIbody">ODBC</span> Salesforce driver (the Salesforce driver) supports the standard SQL query language to fetch, insert, update, and delete data from Salesforce.com, Force.com, and Database.com. </div> <div class="Body"><a name="1555251">NOTE: For the Salesforce Web Service API versions supported by the Salesforce driver, </a>refer to the product matrix on the Progress DataDirect Web site:</div> <div class="Body" style="color: #0000ff; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span class="Cross_ref_"><a href="http://www.datadirect.com/products/odbc/matrix/connectodbc.htm" target="external_window" name="1555253">http://www.datadirect.com/products/odbc/matrix/connectodbc.htm</a></span> </div> <div class="Body"><a name="1515529">NOTE: You can query the SYSTEM_REMOTE_SESSIONS system table to get the version </a>of the Web Service API the driver supports.</div> <div class="Body"><a name="1515626">The driver translates the SQL statements provided by the application to Salesforce queries </a>(SOQL) and Web service calls. Refer to <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'sqlsupport.12.01.html#24065', '');">Chapter 10 â??SQL Statements and Extensions for the Salesforce Driverâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series for ODBC Reference</span> for the SQL statements that the driver supports.</div> <div class="Body"><a name="1515630">The driver maps the Salesforce data model into a set of related relational tables. The </a>mapping representation is stored in XML files external to the driver. This allows the sharing of map files among different client machines.</div> <div class="Body"><a name="1515631">The driver uses a client-side data cache for improved performance. You can define rules </a>that specify which data to cache on the client as well as when the cached data becomes invalid and needs to be refreshed (see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.08.html#1348636', '');">â??Client-Side Cachesâ??</a></span> for details).</div> <div class="Body"><a name="1643011">The Salesforce driver can be used with industry standard tools, which means that </a>developers can leverage their existing SQL knowledge instead of having to learn the Salesforce query language and APIs. Examples include the following tools:</div> <table class="Format_B" cellspacing="0" summary=""> <caption></caption> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="1643357">Business Objects Crystal Reports</a></div> </td> </tr> </table> </div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="list_bulleted_table_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_inner"><a name="1643359">Cognos</a></div> </td> </tr> </table> </div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="1643361">Microsoft Access</a></div> </td> </tr> </table> </div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="list_bulleted_table_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_inner"><a name="1643363">Microsoft Excel </a></div> </td> </tr> </table> </div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="1643365">Oracle Gateway</a></div> </td> </tr> </table> </div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="list_bulleted_table_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_inner"><a name="1643367">Oracle Business Intelligence (OBIEE)</a></div> </td> </tr> </table> </div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="1643369">SAS/Access for ODBC</a></div> </td> </tr> </table> </div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="list_bulleted_table_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_inner"><a name="1643371">SQL Server Linked Server</a></div> </td> </tr> </table> </div> </td> </tr> <tr style="vertical-align: top;"> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="list_bulleted_table_single_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_table_single_inner" style="width: 14.4pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_table_single_inner"><a name="1643373">Tableau</a></div> </td> </tr> </table> </div> </td> <td style="padding-bottom: auto; padding-left: auto; padding-right: auto; padding-top: auto; vertical-align: top;"> <div class="table_text"><a name="1643375"> </a></div> </td> </tr> </table> <div class="Body"><a name="1514612">The driver is supported</a><span class="Emphasis"> </span>in the Windows, UNIX, and Linux environments. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'usingproduct.05.04.html#113375', '');">â??Environment-Specific Informationâ??</a></span> for detailed information about the environments supported by this driver.</div> <div class="Body"><a name="1222338">Refer to the readme file shipped with your DataDirect Connect XE product for the file name </a>of the driver.</div> <div class="Body"><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.01.html#1600339', '');" name="1516017">Figure 21-1</a></span> shows the different components of an environment that uses the Salesforce driver to access Salesforce. Depending on your license from Salesforce.com, the driver could instead connect to Force.com or Database.com.</div> <div class="figure_title">Figure 21-1. <a name="1600339">Salesforce Driver</a><span style="font-size: 9.0pt; font-style: normal; font-weight: normal;"><img class="Default" src="images/salesforce.27.01.1.gif" width="620" height="442" style="display: block; float: none; left: 0.0; top: 0.0;" alt="Application opens a Web Service Session and a Database Session" /></span></div> <div class="figure_end_rule"><a name="1600390"> </a></div> <div class="Body"><a name="1644752">When an application connects to Salesforce through the driver, connectivity to Salesforce is </a>real-time, out of the box. In the background, the driver establishes a Web service session with the Salesforce instance and a database session that opens an embedded database. The application can establish multiple sessions with Salesforce; however, additional Web service and database sessions are always opened in the ratio of one database session per Web service session. The database session maintains the object-to-relational table mapping. In addition, it maintains cached tables and local tables, as well as maintaining views. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.13.html#1349232', '');">â??Database Configuration Fileâ??</a></span> for more details.</div> <div class="Body"><a name="1629694">On Windows, the SQL Engine can be run within the same process space as the ODBC </a>application, or it can be run as a separate process. Some applications may experience problems loading the JVM required for the SQL Engine because the process exceeds the available heap space. If your application experiences problems loading the JVM, you can configure the Salesforce driver to run in a separate 32-bit process within its own JVM. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.16.html#1579796', '');">â??Configuring the SQL Engine Serverâ??</a></span> for more information. </div> <div class="Body"><a name="1629698">Salesforce has certain standard objects that always exist, even if they do not contain </a>anything. Salesforce administrators can also create custom objects using the Salesforce browser interface. Custom Salesforce objects cannot be created by the driver. The relationships among these objects are tabular, like those among the tables in a database. The Salesforce driver recognizes the relationships among both standard Salesforce objects and custom objects and can access, create, and update both. The relationships among objects can be reported through the ODBC SQLForeignKeys and SQLPrimaryKeys functions. The driver leverages Salesforce mechanisms for joining data, minimizing the amount of data that needs to be fetched over the network.</div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de