DataFlux Data Management Studio 2.6: User Guide
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
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
|
Doc ID: dfU_SupportedDB.html |