Mask Group 1

Empower Your Customers’ BI and Analytics Efforts

Advanced BI and analytics efforts require access to data spread across different sources, including relational, data warehouses, cloud, SaaS, big data, NoSQL and many REST endpoints. Give your customers the flexibility they need to connect to any data source with an exhaustive and ever-growing number of data source connectors across ODBC, JDBC, ADO.NET and OData.

Embed Our Connectors Into Your Data Access Layer

Applications can no longer function as islands. That’s especially the case for BI and analytics—regardless of where your customers store their data, modern BI and analytics apps must be able to pull it. DataDirect disrupts the disruption, helping your customers connect their favorite BI tools to different data sources and REST endpoints.

Application Vendors
  • Launch in minutes, not months
    DataDirect connectors are lightweight and architected to connect directly to data without additional client libraries or dependencies
  • Customize your data access layer
    Every last detail is fully customized so you can own the data access experience from end to end. For example, Microstrategy even branded error messages with our OEM package: "[MicroStrategy][ODBC Oracle Wire Protocol driver][Oracle] ORA-00942: table or view does not exist"
  • Respect your runtime
    DataDirect connectors are the fastest on the market and use less memory and fewer CPU cycles to protect your application’s core resources
  • Connect to any data source
    Develop the data access layer for your external data strategy against a single API across OData, JDBC or ODBC
Supported Data Sources
Data sources Description
Amazon Redshift Amazon Redshift
(Amazon Web Services API, Version 2012-12-01)
Apache Hadoop Hive
  • Apache Hive™ (HiveServer1 and HiveServer2)*
  • Apache Hadoop Hive 0.8.0 and higher
  • Amazon EMR 2.1.4 and higher
  • Cloudera CDH update 4 and higher
  • Hortonworks 1.3 and higher
  • IBM BigInsights 3.0 and higher
  • MapR 1.2 and higher
  • Pivotal HD 2.0.1 and higher
Cloudera Impala
  • Cloudera Impala Server 2.0, 2.1, 2.2*
  • Cloudera Impala Server 1.0, 1.1, 1.2, 1.3, 1.4*
IBM dashDB (See IBM DB2) *
IBM DB2 (LUW, z/OS, iSeries)
  • IBM dashDB (now IBM Db2 Warehouse on Cloud)
  • DB2 V10.1, V10.5* for Linux, UNIX, Windows
  • DB2 V9.1, V9.5, V9.7, 9.8 for Linux, UNIX, Windows
  • DB2 V8.x for Linux, UNIX, Windows
  • DB2 11 for z/OS*
  • DB2 V10 for z/OS
  • DB2 V9.1 for z/OS
  • DB2 UDB V8.1 for z/OS
  • DB2 I 7.1, 7.2* (DB2 UDB V7R1, V7R2 for iSeries)
  • DB2 I 6.1 (DB2 UDB V6R1 for iSeries)
  • DB2 for I 5/OS (DB2 UDB V5R4 for iSeries)
dBASE
  • dBASE IV, V
  • Clipper
  • FoxPro 6.0 (with 3.0 functionality only)
  • FoxPro 3.0
  • FoxPro 3.0 Database Containers
  • FoxPro 2.5, 2.6
EDI Standard Support (XML Converters)
  • ACORD AL3
  • EANCOM
  • EDIFACT
  • Edig@s
  • HIPAA
  • HL7
  • IATA AHM780
  • IATA Cargo-IMP
  • IATA PADIS
  • NCPDP SCRIPT
  • NCPDP Telecommunication
  • SEF
  • TRADACOMS
  • X12
FinancialForce.com (See Salesforce) *
Force.com Applications (See Salesforce) *
Google Analytics  
Greenplum
  • Pivotal HAWQ 1.1, 1.2*
  • Greenplum 4, 4.1, 4.2, 4.3*
  • Greenplum 3.3
Informix
  • Informix Dynamic Server 12.1*
  • Informix Dynamic Server 11.0, 11.5, 11.7
  • Informix Dynamic Server 10.0
  • Informix Dynamic Server 9.2, 9.3, 9.4
Microsoft Dynamics CRM Online Microsoft Dynamics CRM Online
Microsoft Office (See SequeLink API Adapter)
Microsoft Dynamics CRM (Kerberos authentication only) 2011 Rollup 16, 2013, 2015
Microsoft SQL Server
  • Microsoft Windows Azure SQL Database Version 11.0
  • Microsoft SQL Server 2014*
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2008 R1, R2
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
  • Microsoft SQL Server 2000
MongoDB
  • MongoDB 3.0*
  • MongoDB 2.2, 2.4, 2.6
