MicroStrategy World 2018 | Jan 15-17 in Las Vegas

Register by September 30 to save $500.

Learn more

Data Connectivity

Maximize the value of every investment across the enterprise.

With a vast library of native gateways and drivers, MicroStrategy can connect to any enterprise resource, so you can fully leverage existing investments–from databases and enterprise directories to cloud applications and physical access control systems.

Screenshot showing a user selecting from dozens of data sources in the MicroStrategy interface.

A few of our connectors.

From big data systems, to NoSQL databases, MicroStrategy makes it easy to tap into data and start getting value fast. Click on the logos below to learn more about how MicroStrategy partners with each of these vendors to deliver analytics on the most demanding datasets.

Amazon Redshift

Learn more

Cloudera

Learn more

IBM DB2

Learn more

Google BigQuery

Learn more

Hortonworks

Learn more

MapR Drill

Learn more

Mongo DB

Learn more

Oracle

Learn more

SAP HANA

Learn more

Spark SQL

Learn more

Microsoft SQL Server

Learn more

Teradata

Learn more

Amazon Redshift

The combination of MicroStrategy and Amazon Redshift offers organizations a mechanism for quickly accessing and processing large volumes of data.

MicroStrategy delivers Redshift-specific SQL syntax, support for key Redshift features including workload management, secure connectivity, query groups, and query labels, and further extensions to existing Redshift functionality.

Amazon Redshift is based on a massively parallel processing architecture and provides support for industry-standard SQL, as well as ODBC/JDBC for client connections. Redshift’s distribution style allows for the breaking down of query requirements for more efficient parallel processing across all hardware nodes. In addition, the Redshift architecture eliminates the need for physical indexes, tablespaces, partitions, and other disk structures used by other databases.

View product sheet
Latest Supported Version

CDH (Cloudera Distributed Hadoop) 5.8

Supported Drivers

MicroStrategy integrates with Amazon Redshift via industry-standard ODBC and JDBC drivers and the SQL query language

Watch the demo

How to connect with Amazon Redshift demo

Cloudera

The combination of MicroStrategy and Cloudera offers organizations a way to connect to massive volumes of structured and unstructured data stored in Hadoop and other big data sources—providing a great combination of performance and insight.

MicroStrategy supports 14 different Impala data types and provides optimized SQL engine settings for Cloudera Impala. By optimizing their settings, organizations can reduce the number of SQL passes generated for each query and provide better query performance by pushing down a variety of analytical functions to the database level.

Cloudera offers an optimized, highly scalable enterprise data warehouse that helps keep storage costs low. Other benefits include improved SLAs through reduced resource contention and easy integration with existing enterprise systems.

View product sheet
Latest Supported Version

CDH (Cloudera Distributed Hadoop) 5.8

Supported Drivers

MicroStrategy integrates with Cloudera through Impala and Hive ODBC connectors that ship with the product

Watch the demo

How to connect with Cloudera demo

IBM DB2

The combination of MicroStrategy and IBM DB2 offers organizations a great way to deliver top-notch query response times. MicroStrategy's tight integration with IBM DB2’s broad list of database functions and SQL functionality helps improve analytical performance.

MicroStrategy offers DB2-optimized SQL syntax, support for key DB2 features including DB2 BLU acceleration, DB2 compression, DB2 workload manager, DB2 intra-partition parallelism, and DB2 function library, as well as extensions to existing DB2 functionality such as aggregate awareness with physical summary tables.

IBM DB2 supports cloud, analytics, and mobile applications, offers self-tuning memory management, provides strong system availability, scalability, security, and cost-effectiveness, and delivers up to 23% lower CPU cost through advanced in-memory techniques.

View product sheet
Latest Supported Version

IBM DB2 9.7 and higher

Supported Drivers

MicroStrategy integrates with IBM DB2 for Linux, UNIX, and Windows via ODBC drivers (ODBC and JDBC) and the SQL query language

