Sybase ETL - SAP

1y ago
3.16 MB
268 Pages
Last View : 14d ago
Last Download : 7m ago
Upload by : Kamden Hassan

User’s GuideSybase ETL4.2

DOCUMENT ID: DC00705-01-0420-01LAST REVISED: March 2007Copyright 2003-2007 by Sybase, Inc. All rights reserved.This publication pertains to Sybase software and to any subsequent release until otherwise indicated in new editions or technical notes.Information in this document is subject to change without notice. The software described herein is furnished under a license agreement,and it may be used or copied only in accordance with the terms of that agreement.To order additional documents, U.S. and Canadian customers should call Customer Fulfillment at (800) 685-8225, fax (617) 229-9845.Customers in other countries with a U.S. license agreement may contact Customer Fulfillment via the above fax number. All otherinternational customers should contact their Sybase subsidiary or local distributor. Upgrades are provided only at regularly scheduledsoftware release dates. No part of this publication may be reproduced, transmitted, or translated in any form or by any means, electronic,mechanical, manual, optical, or otherwise, without the prior written permission of Sybase, Inc.Sybase trademarks can be viewed at the Sybase trademarks page at 1011207. Sybase and the marks listedare trademarks of Sybase, Inc. indicates registration in the United States of America.Java and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.Unicode and the Unicode Logo are registered trademarks of Unicode, Inc.All other company and product names mentioned may be trademarks of the respective companies with which they are associated.Use, duplication, or disclosure by the government is subject to the restrictions set forth in subparagraph (c)(1)(ii) of DFARS 52.227-7013for the DOD and as set forth in FAR 52.227-19(a)-(d) for civilian agencies.Sybase, Inc., One Sybase Drive, Dublin, CA 94568.

ContentsAbout This Book . xiCHAPTER 1CHAPTER 2User’s GuideSybase ETL.Sybase ETL architecture .Sybase ETL Development.Sybase ETL Server .Projects and jobs.Component concepts .Stepping a component record-by-record .Component variables and ports .Adaptable port structure and mapping .Running projects and jobs .Customizing a project.Understanding repositories .Converting datatypes and data formats .SQL .Tools .Unicode support .Expressions.12223333344556677Sybase ETL Desktop. 9Desktop layout . 10Using the Navigator. 11Administering the repository . 12Navigating and browsing the repositories . 13Administering projects and jobs . 13Administering user accounts . 14Using the Properties section . 15Applying component variables . 15Allowing dynamic expressions . 16Encrypting properties . 16Using the Design section . 17Adding components. 17iii

ContentsDeleting components from the Design section.Using the pop-up menu to process commands.Using the Component Store .Customizing preferences .17171718CHAPTER 3Getting Started. 21Starting Sybase ETL . 22Creating your first project . 22Adding a data provider . 23Adding a data sink. 24Adding a data calculator. 25Simulating the project. 26CHAPTER 4Projects and Jobs. 27Managing projects. 28Simulating and executing a project . 29Tracing project execution . 31Simulating the entire project. 32Executing the current project in default grid engine . 32Viewing current mappings . 32Managing port attributes. 33Viewing a simulation flow . 34Controlling multiple data streams . 37Managing jobs. 37Job components . 38Executing a job. 38Creating Jobs . 39Modifying a job . 39Copying a job . 39Deleting a job . 40Renaming a job . 40Scheduling a job. 40Controlling job execution . 40Using templates to create projects and jobs . 41Building a migration template . 41Managing a migration template . 44CHAPTER 5Advanced Concepts and Tools . 47Content Explorer . 48Opening Content Explorer. 48Using the Design area. 49Inspecting log file information. 51ivSybase ETL

ContentsManaging jobs and scheduled tasks .Customizing SQL and transformation rules .Using expressions and procedures .Including variables.Using functions.Using Square Bracket Notation .Entering SQL statements .Using the JavaScript Procedure Editor and Debugger.Parameter Sets .Managing parameter sets.Assigning Parameter Values .Using multiple engines to reduce job execution time .Defining multi-engine jobs .Executing multi-engine jobs .Execution Monitor .Cancelling Job Execution .Analyzing performance data .Performance data model and content .Example reports .CHAPTER 6User’s nts . 77Overview . 78Setting up a component . 78Data blocks and visualization . 79Ports and links. 79Repetitive stepping . 79Entering database connection parameters. 80Working with the SQLite Persistent interface . 83Providing descriptions for components . 84Adding component variables to a component . 85Evaluating SBN expressions . 85Encrypting properties . 86Modifying components . 86Data blocks and visualization . 87Stepping a component multiple times . 87Managing port structures. 88Viewing and mapping to ports . 89Source components . 90DB Data Provider Full Load. 90DB Data Provider Index Load. 92Text Data Provider . 95XML via SQL Data Provider . 98XML via XSLT Data Provider . 103Transformation components . 104v

