User manual BUSINESS OBJECTS CONNECTION SERVER XI 3.0 DATA ACCESS GUIDE

[. . . ] Data Access Guide BusinessObjects Connection Server XI 3. 0 Copyright © 2008 Business Objects. patents, which may cover products that are offered and licensed by Business Objects: 5, 555, 403; 5, 857, 205; 6, 289, 352; 6, 247, 008; 6, 490, 593; 6, 578, 027; 6, 831, 668; 6, 768, 986; 6, 772, 409; 6, 882, 998; 7, 139, 766; 7, 299, 419; 7, 194, 465; 7, 222, 130; 7, 181, 440 and 7, 181, 435. Business Objects and the Business Objects logo, BusinessObjects, Business Objects Crystal Vision, Business Process On Demand, BusinessQuery, Crystal Analysis, Crystal Applications, Crystal Decisions, Crystal Enterprise, Crystal Insider, Crystal Reports, Desktop Intelligence, Inxight, the Inxight Logo, LinguistX, Star Tree, Table Lens, ThingFinder, Timewall, Let there be light, Metify, NSite, Rapid Marts, RapidMarts, the Spectrum Design, Web Intelligence, Workmail and Xcelsius are trademarks or registered trademarks in the United States and/or other countries of Business Objects and/or affiliated companies. All other names mentioned herein may be trademarks of their respective owners. [. . . ] Yes: operations against the database are run as a block when committed. Note: Do not use a driver with Transactional Available=No to access the Business Objects repository. This is set in the cs. cfg file. Transaction Mode <Parameter Name="Transaction Mode">AutoCommit</Parameter> Description Specifies the transaction mode that the database uses. Data Access Guide 73 5 SBO file parameter reference SBO parameter categories Values AutoCommit: statements are committed automatically on completion of a request. Transactional: on competion, an explicit call either completes or rolls back the statement. If not specified, the value is retrieved from the database middleware. Default Type <Parameter Name="Type">Relational</Parameter> Specifies the Business Objects data source type. Description Note: This parameter must not be modified. Unicode <Parameter Name="Unicode">CharSet</Parameter> Description Specifies if the access driver can benefit from the Unicode configuration of the client middleware. If you want to over-ride the default value you add it to the Defaults section of the SBO file for the target data access driver. UTF8: 8-bit UCS/Unicode Transformation Format coding. Values CharSet: Character Set coding. UCS2: 2-byte Universal Character Set coding Default The value set in the cs. cfg file. 74 Data Access Guide SBO file parameter reference SBO parameter categories 5 Version <Parameter Name="Version">Relational</Parameter> Specifies the database version. Description Note: This parameter must not be modified. XML Max Size <Parameter Name="XML Max Size">2048</Parameter> Description Values Default Specifies the maximum size allowed for XML data. This varies depending on the database. Informix SBO parameters These parameters apply to the Informix SBO file. These parameters are defined in the \\<INSTALDIR>\win32_x86\dataAc cess\connectionServer\informix\informix. sbo file. Note: In addition to the SBO parameters, for Informix, in a Unix environment, you must modify the ODBC. INI file. Related Topics · · V5toV6DriverName on page 76 Modifying the Informix ODBC. INI file on page 76 Data Access Guide 75 5 SBO file parameter reference SBO parameter categories Modifying the Informix ODBC. INI file In order to use the data access layer with an Informix database in a UNIX environment, you need to modify the unicode configuration. This configuration information can be in either of the following locations: · The . odbc. ini file located in your home directory. · The file specified by the ODBCINI environment variable. 1. Locate the ODBC. INI file or the file specified by the ODBCINI environment variable, and open it in a text editor. Close the file and save it. Example: ODBC section with the configuration added This code is an example of the ODBC section with the correct information added: [ODBC] UNICODE=UTF-8 V5toV6DriverName <Parameter Name="V5toV6DriverName">{Informix 3. 34 32 BIT}</Pa rameter> Description Specifies the conversion rule from Informix Connect to Informix ODBC. The value of this parameter determines which Informix Driver is used to define the ODBC Data Source Name (DSN) without the connection string. . The value set in the cs. cfg file. Values Default 76 Data Access Guide SBO file parameter reference SBO parameter categories 5 JavaBean SBO parameters These parameters apply to the JavaBean SBO file. These parameters are defined in the \\<INSTALDIR>\win32_x86\dataAc cess\connectionServer\javaean\javaean. sbo file. JavaBean Class <Parameter Name="JavaBean Class">string</Parameter> Description Defines the entry point of the JavaBean that the Business Objects application uses. The entry point is the definition of a java class extending from the Bean interface specified through the com. businessobjects package. None. Values Default URL Format <Parameter Name="URL Format ">string</Parameter> Specifies the URL Format. The JDBC specification does not specify the format of the connection string that it requires. [. . . ] · Documentation from the products Online help and guides in Adobe PDF format are available from the product Help menus. Where only online help is provided, the online help file contains the entire contents of the PDF version of the guide. · Documentation on the web The full electronic documentation set is available to customers on the web from support website at: http://www. support. businessobjects. com/. · Documentation on the product CD Data Access Guide 151 9 Business Objects information resources Customer support, consulting and training Look in the docs directory of your product CD for versions of guides in Adobe PDF format. Send us your feedback Do you have a suggestion on how we can improve our documentation? [. . . ]