In the .json file i have connection information for Amazon Redshift and im publishing to Tableau server.
So i have credentials for those.
But in Tableau Prep, i Have a connection to an excel file.
So, i guess i have multiple connections..
I decided to break the problem into parts.
I created a flow that connects to a file on my pc then publishes the output to another location on my pc, this worked.
Then i created a flow that connects to a file on my pc then publishes the output to tableau Server, this worked too.
My problem seems to be doing this from an input connection to a database then publish to server.
The data source i work with mostly is Amazon Redshift.
i will try other data sources and see if i have a problem with databases generally or just Redshift.
I have a flow file which has two input nodes connects to the same mysql database. I copy the same identical blocks in the json file to make sure the number of input connections matches the number of remote input nodes in the flow file, then it works. Could you please try that and make sure that you have the correct format of json file? here is what is in my json file:
"password": "****" },
"password": "****" }
My issue has now been fixed after implementing the following:
- upgrade to 2018.2.3
- server restart
- repair of install
- duplicated (comma-separated) input connection (port left out)
- output connection as visualized by Flavia above (both serverurl and contenturl required)
Just wanted to follow up to see if you have gotten your "Unable to read the connections file" issue resolved. I am having the same issue (I also have multiple connections to the same SQL server within my Tableau Prep file)