Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\salesforce.27.13.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>Database Configuration File</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#1349232">21 The Salesforce Driver</a> : Database Configuration File</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="1349232">Database Configuration File</a></div> <div class="Body"><a name="1349233">You can configure an embedded database and data mapping using a database </a>configuration file in XML format. Some of these values you can set in the file are the same as those you can set using the <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#982269', '');">Config Options</a></span> connection option (see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#917084', '');">â??Connection Option Descriptionsâ??</a></span>). Some database configuration values can be set only using a configuration file.</div> <div class="Body"><a name="1349240">The name of the database configuration file has the format:</a></div> <div class="syntax_first"><span class="EquationVariables"><a name="1349241">databasename</a></span>.config</div> <div class="Body"><a name="1349242">where </a><span class="EquationVariables">databasename</span> is the name of the database to be configured. For example, if your environment has a database named mydb or a database configuration file named mydb.config, when the driver establishes a connection, it performs the following tasks:</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="1349243">Checks to see if an embedded database named mydb exists (or a database using the </a>default <span class="EquationVariables">databasename</span> if one is not specified). If mydb exists, the driver connects to the remote data source using the mydb database.</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="1349244">If mydb does not exist and the driver is configured to create a database, the driver looks </a>for a database configuration file named mydb.config. If the database configuration file exists, the driver creates the database and mapping using the properties specified in the database configuration file.</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="1349245">If mydb.config does not exist, the driver generates a database configuration file with </a>default settings and uses those settings to create the database and its mapping.</div> </td> </tr> </table> </div> <div class="Body"><a name="1349246">The following is an example database configuration file:</a></div> <div class="syntax"><a name="1349247"><?xml version='1.0' encoding='UTF-8'?></a></div> <div class="syntax"><a name="1349248"><Database xmlns="http//datadirect.com/cloud/config/1.0"></a></div> <div class="syntax"><a name="1349249"> </a> <User name="CONNECT2" defaultSchema="SFORCE"></div> <div class="syntax"><a name="1349250"> </a> <UseSchema name="SFORCE"/></div> <div class="syntax"><a name="1349251"> </a> <UseSchema name="PUBLIC"/></div> <div class="syntax"><a name="1349252"> </a> </User></div> <div class="syntax"><a name="1349253"> </a> <Schema name="SFORCE" type="Salesforce"></div> <div class="syntax"><a name="1349254"> </a> <ConfigOptions>uppercaseidentifiers=true;localtables=0;auditcolumns=none;</div> <div class="syntax"><a name="1349255"> </a> customsuffix=strip;=</ConfigOptions></div> <div class="syntax"><a name="1349256"> <SessionOptions>loginhost=test.salesforce.com;userid=</a></div> <div class="syntax"><a name="1349257"> </a> connect2@progress.com</SessionOptions></div> <div class="syntax"><a name="1349258"> </a> </Schema></div> <div class="syntax"><a name="1349259"> </a> <Schema name="PUBLIC" type="local"></div> <div class="syntax"><a name="1349260"> </a> </Schema></div> <div class="syntax"><a name="1349261"></Database></a></div> <div class="Body"><a name="1349264">The following are descriptions of the elements of the database configuration file.</a></div> <div class="head_3"><a name="1349294">Database</a></div> <div class="gutter_text_right"><a name="1349295">Child Elements</a></div> <div class="Body"><a name="1349296">User, Schema</a></div> <div class="gutter_text_right"><a name="1349297">Description</a></div> <div class="Body"><a name="1349298">The Database element is the root element of the database configuration file. It does not </a>define any configuration; it contains all of the elements that do define the database configuration. One and only one Database element must exist.</div> <div class="head_3"><a name="1349299">User</a></div> <div class="gutter_text_right"><a name="1349300">Parent Element</a></div> <div class="Body"><a name="1349301">Database</a></div> <div class="gutter_text_right"><a name="1349302">Child Element</a></div> <div class="Body"><a name="1349303">UseSchema</a></div> <div class="gutter_text_right"><a name="1349304">Description</a></div> <div class="Body"><a name="1349305">Specifies the User ID used by the driver. At least one User element must exist.</a></div> <div class="gutter_text_right"><a name="1349306">Attributes</a></div> <div class="Body"><a name="1349307">name [required]: The user name is a string with a maximum length of 128 characters. The </a>default is name=<span class="EquationVariables">userid</span>, where <span class="EquationVariables">userid</span> is the User ID used by the driver.</div> <div class="Body"><a name="1349308">defaultSchema: The name of the schema to use for unqualified table and column identifiers. </a>If defaultSchema is not specified, the schema specified in the first useSchema child element is used as the default schema. The default is defaultSchema=SFORCE.</div> <div class="head_3"><a name="1349309">UseSchema</a></div> <div class="gutter_text_right"><a name="1349310">Parent Element</a></div> <div class="Body"><a name="1349311">User</a></div> <div class="gutter_text_right"><a name="1349312">Child Element</a></div> <div class="Body"><a name="1349313">None</a></div> <div class="gutter_text_right"><a name="1349314">Description</a></div> <div class="Body"><a name="1349315">The UseSchema element specifies a schema that is visible to the user of this element. A </a>schema contains the mapping between the remote data model and the relational tables the driver exposes. Multiple schemas can be associated with a user. At least one UseSchema element must exist.</div> <div class="Body"><a name="1349316">A basic User definition typically has two UseSchema elements: one that specifies the </a>mapping to the remote data source and one for the local schema.</div> <div class="gutter_text_right"><a name="1349317">Attributes</a></div> <div class="Body"><a name="1349318">name [required]: The name of the schema to associate with the user. The schema name is </a>a string with a maximum length of 128 characters. The defaults are name=SFORCE [remote] and name=PUBLIC [local].</div> <div class="head_3"><a name="1349319">Schema</a></div> <div class="gutter_text_right"><a name="1349320">Parent Element</a></div> <div class="Body"><a name="1349321">Database</a></div> <div class="gutter_text_right"><a name="1349322">Child Elements</a></div> <div class="Body"><a name="1349323">ConfigOptions, SessionOptions</a></div> <div class="gutter_text_right"><a name="1349324">Description</a></div> <div class="Body"><a name="1349325">The Schema element defines the schema that contains the mapping for a remote data </a>source. The database configuration file must contain at least one schema definition and may contain multiple schema definitions. Each schema definition defines the type of the data source to which the schema maps, the information to connect to the remote database (except password), and the information needed to configure the remote data model to relational table mapping. At least one Schema element must exist.</div> <div class="gutter_text_right"><a name="1349326">Attributes</a></div> <div class="Body"><a name="1349327">name [required]: The name of the schema that defines the data model to relational </a>mapping. This attribute can be any valid identifier name. The defaults are name=SFORCE for the remote data source and name=PUBLIC for the local database.</div> <div class="Body"><a name="1349328">type [required]: The type of remote data source for which the schema defines mapping. This </a>attribute must be type=Salesforce for the remote data source and type=local for the local database.</div> <div class="head_3"><a name="1349329">ConfigOptions</a></div> <div class="gutter_text_right"><a name="1349330">Parent Element</a></div> <div class="Body"><a name="1349331">Schema</a></div> <div class="gutter_text_right"><a name="1349332">Child Element</a></div> <div class="Body"><a name="1349333">None</a></div> <div class="gutter_text_right"><a name="1349334">Description</a></div> <div class="Body"><a name="1349335">The ConfigOptions element is a string that specifies the configuration options used to define </a>how the remote data source data model is mapped to relational tables. The ConfigOption string has the same keys, values, and syntax as the Config Options connection option (see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#917084', '');">â??Connection Option Descriptionsâ??</a></span>) except that the enclosing parentheses are not required (see example configuration file). The default is an empty string.</div> <div class="gutter_text_right"><a name="1349339">Attributes</a></div> <div class="Body"><a name="1349340">None</a></div> <div class="head_3"><a name="1349341">SessionOptions</a></div> <div class="gutter_text_right"><a name="1349342">Parent Element</a></div> <div class="Body"><a name="1349343">Schema</a></div> <div class="gutter_text_right"><a name="1349344">Child Element</a></div> <div class="Body"><a name="1349345">None</a></div> <div class="gutter_text_right"><a name="1349346">Description</a></div> <div class="Body"><a name="1349347">The SessionOptions element is a string of key value pairs that specifies the information </a>needed to connect to the remote data source. SessionOptions includes the server name and remote user id, for example:</div> <div class="syntax_first" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><span style="color: #000000; font-size: 10.0pt; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none; vertical-align: baseline;"><a name="1349349">loginhost=login.salesforce.com;userid=john.public@abccorp.com </a></span></div> <div class="gutter_text_right"><a name="1349350">Attributes</a></div> <div class="Body"><a name="1349351">None</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