Data Replication & Exchange

We are the sole distributor for the Attunity solutions in Macau. Attunity is a pioneer in heterogeneous data availability, supporting many styles of integration across the industry’s broadest array of platforms. Attunity products allow you to integrate and manage data more efficiently and effectively in heterogeneous environments, delivering more data, ready for analytics, to the business.

Purpose

Attunity Replicate enables you to replicate, synchronize, distribute, consolidate and ingest data across all major databases, data warehouses and Hadoop, on premises and in the cloud. Here are the data replication and exchange projects we have implemented based on Attunity products.

features

Data Exchange Project (2008) – IACM DSFSM DSAJ

The Data Replication solution based on Attunity products and iNSys services enable various government departments to exchange critical data for traffic control. The key data includes driving license and vehicle annual renewal license (owned by IACM), vehicle registration (owned by DSAJ) and traffic tickets (owned by DSFSM). The requirements include propagating data from IACM AS/400 DB2 to IACM One-Stop Service and DSFSM SQLServer Database, and from DSFSM SQLServer back to IACM’s AS/400 DB2. The replication process also converts different character sets into Unicode.


Project Scope

  • Real-time Data Replication

    • AS/400 DB2

    • Oracle

    • SQLServer & Interbase

  • Code Conversion

    • EBCDIC to ANSI conversion

    • Double Byte Chinese / Portuguese

    • DBCS & Unicode

  • User-Defined Character (UDC) Mapping

    • IACM Big5 + DSAJ Big5 -> (Unicode + HKCSC) + ChangJie + Quick

    • Define internal code, Fonts, IME (ChangJie + Quick) for non-Unicode in PUA

Data Migration Project (2016) – DSAT

  • Migration Scope - Migrate from AS400 DB2 V5R4 to Oracle 11g R2

    • 120 database tables

    • Data contains English characters, Portuguese characters, Chinese characters and User-defined characters

    • Convert SBCS (Single Byte Chinese Characters) BIG5 to UTF8

  • Attunity Components License for Migration

    • Replicate / StreamFlow

    • CDC agent on source

    • Oracle driver on target

  • Data Verification - Compare the number of migrated records in Oracle with the number of records in AS400 (Count)

Data Migration Project (2017) – DSAT

  • Migration Scope - Migrate from AS400 DB2 V5R4 to Oracle 11g R2

    • 140 database tables

    • Data contains English characters, Portuguese characters, Chinese characters and User-defined characters

    • Convert SBCS (Single Byte Chinese Characters) BIG5 to UTF8

  • Data Verification - Compare the number of migrated records in Oracle with the number of records in AS400 (Count)

© 2019 iN Systems (Macao) Ltd. 盈資系統科技(澳門)有限公司. All Rights Reserved.