This article provides an overview of all the data drivers and plugins you can use to import data into an InMemory Database or Data Discovery in alphabetical order with a short description of their purpose. For InMemory, all of these drivers are included in the installation of TARGIT Data Driver Package and updated when upgrading the package. For Data Discovery, the plugins and drivers are updated when Data Discovery is updated. An exception from this are the online data providers, which can be updated any time by TARGIT. This ensures a much faster resolution time of any bugs or 3rd party API changes.
Data Source | Availability | Purpose | Online Data Provider | Comment |
Alteryx YXDB | InMemory/Data Discovery | Reads data in Alteryx Database format. | Deprecated from 2022 Winter (released December 1st 2022) | |
AX7 | InMemory | Retracts data from D3FO using our integration | ||
CSV | InMemory/Data Discovery | Reads CSV file - either a local file or reachable by URL | ||
Date/Time | Data Discovery | Creates date/time table for use in data models with a dynamic or static range of dates | ||
DB2 | InMemory/Data Discovery | Reads table from DB2 database | ||
Directory | Data Discovery | Input folder where CSV, JSON and Excel files can be dropped. Automatically creates data sources based on these files. |
||
InMemory | Is used to send notifications. Specify SMTP details and send messages during the script run | |||
Environment Variable | InMemory | Reads from environment variables. | ||
European Central Bank | Data Discovery | Retrieves exchange rates between selected currencies in a selected timeframe | ||
Excel | InMemory/Data Discovery | Reads Excel files from either: Local drive URL Google Drive Onedrive |
||
FileList | InMemory | Reads a file structure in a folder, gets file names as results. Used to iterate across multiple files in script | ||
FixedWidth | InMemory | Reads from fixedwidth-structured files | ||
Gateway database | InMemory | Reads data from a database using Gateway client. Need to configure specific connection on gateway client | ||
Google Analytics | InMemory/Data Discovery | Retrieves data from Google Analytics | ||
Google BigQuery | InMemory/Data Discovery | Retrieves data from Google BigQuery | Deprecated from 2022 Winter (released December 1st 2022) | |
Google Trends | InMemory/Data Discovery | Retrieves data from Google Trends on used search terms | Deprecated from 2022 Winter (released December 1st 2022) | |
JavaScript | InMemory/Data Discovery | Allows custom javascript to communicate with rest-APIs | ||
Jira Generic GET Request
|
InMemory/Data Discovery |
Multiple options to retrieve data from the project management app Jira | Yes | |
Jobindsats |
InMemory/Data Discovery |
Retrieves data from data service jobindsats.dk | Yes | |
JSON |
InMemory/Data Discovery |
Reads JSON files either local or by URL | ||
Microsoft Office Access
|
Data Discovery |
Reads Access database table | ||
Microsoft Dynamics 365 Business Central
|
InMemory/Data Discovery | Retracts data from D365 BC using our integration | Yes | |
Microsoft Dynamics 365 Sales | InMemory/Data Discovery | Retracts data from customer relationship management software package developed by Microsoft. | Yes | |
Microsoft Dynamics CRM | InMemory | Retracts data from Dynamics CRM using 3rd party dlls | Deprecated from 2022 Winter (released December 1st 2022) | |
MongoDB |
InMemory/Data Discovery |
Reads MongoDB data source | Deprecated from 2022 Winter (released December 1st 2022) | |
MySQL |
Data Discovery |
Reads MySQL database table | ||
OData |
InMemory/Data Discovery |
Reads data from OData | ||
Quandl |
InMemory |
Retrieves data from Quandl Service |
Deprecated from 2022 Winter (released December 1st 2022) | |
Penton |
InMemory |
Reads data from a Penton database |
Deprecated from 2022 Winter (released December 1st 2022) | |
PostGreSQL |
Data Discovery |
Reads PostgreSQL database table |
||
Python |
Data Discovery |
Executes Python Script on schedule and retrieves resultset |
||
Python DotNet |
Data Discovery |
Executes Python Script on schedule and retrieves resultset |
||
Quandl |
Data Discovery |
Retrieves data from Quandl Service |
Deprecated from 2022 Winter (released December 1st 2022) | |
R Language |
Data Discovery |
Executes R Script on schedule and retrieves resultset |
||
Salesforce |
InMemory/Data Discovery |
Retrieves data from CRM system Salesforce |
Deprecated from 2022 Winter (released December 1st 2022) | |
Salesforce |
InMemory/Data Discovery |
Retrieves data from CRM system Salesforce. |
Yes | |
SAP |
InMemory |
Retracts data from SAP server |
Deprecated from 2022 Winter (released December 1st 2022) | |
SFTP |
InMemory |
Reads file structure from SFTP server |
||
SharePoint |
InMemory/Data Discovery |
Retrieves data from SharePoint's lists and libraries |
Deprecated from 2022 Winter (released December 1st 2022) | |
SharePoint |
InMemory/Data Discovery |
Retrieves data from SharePoint Online's lists and libraries |
Yes | |
SQL Server |
Data Discovery |
Reads data from SQL Server Database table (or view) |
||
SQL Stored Procedure |
Data Discovery |
Executes SQL Stored Procedure on schedule allowing dynamic dataset as resultset |
||
Statistics Denmark |
InMemory/Data Discovery |
Retrieves data from Danish Statistical Authority |
||
TARGIT Analysis |
Data Discovery |
Reads data from data object in TARGIT Analysis |
||
Trello |
InMemory |
Retracts data from Trello task management system |
Deprecated from 2022 Winter (released December 1st 2022) | |
|
Data Discovery |
Retrieves data from Twitter service |
Deprecated from 2022 Winter (released December 1st 2022) | |
Weather |
Data Discovery |
Retrieves data from Weather service based on zip codes |
||
Windows Event Log |
Data Discovery |
Retrieves data from Windows Event Log |
||
XML |
InMemory/Data Discovery |
Reads XML files |
||
Xport |
Data Discovery |
A special data source used to export data sources from one Data Service instance and porting and importing those data sources to another instance of Data Service |
Deprecated from 2022 Winter (released December 1st 2022) |
Comments
Please sign in to leave a comment.