-
1. Re: OBIEE RPD Integration with Tableau
diego.medrano Mar 22, 2017 4:08 PM (in response to Avinash Pentyala)Hey Avinash,
This thread may help you. Looks like some people have been successful connecting to the DB used by OBIEE:
Oracle Business Intelligence (OBIEE) & Tableau
-Diego
-
2. Re: OBIEE RPD Integration with Tableau
Milan Desai Aug 7, 2017 1:57 PM (in response to Avinash Pentyala)Hi,
We have built a connector that successfully connects OBIEE RPD and underlying data sources and publishes a Tableau Data source file on Tableau server. This solution has been implemented for couple of large enterprise clients of Oracle and Tableau. The solution is a server based connector and no need for any desktop set up. The connector allows other key features like defining the joins as per Tableau requirements, filters, changing / renaming columns and tables, and a workflow to publish a curated subject area as a data source on the tableau server. The connector provides an ability to connect to the underlying data sources so no need to go through the slow processing speed of OBIEE server and leverage complete VizQL power of Tableau to build your dashboards. For more information please write to me.
-
3. Re: OBIEE RPD Integration with Tableau
prasad billahalli Jan 29, 2018 6:28 AM (in response to Milan Desai)Hi Milan,
We are having similar need .. wherein we need to use OBIEE RPD has source and tender reports onto Tableau.
Can you please provide insight of your connector .. it would be really great help?
Thanks & Regards,
Prasad S Billahalli
-
4. Re: OBIEE RPD Integration with Tableau
Milan Desai Jan 29, 2018 9:58 AM (in response to prasad billahalli)Hi Prasad,
Pl send me your email and contact information so that I can send you some material on this subject.
Regards,
Milan Desai
913-948-1055
-
5. Re: OBIEE RPD Integration with Tableau
prasad billahalli Jan 29, 2018 10:50 PM (in response to Milan Desai)Hi Milan,
Thanks for the response.
Please send the details at prasad_billahalli@infosys.com and prasadbillahalli@gmail.com.
I am grateful for your help.
Regards,
Prasad S Billahalli
9880030090
Bangalore, Karnataka
India
-
6. Re: OBIEE RPD Integration with Tableau
sureshkumar.vankayala.3 Mar 19, 2018 2:12 AM (in response to Milan Desai)Hi Milan,,
Can you please send information on OBIEE rpd and Tableau integration part to my email
Regards
Suresh
-
7. Re: OBIEE RPD Integration with Tableau
RAHUL PATEL Apr 5, 2018 7:33 AM (in response to Avinash Pentyala)Hi Milan,
I am able to connect Oracle BI server using Oracle BI Server ODBC driver on Tableau Desktop and able to get data on tableau desktop, but on Tableau server i am getting below error
- The drivers necessary to connect to the database server '192.168.0.104' are not properly installed on Tableau Server.
- Specified driver could not be loaded due to system error 5: Access is denied. (Oracle BI server, C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\server\bin\nqsodbc64.dll).
- Generic ODBC requires additional configuration. The driver and DSN (data source name) must be installed and configured to match the connection.
- Unable to connect using the DSN named "DemoBIServer". Check that the DSN exists and is a valid connection.
FYI, DemoBIserver is created on Same Tableau Server machine as system DSN. Oracle BI Server driver is also installed on same machine. OBIEE is also accessible from tableau server machine. Folder of dll is also have full permission, I am using Windows machine only for tableau server.
-
8. Re: OBIEE RPD Integration with Tableau
Shankar Radhakrishnan Oct 24, 2018 4:49 PM (in response to RAHUL PATEL)Hi,
Did you install the obiee client on the server and is the driver installed with the same user as Tableau server service user? Getting Tableau to work with OBIEE driver is cumbersome. You would need to make extensive changes in presentation layer depending on your subject area, the performance problems would be plenty since Tableau queries are not optimized for OBIEE. The following article discusses some of those issues:
How to Connect to Oracle BI Server with Tableau without the shortcomings of Oracle ODBC driver
We developed BI Connector specifically to address these issues and make it easy to use OBIEE as a data source.
Thanks
Shankar
-
9. Re: OBIEE RPD Integration with Tableau
Narayana Pola Nov 2, 2018 4:03 AM (in response to Milan Desai)Hi Milan,
We have the same problem. Can you send us your solution/write-up to narayana.murthy.pola@gmail.com
Thanks,
Narayana Murthy