Connecting to Database

In order to connect to database, you need to provide database connection settings.

How to connect

You will need to provide values for following:

• Database TypeSelect type of database
• NameGive your data source a name for use within Bappaz. ‍
• DescriptionOptional description for database.
• HostThe hostname or IP address of your database. ‍
• PortPort to connect to. ‍
• User NameCredentials to use to connect to the database.‍
• PasswordCredentials to use to connect to the database.‍
• Database NameThe name of the database (this must match the actual name of your database).
• Schema NameOptional name of Schema in database.

Note: For Bappaz to be able to connect to your database, it must be publicly accessible, and configured to accept connections from BAPPAZ IP address

Permissions

For PostgresSQL

SELECT permissions to the INFORMATION_SCHEMA schema in order to read your database information and create meta data dictionary.

For Oracle

SELECT permissions to the DATA DICTIONARY in order to read your database information and create meta data dictionary.

For MySql

SELECT permissions to the INFORMATION_SCHEMA schema in order to read your database information and create meta data dictionary.

For Microsoft SQL Server

SELECT permissions to the INFORMATION_SCHEMA schema in order to read your database information and create meta data dictionary.