Version, Extraction, Tool, Connector, Systems

Jedox is expanding its SAP Palo connectivity. With the latest version of the Palo ETL 3.1 extraction tool, a connector to SAP R/3 and ERP systems is now also available. Previously, Palo ETL enabled the extraction of data directly from the SAP Business Warehouse (BW) for entry in the OLAP database Palo.  [...] With the enhanced Palo SAP connectivity, it is now no longer necessary to refer to SAP BW for OLAP analyses using SAP data. SAP R/3 and ERP system users who do not require full BW functionality can now use the Palo Suite and Palo SAP Connectivity as an easy and very flexible alternative to a BI platform which can be installed quickly and is ideal for use by professionals.  [...] Besides the new 3.1 version of Palo with many new features, enhanced performance and optimized stability is the new Palo OLAP GPU technology the focus of the presentations.  [...]

The Palo SAP Connectivity is an additional component of Palo ETL, which offers additional types of connections and extractions to access SAP Systems directly. Palo can now be integrated optimally into SAP environments.  [...] SAP R/3 and ERP system users who do not require full BW functionality can now use the Palo Suite and Palo SAP Connectivity as an easy and very flexible alternative to a BI platform which can be installed quickly and is ideal for use by professionals. SAP BW system users might access consolidated data from the SAP BW Data Warehouse Layer for OLAP analyses.  [...] The extraction of data from SAP Business Warehouse (BW/BI) is put into practice easily. BW info objects can be loaded directly as dimension into Palo OLAP, including all the original attributes, texts and hierarchies. Transaction data is transferred with high performance from BW Data Store Objects (DSO).  [...]

This allows for example the creation of staging areas to pre calculate and consolidate information before loading them into Palo OLAP. Palo ETL 3.0 SR1 also offers new extraction filter functions for dimensions and cubes. The last new feature area is the dynamical creation and extraction of Palo OLAP rules.  [...] Palo Suite Enterprise 3.0 SR1.  [...]

With Loads, data is written into the target system. The creation of dimensions and cubes in the Palo OLAP Server is achieved in a highly performant manner through optimal utilization of the interface. In addition, data can be written back into relational database systems and flat files.  [...] Drill-Through describes the linking from one data source to another, most often a more detailed data source. With the help of Palo ETL, the Drill-Through to the document data in the source systems is made possible by caching the required data. With this, information on the origin of the data can be displayed on a high level of detail via navigation.  [...] A direct link to SAP systems via RFC/BAPI is facilitated through Palo SAP Connectivity.  [...]

Data Warehousing. Information Flow, Data Collection, Extraction.  [...] Corporate Information Systems. Financial Consolidation, Reporting.  [...] ABB. Financial Consolidation and Reporting (IFRS), DWH for corporate data, macro-economic model for growth forecasting based on industry forecasts.  [...]

The Palo SAP Connectivity is an additional component of Palo ETL and is offered exclusively as part of the Palo Suite Premium. Palo SAP Connectivity replaces the Palo ETL SAP Connector, which only enabled access to SAP BW. Details about the new Palo SAP Connectivity are available at.  [...] For detailed information about Palo and Jedox please visit our website. www.jedox.com.  [...]

Data integration (ETL) stands for the Extraction and Transformation of data within an IT structure. Usually these processes extract data from various Data sources (databases,files, applications, Web Services, E-Mail, etc.), use different rules of transformation (lookup, join, clearing of duplicates, aggregation, etc.  [...] In Comparison to other ETL Tools, Palo ETL is tailored to the specific needs of Palo. This allows the Palo OLAP to be supported as a Data source and as a Data Target. Handling of the cubes, levels, attributes and rules is very simple. The relational model of the Data sources can therefore easily be transformed into an OLAP model.  [...] ) and finally Load the Data into the desired system.  [...]