Translate

Tuesday, 31 March 2015

BI Publisher JDBC Teradata Connection



Teradata Connection in BI Publisher

Connection Type : Teradata JDBC

Shahed Munir --- DELIVERBI


I could see a database connection type of Teradata in BI Publisher but it would not connect.

If there is an error would be something like this : java.sql.SQLException: No suitable driver found for jdbc:teradata:

These are the steps to make it work....


1.Get Files  terajdbc4.jar,tdgssconfig.jar,jtds-1.3.1.jar from Teradata Website . I will put these files in the deliverbi box location or email us for the files...

Link to Files : Click Here to Download Zip file from DeliverBI

2. FTP or goto Server Location for weblogic path MW_HOME is your mw home directory : 

MW_HOME/user_projects/domains/bifoundation_domain/lib

3. Stop all BI Services including weblogic and Copy the files above to the location above 1-2.

4.  Take a backup of the weblogic temporary files in the below location and place in another location and then delete folders .. This will clear the Bipublisher application Cache: 

MW_HOME\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\bipublisher_11.1.1

Once BI Publisher is accessed the application cache is restored and you will see the folders again. I took a back up as i wanted to be sure....

5. Start all BI Services

6. Test Connection - Should say Connection Established Successfully.



Good Luck.. Over and Out.

No comments:

Post a Comment

Google Big Query Clone / Copy DataSets / Tables - PROD --> TEST --> DEV Projects

Google Big Query Cloning of Datasets & Tables across GCS Projects. We searched the internet and could not find a simple cloning / ...