Sage CRM 2023 R1 external database connection only can be use to create one table

Team,

We running Sage CRM 2023 R1, I create a new database connection to our ERP 2021 database, then create a new table connection using this database connection, everything is perfect, however when I try to create second table connection using the same database connection, it failed. I have to create a second database connection link to same ERP database, and can create second table connection without issue. Is this true? One database connection can not be used for multiple table connection?

Thank you.

  • 0

    Hiya

    There is a known issue with the display of external database connections.  BUT you can still do it.

    It may look like you can't connect to another table.  In my case I have a connection to a database called "PanoplyTech2024" and a table called "Contacts".

    But you can still attached to the database when choosing to create a new Table Connection.