Starting from OBIEE 12c Oracle has started supporting the Amazon Cloud database Redshift as a data source. This is very good news as there are lot of clients waiting for using the cloud data sources with OBIEE. Below are the high level steps on configuring the ODBC driver on Linux to use in connection pool.
Below are the high level steps
Download and install Amazon Redshift ODBC driver to access Amazon Redshift data warehouse. Follow the instructions provided in Amazon Redshift documentation.
Note: By default, Amazon Redshift drivers are installed in the following directories
/opt/amazon/redshiftodbc/lib/32 (for a 32-bit driver)
/opt/amazon/redshiftodbc/lib/64 (for a 64-bit driver)
Add the following to odbcinst.ini file
[Driver]
.
.
DriverManagerEncoding=UTF-16
4. dbfeatures.ini
Copy the attached dbfeatures.ini file to BI server config directory, /config/fmwconfig/biconfig/OBIS
Setting Up Database Objects and Connection Pools
Install Amazon Redshift ODBC driver for windows. Create a system DSN.
Set connection pool call interface to “ODBC 3.5”
Below are the high level steps
- Installing Driver
- Configuration of ODBC parameters
- Configure Connection Pool
Installing the Driver
Download and install Amazon Redshift ODBC driver to access Amazon Redshift data warehouse. Follow the instructions provided in Amazon Redshift documentation.
Note: By default, Amazon Redshift drivers are installed in the following directories
/opt/amazon/redshiftodbc/lib/32 (for a 32-bit driver)
/opt/amazon/redshiftodbc/lib/64 (for a 64-bit driver)
Configure connectivity to Amazon Redshift
The following files has to be edited to configure Oracle BI server connectivity to Amazon Redshift :
1. odbc.ini
2. odbcinst.ini
3. amazon.redshiftodbc.ini
4. Copy dbfeatures.ini
Note: The following edits to files assume that the Amazon Redshift drivers are installed under “/opt/amazon/redshiftodbc/lib/64”.
1. odbc.ini
Add the following to odbc.ini file
The following files has to be edited to configure Oracle BI server connectivity to Amazon Redshift :
1. odbc.ini
2. odbcinst.ini
3. amazon.redshiftodbc.ini
4. Copy dbfeatures.ini
Note: The following edits to files assume that the Amazon Redshift drivers are installed under “/opt/amazon/redshiftodbc/lib/64”.
1. odbc.ini
Add the following to odbc.ini file
[ODBC Data Sources]
.
.
.
RedShift=installed
[RedShift]
Description=Amazon Redshift ODBC
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so(default location, once you upgrade or reinstall the driver, file name may change)
ServerName=
Port=
Database=
locale=en-US
QueryTimeout=2000
ProxyHost=
ProxyPort=
2. odbcinst.ini
Add the following to odbcinst.ini file
[ODBC Drivers]
.
.
.
RedShift=installed
[RedShift]
Description=Amazon Redshift ODBC Driver (64-bit)
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so
.
.
.
RedShift=installed
[RedShift]
Description=Amazon Redshift ODBC Driver (64-bit)
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so
3. amazon.redshiftodbc.ini
Edit “/opt/amazon/redshiftodbc/lib/64/amazon.redshiftodbc.ini” and update the following.
Edit “/opt/amazon/redshiftodbc/lib/64/amazon.redshiftodbc.ini” and update the following.
[Driver]
.
.
DriverManagerEncoding=UTF-16
4. dbfeatures.ini
Setting Up Database Objects and Connection Pools
Install Amazon Redshift ODBC driver for windows. Create a system DSN.
Set the database type to “ODBC Basic” or “ODBC Advanced” in connection pool properties
Set connection pool call interface to “ODBC 3.5”
To know more about the data warehouse services, you can check out the official site of the service provided at any time.
ReplyDeleteAdata mart is a data warehouse that is designed to answer a specific set of business questions without duplicating any information from the data warehouse. Data marts provide faster data access, but they don’t have to adhere to the verification, consistency, and completeness requirements of a data warehouse. Data marts are great for business users who need to quickly access information, either in a stand-alone format or in conjunction with other data marts.
ReplyDeleteA data mart is a Data Warehouse Service that is designed to answer a specific set of business questions without duplicating any information from the data warehouse. Data marts provide faster data access, but they don’t have to adhere to the verification, consistency, and completeness requirements of a data warehouse. Data marts are great for business users who need to quickly access information, either in a stand-alone format or in conjunction with other data marts.
ReplyDelete