ContentsAP PE ND IX AviData Calculator JavaScript.Data Splitter JavaScript.Character Mapper .Data Mapper.Data Transposer.Lookup components.Data Lookup .DB Lookup.DB Lookup Dynamic.Staging components .DB Staging .Processing components.Executor JavaScript .Destination components.DB Data Sink Insert.DB Data Sink Update .DB Data Sink Delete .DB Data Sink Synchronize .DB Data Sink Merge.Text Data Sink.XML Data Sink .DB Bulk Load Sybase IQ.Job components.Start.Project .Synchronizer .Multi-Project .Finish.Error 36138140143145147148149150151151152153Function Reference .uAvg .uMax .uMin .uBitAnd.uBitOr .uBitXOr.uBitNot .uIsAscending.uIsBoolean .uIsDate.uIsDescending .uIsEmpty .uIsInteger .156156157158158159159160161162162163163155Sybase ETL

uIsFloat. 164uIsNull. 164uIsNumber . 165uNot . 165uBase64Decode . 166uBase64Encode . 167uConvertDate . 167uFromHex. 169uToHex . 169uHexDecode. 169uHexEncode . 170uToUnicode . 170uURIDecode . 170uURIEncode . 171Working with date and time functions. 173uDate . 176uDateTime . 177uDay . 177uDayOfYear. 178uHour. 178uQuarter . 179uIsoWeek. 179uJuliandate . 180uMinute. 181uMonth. 181uMonthName . 181uMonthNameShort . 182uSeconds. 183uTimeDiffMs . 183uWeek . 184uWeekday. 184uWeekdayName . 185uWeekdayNameShort . 185uYear . 186uError. 187uErrortext. 187uInfo. 188uWarning . 188uTrace . 188uTracelevel . 189uFileInfo. 190uFileRead . 191uFileWrite . 192uFormatDate. 193User’s Guidevii

uGlob . 195uLike . 196uMatches . 196uChoice . 198uFirstDifferent . 199uFirstNotNull. 199uElements. 199uToken. 200uCommandLine . 201uGetEnv. 201uGuid . 202uMD5 . 202uScriptLoad . 202uSetEnv . 203uSetLocale. 203uSleep . 207uSystemFolder . 207uHostname . 213uSMTP. 213uAbs . 216uCeil . 217uDiv . 217uExp . 217uFloor . 218uLn. 218uLog. 218uMod. 219uPow, uPower . 219uRandom . 219uRound . 220uSgn . 220uSqrt . 221uEvaluate. 222uAsc, uUnicode . 224uChr, uUniChr. 224uCap . 224uCon, uConcat. 225uJoin . 225uLeft. 225uLength, uLen. 226uSubstr, uMid . 226uLPos . 227uLower, uLow . 227uLStuff . 227viiiSybase ETL

uLTrim . 228uRepeat . 228uReplace . 228uReverse . 229uRight . 229uRPos. 229uRStuff. 230uRTrim. 230uTrim . 231uUpper, uUpp . 231uEQ . 232uNE. 232uGT. 233uGE . 233uLT . 234uLE . 234uAcos. 235uAsin. 235uAtan . 235uCos . 236uSin . 236uTan . 236A PP EN DIX BSybase ETL Server. 237GRID architecture. 238Communication. 238Using the server. 238GRID Engine Server . 238GRID Engine Server as Windows System Service. 239Troubleshooting. 240Command line parameters . 241INI file settings . 242Default.ini. 243GridNode.ini. 243A PP EN DIX CQueuing and Executing Process Calls. 245Configuring ProcessQ calls . 246Controlling the appearance of a new process . 247Index. 249User’s Guideix

xSybase ETL

