If there are many databases available to ODBC within a project, then when the user looks at their preferences page to understand ODBC details, the page looks unwieldy. I have 2 suggestions that should both be used:
On the preferences page, instead of a table like
Project Name | Server | Port | ORDS DB Name : Database name
xxa : main_444_445
xxb : main_446_447
xxc : main_448_448
xxd : main_450_451
project 1 serv.com 5432 xxe : main_452_453
xxf : main_454_455
xxg : main_456_457
xxh : main_458_459
xxi : main_460_461
We should have a series of the following "entities", one per project
Project: project 1
Server: serv.com
Port: 5432
then two tables, side by side ...
ORDS DB Name | Database name ORDS DB Name | Database name
xxa main_444_445 xxb main_446_447
xxc main_444_445 xxd main_446_447
... etc
When projects have ODBC enabled, there should be an button on the project page that will display just the relevant project "entity"
If there are many databases available to ODBC within a project, then when the user looks at their preferences page to understand ODBC details, the page looks unwieldy. I have 2 suggestions that should both be used:
Project Name | Server | Port | ORDS DB Name : Database name xxa : main_444_445 xxb : main_446_447 xxc : main_448_448 xxd : main_450_451 project 1 serv.com 5432 xxe : main_452_453 xxf : main_454_455 xxg : main_456_457 xxh : main_458_459 xxi : main_460_461
We should have a series of the following "entities", one per project
Project: project 1 Server: serv.com Port: 5432 then two tables, side by side ... ORDS DB Name | Database name ORDS DB Name | Database name xxa main_444_445 xxb main_446_447 xxc main_444_445 xxd main_446_447 ... etc