PostgreSQL

Connecting a PostgresSQL Data Source

To integrate a PostgreSQL database into your Typper BI environment, follow the comprehensive steps below:

1

Choose the Data Source Type

1. Navigate to the ‘Add Data Source’ page in your Typper BI dashboard.
2. Under the ‘Databases’ section, select the ‘MongoDB’ option.

2

Add Data Source Connection Details

Provide the necessary connection details in the form fields:

2. URL: Enter the full database URL in the format postgresql://username:password@hostname:port/database?options.
3. Data Source Name: Assign a unique name for easy identification of your database within Typper BI.
4. Typper BI IP Address: Ensure that the Typper BI’s IP address is whitelisted in your firewall settings to establish a successful connection.

34.16.94.3

3

Select the Schemas to Use

1. Once the database connection is successful, you’ll be prompted to select the schemas you wish to use.
2. Choose the relevant schemas that contain the data needed for your analytics.

4

Schemas Verification

Typper BI will load and verify the tables from the selected schemas. You might have to wait a few moments while the system processes the tables.

5

Confirm the Tables and Columns

1. After schemas are loaded, select the tables and specific columns you need for your reports.
2. You can add descriptions to each table to provide context for our AI.

6

Finalize Adding Your Data Source

1. Review all the details and ensure that everything is correctly set up.
2. Click ‘Add Data Source’ to complete the process.