Hi,
Pregame:
I have a Breeze GP Cluster with EngagementDesigner 3.8.0.1.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.

Issue:
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.

Any hints?
Thanks
Markus

Addition:
In the EngagmentDesigner Logfile I get this output:

ct","properties":{}},"variables":[],"schemaId":"uuidGlobalVariables1234567890","title":"GlobalVariables"}

2021-11-10 09:50:20,886 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: providerName = PostgresJDBC83

2021-11-10 09:50:20,886 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: providerName = postgresJDBC

2021-11-10 09:50:20,886 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = ContactManager1

2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = ContactManager2

2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = ContactManager3

2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = BL

2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: providerName = MSSQL

2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = MSSQLTest2

2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = MSSQLM

2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - writeResponse_doPropertyFill {"returnString":[["BL","MSSQLM"]],"returnValue":true}

Here we see that the JDBC configuration is read for all configured sources, but in the result list I get only two of them.

Why?

How can I use all of my configured JDBC sources?

Markus

Hi Markus,
Could you please check if the following properties are available for the missing datasources.

Url
Validation query
Username
Password

If anyone of them is missing/blank then that datasource will not be added to the list.