Providers
A Provider in the Quantela platform is a data source type. Each Connector and Adapter that is created in the Quantela platform will be on one of these providers.
Quantela has the capability to connect to a number of different providers:
Quantela Data Connector - this is an internal provider that is used to retrieve data from the Quantela platform database. In general, this data this data will have been previously stored to the database by a Quantela platform adapter.
File Connector - this provider is used to get data from static files, typically CSV or JSON files. To use this provider, create a new Connection Template with a type of File.
MS SQL Connector - this is used to connect to a Microsoft SQL Server database. To use this provider, create a new Connection Template with a type of MS SQL.
MySQL Connector - this is used to connect to a MySQL database. To use this provider, create a new Connection Template with a type of MySQL.
Oracle Connector - this is used to connect to an Oracle database. To use this provider, create a new Connection Template with a type of Oracle.
PostgreSQL Connector - this is used to connect to a PostgreSQL database. To use this provider, create a new Connection Template with a type of PostgreSQL.
HTTP Connector - this provider is used to connect to a HTTP data source, typically a REST API. To use this provider, create a new Connection Template with a type of HTTP.
HTTPV2 Connector - this provider is used to connect to a HTTP data source, typically a REST API. It provides the option to enter or import cURL commands and execute them.
Quantela Data Ingestion - this is a special type of provider. It is used in inbound adapters to save entity or event data to the Quantela platform database from where it can be subsequently to analyze or visualize real-time or historical data.
FTP Connector - this provider is used for transferring files to or exchanging files with a host computer. To use this provider, create a new Connection Template with a type of FTP.
SFTP Connector - this provider is a secure FTP (File Transfer Protocol) used for transferring files to or exchanging files with a host computer. To use this provider, create a new Connection Template with a type of SFTP.
In most cases, you will not have to directly configure a provider - you will instead configure a connector for an external data source which is based on one of these providers. However, there are providers which are used to directly access data in the Quantela platform database. When you are using data from these internal data sources then there is no connector involved, and you will use the provider to build a query to retrieve the data you need from the internal database.
Providers are used to identify the data source for Datasets and Adapters. To add a provider to the data flow, drag the corresponding provider icon from the palette on the left of the canvas. Depending on the provider, the parameters required to connect to it and the data to be returned will be different.