Welcome Guest! Log in
Due to some maintenance operations, stambia.org will be switched to read-only mode during the 13th November. It will be possible to read and download, but impossible to post on the forums or create new accounts. For any question please contact the support team.

Stambia DI for InterSystems Caché

    Stambia Data Integration allows to work with InterSystems Caché databases to produce fully customized Integration Processes.

    The database structure can be entirely reversed in Metadata and then used in Mappings and Processes to design and adapt the business rules to meet the user's requirements.


    Prerequisites:
    • The InterSystems Caché JDBC driver must be installed in the Designer and Runtime
    • Stambia DI Designer S19.0.6 or higher

    Note:

    Stambia DI is a flexible and agile solution. It can be quickly adapted to your needs.

    If you have any question, any feature request or any issue, do not hesitate to contact us.

     

    Download

    You can find below the necessary material to work with InterSystems Caché in Stambia DI

    Name Description Download
    Generic Templates Package containing the generic Templates download
    Demonstration Project A project that demonstrates most of the features through examples of Mappings and Processes download

     

    Supported features

    You can find below an overview of what Stambia DI can do with InterSystems Caché databases

    Name Description
    Reverse

    The database structure can be reversed in a dedicated Metadata

    DDL /DML Operations

     

    DML/DDL operations can be performed on the database, such as: Insert, Update, Select, Delete, Create or Drop

    Integration methods
    • Append
    • Incremental Update
    Staging

    The databases can be used as a staging area to make data transformation, mutualization, ...

    The following modes are supported:

    • staging as subquery
    • staging as view
    • staging as table
    Reject

    Reject rules can be defined to filter or detect data that does not fulfill the rules during integrations.

    • Three type of rules can be created: Fatal, Warning, Reject
    • Depending on the specified type, the rejected data will not be handle the same way
    • Rejects of previous executions can also be recycled
    Replication

    Replication of databases is supported.

    The replication source can be any rdbms, Flat files or XML files.

    Articles

    Suggest a new Article!