Data Sources

Before you start working with datapine you will need to connect the data that you wish to analyze. In our software, all those connections to your data are called data sources. You can manage your data sources in the settings section. There you can add, edit, merge, update or remove your data sources.


When you start your trial in datapine, your account will be already connected to our Demo Database. This database is great to take a spin in our software and to get to know the functionality and options it offers. However as soon as you want to build your own KPIs and metrics you will need to import or connect your own data sources first.


In this section, you will find all information regarding available data connections, our connectivity settings and how to connect your data sources securely to datapine. If you can’t find your preferred data source in the dropdown menu on the left or if you experience problems connecting your database, please feel free to contact us at to discuss how we can help you to connect datapine to your data. Let’s take a closer look at the different data sources we support.


1) Databases


Relational databases are a common data source that you can easily connect to datapine. Each database will thereby represent an individual data connection. In this section, you will find information regarding the different database connections and storage options we offer as well as learn how to prepare and how to connect your database to our software.


2) Flat Files


In this section, you will learn how to prepare, upload and update your CSV files to datapine. Flat files such as CSVs can be easily imported into datapine with just a few clicks. You can query, visualize and also cross-query them with other data sources. When importing a flat file, datapine tries to automatically detect column data types, controls for broken values and ensures straightforward automated updates.


Before you start connecting a CSV file, you should decide whether you want to upload this file once or if you wish to update the file regularly. We offer you two different ways to upload or connect your CSV file to datapine:


a) Upload files directly from your computer
b) Connect files via link from cloud storage services like dropbox, Google Drive or Box.


3) Social Media


Connecting datapine to your web or social media data is quite easy and can be setup in just a few steps. We offer build-in, direct connections to your Google Analytics or Facebook Accounts as well as custom developed connections to other social media platforms such as Twitter or Instagram. In this documentation you will find information on how to connect datapine to your Google Analytics AccountFacebook Insights and Facebook Ads with no effort.


4) APIs and other Platforms


In this section, we will provide you with an overview of customized connections we offer as well as a guide on how to connect your custom database to datapine. Many online platforms and web services, such as Google Analytics and Facebook, expose their data through a web API. We use such standard custom connectors to import data from these services directly into datapine. We also offer customized API connections and database connections that allow you to pull in all data you need for your analysis.


5) database access


In this section, you will learn how to prepare your database for a successful direct database connection and how to setup your firewall settings to allow datapine to access your database. Before you start connecting your databases, you might need to make some adjustments to allow datapine to access your database. We generally offer two methods of connecting your database: direct database connection or SSH Tunnel connection. A direct connection is thereby the easiest way of connecting your database to datapine while setting up a SSH Tunnel is the safer option and often necessary if your database is located on a private network.


6) Join Data Sources


In this section, you will learn how to join multiple data sources and how to prepare your databases to perform cross-database queries. Being able to match and unify data from multiple data sources is critical to get actionable insights out of your data. datapine enables you to join different types of data sources, run cross-database queries on the fly and perform advanced calculations on data stored in various locations. In datapine you can link flat files to other files and also databases or connect one database to another.