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

Choose the Data Source Type

add_a_data_source
  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

add_a_data_sourceProvide the necessary connection details in the form fields:
  1. URL: Enter the full database URL in the format postgresql://username:password@hostname:port/database?options.
  2. Data Source Name: Assign a unique name for easy identification of your database within Typper BI.
  3. 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

add_a_data_source
  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

add_a_data_sourceTypper 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

add_a_data_source
  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

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