The specifics depend on the version of the information Server that you deploy. You can use the Java integration Stage (unstructured data Stage) or any Java Pack stages to extract Excel data. As a lookup phase, the Java Client Stage will perform the lookup function. When used as a target phase, the Java Client Stage will use the data. The Java Client phase is a passive phase that can be used as a source, a target, and a lookup phase. The Java Transformer phase is an active phase that invokes a Java application that reads and converts input data and then writes it to the output link defined in the DataStage job. The Java Pack is available in DataStage 7.5.x or later. The DataStage Java Pack is a collection of two plug-in phases (Java Transformer and Java Client) that can be used to invoke Java applications in DataStage. Java integration Stage can be used in the following topologies: As a source, as a target, as a translator, as a lookup phase. Java integration Stage is available in IBM infosphere information Server 9.1 or later. The Java Integration Stage is a DataStage Connector that you can use to invoke a custom Java application from the Infosphere Data Stage and Quality parallel tasks.
DataStage can use its high-performance parallel framework to solve complex business problems by integrating a variety of data sources.ĭataStage Java Integration Stage and DataStage Javapack plug-ins
IBM Information Server DataStage is an ETL product that enables organizations to extract, transform, and load data from heterogeneous data sources. With IBM infosphere information Server, businesses can increase their operational efficiencies with lower costs and risks. It helps to analyze, clean, and integrate information from multiple heterogeneous data sources in a cost-effective manner. The IBM infosphere Information Server consists of a set of data integration products that can help businesses gain business value from information that spans multiple data source systems.