Supported External Data Types and Sources

• a secure and resizable compute capacity to support virtually any workload

• an issue and product tracking software from Atlassian to import data from JIRA via JQL (Java Query Language)

• a software for distributed version management of files

• an online service that displays advertising on websites outside of in-house offerings

• a tracking tool , which is used for traffic analysis of websites

• a web service provided by Google for data management
• Fusion Tables can be used to collect, visualize and share data tables

• Google's former social network

• Google's spreadsheet program that is part of the free, web-based Google Docs Editors Suite

• a marketing automation software for account-based marketing

• creation, retrieval and removal of entities and data stored within Marketo

• search New York Times articles from 1981 to today, retrieving headlines, abstracts, lead paragraphs, links to associated multimedia, and other article metadata

• an enterprise cloud computing firm that specializes in social and mobile cloud technologies, including sales and CRM applications helping companies connect with customers, partners, and employees

• perform searches on Twitter

• a cloud-based customer support platform 

• is the REST API and application gateway for the Hadoop ecosystem

• Amazon's Cloud online storage to store, organize and save data

• a Microsoft storage service for large unstructured binary and text data. Available for Datameer X HDP 2.0+ and CDH 4+ users. Please contact our services department for the connector plug-in

• (For HDP2.0, 2.2 and CDH+4 users) Contact Datameer X services for info

• can be assigned the same name as a pre-defined protocol, in order to extend the number of IP addresses or ports associated with the original protocol

• the local Datameer X filesystem

• a standard network protocol used to transfer from one host or to another host over a TCP-based network, such as the internet

• a distributed file system used by Hadoop applications that creates multiple replicas of data blocks and distributes them on nodes throughout a cluster to allow extremely rapid computations

• offers cloud storage software so that you can store and retrieve lots of data with a simple API
• is built for scale and optimized for durability, availability, and concurrency across the entire data set
• is ideal for storing unstructured data that can grow without bound

• transfers files and encrypts both commands and data, preventing passwords and sensitive information from being transmitted openly over the network

• is a set of Unix utilities including SCP and SFTP, based on SSL, which uses a simple Public Key Infrastructure and Encryption to allow you to securely transfer files between Unix file systems

INFO: Datameer X supports Bitverse SSH Server/Client for the Windows platform. The root paths to be specified while creating the connection should look something like: /c:/mydata/folder1

• a clustered field system that supports both very large-scale and high-performance uses

•  a fast exporting method by loading your data into your S3 server and then copying the data to your Redshift database

• a set of capabilities dedicated to big data analytics, built on Azure Blob storage
• Data Lake Storage Gen2 is the result of converging the capabilities of the two existing storage services, Azure Blob storage and Azure Data Lake Storage Gen1

• is a REST file hosting web service for storing and retrieving data on Google Cloud Platform infrastructure
• the service combines the performance and scalability of Google's cloud with advanced security and sharing features

• Amazon's Cloud online storage to store, organize and save data

• a comprehensive data platform provided as Software-as-a-Service (SaaS)
• enables data storage and analytic solutions

• a query service to run Sql queries against their data

• a quick, scalable data warehouse as a service from the cloud

• Native Amazon Redshift JDBC 4.1 driver or a PostgreSQL jdbc driver can be used

• a fully managed NoSQL database service

• an Apache Spark based analytics service with an interactive workspace

• an unlimited analytics service which enables flexible data queries as you see fit, using on-demand server less resources or provisioned resources at scale

• IBM's relational database management system

• an open-source massively parallel processing (MPP) database

• a lightweight, 100% Java SQL Database Engine

• a relational database based on structured query language

• a relational database based on structured query language

• a column-oriented database management system

• a relational database management system designed for grid computing inclusive CLOB support for importing data

• an object-relational database management system (ORDBMS)

• a column-based, relational database software

• a relational database based on structured query language

• Teradata database needs to be configured to support the appropriate character set

• a grid-based and column-oriented analytic database software

• gives organizations fast access and deep visibility into all of their enterprise data assets - whether in the cloud or on-premises - via a single unified self-service platform 
• with Datameer Spotlight business teams can discover, access, collaborate and analyze more data for faster, more trusted cloud analytics while eliminating complex data movement and maintaining strong governance

