01. Add datasource

Click Datasources. > Datasources

Name your Datasource so it’s easy to identify, then choose the type. The driver and port will auto populate.

02. Add connection settings

Enter the Hostname and default database.

Enter the user name and password

Click Preview to view the SQL statement that creates the Datasource in mamori server.

03. Add connection settings (optional)

Check Advanced Options.

Enter any required settings.

Setting Description
Custom Connection String A custom JDBC connection string to use instead of a generated JDBC connection string
Connection Properties Additional JDBC connection properties to add to the generated JDBC connection string
Connection URL Suffix Suffix to append to the generated JDBC connection string.
Mamori properties  
Pool minimum/maximum/idle timeout/max lifetime cache of database connections available during a session
Use the same LDAP credentials…  
Database object names are case sensitive mamori assumes lower-case object names unless this option is checked.
Execute meta-data calls in smaller parallel calls  

Check Enable Datasource for Data Movement and Advanced settings if the database is to be used for data movement.

04. Save and close

Click Save to finish.