Using the connections section, many different types of connections can be managed. Connections are used by many of the features within FlowWright. One centralized place to maintain connections to databases, oAuth, and others.
Database Connections
FlowWright supports OLE DB based database connections. If OLE DB drivers are required, install them on the server. Select the “Actions -> Create” menu item to create a new database connection.
Database connections can be created, updated, removed, and tested using the “Actions” menu:
Database details
Use this feature to view the database tables and their table structure. The connection names are listed in the table as shown in below UI. Select the connection row and click on “Utils - DB Details” menu option.
The table names belonging to the selected connection database are listed in the left pane. Click on the table to view the column names and data type information.
Update database connection configuration
Connections.config file contains all connection string used by the UI and the engines, this configuration file can be updated from the stored connections by selecting the “Utils - Update Configuration" menu item.