BI.P.EYE
  • Overview
    • Platform Overview
    • Main Features
    • Credentials
      • Databases
        • PostgresSQL
          • Create a read-only user in PostgreSQL
          • Test and save your credentials
    • Datasets
      • Create a PostgreSQL dataset (SQL + AI)
      • AI ChatBot to SQL
    • Dashboards
      • Types of Charts
        • Bar
        • Horizontal
        • Doughnut
        • Pie
        • Line
        • Table
        • Scorecard
        • World Heat Map
        • Bubble Map
        • Google Maps
        • Stacked Bar
        • Polar
        • Title
    • Embed Dashboards
      • Embed dashboards - restriced data per API KEY
    • Filters
      • Dashboard Filters
      • Override Parameters
      • Built in functions
  • Use Cases
    • Bubble.io Integration
Powered by GitBook
On this page
  • Collecting data from a database:
  • Security recommendation:
  1. Overview
  2. Credentials

Databases

Collecting data from a database requires a quick setup, enabling you to easily begin analyzing data.

PreviousCredentialsNextPostgresSQL

Last updated 3 months ago

We support different databases: PostgreSQL, MySQL, SQL Server, and Redshift.

Collecting data from a database:

To collect data from a database and create a chart, follow these steps:

  1. Test and save your credentials for the database.

  2. Write a query or use our AI chatbot to generate a query for you.

  3. Run the query and view the data.

  4. Define a data pipeline to handle filters, date formats, calculations, and other requirements.

  5. Save the dataset.

  6. Create a dashboard and add charts connected to the dataset.

Security recommendation:

For security purposes, we recommend the following:

  2. Grant the necessary privileges to the read-only user, ensuring they only have read access to specific tables.

  3. Whitelist our IP addresses in your firewall to allow direct connections from BI.P.EYE servers to the database servers. 34.231.210.203, 18.204.26.186

Create a user with read-only permissions.