Categories
- All Categories
- 162 Oracle Analytics News
- 29 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
OAC Dataset feeding back into an Oracle table (Tableau access workaround)
Answers
-
An error occurred while communicating with the data source
Bad Connection: Tableau could not connect to the data source.
Error Code: 37CE01A3
No details available.
I copied the Server, Service and Port names from the TNSNAMES file located in the Wallet file.
0 -
TNS_ADMIN Environment Variable has been set properly now. I have tried every combination I can of server names, services, and ports from the TNSNAMES to try to connect to Tableau. This is the Tableau Connection to Oracle screen. Can anyone let me know if you have successfully connected your Tableau Desktop to OADW Cloud? And what should I be entering in each field here? Thanks in advance.
0 -
Do you have the OCI Instant Client installed?
0 -
Yes, it is installed. What are we supposed to do next?
0 -
Here are our results:
Also added optional service name and port:
0 -
Try to follow the steps outlined here: https://www.oracle.com/a/ocom/docs/database/adw-connection-instructions-tableau-desktop.pdf
Otherwise, you can try to open an SR- or hire a private contractor to help get you started.
0 -
Change your server to the TNS name you want to use
0 -
Hi Joshua,
Thanks for all your help. Looks like we will creating an SR. Tried _high, _medium, and _low TNS name entries, all of which are located in the TNSNAMES file.
0 -
Last thing to check - did you add you Wallet contents to the OCI Client network/admin folder?
0 -
Also - check that the database user you are signing in with has 'Resource' and 'Connect' privileges
0
