Connect a data source

Fresco BI only reads from your source: it lists schemas, tables and columns, then imports the tables you pick into a Data Table.

Prerequisites

• The host name and port of the source, and the database name.
• A user that can read the tables you need and cannot write.

Step 1: Create a read-only user

Ask your database administrator for a user with SELECT on the tables you want, plus permission to list schemas, tables and columns. Do not use an administrator account.

Step 2: Allow network access

Cloud. Allow inbound connections from Fresco BI’s outbound IP addresses (the setup guide beside the data source form lists them) on the database port.

On-premises (via Gateway). If the source is inside your private network and the form offers it, choose On-premises (via Gateway); this panel then switches to the Gateway guide.

Step 3: Fill in the form

1. Enter a name, the host, port, database, user and password.
2. Pick the SSL mode. Modes that check the certificate show a CA certificate field.
3. Click Test connection, fix what the test reports, then click Save.

Troubleshooting

• The server rejected the user name or password. Check the user and password.
• No connection could be opened to this host and port. Check the host, the port, and that the firewall allows Fresco BI’s IP. Allow Fresco BI’s outbound IP addresses (the setup guide beside the data source form lists them) on the firewall.
• The SSL connection could not be set up with the chosen mode. Check the SSL mode and the CA certificate. Pick a mode the server supports, or paste the right CA certificate.