About This BookAbout This BookAudienceThis guide is for users of Sybase ETL Development, which provides extract,transform, and load (ETL) capabilities that you can use to transform data fromdata providers to data targets. Sybase ETL Development supports a variety oftransformation capabilities and enables you to convert, cleanse, merge, andsplit data streams. The resulting data stream can then insert, update, or deletedata in a given data target. You view the shape of your data at any step of thedata transformation process by using the unique Sybase ETL “Step and See”technology.How to use thisbookThis book contains the following chapters:User’s Guide Chapter 1, “Sybase ETL” gives you a brief overview of Sybase ETLarchitecture and the feature set of Sybase ETL Development and SybaseETL Server. Chapter 2, “Sybase ETL Desktop” helps you become familiar with thedesign environment for Sybase ETL projects and jobs. This chapterexplains the Sybase ETL desktop, toolbars, and general GUI functionality. Chapter 3, “Getting Started” helps you get started with Sybase ETL. Chapter 4, “Projects and Jobs” guides you through the process of creating,simulating, and executing projects and jobs. It provides valuable insightsrelated to simulation mode. It also shows you how to use templates tocreate projects and jobs for special purposes. Chapter 5, “Advanced Concepts and Tools” describes the set of built-intools that make your design work easier and faster. Familiarize yourselfwith Sybase ETL tools, such as Content Explorer or the Query Designer,to speed up the design of your project work. Chapter 6, “Components” describes Sybase ETL component concepts andall the information relevant to every component. Appendix A, “Function Reference” describes the built-in set of functionsavailable in Sybase ETL. Appendix B, “Sybase ETL Server” describes installation, usage, andarchitecture o

data transformation process by using the unique Sybase ETL "Step and See" technology. How to use this book This book contains the following chapters: Chapter 1, "Sybase ETL" gives you a brief overview of Sybase ETL architecture and the feature set of Sybase ETL Development and Sybase ETL Server.

Related Documents:

Audience This guide is for users of Sybase ETL Development. How to use this book This book contains these chapters: † Chapter 1, "Sybase ETL," is an overview of the Sybase ETL architecture and the feature set of Sybase ETL Development and Sybase ETL Server. † Chapter 2, "Getting Started," describes how to get started using Sybase ETL.

Trusted and unified data environment In-memory/real-timeing SAP HANA SAP Real-time Data Platform SAP Sybase ESP streams Anywhere SAP Sybase SQL mobile and embedded SAP Sybase IQ EDW SAP Sybase ASE transactions SAP Data Services / SAP Information Steward information management Common progra

Difficulty in upgrading from Sybase 12.x to Sybase ASE 15 Many Sybase customers who have not yet upgraded to Sybase ASE 15 are considering migrating away from Sybase and toward Oracle. This is because the expense associated with a Sybase ASE 15 upgrade, in many cases, would cover

SAP ERP SAP HANA SAP CRM SAP HANA SAP BW SAP HANA SAP Runs SAP Internal HANA adoption roadmap SAP HANA as side-by-side scenario SAP BW powered by SAP HANA SAP Business Suite powered by SAP HANA Simple Finance 1.0 2011 2013 2014 2015 Simple Finance 2.0 S/4 HANA SAP ERP sFin Add-On 2.0

SAP Certification Material SAP Certification Material for SAP Aspirants at Low cost Home Home SAP Business Objects SAP BPC CPM SAP BPC 7.0 SAP EWM SAP GTS SAP Public Sector SAP Real Estate SAP FSCM SAP FI/CO SAP AC - FI/CO SAP BI 7.0 SAP CRM 5.0

for Sybase ASE . Developer Edition on Windows 7 box. C: \ Sybase \ C:\ sybase \ase-15_0 corresponds to actual ASE database installation C:\ Sybase \ocs-15_0 corresponds to bundled client software (called OCS in Sybase ASE parlance) development kit. It is interestin

Understanding SYBASE Update Rules 16 Naming Conventions for SYBASE 16 Case Sensitivity in SYBASE 17 Data Types for SYBASE 17 Character Data 17 Numeric Data 18 Abstract Data 18 User-Defined Data Types 19 . Sybase ASE Perfor

Historical view point from medieval sources. The Indian Archives, National Archives of India, New Delhi, 2001. 40) Duniya-i-ilm-o-Adab ki Azeemush Shan Shakhsiyat – Qazi Saiyid Nurullah Shushtari. Rah-i-Islam, New Delhi 2002. 41) Aurangzeb and the Court Historians: A case study of Mirza Muhammed Kazim’s Alamgir Nama. Development of Persian .