Data Integration Service - bizteco1

Data Integration Service



ETL

  • 운영시스템에서 발생하는 다양한 Data를 통합하여 DW, DM을 구축
  • Data Extract, Transform, Cleansing, Load, Integration
  • R-DBMS, NoSQL DB, SAP, MainFrame, File Data Integration
  • Hadoop Interface for Big Data Integration
  • JMS ETL – ETL에 Queue 활용
  • Any place install – No Server 가능
 
ETL

Data Migration

  • Source System의 Data를 Extract, Cleansing 하여 Target System에 적재
  • 이기종 System 간, 이기종 DBMS 간 Data Migration
  • Data discovery, profiling, cleansing, transformation, validation
  • BTC Saas Service for Data Migration
 
Migration

EAI

  • Enterprise Application Integration
  • Application, Data, Protocol Communication & Integration
  • 기업내 분산된 다양한 업무간 또는 내.외부 기관간 연계 구현 및 업무 통합
 
EAI

iShark ESB (Base on Apache ActiveMQ)

  • JMS Broker에 기반한 Enterprise Service Bus 구축
  • 표준화되고 안정적인 Service Bus를 통한 Data 및 Service Integration
  • 기업내 분산된 다양한 업무간 또는 내.외부 기관간 연계 및 통합
  • Application, Data, Protocol, Adapter, Service Integration
 
iShark ESB

iShark ESB Development Component

  • JMS Broker에 기반한 Enterprise Service Bus 구축
  • 표준화되고 안정적인 Service Bus를 통한 Data 및 Service Integration
  • 기업내 분산된 다양한 업무간 또는 내.외부 기관간 연계 및 통합
  • Application, Data, Protocol, Adapter, Service Integration
 
iShark ESB Component

BTC SaaS

  • Software as a Service
  • DB Migration Between different DBMS
    • Project Test시스템 구축
    • 이 기종 DBMS Data Migration
    • ETL with Heter-DBMS Join Function on JDBC
  • Excel vs DBMS
    • Excel Upload
    • DB Data Download
    • Excel & DB Join
  • EAI (Different function to One function)
    • FILE Adapter
    • DB Adapter
    • FTP Adapter
    • Excel Adapter
  • Reporting Generator
    • DB Data Statistic Report to Excel and PDF format and Sendmail

BTC SaaS Service for Data Migration

  • Data Migration can be performed by yourself using BTC SaaS Service.
    Be More performance and Stronger security, Rent SaaS Packages with DI Machine.
  • Can be performed independently of the type of OS, DBMS types and versions.
  • High Performance
  • Provides Integrated Development Environment (IDE) for easy and fast development
  • Easy & Simple & Fast Development
  • Data Migration Cost 60% Down and Shorter Period 60%

BTC Saas Service for Data Migration

DI Machine Rent 및 Sale

  • iShark DI Engine on Machine with HA(24×365)
  • iShark ESB on Machine with HA(24×365)
  • 사용자 교육

 
BTC DI Machine

BTC Oracle RTCC (Real Time Capture & Change)

 iShark Watcher가 CDC 처리 대상테이블의 실시간 변경 데이터를 Capture하여 Queue에 넣고 Apply Daemon이 Target DB에 동기화 합니다. (Oracle 10.2 이상)

    • Oracle to ANY DB CDC on ESB
    • Oracle to ANY DB CDC on JDBC
    • 실시간 CRUD 적용
    • No Logging Table 처리 가능
    • Transform, Filtering, Verification 가능
    • Business Logic 추가 적용 가능
    • ETL, ESB 와 연계 처리 가능

 

BTC Oracle RTCC