You are here: Data Riser Bar>Working with Data Connections>Supported Databases for Data Storage

DataFlux Data Management Studio 2.6: User Guide

Supported Databases for Data Storage

DataFlux ODBC Data Sources

DataFlux Data Management Studio can use DataFlux ODBC 7.1 drivers to access data in the following databases:

Driver Database Version
Apache Hive ™ Apache Hadoop Hive 0.8.x , 0.9.x , 0.10.x, 0.11.x, 0.12.x
Apache Hive Amazon Elastic MapReduce (Amazon EMR) Hive 0.8.x, 0.9x
Apache Hive Cloudera’s Distribution Including Apache Hadoop: CDH 3.0, 4.0.x, 4.1, CDH4.2, CDH4.5, CDH5.x. Hive 0.8.x , 0.9.x , 0.11.x , 0.12.x
Apache Hive Hortonworks Distribution for Apache Hadoop: HDP 1.3, 2.0. Hive 0.11.x, 0.12.x
Apache Hive MapR Distribution for Apache Hadoop: MapR 1.2 MapR 2.0. Hive 0.7.1 , 0.9.x
Btrieve® Btrieve 6.15
Btrieve Pervasive.SQL™ 7.0, 8.5, and 2000
Impala Wire Protocol Cloudera Impala™ Server 1.0 (for Apache Hadoop) 
dBASE Clipper™
dBASE dBASE IV and V
dBASE FoxPro 2.5, 2.6, and 3.0
dBASE FoxPro 6.0 (with 3.0 functionality only)
dBASE FoxPro 3.0 Database Containers (DBC)
DB2® Wire Protocol IBM® DB2 v9.1, v9.5, v9.7, and v9.8 for Linux®, UNIX, and Windows®
DB2 Wire Protocol IBM DB2 v10.1 and 10.5 for Linux, UNIX, and Windows
DB2 Wire Protocol IBM DB2 Universal Database™ (UDB) v8.x for Linux, UNIX, and Windows
DB2 Wire Protocol IBM DB2 v9.1, v10, and v11 for z/OS
DB2 Wire Protocol IBM DB2 UDB v7.x, v8.x, and v8.1 for z/OS
DB2 Wire Protocol IBM DB2 UDB V5R1, V5R2, V5R3, V5R4, V6R1, and V7R1 for iSeries®
Greenplum Wire Protocol Greenplum Database 3.3, 4,4.1, 4.2, and 4.3
Greenplum Wire Protocol Pivotal HAWQ 1.1
Informix© (client) Informix Dynamic Server 9.2, 9.3, 9.4, 10.0, 11.0, 11.5, and 11.7
Informix Wire Protocol Informix Dynamic Server 9.2, 9.3, 9.4, 10.0, 11.0, 11.5, 11.7, and 12.1
MySQL™ Wire Protocol MySQL 5.0x, 5.1, 5.5, and 5.6
Oracle® (client) Oracle 8i R3 (8.1.7)
Oracle (client) Oracle 9i R1 and R2 (9.0.1 and 9.2)
Oracle (client) Oracle 10g R1 and R2 (10.1 and 10.2)
Oracle (client) Oracle 11g R1 and R2 (11.1 and 11.2)
Oracle Wire Protocol Oracle 8i R3 (8.1.7)
Oracle Wire Protocol Oracle 9i R1 and R2 (9.0.1 and 9.2)
Oracle Wire Protocol Oracle 10g R1 and R2 (10.1 and 10.2)
Oracle Wire Protocol Oracle 11g R1 and R2 (11.1 and11.2)
Oracle Wire Protocol Oracle 12c R1 (12.1)
PostgreSQL® Wire Protocol PostgreSQL 8.2, 8.3, 8.4, 9.0, 9.1, and 9.2
Progress OpenEdge Wire Protocol Progress OpenEdge 10.1x, 10.2x, 11.0, 11.1, 11.2, and 11.3
Salesforce Salesforce (API Version 26)
SQL Server Legacy Wire Protocol Microsoft® SQL Server® 7.0
SQL Server Legacy Wire Protocol Microsoft SQL Server 2000
SQL Server Legacy Wire Protocol Microsoft SQL Server 2005
SQL Server Legacy Wire Protocol Microsoft SQL Server 2008 R1, R2
SQL Server Wire Protocol Microsoft SQL Server 2000
SQL Server Wire Protocol Microsoft SQL Server 2005
SQL Server Wire Protocol Microsoft SQL Server 2008 R1, R2
SQL Server Wire Protocol Microsoft SQL Server 2012
SQL Server Wire Protocol Microsoft SQL Server 2014
SQL Server Wire Protocol Windows Azure SQL Database v11.0
Sybase® Wire Protocol Sybase Adaptive Server® 11.9
Sybase Wire Protocol Sybase Adaptive Server Enterprise® 12.0, 12.5x, 15.0, 15.5, and 15.7
Sybase IQ Sybase IQ 15.0, 15.1, 15.2, 15.3, and 15.4
Teradata® Teradata 12.0, 13.0, 13.1, 14.0, and 14.1
Teradata Teradata V2R6.0, V2R6.1, and V2R6.2
Text Text Files
XML XML Documents (tabular and hierarchical formatted)

For more information about DataFlux drivers (rebranded DataDirect drivers), see the Data Direct online documentation. This documentation is found in the ODBC folder in the installation directory for DataFlux Data Management Studio. Here is an example path:

C:\Program Files (x86)\DataFlux\ODBC\7.1\doc\userguide\help.htm

Other Data Sources

In addition to the data sources mentioned above, DataFlux Data Management Studio can access the following data sources: 

Data Source Supported Versions
SAS data sets

DataFlux Data Management Studio 2.6 and DataFlux Data Management Server 2.6 use the SAS Threaded Kernel Table Services Driver for Base SAS 9.4. Accordingly, they can access any SAS version 8 data set or any SAS version 9 dataset. Prior versions of the client and server can access any SAS version 8 data set or any SAS version 9 dataset that was not created with the Extend Observation Counter turned on. See Adding SAS Data Set Connections.

Databases (including SAP and Hadoop) managed by the SAS® Federation Server

For information about the supported databases, see the documentation page for SAS Federation Server.

Microsoft Excel Excel versions supported by the Microsoft Excel ODBC driver, as described in the help for that driver.
SAP®

The custom connection method that is described in Adding Custom SAP Connections uses the SAS/ACCESS Interface to R/3 software. Accordingly, this method requires SAP Kernel Release 4.6C or higher. The SAS/ACCESS Interface to R/3 software for Windows and UNIX requires the 64-bit SAP Unicode RFC library, Release 7.20 or higher, which is provided by SAP AG. Refer to SAP Note 413708 for the current version, download and installation instructions.

SAP data can also be accessed with the SAS Federation Server. For information, see the documentation page for SAS Federation Server.

 

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfU_SupportedDB.html