Support & Forums
Labs & Sandboxes
I have a Breeze GP Cluster with EngagementDesigner 22.214.171.124.105001 up and running.
I configured seven JDBC Sources hosted on three different database servers.
Some of them are Postgres the others are MSSQL.
For both database engines the JDBC Drivers are installed in Breeze.
For all seven JDBC Sources the "TestConnection" is executed successfully.
Breeze has been rebooted several times after the JDBC Source were configured.
When I create a new Workflow in ED using the ReadFromDB task, I get only two of my seven configured databases for selection.
The two JDBCSource which I can select from drop down is one Postgres and one MSSQL. So I know that both drivers are installed correctly. (Screenshots are attached)
Why I do not get the other five databases for selection?
I didn't find any restrictions in the documentation.
In the EngagmentDesigner Logfile I get this output:
Here we see that the JDBC configuration is read for all configured sources, but in the result list I get only two of them.
How can I use all of my configured JDBC sources?
Could you please check if the following properties are available for the missing datasources.
If anyone of them is missing/blank then that datasource will not be added to the list.