Data Access Guide SAP BusinessObjects Business Intelligence platform 4.0 Feature Pack 32012-03-15

UNION_IN_SUBQUERY...17613.1.37Data type conversion

Related Topics• Connection pools9.4.7 Setup File Extension<Parameter Name="Setup File Extension">setup</Parameter>Note:Do not ch

Note:Do not change this setting.Sets the file extension for SQL parameter files.DescriptionprmDefault9.4.10 Strategies Extension<Parameter Name=&qu

9.4.12 Validate XML Streams<Parameter Name="Validate XML Streams">No</Parameter>Triggers the validation of the XML streams parse

This configuration allows the library deployment mode with JNI and the server deployment mode.9.6 Configuring the deployment modeParameters defined in

Caution:To avoid connection failures, you must make sure your environment provides all the necessarymiddleware, otherwise you must set the network lay

The Traces section of the cs.cfg file helps you activate traces for Connection Server jobs and driversand log them separately from SAP BusinessObjects

The traces are logged into a file whose default name is TraceLog_<pid>_<timestamp>_trace.log.If you want to set another name to the log fi

2006/11/14 10:49:49.600|<<|||5784|5852|||||||||||||||||unknown|unknown|JobId:0| ENTER SQLSetEnvAttrSQLHENV 0x02E012A0SQLINTEGER 200SQLPOINTER 0x

2012-03-15108Configuring data access global parameters

Configuring data access driver parameters10.1 Configuring driver parametersTo configure data access for a particular data access driver, you can eithe

Document HistoryThe following table provides an overview of the most important document changes.DateVersionLearning about Connectivity Services, see C

Note:The parameters set in the DriverDefaults section of cs.cfg are overridden by correspondingsettings in the SBO files.• <driver>.setupThis fi

SBO fileDatabase technologySub-directorydatafederator.sboData Federator Serverjdbcdb2.sboIBM DB2derby.sboDerbygreenplum.sboGreenplum and PostgreSQLhsq

SBO fileDatabase technologySub-directoryteradata.sboTeradata2012-03-15112Configuring data access driver parameters

SBO fileDatabase technologySub-directoryaccess.sboMicrosoft Accessodbcaccess2010.sboMicrosoft Access 2010datafederator.sboData Federator Serverdb2iser

SBO fileDatabase technologySub-directoryProgress OpenEdgeprogress.sbosqlsrv.sboMicrosoft SQL Serversybase.sboSybaseteradata.sboTeradataoledb.sboGeneri

from the greenplum.sbo and access.sbo files, because they deploy the configuration on both 32-bitand 64-bit MS Windows. Note Greenplum 4 database is a

You specify the SBO file name, its directory and the database network layer that is used for theconnection.2.Check that the file is valid against the

10.1.6 JDBC driver propertiesYou can add JDBC driver properties by doing one of the following:• In the connection wizard of your application, at conne

These can work with either DataDirect ODBC 6.0 SP2 driver or DataDirect ODBC 6.0 SP2 brandeddriver.You can find the DataDirect branded driver files in

For example:[ODBC Data Sources]sql2005=sql=DataDirect 6.0 SQL Server Native Wire ProtocolDriver=/.../enterprise_xi40/linux_x64/odbc/lib/CRsqls24.soDes

DateVersionNew Sybase IQ 15 connectivity through ODBC and JDBC introducedon all platforms.ODBC Data Source Administrator Tool, see 64-bit Microsoft Wi

2012-03-15120Configuring data access driver parameters

SBO parameter reference11.1 SBO file structureThere is a <driver>.sbo file for each supported data access driver. Each <driver>.sbo file i

DescriptionFile sectionThis section contains a DataBase child element for each databasemiddleware that is supported by the data access driver.Each Dat

• ODBC• OLE DB• OLE DB for OLAP• Open• Sybase ASE/CTLEach parameter is shown with the following information:• example of how the parameter appears in

