Birst provides data extraction and connectivity 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 sources in real-time with Birst Live Access—without the need to extract it to the Cloud.
RDBMS AND ANALYTICS SOURCES
Birst supports scheduled data extraction from all major relational database management systems, including Oracle, DB2, SQLServer, MySQL, Sybase, and PostgreSQL and any JDBC compliant data source. Data extraction of entire database tables as well as custom SQL select statements is possible. These capabilities extend to modern analytics databases like Vertica and Amazon Redshift.
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.
Big Data Sources
Through Birst’s Automated ETL and Data Warehousing capabilities, Birst allows you to combine Big Data with operational data to gain insight into impact of Big Data activities on operational metrics. Birst offers connectors for Impala, Hadoop Hive, and Cassandra.
Connect directly to SAP HANA or automatically build a Birst data warehouse in HANA. Connect to SAP ERP (R/3 or ECC 6) via BAPI calls or the execution of SAP Queries. Birst also supports a data extraction connector for SAP Business Warehouse (BW) Data Source Objects (DSO).
Enable your organization to leverage its investment in Microsoft Analysis Services (SSAS) and Hyperion Essbase cubes and other OLAP sources that accept XMLA calls. Birst connects to SSAS and Essbase instances by issuing MDX, automatically generates the required metadata and queries existing cubes securely and in real-time, behind your firewall.
Utilize the Web Services API of NetSuite to extract standard and custom data objects or specific columns for customized analytics. Speed your deployment with our Operational Analytics Solution Accelerator which includes a pre-built dimensional model, KPIs, and reports for bookings, billings, and backlog analytics.
Through Birst Connector Framework, Birst or a Birst Partner can provide a connector to any on-premise or cloud application via available webservices. Birst can also accept extracts from applications flat file formats, including csv, txt and others.
Utilize the Web Services API of Marketo to extract data objects or specific columns for customized analysis. Speed time to deployment with pre-built Marketo connector exposing critical objects and enabling joining of Marketo data with Salesforce.com or other CRM solutions.
Live Access connectors
- Google Analytics
- SAP BW InfoCubes
- MS Analysis Service Cubes
- Hyperion Essbase Cubes
- MS SQL Server
- Sybase IQ
- Generic JDBC
- Amazon Redshift