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 http://www.sybase.com/detail?id 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
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
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.
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
Difﬁculty 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 www.SAPmaterials4u.com 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-Deﬁned 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 .