page_title: CubePort
section_title: Objects Converted
hierarchical_section_title: CubePort / Objects Converted
caption_attribution_description: English: CubePort Architectural Diagram
context_page_description: CubePort is a commercial software application that converts from Oracle Essbase to the analogous Microsoft product Microsoft Analysis Services, which is built into Microsoft SQL Server. This application achieves this through various analogy mapping techniques, and is a standard client-server application that runs on a Windows computer but may connect to non-Windows servers. CubePort converts the various OLAP structures and syntaxes in the source through an extraction process, interprets, and recreates in the target. The objective is to simulate exactly the behavior of the original source system to the target system.
  The application also includes UI phases such as Authentication, Questions, Extraction, and Verification. Substantial testing normally occurs after the conversion process prior to posting the objects to production.
context_section_description: These standard objects in a cube are converted by the software with varying levels of robustness:
  Cube Outline
  Cube Data Loads and Dimension Builds
  Cube Security Model
  Cube Substitution Variables
  Cube Calculation Scripts
  Cube Report Scripts
  The output objects of a successful run of CubePort are: A relational Star schema and/or relational Snowflake schema, OLAP cube, Etl load packages, MDX (Multidimensional Expressions) files, and others.
caption: CubePort Simple Diagram
exif: {}