Sidebar

How can I manage multiple database connections to the same database in QIE

0 votes
409 views
asked Oct 24, 2013 by gary-t-8719 (14,860 points)
Is there a better way to manage multiple database connections to the same database that may exist across multiple zones in QIE?

1 Answer

+1 vote
 
Best answer
When using multiple zones in QIE for different channels that may need to have access to the same database connection it is often easier to promote one of the existing Database Connections to the Global Database Connections area. This will then make that database connection available for use to all channels across all zones. This will also reduce the number of connections that need to be managed should an element about the connection changes like the user name or password.

To promote an existing database connection to the Global area, navigate to the Zone that has the current database connection and select the Database Connection. Then select the link titled “Promote to Global Connection” next to the Save and Cancel button. This will then move the database connection from that zone to the Global Settings area. No other changes are needed. All existing reference to that connection in your mappings will be updated automatically to reference the connection in the Global Settings area.
answered Oct 24, 2013 by gary-t-8719 (14,860 points)
selected Dec 17, 2013 by ron-s-6919
...