Скачать или смотреть How to Connect OBIEE to Postgres DB Without Third-Party Drivers

Discover the step-by-step process to connect OBIEE 12c to a PostgreSQL database using ODBC drivers. Explore official documentation and learn about driver options.
---
This video is based on the question https://stackoverflow.com/q/62753947/ asked by the user 'Егор Раковский' ( https://stackoverflow.com/u/13362439/ ) and on the answer https://stackoverflow.com/a/62778807/ provided by the user 'Chris' ( https://stackoverflow.com/u/4729822/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: how to connect obiee to postgres db?

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Connecting OBIEE to PostgreSQL Database: A Comprehensive Guide

Connecting Oracle Business Intelligence Enterprise Edition (OBIEE) to a PostgreSQL database can be a challenging task, particularly for those new to data analytics or unfamiliar with OBIEE. This guide aims to demystify the connection process and help you set up your OBIEE 12c environment to analyze data from a PostgreSQL database seamlessly.

Understanding the Challenge

In many organizations, PostgreSQL serves as a robust database solution. However, connecting it to OBIEE requires some specific steps and the right drivers. Users often have questions about the necessity of third-party drivers and whether it's possible to use basic connection protocols without additional software.

Here, we will explore how to directly connect OBIEE to a PostgreSQL database without relying on third-party drivers such as those offered by CData.

Required Drivers: ODBC vs. JDBC

Before diving into the connection process, it's essential to understand the difference between the two types of drivers:

ODBC (Open Database Connectivity): ODBC is a standard API for accessing database management systems. It allows OBIEE to analyze data from various sources, including PostgreSQL. For OBIEE 12c, using ODBC is the recommended method for connecting to PostgreSQL databases.

JDBC (Java Database Connectivity): JDBC is a Java-based API. Its availability in OBIEE is primarily linked to future versions of Oracle Analytics Server, which means it may not be suitable for your current setup with OBIEE 12c.

Given these distinctions, you must focus on obtaining an ODBC driver for PostgreSQL.

Step-by-Step Connection Guide

1. Install the ODBC Driver for PostgreSQL

Download the Driver: Navigate to the PostgreSQL ODBC driver download page and select the version compatible with your system.

Follow the Installation Instructions: Each version may have specific installation guidelines, so ensure you follow them closely.

2. Configure the ODBC Data Source

Open ODBC Data Source Administrator: This tool assists you in managing ODBC connections.

Add a New Data Source:

Select the ODBC driver you installed.

Provide the necessary connection details, including server address, database name, user name, and password.

Save your configured data source with a name that is easy to remember.

3. Connect OBIEE to the ODBC Data Source

Launch OBIEE: Start your OBIEE 12c application.

Navigate to the Repository Creation Utility (RCU): This tool streamlines the process of connecting to various data sources.

Choose your Data Source: When prompted, select the ODBC source you configured.

Test the Connection: It is essential to verify that the connection is successful before proceeding.

4. Create an Analytics Model

Build Your Repository: Use OBIEE's admin tools to create and configure the model that will analyze data from your PostgreSQL database.

Set Up Subject Areas: Organize your data into subject areas that are meaningful to your business needs, enhancing the usability of your analytics.

Conclusion

Connecting OBIEE to a PostgreSQL database using ODBC drivers is not only feasible but also quite straightforward when you know the steps to take. While ODBC remains your best option for the current environment of OBIEE 12c, future updates to Oracle Analytics Server may change the landscape for drivers. Until then, ensure you have the ODBC driver correctly set up and configured to unlock the analytical power of your PostgreSQL data.

By following this guide, you can successfully integrate OBIEE with PostgreSQL, allowing you to make more data-driven decisions and enhance your organization's analytics capabilities. If you have any questions or need further assistance, feel