Watch the demo

How to connect with IBM DB2 demo

Google BigQuery

The combination of MicroStrategy and Google BigQuery enables end users to run ad-hoc analyses on massive datasets, query petabytes of data, and build enterprise reports and dashboards.

MicroStrategy supports all of Google BigQuery’s data types, as well as user-defined functions (UDFs) which allow users to extend the SQL language by writing their own custom functions. MicroStrategy supports UDFs defined in Google BigQuery via pass-through functions. MicroStrategy also improves query performance by pushing down a variety of analytical functions to the database level and reducing the number of SQL passes required for a given query.

Google BigQuery is a cloud-based service that leverages Google’s infrastructure for real-time big data analytics. It allows users to conduct interactive queries on petabytes of data, and provides speed and flexibility through a familiar SQL-like query syntax.

View product sheet
Supported Drivers

MicroStrategy integrates with Google BigQuery through the ODBC connector that ships with the product, and natively via API.

Watch the demo

How to connect with Google BigQuery demo

Hortonworks

MicroStrategy and Hortonworks have worked hard to offer optimized connection points between both platforms. Some of the world’s largest big data customers rely on this joint solution to deliver critical business analytics.

Together, MicroStrategy and Hortonworks provide all the tools organizations need to operationalize their Hadoop data. MicroStrategy supports 13 Hive datatypes and delivers optimized SQL engine settings for Hortonworks Hive. By pushing over 70 analytical functions to the database, and reducing the number of SQL passes, MicroStrategy can deliver unrivaled performance on the largest datasets.

Hortonworks is focused on increasing the usability of the Hadoop platform and provides a 100% open-source distribution for analyzing, storing, and managing big data. It’s easy to install and set up and is the only Hadoop distribution that supports the Windows platform.

View product sheet
Latest Supported Version

HDP 2.2

Supported Drivers

MicroStrategy integrates with Hortonworks through Hive. MicroStrategy ships with drivers for Hive

Watch the demo

How to connect with Hortonworks demo

MapR Drill

The combination of MicroStrategy and MapR offer organizations a powerful mechanism for exploring data on Hadoop. By leveraging this joint solution, organizations can provide direct access to semi-structured data without requiring IT involvement.

MicroStrategy offers support for 92% of MapR datatypes. By generating multi-pass SQL, MicroStrategy is able to execute complex business queries quickly and efficiently, and further accelerates performance by pushing some functions down to Apache Drill (an open source project supported by MapR). MicroStrategy also delivers built-in support of SQL generation for Drill.

MapR provides a powerful advanced architecture that supports global real-time data applications, lowers TCO, and is 100% binary compatible with HDFS. MapR integrates the power of Hadoop and Spark to deliver global event streaming, enterprise storage, and real-time database capabilities that open the door to developing innovative data applications. As part of its open source commitment, MapR constantly tests and validates core Apache projects before including them in the platform.

View product sheet
Latest Supported Version

MapR 5.2

Supported Drivers

MicroStrategy integrates with MapR via Drill and Hive

Mongo DB

When used together, MicroStrategy and MongoDB enable organizations to connect to a schema-less database that can handle large volumes of structured, semi-structured, and unstructured data. Organizations can then leverage this data to build powerful enterprise reports and business applications.

MicroStrategy supports 13 MongoDB data types and delivers better performance by pushing 65 analytical functions down to the database. Also, MicroStrategy can complete queries with fewer SQL passes using optimized settings that are specific to MongoDB.

MongoDB is a powerful NoSQL database that can handle large volumes of structured, semi-structured, and unstructured data. Featuring an efficient scale-out architecture, MongoDB can scale horizontally with ease and at a lower cost, without requiring schema migrations.

View product sheet
Latest Supported Version

MongoDB 3.2

Supported Drivers

MicroStrategy supports MongoDB through traditional ODBC and JDBC drivers. MongoDB ODBC and JDBC drivers are shipped with MicroStrategy releases

