Connect to a Data Store

This page shows you how to add and configure a connection to a database. This connection allows Baffle Manager to enumerate fields or columns. The fields or columns can then be selected as part of a data privacy policy, to enable column level encryption. You can choose from the following supported databases:

  • AWS RDS – Aurora MySQL
  • AWS RDS – MariaDB
  • AWS RDS – MySQL
  • AWS RDS – SQL Server
  • AWS Redshift
  • Azure SQL
  • Azure MySQL
  • MariaDB
  • MySQL
  • Postgres – required for IBM Cloud
  • SQL Server

To add and connect to a data store, do the following:

  1. Click the database icon in the left navigation panel. A list of configured databases appears.
    Database_icon.png
  2. Click +DATABASE in the upper right corner of the window to add a data store.

    DataStore__Database.png
  3. In the Add Database dialog, enter a name and description for the database.
  4. Select a Database Type from the drop-down list.
  5. Enter the Hostname or IP Address (endpoint) for the database.
    NOTE: For an AWS RDS database, enter the endpoint URL.
  6. Enter the Port for the database. Default database ports are listed in the Port Requirements table. 
  7. Enter the user Database Username and Database Credential.
    NOTE: Review the following items before specifying a database:
    – Create a new user on your database for use with Baffle. For more information, see Database Privileges.
    – For IBM Cloud use a Postgres database and enter your database name in the Postgres Database Name field. In the following example, we entered ibmclouddb.

    IBMC_Add-Database-Postgres.png

    – For all Postgres configurations,
    enter the name of your database in the ‘Postgres Database Name' field. Otherwise, Baffle Manager tries to connect to a database with the same name as your database username. If no such database exists, then the connection attempt fails. The default database name is postgres.
    – Example of an SQL Server configuration:

    DataStore_MS_SQL_Server_config.png
  8. Optional: Select Use SSL, click Add file, and upload an SSL Certificate.
    IMPORTANT! NOTE: Currently, the SSL connection from AWS RDS databases to Baffle Manager requires the use of a RDS root certificate. The AWS certificate bundle is not currently supported. For more information, see the Amazon AWS documentation for Using SSL/TLS to encrypt a connection to a DB instance.

  9. Click Add Database to complete enrollment. The new database appears in the list of configured databases.

Next Steps:




 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.