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 iSeries | InMemory/Data Discovery | Reads table from DB2 database | Deprecated from 2023 - August release. | |
| 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. |
Not available in TARGIT Cloud. | |
| 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/Data Discovery (cloud) | Reads data from a database using Gateway client. Need to configure specific connection on gateway client | ||
| Generic Rest-API | API to connect to any given Rest-API | Interface to set up communication to Rest API. Design is similar to e.g. Postman | ||
| Google Analytics | InMemory/Data Discovery | Retrieves data from Google Analytics | Google deprecates their API for this driver June/July 2023. Please move to new online driver - see more information here. | |
| Google Analytics | InMemory/Data Discovery | Retrieves data from Google Analytics | Yes | |
| 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) | |
| HubSpot | InMemory/Data Discovery | Retrieves data from the HubSpot API | Yes | |
| JavaScript | InMemory/Data Discovery | Allows custom javascript to communicate with rest-APIs | Not available in TARGIT Cloud. | |
|
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 | Please use new assembly for .NET 8 from the latest release and change the reference in the data source settings. | |
| 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 | Not available in TARGIT Cloud. | |
| Python DotNet | Data Discovery | Executes Python Script on schedule and retrieves resultset | Not available in TARGIT Cloud. | |
| 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 | Not available in TARGIT Cloud. | |
| 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 | InMemory/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 | Data Discovery | Retrieves data from Danish Statistical Authority | Out of support. Will be removed when API changes. | |
| Statistics Denmark | InMemory/Data Discovery | Retrieves data from Danish Statistical Authority | Yes | |
| 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 | InMemory/Data Discovery | Retrieves data from Weather service based on zip codes | ||
| Windows Event Log | Data Discovery | Retrieves data from Windows Event Log | Not available in TARGIT Cloud. | |
| 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
Hi,
the list seems to be a little bit out of date.
Is it possible to update it?
Marc Hoeller thank you for your comment. I went through the overview and made a few smaller changes, but overall it should be correct. Have you noticed the rightmost "Comment" column? On some screen resolutions, it may be hidden outside the screen area.
Please sign in to leave a comment.