跨平台信息系统数据迁移技术研究与实现  

Research and realization of cross-platform information system data migration technology

作　　者：李静 马超 黄镜宇 卢艳艳 Li Jing;Ma Chao;Huang Jingyu;Lu Yanyan(State Grid Hebei Information&Technology Company,Shijiazhuang 050000)

机构地区：[1]国网河北省电力有限公司信息通信分公司

出　　处：《电气技术》2019年第10期70-74,共5页Electrical Engineering

摘　　要：河北公司营销分析与辅助决策系统运行所依托的小型机设备已运行多年,近年来IBM 9116-561型号设备稳压模块存在家族缺陷,存在因设备故障导致营销类数据报表无法正常报送的风险,影响系统的安全稳定运行。基于以上因素的考虑,本文主要讲述ETL、Sybase数据库从现有小型机环境迁移至PC服务器设备过程中涉及的关键技术,主要包括:①Informatica及工作流导出和导入;②Sybase和ETL抽取工具的衔接;③新环境数据抽取。通过以上方面的技术研究,不仅有效解决了系统运行过程中存在的问题,为后续更好地开展运维工作打下基础,也为其他系统跨平台迁移提供了经验,具有很好的借鉴意义和价值。The minicomputer equipment supported by the operation of the marketing analysis and auxiliary decision system of State Grid Hebei Corporation has been running for many years.In recent years,the IBM 9116-561 model device voltage regulator module has a family defect.There is a risk that the marketing data report cannot be reported normally due to the equipment failure,affecting the system.Safe and stable operation.Based on the above considerations,this article describes the key technologies involved in the migration of ETL and Sybase databases from existing minicomputer environments to PC server devices.The major technologies include:①Informatica and workflow export and import;②Sybase and ETL Extraction of tools;③Extraction of new environmental data.Through the technical research in the above aspects,it not only effectively solves the problems existing in the system operation process,lays the foundation for better follow-up operation and maintenance work,but also provides experience for the cross-platform migration of other systems,and has good reference value.

关 键 词：ETL INFORMATICA SYBASE 数据迁移 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]