Oracle Integration

Oracle Integration

Master Data Management

To any Finance Department financial master data is like the DNA as it defines GL accounts, organisational hierarchies, legal entities, assets, cost centers and other core F&A data objects. Up-to-date and accurate master data represents an ongoing challenge for Finance and Accounting teams. Very few options that satisfy their master data requirements are available to F&A teams.

MDM software solutions mostly address master data such as customers (CDI) and products (PIM). Thus, Finance & Accounting teams usually make use of tools like Oracle Hyperion DRM that come pre-packaged with their EPM/BI solutions. DRM has become the tool of choice for users who want to master their corporate chart of accounts. This helps them rationalise, maintain and align their general ledger chart of accounts and their corporate consolidation structures inside DRM to ensure accurate financial consolidation and reporting.

Maintaining an evergreen set of maps between general ledger account segments, financial reporting and consolidation structures is critical to faciliatating consistent and accurate consolidation across statutory or tax reporting jurisdictions, divisions and geographies. This helps optimize performance measurement, financial consolidation and reporting requirements.

At S&M Tech Solutions, our consultants help you create and manage various hierarchies, dimensions, attached properties and reporting structures by rationalising master data across layers. We are reponsive to your evolving organisation structure.


Data integration with Oracle Hyperion Financial Data Quality Management Enterprise Edition (FDMEE) enables improved access to data sources to finance teams. Through integration with Enterprise Resource Planning (ERP) systems and other data sources, FDMEE transforms data and metadata from various sources and creates data flow to populate Hyperion products.

Our Oracle-Hyperion experts will help you gain the best rewards from an FDMEE implementation by helping you define your organisation’s specific data mapping needs.


ODI is an Extract Load and Transform (ETL) tool. It is in Oracle fusion middleware suite of products. ODI is capable of high volume data loads and data transformations, and high performance in general. It is compatibile with all major databases. Essbase, HFN and Planning adapters can be directly plugged into it.

Components in ODI, called Knowledge Modules, contain information that allow it to specific tasks against specific technology like Planning. S&M Tech Solutions offers solutions for Hyperion as well as ODI systems. Contact us to know how we can integrate your existing system through ODI.


EPMA eliminates dependency on conventional ETL tools. It offers a unified interface that enables building and loading of hierarchies directly to various applications through flat files or interface tables. Though several complications are involved in it's setup EPMA is an exceptional tool for managing and deploying metadata between multiple applications. Even experienced developers find creating solutions using the shared library, flat file generator as well as interface tables challenging.

Our consultants have successfully implemented EPMA solutions for our clients. Contact for information on EPMA.


All Oracle Hyperion technologies use SQL to transact to databases in the background. To fully understand the workings of derivable queries, sub-queries and other advanced Hyperion features one needs to understand SQL. To know how your Hyperion system will operate you need to know how SQL operates. A good understanding of SQL will immensely facilitate the understanding of the needs and limitations of the Hyperion system. This will allow us to create a soulution that will meet your purpose.

S&M Tech Solutions can help your SQL system irrespective of the scope. We have worked on several Hyperion-SQL setups for clients. We will help you find the ideal business analytics solution or data platform.