1. Managing Metadata Repositories for Oracle Analytics Server
  2. Build Your Metadata Repository
  3. Set Up Data Sources on Linux
  4. About Setting Up Data Sources on Linux

About Setting Up Data Sources on Linux

When the Oracle BI Server is running on Linux, most data source connections are for query-only access.

The Model Administration Tool is used for importing objects and is a Windows-only tool. You must set up data source connections for import on Windows.

When the Oracle BI Server is running on Linux 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 Model Administration Tool on Windows, and then copy the repository file back to the Linux computer.

There are three types of data source connections on Linux platforms:

  • Native data source gateway connections, such as OCI for Oracle Database

  • ODBC connections using the DataDirect Connect ODBC drivers that are bundled with Oracle Analytics Server

  • Native ODBC connections using external drivers, such as for Teradata data sources

You can have a single repository that contains both DataDirect Connect ODBC connections and native ODBC connections. If you're using the native ODBC drivers and DataDirect ODBC drivers, you must manage the drivers with the same DataDirect ODBC driver manager. For example, the Teradata ODBC drivers include their required ODBC driver managers. When the Teradata ODBC driver is used with Oracle Analytics Server, you must manage the driver with the DataDirect ODBC driver manager that's bundled with Oracle Analytics Server.