Refreshing Flow Output From Command Line Error "The following connection(s) were not found: <data source server>"
Published: 28 Nov 2019 Last Modified Date: 09 Mar 2020
When refreshing flow output files from the command line, the following error may occur:
"We don't have credentials of all connections in tfl/tflx file. The following connection(s) were not found: <data source server>"
Tableau Prep Builder
Command Line Interface
Flow connecting to databases
Ensure the connection details in the credentials .json file is set up the EXACT same way as the connection string to the database server when the Tableau flow file (.tfl) was initially created. Meaning, if the connection string to the database server does not have a port/service, then do not include a port/service value in the .json credentials file under Input Connections.
Steps to check:
Open the flow in Tableau Prep Builder.
Select the connection to the database > Edit connection.
Choose the database server specified under Server.
Open your .json credentials file.
Pay attention to the Input Connections and make sure it matches the Edit Connection details in the flow.
If there are NO ports specified in Edit Connections, then do NOT specify a port in json credentials file.
When you run the process, the hostname, port and username provided in the credentials .json file is used to find the matching connection in the Tableau flow file (tfl) and update it before running the process
Thank you for providing your feedback on the effectiveness of the article.