In the tnsnames.ora file, the Oracle Database alias (the defined entry name) must match the Data Source Name used in the repository connection pools of all physical Oracle databases. You must use the bundled version to connect. OCI is installed by default with Oracle BI Enterprise Edition. The Oracle BI Server uses the Oracle Call Interface (OCI) to connect to the database. You can connect to both Oracle Database and DB2 using native gateways (OCI and DB2 CLI, respectively). Note that you cannot have a single repository that contains both DataDirect Connect ODBC connections and native ODBC connections. Native ODBC connections using external drivers, such as for Teradata data sources
#Setup informix odbc drivers
ODBC connections using the DataDirect Connect ODBC drivers that are bundled with Oracle Business Intelligence Native data source gateway connections, such as OCI for Oracle Database or DB2 CLI for IBM DB2 There are three types of data source connections on Linux and UNIX platforms:
#Setup informix odbc update
When the Oracle BI Server is running on Linux or UNIX and you need to update database object settings (such as the database type) or connection pool settings, you can copy the repository file to a Windows computer, make the changes using the Administration Tool on Windows, and then copy the repository file back to the Linux or UNIX computer. Note that some data source connections on Linux and UNIX do support write operations for special functions, like data source connections for write-back, usage tracking, and annotations for Oracle Scorecard and Strategy Management. Because of this, data source connections for import must be set up on Windows. The Administration Tool is used for importing objects and is a Windows-only tool. When the Oracle BI Server is running on Linux or UNIX, most data source connections are for query-only access. Setting Up Oracle TimesTen In-Memory Database on Linux and UNIXĬonfiguring Oracle RPAS ODBC Data Sources on AIX UNIXĬonfiguring and Using Apache Hadoop Data Sources on LinuxĬonfiguring Essbase Data Sources on Linux and UNIXĬonfiguring DB2 Connect on IBM z/OS and s/390 Platforms Using DataDirect Connect ODBC Drivers on Linux and UNIXĬonfiguring Database Connections Using Native ODBC Drivers This chapter contains the following topics:Ībout Setting Up Data Sources on Linux and UNIXĬonfiguring Data Source Connections Using Native Gateways
See "System Requirements and Certification" for information about supported Linux and UNIX platforms. When you move to a production system, however, you can choose to run the Oracle BI Server on a Linux or UNIX platform. Most repository development is performed on Windows, because the Administration Tool runs only on Windows.
#Setup informix odbc how to
This chapter describes how to set up data sources for use with Oracle Business Intelligence when the Oracle BI Server is running on Linux or UNIX. 20/35 16 Setting Up Data Sources on Linux and UNIX
0 kommentar(er)
