Aug 09, 2022 Last Updated 12:14 PM, Jul 18, 2022

Super User

Hi my name is Marcubie and I have been the Creative Director on Medunten Technology. The languages only differ in their grammar, their pronunciation and their most common words. he thought. It wasn't a dream. His room, a proper human room although a little too small, lay peacefully between its four familiar walls pronunciation 

Case References

Omni360 FEP

參考客戶群
台新銀行 國泰世華銀行
新核心系統
復華銀行 元大銀行
新核心系統
國泰銀行 台北富邦銀行
澳盛銀行  

 

Omni360-TR

參考客戶群 
台新銀行 國泰世華銀行 
國泰世華銀行 國泰世華銀行
新核心系統
萬泰銀行 台北富邦銀行
澳盛銀行 台新銀行 

 

信用卡

參考客戶群 專案名稱
法商喜加利(Cetelem)發展股份有限公司 Sema CardPac 系統建置及維運
法商佳信銀行 信用卡系統維運
台新銀行 Debit Card 管理以及交易處理系統建置
台新銀行 白金卡權益管理系統建置
台新銀行 銀聯卡系統建置
中國信託商業銀行 海外信用卡業務系統建置
台北富邦銀行 悠遊Master Debit Card系統建置
永豐銀行 悠遊卡系統建置
國泰世華銀行 銀聯金融卡系統建置
聯合信用卡中心 央行同業資金調度系統
永豐銀行 高捷一卡通系統建置

 

Call Center&CRM

參考客戶群 專案名稱
花旗銀行台北分行 Phone Banking Call Center 系統移植
花旗銀行台北分行 Credit Card Call Center 整合系統開發
花旗銀行台北分行 Call Center 第三階段整合工作 (Preview Outbound)
花旗投顧 Call Center系統建置共45席
花旗銀行帳務催收中心 Predictive Dialer Outbound系統建置建置共96席
花旗銀行帳務催收中心 Conversations催收系統升級共145席
花旗銀行帳務催收中心 催收中心Best time to call 系統建置
台灣惠氏股份有限公司 全國第一家分散式 Call Center 系統建置
上海惠氏營養品有限公司 Call Center系統建置共50席(Inbound 10席 Outbound 40席)
美國惠氏藥廠(香港)有限公司 Call Center Outbound系統建置共20席
廣州惠氏營養品有限公司 Call Center Outbound系統建置共50席
香港American Express Call Center系統建置共35席
櫻花企業 產品叫修系統建置共10席
台新銀行 信用卡中心 E-News系統建置
華信銀行 Call Center系統建置共100席
富邦投信 IVR 系統轉換及建置
建華金控 高雄第二客服中心系統建置共100席
萬泰銀行 Predictive Outbound系統建置
世華商業銀行 Call Center 系統整合共60席
國泰銀行 Call Center系統建置共120席
國泰世華銀行 Call Center合併專案共220席
國泰世華銀行 台中第二客服中心系統建置共100席
遠東銀行 Inbound Call Center系統建置
復華銀行 財富管理系統建置、全行業務報表系統
中國銀行
新核心系統
個人貸款催收系統建置
合作金庫銀行 客戶關係管理系統 –行銷活動管理建置
新秀國際行銷顧問有限公司 電話行銷系統建置共 25 席
全聯社 客戶資料清洗、客戶關係管理系統

 

其他

參考客戶群 專案名稱
新加坡儲蓄銀行 金融前端系統 Y2K 改造工程
新加坡發展銀行與儲蓄銀行 合併電子金融支付系統整合顧問專案
中國農民銀行 IC 金融卡專案
中國農民銀行 Asset 2000+ Y2K改造及測試工作
中國國際商業銀行 Asset 2000+ Y2K改造及測試工作
高新商業銀行 Asset 2000+ Y2K改造及測試工作
中國農業銀行
深圳及廣東分行
1/LINK(POS, ATM及跨行連線系統) Y2K改造及測試工作
中國建設銀行
深圳及上海分行
1/LINK(POS, ATM及跨行連線系統) Y2K改造及測試工作
香港道亨銀行 ENM
中央信託局 ENM, 自動化設備監控系統
華南商業銀行 ENM, 自動化設備監控系統
合作金庫 ENM, 自動化設備監控系統
台灣中小企業銀行 ENM
玉山銀行 ENM
高新商業銀行 ENM, Asset 2000+
板信商業銀行 ENM
台北市第五信用合作社 ENM
復華銀行 FISC Gateway專案
萬泰銀行 FISC Gateway專案
中華開發工銀 亂碼化設備提升及FISC Gateway專案
國泰世華銀行 亂碼化系統建置
澳盛銀行 NCCC NMIP系統建置
渣打銀行 NCCC NMIP系統建置
星展銀行 HSM & NMIP系統建置
中華開發金控 IFRS報表及主管機關申報系統

 

