Skip to main content

Connecting BI and Database Tools

A reporting or BI tool can read CRM data directly through a database connection. The service account supplies the user name and password for that connection. The bank's analyst in this example uses a PostgreSQL connection to build reports in a BI tool.

Create Service Account form with the How to connect BI and DB tools section expanded, showing the driver, host, port, database name, user name and password fields

Figure 1. The BI and database help section, listing the connection settings a tool needs.

Connection Settings​

SettingValue
Driver or enginePostgreSQL
Host or serverYour UNICONNECT AI address, for example yourcompany.example.com
Port15432
Database nameuniconnect
User nameThe Client ID of the service account
PasswordThe credential of the service account

Connecting a Tool​

  1. Add a PostgreSQL data source in the BI tool.
  2. Enter the host, port and database name from the table above.
  3. Enter the Client ID as the user name and the credential as the password.
  4. Test the connection, then choose the tables to use.
info

The copy icon beside each value in the help section copies it, so nothing has to be typed.

tip

Use a separate service account for each BI tool. If one tool is retired, its account can be removed without affecting the others.