Adding your data
Datawisp can
Connect to your existing infrastructure (databases, data warehouses, data lakes, ...) If you already have your data stored in some form of database, this is the recommended approach. Data is processed on your infrastructure. The full dataset is never copied.
Work with files uploaded to Datawisp (Excel, CSV, JSON, ...) Alternatively, you can upload documents to Datawisp. In that case, the Datawisp servers will store and process the data.
Supported data sources
Data warehouse platforms
Snowflake
Google BigQuery
AWS Redshift
MotherDuck
PlanetScale
Databases
MariaDB
MySQL
MariaDB
Microsoft SQL Server
PostgreSQL
Note: databases are supported regardless of your provider. Datawisp supports EC2, Google Cloud databases, Azure Database, PlanetScale, ...)
Files
Excel (xlsx)
JSON
CSV
Google Sheets
Note: to import a Google Sheet, link sharing must be enabled ("Anyone with the link can see").
Other Applications, CRMS, Analytics Tools, ...
Datawisp supports other tools, such as:
Google Analytics
Firebase
Honeycomb
AppsFlyer
...
Many applications like those allow Datawisp to connect directly to them via a data platform (e.g. Google Analytics / Firebase data can be accessed via BigQuery) with a little setup. In most other cases, our onboarding team will help you connect the data to Datawisp.
Overview
Typically, our team will help you add your data to Datawisp. This is included in every Datawisp subscription, including free trials.
Data is always added to Datawisp via the data page, which you can access on the left sidebar.
To add data, you can use the "Add Data" button. For some data sources, you can find additional help on one of the subpages. And if you have any trouble, please don't hesitate to ask.
Data Dictionaries
After adding your data to Datawisp, we recommend adding a Data Dictionary.
Security
Datawisp always connects to your database via an encrypted connection.
TLS Certificates
Many cloud providers unfortunately do not deploy valid certificates for their databases. In this case, Datawisp will offer you to pin the certificate it receives at import time. After a certificate is pinned, Datawisp will refuse to connect if your database sends a different certificate.
Whitelisting
To allow Datawisp to connect to your database, you may need to whitelist Datawisp's IP in the respective firewall. The current IP is always shown in the add data view.
Please refer to the documentation of your firewall if Datawisp is unable to connect to your database. If you still need help, don't hesitate to reach out to our team.
Private Networks, NATs, Gateways, VPNs, Private Clouds, ...
If your setup requires additional authentication to connect to the database, please reach out to our team.
Last updated