顧問服務

專案名稱
協助TCS FS進行廣東農信銀行新核心系統建置顧問服務
協助FNS進行中國華夏銀行系統建置顧問服務
協助FNS進行中國建設銀行系統建置顧問服務
協助TCS FS進行杭州商業銀行新核心系統建置顧問服務
協助TCS FS進行台北富邦銀行核心系統差異分析服務
Tagged under

CoSort (Data Transformation)

  • Nov 19, 2014
  • Published in IRI

The world's first commercial sort package off the mainframe continues to deliver maximum price-performance and functional versatility for manipulating huge files, tables, and other data sources.

IRI CoSort® is not only the world's #1 sort/merge utility, it is also a proven, user-friendly, one-stop "super tool" supported in Eclipse for easily performing, and accelerating.

Use CoSort and its powerful 4GL program and Eclipse GUI for:

  • legacy sort replacement and data migration projects
  • fast data warehouse ETL and ODS operations
  • very large database (VLDB) load and query acceleration
  • BI tool performance optimization; data governance
  • application performance improvement

Use CoSort to augment - or replace - existing ETL / sort / BI tools, 3GL and SQL programs, or batch and shell (Perl, Python, etc.) scripts.

 

Feature & Benefit

Feature

Benefit

Multi-threaded sort, sum, and reformat engine

Speed, as multiple cores process big data together. A much lower-cost, and far more proven alternative to riskier and more complex platforms like Hadoop, in-memory or NoSQL DBs, DB and ELT appliances.

Single-pass sort, join, aggregate, report, and protect

Task, I/O, script, and vendor consolidation

Single-pass, single-script ETL for flat files, ODBC and bulk-loaded DBs

The data integration market's simplest, most price-performant ETL solution for big data warehouses

One easy 4GL for data definition, manipulation, and BI

No/low learning curve, self-documenting metadata for report generation, too.

Filtering, selection, de-duplication, segmentation

Bulk data reduction, customer data integration (CDI)

Multi-source joins, slowly changing dimensions, lookups

Built-in change data capture and BI

Built-in field protections (mask, encrypt, etc.) for PII, PHI

Combine data security with staging and reporting

Built-in test data generation capabilities

Easily move between production and testing

Free IRI Workbench GUI, built on Eclipse

Access, share and deploy data, metadata, and jobs

Replacements for COBOL, Unix, and other sort verbs

Save time and money without source conversion

Data type, endian, and file format conversion

Migrate mainframe and DB data

Expressions, validations, complex transforms

Bespoke data manipulation and discrete solutions

Mainframe sort and metadata converters

Migrate from costlier utilities and applications

Supports 24/34 COBIT v4 control objectives

Facilitate data governance and stewardship

 

IRI CoSort Use Cases

Task Consolidation Unlimited Mapping Database Acceleration
CoSort use case 2 CoSort use case 3
"CoSort runs our data filtering, sorting, merging, aggregating, and reformatting tasks together, and manages them all in one script we can easily understand and tweak." "CoSort moves data between massive file sources and targets efficiently. We can pre-sort to speed loads and create hand-off files for BI at the same time." We use CoSort for change data capture and offline reorgs -- improving performance 80%. It removes our data volume ceiling and speeds up queries."
Tagged under

NextForm (Data Migration)

  • Nov 19, 2014
  • Published in IRI

NextForm v3 is the latest data management product supported in Eclipse from IRI, The CoSort Company. Spun from the SortCL program in IRI CoSort, IRI NextForm is a data migration and reformatting package that helps you convert and re-use the data stored in legacy fields, file formats, and databases.