Watch the demo

How to connect with Mongo DB demo

Oracle

The integration of MicroStrategy and Oracle delivers a number of benefits to joint customers, especially improved performance for analytical queries powering MicroStrategy mobile apps.

MicroStrategy supports 13 of Oracle’s data types, and by integrating with Oracle Big Data SQL, features superior pushdown of analytics when compared to direct Hadoop access. In fact, 97% of analytical functions can be pushed down to the database. MicroStrategy also features optimized SQL engine settings for Oracle.

Oracle brings a strong market presence, powerful backup and recovery mechanisms, and a high integrity of data storage. With extensive offerings, Oracle can support a range of high-level, integrated technology and business solutions.

View product sheet
Supported Drivers

MicroStrategy integrates with Oracle via ODBC drivers, which are shipped with the product

Watch the demo

How to connect with Oracle demo

SAP HANA

MicroStrategy and SAP HANA offer organizations access to highly compressed, transactional, and real-time data that is both highly performant and scalable.

MicroStrategy has optimized SQL engine settings for SAP HANA and supports 22 of its data types. It delivers better query performance by pushing down almost all the analytical functions to the database. MicroStrategy can complete queries with fewer SQL passes using optimized settings that are specific to SAP HANA.

SAP HANA offers an in-memory, high-performance database with MPP architecture for scalability. With columnar and row-based data storage, it delivers highly compressed, transactional, and real-time data. HANA offers enhanced modeling capabilities that provide a semantic layer for all clients.

View product sheet
Supported Drivers

MicroStrategy integrates with SAP HANA via industry-standard ODBC and JDBC drivers and SQL query language

Watch the demo

How to connect with SAP HANA demo

Spark SQL

MicroStrategy integrates with Spark SQL, leveraging the power of in-memory cluster computing to run analytics against Hadoop and other big data sources.

MicroStrategy delivers native support for 11 Spark SQL datatypes, providing the flexibility that allows users to change views rather than make physical changes to underlying tables. It delivers better query performance by pushing down approximately 81% of all analytical functions to the database. And it can reduce the number of SQL passes with optimized settings.

Spark SQL provides standard connectivity mechanisms via ODBC and JDBC. It allows users to query structured data as a distributed dataset, making it easy to run SQL queries along complex algorithms. Spark SQL uses the same engine for both interactive and long queries, allowing for rapid scaling up for large jobs. It is compatible with existing and unmodified Hive queries and data.

View product sheet
Latest Supported Version

Spark SQL 1.6

Supported Drivers

MicroStrategy integrates with Spark SQL via industry-standard ODBC drivers and SQL query language

Watch the demo

How to connect with Spark SQL demo

Microsoft SQL Server

MicroStrategy and Microsoft SQL Server seamlessly integrate to deliver an optimized reporting experience.

MicroStrategy delivers Microsoft SQL Server-specific SQL syntax, multi-pass SQL, and extensions to SQL Server functionality. It supports key features such as parallel query execution, indexed views, compression, partitioning, pass-through authentication, and clustered column-store indexes.

With a strong reputation and presence in the market, Microsoft SQL Server offers powerful backup and recovery mechanisms, reliable data storage, and extensive functionality that provide high-level technology and integrated business solutions.

View product sheet
Latest Supported Version

SQL Server 2016

Supported Drivers

MicroStrategy integrates with Microsoft SQL Server via traditional ODBC and JDBC SQL drivers. SQL Server ODBC and JDBC drivers are shipped with MicroStrategy releases

Watch the demo

How to connect with Microsoft SQL Server demo

Teradata

MicroStrategy and Teradata combine to provide world-class business intelligence and data warehouse technologies. As a pair, these companies deliver best-of-breed solutions for complex and demanding customer requirements.