Yes: the database supports array binding.No: the database does not support array binding.ValuesThe value set in the cs.cfg file.Default11.3.2 Array Bi

The value set in the cs.cfg file.Default11.3.4 Array Fetch Size<Parameter Name="Array Fetch Size">10</Parameter>Specifies the nu

The number of rows retrieved per slice (integer).Note:1 specifies that array fetching is disabled.Remember:0 specifies that the driver decides which a

Specifies the separator character that is used between elements ofdatabase identifiers (qualifiers, owners, tables and columns). For exam-ple, databas

11.3.9 Driver Capabilities<Parameter Name="Driver Capabilities">Procedures,Query</Parameter>The capabilities of the driver, that

The name of the driver.Note:You can use a regular expression based on the GNU regexp syntaxfrom PERL.ValuesNo default value.Default11.3.11 Escape Char

Introduction to data access guide2.1 About the data access guideThe Data Access Guide helps you learn about Connection Server functionality and how to

Related Topics• To create a JDBC connection with Extensions11.3.13 Family<Parameter Name="Family">Sybase</Parameter>Note:Do not

11.3.15 Identifier Quote String<Parameter Name="Identifier Quote String">&quot;</Parameter>Specifies the character used to q

Note:Do not edit this parameter.Specifies if performance monitoring through CA Wily Introscope is acti-vated for the driver.DescriptionTrue: the monit

Note:Do not edit this parameter.Indicates if 64-bit integers can be handled directly by the middleware.DescriptionTrue: 64-bit integers can be handled

Yes: owners are supported.No: owners are not supported.ValuesNot specified. Connection Server retrieves this information from thedatabase middleware.D

True: the database middleware handles query timeouts.False: the database middleware does not handle query timeouts.ValuesFalseDefault11.3.24 Quote Ide

11.3.26 SQL Parameter File<Parameter Name="SQL Parameter File">oracle</Parameter>The name of the file that stores database param

<Parameter Name="Strategies File">oracle</Parameter>Specifies the name, with no extension, of the Strategy file (.stg).This file

Yes. This is set in the cs.cfg file.Default11.3.30 Type<Parameter Name="Type">Relational</Parameter>Note:Do not edit this parame

11.3.32 URL Format<Parameter Name="URL Format ">string</Parameter>Specifies the URL Format.The JDBC specification does not speci

• New connectivities are available through Connection Server. See theProduct Availability Matrixformore information.• A new driver is available for SA

11.4 JavaBean SBO parametersThese parameters apply to the JavaBean SBO file. They are used to configure a JavaBean connection.These parameters are def

<Parameter Name="ERP Max Rows">2147483647</Parameter>Specifies the maximum number of rows that can be returned by a queryto an I

Related Topics• Shared Connection11.6.2 Escape Character Available<Parameter Name="Escape Character Available">True</Parameter>S

11.6.4 Get Extended Column<Parameter Name="Get Extended Column">No</Parameter>Note:Do not edit this parameter.Specifies if the D

11.6.6 PrimaryKey Available<Parameter Name="PrimaryKey Available">True</Parameter>Specifies whether the primary keys of database

Note:Do not edit this parameter.Specifies whether the requested connection of a connection pool isshared. Operates in conjunction with the Connection

ISO88591: the default character set value specified for HP Neoview onUNIX.ValuesIf not specified, Connection Server uses the character set specified i

11.7.4 Empty String<Parameter Name="Empty String">EmptyString</Parameter>Specifies that certain functions, for example SQL table

Specifies whether the middleware handles the SQLDescribeParamODBC function. This function helps you describe the parameters of astored procedure. This

Yes: the connection can use the branded driver.No: the connection cannot use the branded driver.ValuesNoDefaultRelated Topics• Configuring data access

Note:For administrative tasks such as starting and stopping Connection Server, managing properties andmetrics, refer to theSAP BusinessObjects Busines