Apply and view your data in new ways ... in new files and tables, custom reports, BI tools, virtualized views, and more. NextForm handles data in all of these:

File Formats

Data Type Groups

CSV

Delimited Text 

Fixed-position Text

žLDIF

žMicro Focus Variable Length

Micro Focus ISAM¹

Line / Record / Variable Sequential

žVariable Blocked

žVision¹

žVSAM, QSAM, KSAM, C-ISAM²

žXLS (Excel)

žXML3

žASCII (C types)

žNumerics (All)

žEBCDIC MF & RM COBOL

žEndian (Big, Little, BOM)

žDates

žTimestamps

žComposite

žSingle-Byte

žMulti-Byte (CJK, Thai)

žUnicode (UTF-16)

žPacked Decimal

žZoned Decimal

Databases

Unstructured Sources

žOracle

žDB2 UDB

žDB2 Mainframe² 

žMySQL

žSQL Server

žSybase

žTeradata

žASN.1 TAP3

ž.DOC, .DOCX

ž.EML, .OST, .PST

ž.PDF, RTF

ž.PPT., .PPTX

ž.TXT, .XML

ž.XLS, .XLSX

¹ NextForm COBOL edition supports standalone conversion of Micro Focus and Acucobol Vision index files.

² Contact IRI Professional Services for VSAM and related semi-structured data conversion services.

³ Non-UIMA versions require XML data elements to conform to a flattened structure and other restrictions.

 

Feature & Benefit

Feature

Benefit

   

Recasts huge files fast; reliable, scalable migration of legacy data sets to client/server RDBs

Facilitates right-sizing initiatives, reduces data synchronization requirements, and saves time and money over custom coding or (the acquisition, implementation, and support of) legacy platforms

Converts over 100 data types

Allows data re-use in new platforms and applications

Structures unstructured data

Unlocks data elements and exposes associations for relational use

Re-maps field layouts

Supports pivot transformations, reporting needs, and database repopulation (inserts)

Data replication

Allows re-use of same or re-formatting data copies without new system re-generation, and facilitates data virtualization

Migrates database versions and platforms

Frees data and application from stale procedures,and frees company's locked into specific vendor terms

Built-in report generation

Migrate and expose information in multiple sources in custom displays suitable for billing and analytics

Interoperable metadata

Re-use source and target data definitions, as well as mapping and manipulation specifications in CoSort (for data transformation and reporting), FieldShield (data masking), and RowGen (test data generation)

Simple data and definition (metadata) syntax, optionally supported in purpose-built Eclipse GUI

Data migration tasks are easy to configure, run, modify, and share

Cross-platform; runs on Windows, Unix/Linux

The same jobs defined or run on one platform can be modified or run on any other

Low cost licenses and volume discounts

Immediate project ROI and low TCO for enterprise-wide deployment

 

IRI NextForm Use Cases

Quick and Easy Data Migration Multiple Files and Data Types Multiple Files and Data Types
NextForm use case 1 NextForm use case 2 NextForm use case 3
"NextForm simply and quickly customizes our outputs when converting LDIF files to CSV. A 165mb LDIF file converted in seconds, 1+GB in less than a minute. Excellent product!" "NextForm converts EBCDIC data files (including zoned and PD fields) to ASCII. As a beginner I was able to make new jobs quickly and determine the output was correct." "Performance was great, and the GUI was not necessary because the jobs self-document. Among all the conversion tools we found, NextForm was at once the easiest and most robust.
Tagged under

Workbench (GUI)

  • Nov 19, 2014
  • Published in IRI

IRI Workbench™ is the free graphical user interface (GUI) and integrated development environment (IDE) for all IRI software products. Running on Windows and Linux clients, IRI Workbench combines the proven performance of IRI software engines with the familiar job design and management facilities of Eclipse.

IRI Workbench features metadata creation, conversion, discovery, and application wizards to help you generate, deploy, and manage the simple data definition files (DDF) and job scripts common to all IRI software.

IRI Workbench includes purpose-driven wizards to build new jobs for:

  • very large database extraction (E) using IRI FACT
  • data transformation (T), loading (L), and reporting using IRI CoSort
  • DW ETL and database reorg using FACT and CoSort
  • data and database migration, replication, or federation using IRI NextForm or CoSort
  • data encryption and masking using IRI FieldShield or CoSort
  • test data generation jobs using IRI RowGen or CoSort