MicroStrategy provides Teradata-specific SQL syntax, integrating with tools that include Teradata Parallel Transporter API (TPT API). MicroStrategy delivers extensions to Teradata functionality such as aggregate awareness with physical summary tables and middle-tier caching via intelligent cubes. It also allows for multi-pass SQL for increased analytical abilities.

Teradata is an industry leader, providing data and user scalability, enterprise data integration, and fast retrieval of data. It is primarily used to warehouse large amounts of data for analytical analysis.

View product sheet
Latest Supported Version

Teradata 15.10

Supported Drivers

MicroStrategy integrates with Teradata through traditional ODBC and JDBC drivers

Watch the demo

How to connect with Teradata demo

A large library of data sources.

MicroStrategy supports connectivity to over a hundred enterprise databases and other information assets. View the product readme for the latest list of supported connectors.

See all connectors

Powerful Analytics with Relational Databases

The MicroStrategy platform includes native ODBC drivers that provide optimized connectivity to over 40 of the most popular RDBMS. MicroStrategy leverages the power of RDBMS and push-down analytics to deliver high-performance BI. In addition, MicroStrategy generates optimized SQL syntax that is tailored to each specific database platform and version — which enhances the end user experience by delivering rapid response times.

Interactive Applications with OLAP Sources

With MicroStrategy, it’s easy to access data from MDX cube sources including SAP BW, IBM Cognos TM1, Oracle Essbase, and Microsoft Analysis Services. Users can easily leverage the information stored in these sources and blend it with other enterprise sources to build rich reporting and dashboard applications.

Analytical Applications with Big Data and Hadoop

With certified drivers for Cloudera, Hortonworks, MapR, Amazon EMR, and more, the MicroStrategy platform empowers organizations to build web and mobile applications on top of big data and Hadoop distributions. Whether it’s leveraging advanced SQL on Hadoop technologies for interactive queries; or it’s connecting to, querying, and analyzing data from NoSQL sources – MicroStrategy delivers. And with integration to Apache Solr and Splunk, there are virtually no limits to dynamically search on semi-structured or unstructured data.

Analyze every kind of data.

With out-of-the-box gateways and native drivers, MicroStrategy makes it easy to seamlessly connect to any enterprise resource, including databases, mobile device management (MDM) systems, enterprise directories, cloud applications, physical access control systems, and more.

Data

MicroStrategy provides instant access to data of any kind with out-of-the-box connectors to everything from personal spreadsheets to enterprise data warehouses and massive big data systems. MicroStrategy delivers optimized connectivity to 70+ RDBMS systems, MultiDimensional Expressions (MDX) cube sources, Hadoop systems, and cloud-hosted data sources. The combination of these powerful connecters with MicroStrategy’s multi-pass SQL engine, push-down architecture, and data blending capabilities makes the MicroStrategy platform uniquely suited to provide optimized performance and unmatched data access.

Applications

MicroStrategy makes it easy to leverage any information across the enterprise in order to build powerful analytics applications. With native ODBC connectors and free-form SQL options, MicroStrategy can connect to everything from data warehouses to cube databases, flat files, and even operational databases that support ERP, CRM, or web applications. MicroStrategy can also easily access web-based reports and queries from other business intelligence systems.

Libraries

In addition to out-of-the-box MicroStrategy libraries, it’s easy to extend access to third-party and open source visualizations, statistical functions, maps, and multimedia content. The powerful MicroStrategy Software Development Kit (SDK) lets users seamlessly integrate with R advanced analytics, D3, GIS providers (Geospatial Information Systems), and much more.

Protocols

With a variety of built-in gateways, MicroStrategy makes it simple to synchronize analytics applications with your existing directories, whether it's to implement LDAP authentication with single sign-on options, or to integrate with enterprise mobility management solutions. In addition to providing native support on iOS for AirWatch, MobileIron, and GoodDynamics, MicroStrategy offers further customization with its SDK package.

Next Capability Data Discovery