Foresight Analytics Platform ensures access to a wide class of data sources using ODBC, OLEDB, OLEDB for OLAP property. It enables the user to create solutions for various analytical problems.
Supported data sources:
Multidimensional data sources:
Microsoft Analysis Services.
SAP NetWeaver BW.
SAP HANA.
OLE DB for OLAP compatible multidimensional sources.
Production relational DBMS:
Microsoft SQL Server.
Oracle.
IBM DB2.
Teradata.
PostgreSQL.
SQLite.
ODBC or OLE DB-compatible DBMS. such as Sybase IQ, and so on.
If the DBMS supports capability of building clusters and fails-over (for example, SQL Server Failover Cluster, Oracle RAC), this functionality is used transparently and it does not require shutting down, rebooting or restarting the application.
A particular type of access to DBMS is available, that is, a HTTP driver that does not require installing front end of the DBMS for Foresight Analytics Platform desktop application.
Hardware and software systems:
Oracle Exadata.
EMC Greenplum.
IBM Netezza.
Teradata Data Warehouse Appliance.
HP Vertica.
Local data sources and desktop DBMS:
XML (with ability to set an XPath query for a data sample).
JSON (including via the REST service).
DBF (dBase).
CSV.
TXT.
VPF.
Microsoft Excel files.
Microsoft Access.
Paradox, and so on.
Foresight Analytics Platform supports platform integration with platform for Apache Hadoop distributed data storing and handling. Integration is executed via support of Apache Hive data source being the infrastructure for creating data warehouses. Hive works on the base of Hadoop, being the ODBC interface and enables access to Hadoop data and their analysis by means of SQL-like HiveQL query language.
The setup of Foresight Analytics Platform enables the user to:
Download RSS feed data.
Implement specific data adapters.
See also: