Sunopsis

Last updated

Sunopsis is a software company based near Lyon, France. It also has a United States headquarters in Burlington, Massachusetts. [1] The company was bought by Oracle in October 2006. [1] The new name of Sunopsis is Oracle Data Integrator - ODI. [2]

Contents

Sunopsis products provide solutions[ buzzword ] for data warehousing, data integration, data migration, data synchronization and Master data management.

Major products

Sunopsis Data Conductor

A data integration software product for ETL 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 (SOA) 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

See also

Related Research Articles

Model Driven Architecture® (MDA®) is a software design approach for the development of software systems. It provides a set of guidelines for the structuring of specifications, which are expressed as models. Model Driven Architecture is a kind of domain engineering, and supports model-driven engineering of software systems. It was launched by the Object Management Group (OMG) in 2001.

Visual programming language Programming language written graphically by a user

In computing, a visual programming language (VPL) is any programming language that lets users create programs by manipulating program elements graphically rather than by specifying them textually. A VPL allows programming with visual expressions, spatial arrangements of text and graphic symbols, used either as elements of syntax or secondary notation. For example, many VPLs are based on the idea of "boxes and arrows", where boxes or other screen objects are treated as entities, connected by arrows, lines or arcs which represent relations.

Enterprise service bus Communication system in a service-oriented architecture

An enterprise service bus (ESB) implements a communication system between mutually interacting software applications in a service-oriented architecture (SOA). It represents a software architecture for distributed computing, and is a special variant of the more general client-server model, wherein any application may behave as server or client. ESB promotes agility and flexibility with regard to high-level protocol communication between applications. Its primary use is in enterprise application integration (EAI) of heterogeneous and complex service landscapes.

The common warehouse metamodel (CWM) defines a specification for modeling metadata for relational, non-relational, multi-dimensional, and most other objects found in a data warehousing environment. The specification is released and owned by the Object Management Group, which also claims a trademark in the use of "CWM".

In software testing, test automation is the use of software separate from the software being tested to control the execution of tests and the comparison of actual outcomes with predicted outcomes. Test automation can automate some repetitive but necessary tasks in a formalized testing process already in place, or perform additional testing that would be difficult to do manually. Test automation is critical for continuous delivery and continuous testing.

Business process automation (BPA), also known as business automation or digital transformation, is the technology-enabled automation of complex business processes. It can streamline a business for simplicity, achieve digital transformation, increase service quality, improve service delivery or contain costs. It consists of integrating applications, restructuring labor resources and using software applications throughout the organization. Robotic process automation is an emerging field within BPA.

Business Objects's Data Integrator is a data integration and ETL tool that was previously known as ActaWorks. Newer versions of the software include data quality features and are named SAP BODS . The Data Integrator product consists primarily of a Data Integrator Job Server and the Data Integrator Designer. It is commonly used for building data marts, ODS systems and data warehouses, etc.

In computing, Data transformation is the process of converting data from one format or structure into another format or structure. It is a fundamental aspect of most data integration and data management tasks such as data wrangling, data warehousing, data integration and application integration.

Oracle Fusion Middleware consists of several software products from Oracle Corporation. FMW spans multiple services, including Java EE and developer tools, integration services, business intelligence, collaboration, and content management. FMW depends on open standards such as BPEL, SOAP, XML and JMS.

IBM App Connect Enterprise is IBM's integration broker from the WebSphere product family that allows business information to flow between disparate applications across multiple hardware and software platforms. Rules can be applied to the data flowing through the message broker to route and transform the information. The product is an Enterprise Service Bus supplying a communication channel between applications and services in a service-oriented architecture.

An information server is an integrated software platform consisting of a set of core functional modules that enables organizations to integrate data from disparate sources and deliver trusted and complete information, at the time it is required and in the format it is needed. Similar to how an application server is a software engine that delivers applications to client computers, an information server delivers consistent information to consuming applications, business processes and portals.

Knowledge Discovery Metamodel (KDM) is a publicly available specification from the Object Management Group (OMG). KDM is a common intermediate representation for existing software systems and their operating environments, that defines common metadata required for deep semantic integration of Application Lifecycle Management tools. KDM was designed as the OMG's foundation for software modernization, IT portfolio management and software assurance. KDM uses OMG's Meta-Object Facility to define an XMI interchange format between tools that work with existing software as well as an abstract interface (API) for the next-generation assurance and modernization tools. KDM standardizes existing approaches to knowledge discovery in software engineering artifacts, also known as software mining.

Frameworx is an enterprise architecture framework geared towards communications service providers.

The Oracle Unified Method (OUM), first released by Oracle Corporation in 2006, is a standards-based method with roots in the Unified Process (UP). OUM is business-process and use-case driven and includes support for the Unified Modeling Language (UML), though the use of UML is not required. OUM combines these standards with aspects of Oracle's legacy methods and Oracle implementation best-practices.

Rational Software Architect is a modeling and development environment that uses the Unified Modeling Language (UML) for designing architecture for C++ and Java EE (JEE) applications and web services. Rational Software Architect is built on the Eclipse open-source software framework and includes capabilities focused on architectural code analysis, C++, and model-driven development (MDD) with the UML for creating applications and web services.

In information systems, applications architecture or application architecture is one of several architecture domains that form the pillars of an enterprise architecture (EA).

Oracle Warehouse Builder

Oracle Warehouse Builder (OWB) is an ETL tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems.

Java Composite Application Platform Suite is a standards-based enterprise service bus software suite from Oracle Corporation. The suite has several components that help to integrate existing applications and deliver new business services in a service-oriented architecture environment. It is a Java EE compliant platform and provides application-to-application integration, business-to-business integration, business process management along with integrated human workflow, an Enterprise Information Portal, extract transform and load (ETL), business activity monitoring and composite application development.

Event-driven SOA is a form of service-oriented architecture (SOA), combining the intelligence and proactiveness of event-driven architecture with the organizational capabilities found in service offerings. Before event-driven SOA, the typical SOA platform orchestrated services centrally, through pre-defined business processes, assuming that what should have already been triggered is defined in a business process. This older approach does not account for events that occur across, or outside of, specific business processes. Thus complex events, in which a pattern of activities—both non-scheduled and scheduled—should trigger a set of services is not accounted for in traditional SOA 1.0 architecture.

Oracle Data Integrator (ODI) is an Extract, load and transform (ELT) tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems.

References

  1. 1 2 "Oracle buys Sunopsis". East Bay Business Times. 2006-10-09. Retrieved 2007-09-08.
  2. new name of sunopsis is Oracle Data Integrator - ODI http://www.next-decision.fr/les-editeurs/etl/oracle-odi