• is Google's fully managed data warehouse for petabyte analytics

• is an open-source non-relational distributes database
• is written in Java and runs on top of HDFS

• In order to satisfy the classloader requirements, hbase-protocol.jar must be included in Hadoop's classpath and the root Datameer X classpath (/etc/custom-jars) for version 0.96.1 to 0.98.0
• Learn more on the Apache HBase Reference.

• a service that stores metadata related to Apache Hive and other services, in a backend RDBMS, such as MySQL or PostgreSQL

• an open source data warehouse system for querying and analysing large data sets stored in Hadoop

• a service that enables clients to execute queries against Hive
• it supports multi-client concurrency and authentication
• provides support for open API clients like JDBC and ODBC

• IMAP is the internet standard protocol used by email clients to retreive email messages from a mail server over a TCP/ IP connection
• POP3 is a client/ server protocol in which email is received and held

• the security instance when you have a Hive Server2 JDBC instance running

• a business analytics service provided by Microsoft
• provides interactive visualizations with self-service business intelligence capabilities

• visual analytics platform to host, and hold all tableau workbooks, datasources and more

• minimum CentOS 7 as operating system
• requirements on Hadoop cluster`s operation system libraries:
  • GNU C Library (libc6) version >= 2.15
  • GNU Standard C++ Library v3 (libstdc++6) version >= 6.1.0

• record of all incoming requests from the Apache server
• requests are processed to a log file - format of access log is highly configurable
• location and content of the access log are controlled by the CustomLog directive

• Avro file contains data serialized in a compact binary format and schema in JSON format that defines the data types
• an Avro file may also store markers if the datasets are too large and need to be split into subsets when processed

• is a section of code that defines the data structures of COBOL programs

• stores tabular data (numbers and text) in plain-text form (sequence of characters, with no data that has to be interpreted instead, as binary numbers)
• consists of any number of records, separated by line breaks of some kind
• each record consists of fields, separated by some other character or string (most commonly a literal comma or tab)

• is a spreadsheet application by Microsoft

• a file with a font whose letters and characters each occupy the same amount of horizontal space

• file contains Hyper Text Markup Language

• IIS is a web server application and set of feature extension modules for usage with Microsoft Windows
• IIS 7.5 supports HTTP, HTTPS, FTP, FTPS, SMTP AND NNTP

• an unordered collection of 'key:value' pairs, comma-separated and enclosured in curly braces
• keys must be strings and should be distinct from each other

• a set of two linked data items: key and value
• key is the unique identifier for some item of data
• value is the data that is identified

• logging package written in Java

• a generic term for a family of related file formats used for holding collections of electronic mail messages

• Netfilter is the packet filtering framework inside the Linus kernel
• IP tables is a user space application that allows the system administrator to configure tables provides by the Linux kernel firewall

• a free and open-source column-oriented data storage format of the Apache Hadoop ecosystem

• Only supported in conjunction with Hive
• Supports default compression types
• Export supported only for existing partitioned Hive tables

• a columnar storage format available to any project in the Apache Hadoop ecosystem, regardless of the choice of data processing framework, data model or programming language

• External Parquet documentation
• Supports default compression types

• a data placement structure that determines how to store relational tables on computer clusters

• Export supported in conjunction with Hive only for existing partitioned Hive tables

• specify the file or folder, enter a Regex pattern for processing the data, and specify whether the first row contains the column headers

• a flat file consisting of binary key/value pairs. It is extensively used in MapReduce as input/output formats.

• Supports default compression types

• a compressed snapshot of data stored on disk and loaded into memory as required to render a Tableau viz

• a zip file that contains the data source file (.tds), as well as any local file data such as extract files (.hyper or .tde), text files, Excel files, Access files, and local cube files

• such as Twitter data
• information that either doesn't have a pre-defined data model and/or doesn't fit well into relational tables
• unstructured information is typically text-heavy, but might contain data such as dates, numbers, and facts as well 
• this results in irregularities and ambiguities that make it difficult to understand using traditional computer programs as compared to data stored in fielded form in databases or annotated in documents

• specify  the file or folder, the root element, container element, and XPath expressions for the fields you would import to Datameer

• Supports default compression types