Sunopsis
Encyclopedia
Sunopsis is software company based near Lyon
, France
. It also has a United States headquarters in Burlington, Massachusetts. The company was bought by Oracle
in October 2006.
Sunopsis products provide solution
s for data warehousing, data integration
, data migration
, data synchronization
and Master data management
.
projects, Sunopsis Data Conductor provides a business-rules-driven approach to defining data transformation and integration processes. It is based on an E-LT architecture.
Business-rules-driven Approach to Data Integration: Unlike traditional ETL tools that closely intermix data transformation rules with the procedural steps of the integration process and require the development of both data transformations and data flow, Data Conductor clearly separates the business rules (the “what”) from the actual implementation (the “how”). Business rules describing mappings and transformations are defined graphically, through a drag-and-drop interface, and stored independently from the implementation. Data Conductor generates the data flow automatically using code templates (Knowledge Modules), which can be fine tuned if required.
E-LT Architecture:Traditional ETL tools perform complex data transformations using proprietary, middle-tier ETL engines. Instead, Sunopsis uses the E-LT (Extract – Load & Transform) approach, wherein all data transformations are executed by the existing RDBMS engine(s).
) integration with a single user interface and a common business rules driven approach. The platform enables the enterprise to present a single view of its Information Systems, with a unified access model. Active Integration Platform is built around a persistent data and event database – the Active Integration Hub (AIH) – which essentially captures the superset of all data and business events contained in all systems linked by the Active Integration Platform.x
Lyon
Lyon , is a city in east-central France in the Rhône-Alpes region, situated between Paris and Marseille. Lyon is located at from Paris, from Marseille, from Geneva, from Turin, and from Barcelona. The residents of the city are called Lyonnais....
, France
France
The French Republic , The French Republic , The French Republic , (commonly known as France , is a unitary semi-presidential republic in Western Europe with several overseas territories and islands located on other continents and in the Indian, Pacific, and Atlantic oceans. Metropolitan France...
. It also has a United States headquarters in Burlington, Massachusetts. The company was bought by Oracle
Oracle Corporation
Oracle Corporation is an American multinational computer technology corporation that specializes in developing and marketing hardware systems and enterprise software products – particularly database management systems...
in October 2006.
Sunopsis products provide solution
Solution
In chemistry, a solution is a homogeneous mixture composed of only one phase. In such a mixture, a solute is dissolved in another substance, known as a solvent. The solvent does the dissolving.- Types of solutions :...
s for data warehousing, data integration
Data integration
Data integration involves combining data residing in different sources and providing users with a unified view of these data.This process becomes significant in a variety of situations, which include both commercial and scientific domains...
, data migration
Data migration
Data migration is the process of transferring data between storage types, formats, or computer systems. Data migration is usually performed programmatically to achieve an automated migration, freeing up human resources from tedious tasks...
, data synchronization
Data synchronization
Data synchronization is the process of establishing consistency among data from a source to a target data storage and vice versa and the continuous harmonization of the data over time. It is fundamental to a wide variety of applications, including file synchronization and mobile device...
and Master data management
Master Data Management
In computing, master data management comprises a set of processes and tools that consistently defines and manages the non-transactional data entities of an organization...
.
Sunopsis Data Conductor
A data integration software product for ETLExtract, transform, load
Extract, transform and load is a process in database usage and especially in data warehousing that involves:* Extracting data from outside sources* Transforming it to fit operational needs...
projects, Sunopsis Data Conductor provides a business-rules-driven approach to defining data transformation and integration processes. It is based on an E-LT architecture.
Business-rules-driven Approach to Data Integration: Unlike traditional ETL tools that closely intermix data transformation rules with the procedural steps of the integration process and require the development of both data transformations and data flow, Data Conductor clearly separates the business rules (the “what”) from the actual implementation (the “how”). Business rules describing mappings and transformations are defined graphically, through a drag-and-drop interface, and stored independently from the implementation. Data Conductor generates the data flow automatically using code templates (Knowledge Modules), which can be fine tuned if required.
E-LT Architecture:Traditional ETL tools perform complex data transformations using proprietary, middle-tier ETL engines. Instead, Sunopsis uses the E-LT (Extract – Load & Transform) approach, wherein all data transformations are executed by the existing RDBMS engine(s).
Sunopsis Active Integration Platform
Sunopsis Active Integration Platform is an integration platform that unifies data-, event- and service-based (SOAService-oriented architecture
In software engineering, a Service-Oriented Architecture is a set of principles and methodologies for designing and developing software in the form of interoperable services. These services are well-defined business functionalities that are built as software components that can be reused for...
) integration with a single user interface and a common business rules driven approach. The platform enables the enterprise to present a single view of its Information Systems, with a unified access model. Active Integration Platform is built around a persistent data and event database – the Active Integration Hub (AIH) – which essentially captures the superset of all data and business events contained in all systems linked by the Active Integration Platform.x