bdcs

Oracle OAC Provisioning

This tutorial shows you how to provision your first Oracle Analytic Cloud Services.

Login to OAC

$ su - oracle
$ cd  /bi/domain/fmw/user_projects/domains/bi/config/fmwconfig/bienv/core
$ vi odbc.ini
[HiveODBC]
Driver=/bi/app/fmw/oracle_common/../bi/modules/oracle.bi.datadirect.odbc/8.0.2/lib/ARhive28.so
Description=Oracle 8.0 Apache Hive Wire Protocol
ArraySize=16384
Database=bigdata_prd
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
HostName=129.154.85.159
LoginTimeout=30
MaxVarcharSize=2000
PortNumber=10000
RemoveColumnQualifiers=0
StringDescribeType=12
TransactionMode=0
UseCurrentSchema=0

 

Happy learning guys!