MySQL
  • MySQL Enterprise Edition 5.0, 5.1, 5.5, 5.6*
  • MySQL Community via MySQL Connector/J 5.1
Oracle Database
  • Oracle 12c R1 (12.1)*
  • Oracle 11g R1, R2 (11.1, 11.2)
  • Oracle 10g R1, R2 (10.1, 10.2)
  • Oracle 9i R1, R2 (9.0.1, 9.2)
Oracle Eloqua Oracle Eloqua API 2.0
Oracle Service Cloud Oracle RightNow CX API 1.2 against sites with February 2014 version or later
Oracle Sales Cloud Oracle Sales Cloud 11.1.10 and 11.1.11
Pervasive (Btrieve)
  • Pervasive.SQL 7.0, 8.5, 2000
  • Btrieve 6.5
PostgreSQL
  • PostgreSQL 9.0, 9.1, 9.2, 9.3, 9.4*
  • PostgreSQL 8.2, 8.3, 8.4
Progress OpenEdge Progress OpenEdge 10.1.x and higher
Progress Rollbase 2.0 and higher
Salesforce Salesforce (API Version 34)*
ServiceMax (See Salesforce) *
Spark SQL Apache Spark SQL 1.2, 1.3, 1.4, 1.5*
SugarCRM 7.1.6 and higher
SAP Sybase ASE
  • SAP Adaptive Server Enterprise 16.0*
  • Sybase Adaptive Server Enterprise 15.0, 15.5, 15.7
  • Sybase Adaptive Server Enterprise 12.0, 12.5, 12.5.x
  • Sybase Adaptive Server Enterprise 11.9
SAP Sybase IQ
  • SAP IQ 16.0*
  • Sybase IQ 15.0, 15.1, 15.2, 15.3 ,15.4
Teradata
  • Teradata 15.00*
  • Teradata 14.00, 14.10*
  • Teradata 13.0, 13.1
  • Teradata 12.0
  • Teradata V2R6.0, V2R6.1, V2R6.2
Text Text Files
XML XML Documents (tabular- and hierarchical-formatted)
Veeva CRM (See Salesforce) *
SequeLink API Adapter Connectivity to legacy sources (MS Access/Excel, IBM Unidata, CA Datacom, C-ISAM, flat files, etc.)
REST API (See OpenAccess SDK)
OpenAccess SDK Custom connectivity to databases, applications, business logic, or file based data stores
  *Day One Support Included with Data Source Support: Provides additional support for disruptive technologies across big data and cloud with frequent release cycles. With this policy, Progress DataDirect on-premises ODBC and JDBC drivers will support any new versions of supported data sources on day one.

Get the Unfair Advantage with DataDirect

Unlock your customers’ analytics efforts with full support for data sources of all shapes and sizes. With a single decoupled codebase and API for the data access layer, you can give your customers the ability to connect to an unlimited number of data sources with a single API.

  • Develop against open standards
    Avoid vendor lock-in by adopting open industry standards. DataDirect is the leader in data connectivity standards having co-founded the ODBC specification and serves on the JDBC Expert Group, OData Technical Committee and ANSI SQL Committee.
  • Get a single dedicated partner
    Deliver full support for the breadth of data sources in all shapes and sizes, with constant vigilance for the next security vulnerability (POODLE, FREAK, LOGJAM) in your data access layer. Focus on serving your customers, let us take care of the rest.
  • Get unlimited support
    We support you so you can support your customers. Make sure your POC is a success with 24/7 support and access to expertise from our engineering teams, partnerships and leading technology companies such as Microsoft, Oracle, and IBM through our TSANet multi vendor support channel.

Using Progress DataDirect, it took us just 20 minutes to combine the data back together in Salesforce and suddenly the customer had visibility into 25% more opportunities. We were able to decrease our time to market by 5X using DataDirect versus building our own connector. And we are able to build a proof of concept within just hours to demonstrate the value to our customers. From the development side of our business this is very exciting.

Ken Miller

Product Director, Panintelligence Ltd

Our clients are constantly asking for new data source support, and we know that DataDirect will quickly make an ODBC driver available. The Salesforce and Hive drivers are only the most recent in a long series of such innovations. They position us very favorably against the competition.

Jochen Demuth

Director of Partner Engineering, MicroStrategy

Application Vendors

Connect to any data using a single API
across Relational, Data Warehouses, Cloud, SaaS,
Big Data, and NoSQL

Leаrn more

Data Source Vendors

Deliver open connectivity to your
database, application or cloud with leading industry standards
across ODBC, JDBC, ADO.NET or Odata

Leаrn more