11.8.1 Enumerator CLSID<Parameter Name="Enumerator CLSID">MSDASQL Enumerator</Parameter>Note:Do not edit this parameter.Specifie

<Parameter Name="MSOlap CLSID">msolap.4</Parameter>Note:Do not edit this parameter.Specifies class ID of OLE DB provider. This p

11.11 Sybase SBO parametersThese parameters apply to the Sybase ASE/CTLIB SBO file. These parameters are used to configurea Sybase ASE/CTLIB connectio

True: the encryption password mechanism of the middleware is used.False: the encryption password mechanism of the middleware is notused.ValuesThe valu

11.11.5 Text Size<Parameter Name="Text Size">2147483647</Parameter>Note:This parameter is not mandatory.Specifies the maximum si

Configuring database capability parameters12.1 About database capability parametersDatabase capability parameters describe capabilities of databases u

12.2.1 PRM parameter file structureThere is a PRM file for each supported database driver. Each file is divided into sections, which containspecific p

DescriptionFile sectionFunctions available to universe design tool and information design tool, forexample Average, Sum, Variance. Functions are also

3.Expand sections as required.4.Set values by entering the value in the appropriate tag.5.Save and close the file.12.4 To view and edit a function hel

PRM parameter reference13.1 PRM file configuration referenceThe database capability parameters are listed alphabetically. To view functions, date oper

2012-03-1516Introduction to data access guide

WHEN: indicates a WHEN clause is used. This is the default value forIBM Red Brick databases.QUALIFY: indicates a QUALIFY clause is used. This is the d

YES: the database supports random sampling.NO: the database does not support random sampling.ValuesYESDefault13.1.4 DISTINCT<Parameter Name="D

YES: the database supports outer joins.NO: the database does not support outer joins. The Outer join checkboxes in the Edit Join dialog box of the uni

13.1.8 GROUP_BY_SUPPORTS_COLUMN_INDEX<Parameter Name="GROUP_BY_SUPPORTS_COLUMN_INDEX">NO</Parameter>Specifies if the database su

YES: the database supports complex expressions in the GROUP BYclause.NO: the database does not support complex expressions in the GROUPBY clause.Value

YES: the database supports the HAVING clause.NO: the database does not support the HAVING clause.ValuesNODefault13.1.12 INNER_JOIN<Parameter Name=&

INTERSECTDefault13.1.14 INTERSECT_ALL<Parameter Name="INTERSECT_ALL">YES</Parameter>Specifies if the database supports the INTER

<Parameter Name="JOIN">YES</Parameter>Specifies if the database supports a JOIN operation between two tables.DescriptionYES: the

$(+): this syntax is used with Oracle.$*: this syntax is used with Sybase, MS SQL Server and IBM Red Brick.Note:$ represents a join expression.ValuesS

MINUS: the database supports the MINUS set operator.EXCEPT: the database supports the EXCEPT set operator.No value: the database does not support any

Introduction to data access3.1 About Connection ServerConnection Server is the data access software that manages the connection between an SAPBusiness

13.1.23 ORDER_BY<Parameter Name="ORDER_BY">YES</Parameter>Specifies if the database supports the ORDER BY clause.DescriptionYES:

Specifies if the database supports the use of column indexes from theSELECT statement in the ORDER BY clause.DescriptionYES: the database supports the

YESDefault13.1.28 RIGHT_EXT_JOIN<Parameter Name="RIGHT_EXT_JOIN">YES</Parameter>Specifies if the database supports right externa

13.1.30 SEED_SAMPLING_SUPPORTED<Parameter Name="SEED_SAMPLING_SUPPORTED">YES</Parameter>Specifies if the database supports seed

13.1.32 SUBQUERY_IN_FROM<Parameter Name="SUBQUERY_IN_FROM">YES</Parameter>Specifies if the database supports the use of subqueri

YES: the database supports the use of subqueries inside the WHERE clause.NO: the database does not support the use of subqueries inside the WHEREclaus

