Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\salesforce.27.20.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>Using DataDirect Bulk Load With 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;"> <a class="WebWorks_Breadcrumb_Link" href="salesforce.27.01.html#1251922">21 The Salesforce Driver</a> : Using DataDirect Bulk Load With the Salesforce Driver</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="1251922">Using DataDirect Bulk Load With the Salesforce Driver</a></div> <div class="Body"><a name="1298053">The driver supports DataDirect bulk load. Bulk load connection options are located on the </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.03.html#1229306', '');">Bulk tab</a></span> of the driver Setup dialog box. The driver sends data to a Salesforce instance using the Salesforce Bulk API instead of the Web Service API. Using the Bulk API significantly reduces the number of Web service calls the driver uses to transfer data and may improve performance.</div> <div class="Body"><a name="1564472">See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'advanced.06.6.html#109749', '');">â??Using DataDirect Bulk Loadâ??</a></span> for a general description of DataDirect bulk load and its implementation.</div> <div class="head_2"><a name="1568912">Bulk Operation Support</a></div> <div class="Body"><a name="1568952">The Salesforce driver supports additional bulk operations besides bulk Insert when loading </a>a data from an input file.</div> <div class="Body"><a name="1568954">Features include:</a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="1568956">Bulk Delete - The input file contains only a list of values for a Salesforce primary key </a>column. The driver uses the bulk protocol to delete the rows corresponding to the key values.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="1568958">Bulk Update - The input file contains a list of values for a Salesforce primary key column </a>(required) and columns for which the data should be updated. The driver uses the bulk protocol to update the columns based on the rows that match the primary key values.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="1568960">Bulk Upsert - The input file contains a list of values for a Salesforce External Id column </a>(required) and column values for which the data should be updated if the external id value already exists or inserted to the table if the external id value does not exist.</div> </td> </tr> </table> </div> <div class="Body"><a name="1569044">Refer to </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'bulk.11.1.html#106056', '');">Chapter 9 â??DataDirect Bulk Loadâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series for ODBC </span><span class="Emphasis">Reference</span> for details.</div> <div class="head_2"><a name="1298059">Using Column Mapping</a></div> <div class="Body"><a name="1568060">The Salesforce driver can use the DataDirect functions LoadTableFromFile (for an ANSI </a>application) and LoadTablefromFileW (for a Unicode application) to support mapping of the column names defined in the input file to columns defined in the Salesforce table. </div> <div class="Body"><a name="1569636">To take advantage of this feature, create a list of columns that are </a><span class="Emphasis">not</span> auto-generated by Salesforce and specify a string argument of the format:</div> <div class="syntax_first"><a name="1568062">TableName(</a><span class="EquationVariables">ColumnName</span>[,<span class="EquationVariables">ColumnName</span>[,<span class="EquationVariables">ColumnName</span>]...])</div> <div class="Body"><a name="1568064">for the TableName parameter of the LoadTableFromFile(W) function. </a></div> <div class="Body"><a name="1569543">By default, the driver requires a one-to-one mapping of the columns defined in the input file </a>to the columns defined in the Salesforce table. Because Salesforce tables contain several auto-generated key columns, it is not possible to achieve the required one-to-one mapping. Use only columns that were <span class="Emphasis">not</span> auto-generated in the column list for which the data file defines the data that you want to load.</div> <div class="Body"><a name="1298164">Refer to </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('reference', 'bulk.11.1.html#106056', '');">Chapter 9 â??DataDirect Bulk Loadâ??</a></span> in the <span class="Emphasis">DataDirect Connect Series for ODBC </span><span class="Emphasis">Reference</span> for details.</div> <div class="head_2"><a name="1297989">Using Bulk Load for Single Inserts/Updates/Deletes </a></div> <div class="Body"><a name="1297991">You can configure the driver to use the bulk load protocol when it encounters a request to </a>execute a single Insert, Update, or Delete statement that affects many rows. When the EnableBulkLoad connection option is set to true, the Salesforce driver uses the Salesforce Bulk API for single Insert, Update, and Delete statements if the number of rows affected by the operation exceeds the threshold set by the BulkLoadThreshold connection option. </div> <div class="Body"><a name="1297992">For example, if you set the EnableBulkLoad connection option to true and the </a>BulkLoadThreshold connection option to 2000, executing the following statement would use the Bulk API if the number of rows returned by <span class="Syntax">SELECT rowid, sys_name FROM account</span> is more than 2000 rows.</div> <div class="syntax_first"><a name="1297993">INSERT INTO tmpAccounts(accountId, accountName)</a></div> <div class="syntax"><a name="1297994">SELECT rowid, sys_name FROM account</a></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