Within the wizards and dialogs are also data mapping, MDM, and rule application facilities. Each created or imported job produces one or more standalone job scripts or configuration files to drive the above tasks.

Modify jobs with GUI components or a syntax-aware editor. Execute from the GUI, local or remote system command line, a batch script, or API call.

IRI job scripts are simple, portable text files. Run them anywhere that the back-end IRI software product is licensed. The scripts' data and job definitions all use the shared metadata of the CoSort Sort Control Language (SortCL) 4GL program.

Scripts and metadata managed in the IRI Workbench are easy to search and share with built-in Eclipse functionality. Free Eclipse plug-ins like GIT and SVN support team sharing, version control, and metadata lineage and impact analysis.

Eclipse Facilities

One of the most powerful aspects of the IRI Workbench GUI is that it is built on Eclipse™.

The Eclipse Integrated Development Environment (IDE) gives IRI CoSort, IRI Fast Extract (FACT), IRI FieldShield, IRI RowGen, and IRI NextForm users:

  • A familiar, common GUI, and a shared metadata, job, and worfklow management system
  • The power to combine products in purpose-driven ways (e.g., the offline reorg wizard)
  • Direct browsing and data movement for local and remote source files and on-line RDBs
  • Ergonomic features like perspective control and text search (e.g., for metadata impact analysis)
  • Plug-in interactions for BI/analytics (e.g., BIRT), metadata asset control (e.g. EGit), data modeling, etc.
  • Access to Hadoop (HDFS), mainframe, semi-structured, and unstructured data sources
  • The opportunity to use Enterprise Service Bus (ESB) modules from providers like W2O2

For example, the Eclipse data tools platform (DTP) plug-in gives IRI Software users the ability to browse and edit their source and target databases as they:

  • unload in bulk with FACT, and select/filter in CoSort/SortCL or in SQL
  • load in bulk with pre-CoSorted data, and insert/update in CoSort/SortCL or SQL
  • manipulate and protect table contents with FieldShield (or CoSort/SortCL)
  • migrate tables with NextForm (or CoSort/SortCL)
  • generate test tables with RowGen (or CoSort/SortCL)

Workbench1

In the same GUI, the results of CoSort/SortCL, FieldShield and other IRI software operations can feed advanced data visualization plug-ins like BIRT:

Workbench2

Discover Data

The IRI Workbench supports the discovery and definition of your disparate data sources in both local and remotely connected systems. All flat files and database tables to which you connect can be defined automatically in data definition file (DDF) format. The data discovery and definition features in the Workbench support all IRI software users. Standalone data profiling tools may also be used, outside of or integrated into Eclipse. Once profiled and documented in DDF metadata repositories, you are ready to being using the layout information in their data integration, staging, protection, and BI applications.

Workbench3

 

Design and Run Job

The IRI Workbench provides a simple visual interface and ergonomic modules to design and run all IRI software. In the GUI, built on Eclipse, you build, modify, share, and execute simple, portable job scripts.

The job scripts for all the products (except IRI FACT) are based on the IRI CoSort Sort Control Language (SortCL) program. SortCL is a fourth-generation language (4GL) designed to be self-documenting for English readers, but with the IRI Workbench, you do not have to learn the language.

Job scripts can also render in a syntax-aware editor. You can use the editor to write or modify parameters. Changes in the scripts are reflected dynamically in the job outline, the GUI dialogs, and broader job flow (project) metadata. Thus there are a number of places you can make changes that will propagate automatically.

Tagged under

FieldShield (Data Masking)

  • Nov 19, 2014
  • Published in IRI

IRI FieldShield® is powerful, affordable, and easy-to-use data masking software for structured data sources (DBs and flat files), big and small.

FieldShield shields fields with the compliance industry's broadest array of protection functions. FieldShield provides role-based access controls for sensitive data on a static or dynamic basis to help you comply with CIPSEA, FERPA, HIPAA/HITECH, PCI, SOX, and international data privacy laws like the EU Data Privacy Directive and POPI in S. Africa.