13.1.37 UNION_IN_SUBQUERY<Parameter Name="UNION_IN_SUBQUERY">YES</Parameter>Specifies if the database supports the use of the UN

Data type conversion reference14.1 Data type conversionIn the information design tool, data foundations expose tables from one or more relational data

The Data Access layer manages the conversion of data types exposed by network layers into ConnectionServer data types, which are then mapped to data t

Data foundation data typeType declared in the DDL fileBITBIT, BOOLEANDATEDATETIMETIMETIMESTAMPTIMESTAMPDECIMALBIGINT, DECIMALDOUBLEFLOAT, DOUBLE, REAL

• the application and the data access driver• Connection Server and the data access driver3.2.1 System architectureThe diagram below details where Con

Data foundation data typeJDBC data typeLONGVARBINARYBLOB, LONGVARBINARYBITBIT, BOOLEANLONGVARCHARCLOB, NCLOBDATEDATETIMETIMETIMESTAMPTIMESTAMPDOUBLEDO

Data foundation data typeInformix JDBC data typeIt can be mapped to:• DATE if the Informix data type follows the pattern DATETIME\\s+(HOUR|MINUTE|SECO

Data foundation data typeSQL type nameOracle JDBC data typeTIMESTAMPTIMESTAMPany valueDOUBLEany valueBINARY_DOUBLEDOUBLEFLOATOTHERREALany valueBINARY_

Data foundation data typeODBC data typeTIMESTAMPSQL_DATETIME, SQL_TIME, SQL_TIMESTAMP,SQL_TYPE_TIME, SQL_TYPE_TIMESTAMPLONGVARCHARSQL_LONGVARCHAR, SQL

Data foundation data typeDB2 ODBC data typeLONGVARBINARYSQL_BLOBLONGVARCHARSQL_CLOB, SQL_DBCLOB, SQL_LONGVAR-GRAPHICDOUBLESQL_DECFLOATCHARSQL_GRAPHICV

MS SQL ServerThe following table lists the data types that could show up in results when the user queries an MS SQLServer database through ODBC, and t

Data foundation data typeOLE DB data typeDECIMALDBTYPE_DECIMALTINYINTDBTYPE_I1, DBTYPE_UI1SMALLINTDBTYPE_I2, DBTYPE_UI2INTEGERDBTYPE_I4, DBTYPE_UI4BIG

Data foundation data typeMS SQL Server OLE DB data typeXMLDBTYPE_XML14.1.6 Oracle OCIThe following table lists the data types that show up through Ora

14.1.7 Sybase CTLThe following table lists the data types that show up through Sybase CTL and their equivalent in datafoundations.Note:Sybase CTL data

Data foundation data typeSybase CTL usertypeSybase CTL data typeDECIMALCS_DECIMAL_TYPE,CS_MONEY_TYPE, CS_MON-EY4_TYPEDOUBLECS_FLOAT_TYPEINTEGERCS_INT_

• Contact your SAP representative to determine if there is a driver available, and if you are licencedto use it.• Use the Driver Development Kit (DDK)

14.2 Large variable length data limitationRestriction:The limitation only relates to Crystal Reports applications.Due to Data Access layer implementat

More InformationLocationInformation Resourcehttp://www.sap.comSAP product informationhttp://help.sap.com/businessobjectsAccess the most up-to-date Eng

LocationInformation Resourcehttps://service.sap.com/notesThese notes were formerly known as Knowledge Base articles.Noteshttps://www.sdn.sap.com/irj/s

Index64-bit supportabout 25Microsoft Windows support 26UNIX environment 25AABAP functions 71about the guide 13ActiveDataSources setting 103Adaptive Co

data types(continued)Sybase 188databasescapability parameters 155checking access 47configuring access 103listing supported 40selecting access to 104su

middleware(continued)listing supported 42MINUS 168MINUS_ALL 169MINUS_IN_SUBQUERY 169MS AccessDISCTINCT 161MS SQL Server 117MSOlap CLSID 151multisource

SUBQUERY_IN_IN 174SUBQUERY_IN_WHERE 174supported connectivities 42supported databases 40supported network layers 40Sybaseconnectivity check example 47

© 2011 SAP AG. All rights reserved.SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAPBusinessObjects Explorer, StreamWork, and other SAP produc

The cs.cfg file contains parameters that apply to all installed data access drivers.Related Topics• About global parameters3.3.2 About the driver conf

ExampleDescriptionCan be edited?Driver specific fileoracleen.codEach data access driv-er has a COD file.Stores information relat-ed to connection defi

• Server modeConnection Server is a CORBA server and is accessed remotely. Connection Server serves theCORBA and HTTP clients to address the 2-tier an

DescriptionConnectivity ServiceConnectionSupport of ODBC, OLE DB, OCI, and soon.Native Connectivity ServiceAll 64-bit native datasourcesSupport of dat

2012-03-1524Introduction to data access

Learning data access specifics4.1 64-bit operating system supportSAP BusinessObjects provides releases of the SAP BusinessObjects Business Intelligenc

• DB2 UDB for iSeries V6 with Client Access AS400• DB2 UDB for i v6.1 with Client Access AS400• Generic datasource through OLE DB• MS Access 2010 thro

Related Topics• Array Fetch Size4.1.3 Installation of ODBC driversFor installations of the information design tool or universe design tool on a 32-bit

DescriptionData sourceSSO to BI platform is Windows AD with Kerberos.MS Analysis Services on Microsoft WindowsSSO to BI platform is Windows AD with Ke

Connection Server is able to manage data from data sources that result either from SQL query or storedprocedure execution.Stored procedures are SQL sc

ContentsDocument History...11Chapter 1 I

Note:The other IN/OUT cursor parameters of the procedure are ignored.The unsupported Oracle stored procedures are the following:• any PL/SQL procedure

b. Write the following statement with several parameters:CREATE or REPLACE PROCEDURE get_ownerobjects(owner_name INvarchar2, cat_cv IN OUT catalog_dat

• Each time that Connection Server requires information, the data access driver opens a connectionto the database, retrieves the data, then closes the

• client proxies in a 2-tier deployment, on the client tier• server bridges in a web tier deployment, on the web tierNote:Connection Server also provi

• available memory is the difference between max memory and the current amount of allocatedmemory• constant is the maximum HEALTH (set to 10000 for Co

The Data Access layer provides the following binaries:• ConnectionServer.exe, which is the default binary. HOARD is not enabled.• ConnectionServerOpti

• Tree view, where successive function calls of a specific workflow are displayed and time spent ona function is highlighted to track the time-consumi

Creating a connection5.1 Connection requirementsThis section covers the requirements for creating a connection.• Ensure that your platform conforms to

Note:The results of all checks apply to your local machine, from which you run the tool.The cscheck tool is installed in the boe-install-dir\platform_

Example:To display help in English on the cscheck tool, use the following command:cscheck --helpTo display help in French on the connectivity function

Connection pools...314.4About connecti

The remaining part of the command consists of the function and its option arguments.function name can take the following values. Each function has a s

The following is an excerpt of the result list:Oracle ClientOracle 10Oracle 11Sybase Open ClientSybase Adaptive Server 12Sybase Adaptive Server 15Info

Informix XPS 8.5Informix Dynamic Server 7.3Informix Dynamic Server 2000Informix Dynamic Server 10Informix Dynamic Server 11This access driver is insta

Table 5-1: Function input parametersThe mode in which the client application accessesConnection Server:• local: lists connectivity types available ont

Example: Finding CORBA server connectivitiesThe following command returns a list of the data access drivers available from a CORBA server.cscheck find

Related Topics• Check tool—function overview• Displaying help on the cscheck tool• Check tool—connectivity• Check tool—accessdriver5.2.8 Check tool—ac

The result is the following:Starting to check the access driver component installation...Begin AND operator...Config Directory... success.%SharedRoot%

cscheck -l en connectivity -c "Oracle Client" -d "Oracle 10">c:\result.txtIf the middleware is not correctly installed, the res

Table 5-5: Function input parametersThe mode in which the client application accessesConnection Server:• local: Connection Server is running on theloc

• Network layer: Oracle Client• Database: Oracle 10g• Data source: Harlaxton• User name: efashion• Password: X2345cscheck ping -m local -c "Oracl

Driver capabilities...636.1.1File loca

Note:JDBC connectivity is available for SAP BusinessObjects Enterprise XI 3.0 and higher. Web IntelligenceRich Client supports JDBC connectivity in 3-

3.Add the required .jar file details to the ClassPath area. Include the fully qualified path nameswhen specifying these files, for example:<Path>

5.3.3 To create a JDBC connection with ExtensionsIn order to create a JDBC connection:• Obtain the necessary JDBC driver software for the database, an

5.3.4 JAR file location referenceThe following table describes the names of the folders where you must place middleware JAR files toenable JDBC connec

Extensions parameter valuesDatabaseVendoringres9, ingres, jdbcIngres Database 9Ingressqlsrv2005, sqlsrv, jdbcMS SQL Server 2005Microsoftsqlsrv2008, sq

Extensions parameter valuesDatabaseVendorsybase15, sybase, jdbcSybase Adaptive Server Enterprise15, Sybase Adaptive Server Enter-prise 15.5Sybaseasiq1

2.Copy the required .jar file to the connectionserver-install-dir\connectionServer\jdbc\drivers\jdbc directory.You have to create the directory if it

Layers on Database Middleware Selection screen. If you do not, the connection wizard does notdisplay the JavaBean drivers that are available.Related T

</ClassPath><Parameter Name="JavaBean Class">com.businessobjects.beans.excel.Excel</Parameter><Parameter Name="URL

A set of data access drivers are installed when you install the SAP BusinessObjects Business Intelligenceplatform. You can use these data access drive

Configuring Connection Server for a Web Intelligence Rich Client connection to DataFederator...

The configuration files are located in the connectionserver-install-dir/connectionServer/odbc directory.2.Use an XML editor to open the odbc.sbo file

5.5.2 To create a generic ODBC3 connectionThe following procedure shows how to configure a generic ODBC connection to a database with thefollowing ass

9.Install the relevant ODBC drivers on your UNIX machine.10.Configure the data source by editing the odbc.ini file.11.Save and close the odbc.ini file

Data access driver reference6.1 CSV file connectionsThis section only relates to connections to be created in the information design tool.The Data Acc

• DISTINCT clause within SELECT statement• UNION and UNION ALLNote:The ORDER BY operation depends on the Bucket Split Size SBO parameter.The data acce

6.1.3 Table mappingThe data access driver exposes CSV files as tables to the information design tool.You can connect to multiple files if the Filepath

6.1.4 Schema detectionThe Data Access layer provides the following methods for the schema detection of a CSV file:• no detection• automatic detection•

Caution:Only Probe Rows set to all allows the driver to find the longest string.• column nullabilityNullability is true if there is a null value in th

6.2 SAP ERP connectionsThe Data Access layer allows the SAP BusinessObjects Business Intelligence platform to connect toSAP ERP systems through the SA

The data access driver does not allow ordering columns by index in SQL statements. Only ORDER BYwith column names is a valid clause. The ORDER_BY_SUPP

Configuring data access for DataDirect ODBC branded drivers...11710.2To enable the use of DataDirect branded d

Fields are mapped to table columns. An InfoSet or an SAP Query contains fields that are both projectionand selection fields. It also contains selectio

internally by the driver (other filtering with WHERE, GROUP BY, DISTINCT and sorting only with ORDERBY aggregate functions).When the application user

• An optional parameter that has a default value is mapped to an optional input column. The userdoes not have to set a value to this column. The value

6.2.4 ERP limitations• The JCo API does not support array fetch. This means the result data is returned all at once. Torestrict the number of resultin

2012-03-1574Data access driver reference

Connection reference7.1 Apache Hadoop HIVE connectionsThe Data Access layer allows the SAP BusinessObjects Business Intelligence platform to connect t

JAR filesHIVE database ver-sionhadoop-0.20.1-core.jar or hadoop-core-0.20.2.jarhive-exec-0.8.0.jarhive-jdbc-0.8.0.jarhive-metastore-0.8.0.jarhive-serv

Related Topics• http://technet.microsoft.com/en-us/library/cc917711.aspx• http://technet.microsoft.com/en-us/library/cc917712.aspx7.4 Oracle EBS conne

7.6 Oracle RAC connectionsThe Data Access layer allows the SAP BusinessObjects Business Intelligence platform to connect toOracle Real Application Clu

13.Save the file.14.Restart the service and application.When you complete this task, the connection to salesforce.com is properly configured.7.8 SAP H

JavaBean Class...14011.4.1JCO SBO para

Creating a JDBC connectionThe SAP HANA 1.0 SP3 JDBC drivers are installed as part of the BI platform in the connectionserver-install-dir\connectionSer

DescriptionOptiona.Exit the information design tool.b.Open the InformationDesignTool.ini file forediting.It is located at the bip-install-dir\win32_x8

The following steps enable single sign-on to the HANA database through JDBC for SAP BusinessObjectsWeb Intelligence.Note:This procedure applies to the

Related Topics• To configure single sign-on for the information design tool7.8.6 To configure the Java Virtual Machine for instrumentationYou can moni

ODBC driver connects to ASCII database kernels via ASCII and to Unicode database kernels withUCS2.SAP MaxDB does not require a specific driver manager

7.11 SAS connectionsConnections to SAS do not use Connection Server. They use an adapted JDBC connector toSAS/SHARE data sets.To configure these conne

2012-03-1586Connection reference

Creating a connection to Data Federator XI 3.0 QueryServer8.1 About Data Federator XI 3.0 Query Server connectionsYou can create connections to tables

8.2 Configuring the connection wizard for a Data Federator JDBC or ODBC connectionIn order to create a connection to Data Federator XI 3.0 Query Serve

Related Topics• Configuring the Data Federator ODBC middleware• Configuring Connection Server for a Data Federator ODBC connection8.3.1 Configuring th

To view and edit a function help text file...15812.4To edit the help text

To configure the cs.cfg file, set parameters under the JavaVM tag, as follows:<ClassPath><Path>\\data-federator-drivers-install-dir\\OaJdb

8.4.1 Configuring the Data Federator ODBC middleware for a connection to WebIntelligence Rich ClientTo configure the Data Federator ODBC middleware, y

8.4.3 Setting the Windows RichClient registry keyTo modify the Windows RichClient registry key, use a tool such as regedit.1.In the registry, locate t

Caution:The universe design tool and OpenEdge bridge must specify the same JVM directory path.2012-03-1593Creating a connection to Data Federator XI 3

2012-03-1594Creating a connection to Data Federator XI 3.0 Query Server

Configuring data access global parameters9.1 About global parametersYou can configure the global parameter values that apply to all connections. You c

This section defines parameters that apply to all data access drivers. They can be overridden for aspecific driver by corresponding settings in the &l

• possible values that can be set for the parameter (where applicable)• default value for the parameterNote:Some settings can only be modified from th

Note:Do not change this setting.Sets the file extension for the connection description files.DescriptioncodDefault9.4.4 Ignore Driver Load Failure<

Caution:Load Drivers On Startup only applies to library mode.Determines how driver libraries are loaded.Description• Yes: all installed drivers are lo