Connections

Visual DB supports various relational database management system (RDBMS) data sources, including PostgreSQL, MySQL, MariaDB, SQL Server and Oracle. Rather than requiring you to use an RDBMS that is built into Visual DB, it allows you to use your own. Relational databases often act as integration hubs, with multiple business applications and tools accessing and updating the same data. By using your own database you ensure that the database can be used with multiple applications beyond just Visual DB.

Adding a Connection

Use the connections tab to set up connections to database servers. You will need to know the host name or IP address of the database server, and the username and password for the database. The credentials you enter will be used to connect to the database when the forms, reports and sheets in your application are used. Visual DB stores the password in an encrypted format.

Only Visual DB users with the Database Admin or Owner role can view connection settings. Additionally, as a security precaution, the connection dialogs will not display the password stored by Visual DB.

Note

The Visual DB service is located in the cloud and it can only connect to RDBMS servers that are also in the cloud. It cannot connect to RDBMS servers running on your own computer, or in your company’s intranet.

Whitelisting Visual DB

Visual DB supports cloud database services such as Neon and Supabase, and traditional cloud providers such as Microsoft Azure, Google Cloud and Amazon Web Services. Traditional cloud providers typically only allow database connections from whitelisted (i.e., explicitly permitted) IP addresses. The method for whitelisting IP addresses varies depending on the cloud provider. Visual DB’s IP address, which needs to be whitelisted, is displayed in the Connection dialogs.