Create, manage, and run FieldShield jobs in its familiar and friendly GUI, built on Eclipse. Modify and run FieldShield's simple text scripts from the GUI, command line, batch programs, or database applications. Or, call FieldShield functions at the API level for embedded data protection.

FieldShield is the best way to:

  • Profile, secure, present, and populate data in a familiar integrated development environment (IDE)
  • Mask big data using your existing systems, without Hadoop, in-memory databases, or appliances
  • De-identify data in one or more sources simultaneously based on your business rules
  • Specify protection conditions and rules across tables for efficiency and referential integrity
  • Encrypt and remove the individualizing characteristics of data without cutting off access to non-sensitive data, or changing its basic appearance
  • Auto-create XML audit logs to help verify compliance with data privacy laws
  • Fold data masking into data transformation, migration, replication, loading, federation, and BI activities

 

Feature & Benefit

Feature

Benefit

Field-level protection

Protects faster and surer than other, bulk protection methods. Leaves non-sensitive data in its original format and available for regular processing. Even if one field is compromised, the others stay safe with their own protection (vs. breaches where one password exposes all).

Multiple function choices (i.e., encrypt, mask, pseudonymize, hash, de-ID, randomize, substring, math, etc.)

Bases security decisions on the nature of each datum, on considerations like: security level, reversibility, ciphertext appearance, and speed.

Multi-platform executable and external libraries

Deploys concealment and revelation widely and easily, through bulk/batch, real-time applications, or through stored (SQL) procedures (e.g., in-situ encryption).

Database and file agnostic, multi-source and target

Secures data at sources and endpoints across multiple database platforms and file formats with the same product, and at the same time.

Random value lookups

Pseudonymizes PII using data from the same or third-party source(s) to provide realism, safety, and reversibility (optional).

Format-preserving encryption

Preserves the look and feel of the original values, fooling hackers and enabling application and load testing while preserving referential integrity.

Cross-table rule application and storage

Defines, enforces, and re-uses protections for common-named tables throughout an entire database. Preserves referential integrity because common start values get the same end values.

Standard and custom National ID (NID) masking

Saves research and design time in complying with de-identification requirements and local data privacy laws.

Hashing and tokenization routines

Validates the integrity, and improves the security, of encryption operations.

XML audit log file option

Verifies data privacy law compliance efforts and supports queries and reporting of all runtime details.

Multi-source, single (or multi)-target

Saves protection design and execution time by protecting many different files and tables in the same job script and I/O pass. Consolidates multiple protections and authorizations in a single target, and thus reduces both throughput and data synchronization concerns; i.e., different people can reveal different fields from the same document.

Metadata compatibility with IRI CoSort (SortCL) and MIMB-supported platforms

Runs data protection with data transformation, migration, and reporting in the same job script and I/O pass. MIMB users can convert existing metadata in BI, CRM, DB, ETL, and modeling tools, into the data definition file (.DDF) format that FieldShield uses to protect the data used in those apps.

Easy 4GL scripts supported by an Eclipse GUI with: metadata discovery and job creation wizards, function dialogs, syntax-aware editing, and runtime options

Reduces the learning curve in discovering, profiling, and protecting data in disparate sources. Data layouts and field functions are self-documenting so that data architects, DBAs, and compliance teams can easily design, modify, and verify jobs. Eliminates the complexity of proprietary GUIs and cumbersome database encryption implementation.

 

IRI CoSort Use Cases

Payment Card Industry Data (PCI) Personally Identifying Information (PII) Protected Health Information (PHI)
FieldShield use case 1 FieldShield use case 2 FieldShield use case 3
"FieldShield decrypts and re-encrypts fields in our credit card migration and test files, and easily generates and manages encryption keys." "We use the FieldShield GUI to design and run our Oracle data masking jobs on Linux. Eclipse is familiar to us already so we didn’t need any help." "FieldShield’s de-identification and hashing functions help our geo-medical consumer health databases exceed HIPAA requirements."
Tagged under

Popular Products

Solace

Solace

Distributing Products

i-Encounter Gatos

i-Encounter Gatos

Customer Relationship Management

i-Encounter Agent

Customer Relationship Management

i-Encounter Collection

Customer Relationship Management

i-Encounter eLoan

Customer Relationship Management