Data Drivers & Plugins Overview

Jakob Bak

March 10, 2023 11:51

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.
Email	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 Generic POST request Get project Get user Search Cloud (Get user)	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)
Twitter	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)

Data Drivers & Plugins Overview

Comments

Articles in this section