Data Sources Overview

This article provides an overview of all the data sources you can access from Data Discovery in alphabetical order with a short description of their purpose.

 

Data Source Purpose Depricated from version Requires special module
Alteryx YXDB Read data in Alteryx Database format. 2022 Winter (released December 1st) No
CSV Read CSV file - either a local file or reachable by URL   No
Date/Time Creates date/time table for use in data models with a dynamic or static range of dates   No
DB2 Read table from DB2 database   No
Directory Input folder where CSV and Excel files can be dropped. 

Automatically creates data sources based on these files.
  No
European Central Bank Retrieves exchange rates between selected currencies in a selected timeframe   No
Excel Read Excel files from either:
Local drive
URL
Google Drive
Onedrive
  No
Google Analytics Retrieves data from Google Analytics   No
Google BigQuery Retrieves data from Google Big Query 2022 Winter (released December 1st) No
Google Trends Retrieves data from Google Trends on used search terms 2022 Winter (released December 1st) No
HTML Tables "Scrapes" HTML tables from defined webpage   No
Import.io Retrieves data from Import.io service 2022 Winter (released December 1st) No
JavaScript Allows custom javascript to communicate with rest-APIs   Yes

Jira

Generic GET Request
Generic POST request
Get project
Get user
Search
Cloud (Get user)

 

Multiple options to retrieve data from the project management app Jira   Yes

Jobindsats

Retrieves data from data service jobindsats.dk   Yes

JSON

Read JSON filer either local or by URL   No

Microsoft Office Access

Read Access database table   No

Mongo DB

Read Mongo DB data source 2022 Winter (released December 1st) No

MySQL

Read MySQL database table   No

OData

Reads data from Odata   No

Oracle

Reads Oracle database table   No

PostgreSQL

Reads PostgreSQL database table   No

Python

Executes Python Script on schedule and retrieves resultset   No

Python DotNet

Executes Python Script on schedule and retrieves resultset

  No

Quandl

Retrieves data from Quandl Service

2022 Winter (released December 1st) No

R Language

Executes R Script on schedule and retrieves resultset

  No

Salesforce

Retrieves data from CRM system Salesforce

  No

SQL Server

Reads data from SQL Server Database table (or view)

  No

SQL Stored Procedure

Executes SQL Stored Procedure on schedule allowing dynamic dataset as resultset

  No

Statistics Denmark

Retrieves data from Danish Statistical Authority

  No

TARGIT Analysis

Reads data from data object in TARGIT Analysis

  No

Twitter

Retrieves data from Twitter service

2022 Winter (released December 1st) No

Weather

Retrieves data from Weather service based on zip codes

  No

Windows Event Log

Retrieves data from Windows Event Log

  No

XML

Read XML files

  No

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.