Birst provides data connectivity and extract options for a wide variety of databases, flat and structured files as well as popular Cloud and on-premise applications. Query your on-premise data in real-time with Birst Live Access—without the need to extract it to the Cloud.
RDBMS
Birst supports scheduled data extraction from all major relational database management systems, including Oracle, DB2, SQLServer, MySQL, Sybase, and PostgreSQL. Extraction of entire database tables as well as custom SQL select statements is possible. Schedule data extraction and processing tasks using either Birst’s built-in scheduler or your preferred OS task scheduler.
SAP
Connect directly to a SAP ERP (R/3 or ECC) instance via BAPI calls or the execution of SAP Queries. Birst supports a data extract connector for SAP Business Warehouse (BW) Data Source Objects (DSO).
Salesforce.com
Utilize the Web Services API of Salesforce.com to extract standard and custom data objects as well as issue custom SOQL queries for data extraction. Speed your deployment with our sales analytics solution accelerator which includes a pre-built dimensional model and report content for sales and pipeline analytics.
Hadoop Hive
Enable aggregation and analysis of Big Data in a Hadoop cluster. Our Hive connector supports both batch extract of data from Hadoop and real-time queries using Birst Live Access.
OLAP Cube
Enable your organization to leverage its investment in Microsoft Analysis Services (SSAS) and Hyperion Essbase cubes. Birst connects to SSAS and Essbase instances, automatically generates the required metadata and queries existing cubes securely and in real-time, behind your firewall.
Other applications with SnapLogic
Our partnership with SnapLogic enables scheduled extraction and loading of data from all of SnapLogic’s supported cloud and on-premise source applications. See http://store.snaplogic.com/ for a list of available data connectors.
Connectors for data uploads
- Delimited flat files
- Excel spreadsheets
- MS Access files
- MS SQL Server
- Oracle 11g
- MySQL
- PostgreSQL
- Hive/Hadoop
- Generic JDBC
- Salesforce.com
- SAP ERP (BAPI Objects)
- SAP ERP (Queries)
- SAP BW DSO
Live Access connectors
- Google Analytics
- SAP BW InfoCubes
- MS Analysis Service Cubes
- Hyperion Essbase Cubes
- MS SQL Server
- Oracle 11g
- DB2
- MySQL
- InfoBright
- ParAccel
- Vertica
- Teradata
- Sybase IQ
- Hive/Hadoop
