Data Connection

Metatron Discovery can connect to an external database directly. To connect to an external database, you must create and manage a data connection containing the access information to that database. By registering such a data connection, you don’t need to enter the access information each time you connect to the same database.

The Data Connection menu can be accessed under MANAGEMENT > Data Storage > Data Connection on the left-hand panel of the main screen.

../../_images/create_datasource_1.en.png

Data connection management home

On the Data Connection home page, you can create, edit and view database connections.

../../_images/data_connection_1.en.png
  • Publish: Filter the data connection list by public workspace.

  • Creator: Filter the data connection list by creator.

  • DB type: Filter the data connection list by database type (MySQL, PostgreSQL, Hive, or Presto).

  • Security: Filter the data connection list by security type (Always connect, connect by user’s account, or connect with ID and password).

  • Created time: Filter the data connection list by time of creation (Today, Last 7 days, or Between).

  • Search: Search the data connection list by data connection name.

  • Number of data connections: Displays how many data connections are returned in the list.

  • New: Click on it to create a new data connection.

  • Delete: Hover the mouse over a data connection to display a recycle bin icon. Click the icon to delete the data connection.

Create a data connection

On the Create data connection screen, enter the required information to create a connection.

../../_images/data_connection_creation.en.png
  • DB type: Four database types are currently supported. (MySQL, PostgreSQL Hive, Presto)

  • Host: Enter the hostname to connect to the database.

  • Port: Enter the port to connect to the database.

  • URL only: Enter a database URL instead of a host and port.

  • User name: Enter the username of the database.

  • Password: Enter the password of the database.

  • Security: Set the type of security to be applied while using the data connection.

    • Always connect: Logs in using the account information the user has entered to create a new data connection.

    • Connect by user’s account: Logs in using the account information registered in Metatron Discovery.

    • Connect with ID and password: Requires to enter the account information every time the data connection is used.

  • Validation check: Checks whether the connection information entered is valid; the result is shown next to the button. The validity of the connection appears below the button.

  • Advanced settings: You can add a custom property key and value as options.

  • Publish: Set which workspaces have access to the data connection.

    • Allow all workspaces to use this data connection: Select this check box to make the data connection available in all workspaces.

    • Edit: Used to allow specific workspaces to access the data connection. This button will disappear if the data connection is set as open data.

    • Number of shared workspaces: Displays how many workspaces have access to the data connection.