SQL and NoSQL DB Connectors

Aside from your local PC, you can also have stored remotely data in data warehouses thus papAI integrates some Database connectors, either SQL or NoSQL based and even Cloud storage. The goal of this tool is to simplify the process of importing these types of data into your project's flow without having to download them on your local machine and losing time and storage as well.

First of all, you need to create your connection to your desired database by selecting the Connections icon through the Import a dataset button or through your papAI profile on the top right corner.

Connections icon through project's main page
or

Connections icon through your profile tab

In the Connections interface, you can select which type of database you want to connect with papAI. We have a huge catalogue of database connectors included into the platform such as :

• SQL type Databases :

  • PostGresSQL
  • MySQL
  • Microsoft SQL Server
  • Oracle
  • Snowflake

• NoSQL type Databases :

  • MongoDB
  • ElasticSearch
  • Cassandra

• Object based storage :

  • Amazon S3
  • Microsoft Azure Blob Storage
  • Google Cloud Storage

Connectors interface

When you chose the right connector to the database, all you need is typing your credentials to connect to the database and test the connection. If the connection status is up then you are suited up to import any dataset directly from that database onto your projects.

Connection access credentials interface

Through that existing connection, you only select the dataset needed and go through the regular settings just as a locally imported dataset and click the Create button. It will appear on your project's flow, ready to be used for any operation available in papAI.

Database dataset import interface

Here is a demo using DB connectors