The Data Integration Platform You've Been Looking For
More than 500+ connectors. Smart connectors.
Smart Connectors
Our connectors were built by our development team to be efficient, fast and to perform data processing “on the fly” saving you hours of trying to understand how to get your data from your favorite application or API in a way that you can do something with it right away.
We have hundreds of structures of well known systems ready to be used in your tables and all our Smart Connectors take care of throttling, authentication and paging for you automatically.
See all our Smart ConnectorsWe have hundreds of structures of well known systems ready to be used in your tables and all our Smart Connectors take care of throttling, authentication and paging for you automatically.
Smart Views
Connecting to the data sources is sometimes the easy part but getting data from multi purpose APIs is a little harder. Our Smart Views take care of that.
We make sure that data comes ready for analysis even if it requires multiple calls to the API or service. Additionally, we perform data validation as we receive the data.
See all our ConnectorsWe make sure that data comes ready for analysis even if it requires multiple calls to the API or service. Additionally, we perform data validation as we receive the data.
Finally, we understand how to bring data that has been added or modified since the last data refresh making it fast and easy to keep it updated.
API Connectors
Just because applications have an API it does not mean they all follow the same standards or behave the same way.
Our Web Service for REST/SOAP and GraphQL Connectors, are the Postman equivalent of flexible data connectors for your data pipeline! These are some of the features:
- SOAP 1.1, 1.1, REST and GraphQL
- XML, JSON, Text and Delimited payloads
- 15 Pagination modes
- Multiple Throttling capabilities
- 8 Authentication Methods (Oauth, basic, AWS, and more…)
- Header, Body and Cookie static or dynamic parameterization
- Multiple Call with dynamic IDs in the URL, Header or Body
Databases. Big or Small.
Our native database connectors are focused on two things: speed and security. Oracle, MySQL, MariaDB, PostgreSQL, SQL Server, and many more are easily accessible whether they are hosted in Azure, Google or Amazon.
See all our Database connectorsWe also offer connectors for the Big Data databases such as RedShift, Google Big Query, Cassandra and DynamoDB or NoSQL or document databases such as Mongo DB and Azure Cosmos.
And for everything else we have our generic ODBC connector which can help you connect to pretty much anything...
More ways to load data...
For data behind the firewall
For on-premise data, use our Data Loader application to securely send data without compromising your firewall rules and opening up your internal data sources.
Our Data Loader was designed from the ground up to give you super fast data transfers while keeping the data in transit secured.
Here are some of the key features of our Data Loader app:
Our Data Loader was designed from the ground up to give you super fast data transfers while keeping the data in transit secured.
Here are some of the key features of our Data Loader app:
- Lightweight (less than 35 MB)
- Performant (optimized trickle batches)
- 3 levels of security and encryption
- Requires only HTTPS access to the internet or via a proxy
- Available in Windows, Linux and OSX
- Windows available as Command Line or Service and in 32/64 bit
For data everywhere else
ODBC
This widely used connector to get to the data in databases (special older formats) and files. Use Windows ODBC panel or provide a DSNless connection string.
SFTP
The protocol that never goes away because it works great for large files and you can do wonderful things such as archiving, deletion and much more.
RSS
Yeah they are still around and some news feeds and finance systems still use them. We got a connector for them.
HTTPS
A file sitting on a web server somewhere in the world? Use this connector to retrieve it and parse it.
If nothing else is possible maybe your application can send exports via email in an automated way. Well we got that too!
Real Time Data using Data Hooks
Use our Data Hooks module to create endpoints ready to receive and parse any data.
If you want real-time data, configure your apps to send a hook with data or subscribe to events to get the latest changes.
Data Hooks can process inbound web service calls, but also process inbound custom emails and soon to subscribe to MQTT brokers.
More about Data HooksIf you want real-time data, configure your apps to send a hook with data or subscribe to events to get the latest changes.
Data Hooks can process inbound web service calls, but also process inbound custom emails and soon to subscribe to MQTT brokers.
Real Time Data using our API
Are you coding your own app or are you able to make web service calls? Then use our API to inject data in real time into your data warehouse, upload files and process them, and so much more.
Insert, update and delete data one row or multiple rows at a time.
Trigger schedules and data flows to initiate downstream processes and much much more.
For data on your computer
Coming soon, to our line up of productivity clients apps, the Data Sync app available for Windows and OSX will give our users the capabillty of syncing data from and to their Data Warehouse directly from file explorer.
Secure. By Design.
We require a minimum of TLS 1.2 for all data in-transit, and for at-rest we use AES-256 encryption layers for Database and Storage.
Our data is processed and stored in Microsoft Azure and Amazon AWS, the leading global infrastructure providers.
Our data is processed and stored in Microsoft Azure and Amazon AWS, the leading global infrastructure providers.
