Skip navigation links
Customer care
Technical Info
Reportive Data Analyzer
Reportive Analyzer
Reportive Designer
Analyzer deployment
Reportive Studio
Data Connectors
Integrated ETL
Composite Objects
Office integration
Data cubes generator
Production
Production Center
Reportive > En > Support > Technical Info > Reportive Studio > Data Connectors

Reportive Studio

Data Connectors


Reportive Studio integrates data connectors that allow you to access the vast majority of your corporate data sources.

                                                                       

The Reportive Dataset data format incorporates multidimensional characteristics that make it possible to extract data from flat files, relational databases, multidimensional cubes, or any business application with which it can communicate to extract the data.

The cartographic module introduces the possibility of extracting data from different layers of maps (including geolocation data) so as to merge it with business data and to prepare advanced maps to integrate into the reports.

The Reportive solution is designed to integrate into your business in a non-intrusive manner while making the most of all available data sources. The solution also includes connectors that allow you to retrieve data from your existing BI tools (SAP/Business Objects, SAP/BW, IBM/Cognos Impromptu).
 

Excel connector

 

 

This connector can handle most Excel workbooks, including:

 

  • processing of "accounting" models (an extra column is added every month), detecting hierarchies of columns based on their offset position or a rendering style,

  • processing of named ranges,

  • batch processing of a set of workbooks,

  • possibility to include the name of the workbook or of the tabs in the extracted data.

     

                                                

                                                                       Data transposition 

 

The connector supports the extraction of data in all formats supported by Microsoft Excel 2003, 2007 and 2010.

 


Text connector

This connector allows for quick retrieval of text data, taking into account a number of characteristics:

 

  • File encoding (ANSI, MS-DOS, Unicode UTF-8, Unicode UTF-16 (Little Endian, Big Endian)),
  • Language of the data for non-Unicode files (French, Greek, Russian, Japanese...),
  • Delimited data (multiple delimiters supported) or fixed width,
  • Include axis headers or not,
  • Remove the first n rows of data,
  • Separators (decimal, thousands)
  • Interpretation of empty cells (last known item of data or empty),
  • Automatic whitespace trimming
  • Automatic change of case

The performance of the connector allows an interpretation of more than 80,000 cells per second on a simple laptop.


 

SQL connectors

The solution integrates two SQL connectors. The first one, "SQL ODBC", uses the Microsoft Query tool that comes with the Microsoft Office suite to define queries on any ODBC-compatible data source (flat files, Microsoft Access, Fox Pro, Microsoft SQLServer, Oracle, Sybase, Informix, MySQL, IBM DB2, IBM Lotus Domino PostgreSQL, Pervasive SQL)...

Using Microsoft Query, you can query the database visually, without any knowledge of SQL.


 

                                                                         Microsoft Query


This connector also allows you to set up a parameterized query - the parameter can be a constant or a list of values calculated by Reportive (e.g. detailed information about the top 5 sellers in each region).

The second connector, "SQL Reader", is designed for more advanced users, as it allows you to enter ODBC-compatible SQL sentences and to exploit the power of the SQL language and of proprietary extensions of implementations made by Microsoft SQLServer or Oracle.
 

 

OLAP connectors (Microsoft Analysis Services, SAP/BW, Oracle Essbase)

These connectors can extract data from cube files (with a .cub extension) or from Microsoft Analysis Services, SAP BW (Business Warehouse), or Oracle Essbase servers.

 

                                     

                                                                       Olap Query
 

 The simple, easy-to-understand interface allows you to build a query quickly without any prior knowledge of the MDX language used for querying multidimensional cubes.

A unique query-slicing feature makes it possible to process large queries by subdividing them into sub-queries that are easier to calculate, thus avoiding to crash the server. Among other things, this feature means better use of cube partitioning so as to achieve faster response times.

Combined with an incremental cache, the query then interrogates the server only for missing combinations (those that do not exist locally), thus avoiding sending queries for data that has already been retrieved.

Multidimensional queries extract not only raw data, but also aggregated data whose calculation mode is not known by Reportive. Reportive's data format and calculation engine take this information into account each time that the aggregated level data is used in calculations.