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. Business Objects owns the following U. S. 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. [. . . ] db2iseries for IBM DB2 iSeries db2udb for IBM DB2 informix for Informix sqlsrv for Microsoft SQL Server 2000 Values oracle for Oracle redbrick for Red Brick sybase for Sybase asiq for Sybase ASIQ teradata for Teradata Default The listed values. Data Access Guide 71 5 SBO file parameter reference SBO parameter categories SSO Available <Parameter Name="SSO Available">False</Parameter> Description Values Default Specifies whether or not Single Sign On is supported. False: Single Sign On is not supported . False Strategies File <Parameter Name="Strategies File">oracle</Parameter> Description Specifies the name, with no extension, of the Strategy file (. stg). This file contains the external strategies that Designer uses for automatic universe creation. Strategy files are stored in the same directory as the . sbo file. informix for Informxix. Values oracle for Oracle. teradata for Teradata. Default See values above. Table Name Max Size <Parameter Name="Table Name Max Size">1024</Parameter> Description Specifies the maximum length in characters of a database table name. 72 Data Access Guide SBO file parameter reference SBO parameter categories 5 Values Default An integer that specifies the maximum database table name length in characters. The value set in the database middleware. Transactional Available <Parameter Name="Transactional Available">Yes</Parameter> Specifies if SQL operations run against the database are run as block transactions or individually. Description This parameter is not listed by default in the . sbo file. Add it to the . sbo file if your data access driver does not support transactional mode. Yes: operations against the database are run as a block when committed. Values No: each SQL statement is immediately 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. This parameter appears as a driver default in the cs. cfg file. Its value applies to all data access drivers. It is not listed by default in the SBO file. 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. [. . . ] · 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?Is there something you particularly like or have found useful?Email us, and we will do our best to ensure that your suggestion is included in the next release of our documentation: documentation@businessobjects. com. Note: If your issue concerns a Business Objects product and not the documentation, please contact our Customer Support experts. [. . . ]