Extended Systems OneBridge 4.1 Handbücher

Bedienungsanleitungen und Benutzerhandbücher für Server Extended Systems OneBridge 4.1.
Wir stellen 4 PDF-Handbücher Extended Systems OneBridge 4.1 zum kostenlosen herunterladen nach Dokumenttypen zur Verfügung Betriebsanweisung, Bedienungsanleitung, Installationsanleitung


Inhaltsverzeichnis

Sybase IQ ETL

1

DC00608-01-0410-01

2

October 2006

2

Contents

3

User’s Guide vii

7

User’s Guide ix

9

Sybase IQ ETL 4.1

10

About This Book

11

Sybase IQ ETL 4.1

12

About This Book

13

If you need help

14

Projects and jobs

16

Component concepts

16

Customizing a project

17

Running a project

17

Understanding repositories

18

CHAPTER 1 Sybase IQ ETL

19

Unicode support

20

Expressions

20

Internal database

20

8 Sybase IQ ETL 4.1

22

Sybase IQ ETL Development

23

Using the Navigator

24

Administering the repository

25

Administering user accounts

27

Using the Properties section

28

Using the Design section

29

Adding components

30

Customizing preferences

31

User’s Guide 19

33

20 Sybase IQ ETL 4.1

34

Getting Started

35

Creating your first project

36

Adding a data sink

37

Adding a data calculator

38

Simulating the project

39

26 Sybase IQ ETL 4.1

40

Projects and Jobs

41

Managing projects

42

User’s Guide 29

43

❖ To simulate a project

43

Viewing current mappings

45

Managing port attributes

46

Viewing a simulation flow

46

User’s Guide 33

47

User’s Guide 35

49

Managing jobs

50

Executing a job

51

Cancelling job execution

52

Creating Jobs

52

Building a migration template

54

User’s Guide 41

55

Managing a migration template

57

44 Sybase IQ ETL 4.1

58

Advanced Concepts and Tools

59

Opening Content Explorer

60

Using the Design area

60

Creating queries

61

Content Explorer

62

User’s Guide 49

63

Evaluate property is

65

Including variables

66

Using functions

67

Using Square Bracket Notation

68

Entering SQL statements

68

Entering queries

69

Validating queries

69

Query designer

69

SELECT * FROM

70

PRODUCT [uTracelevel(5)]

70

User’s Guide 57

71

Features

71

Edit and Debug mode

72

User’s Guide 59

73

❖ To step through the code

73

❖ To step to a Breakpoint

73

Special JavaScript features

74

Analyzing performance data

77

Example reports

79

Project execution history

80

User’s Guide 67

81

68 Sybase IQ ETL 4.1

82

Components

83

Setting required properties

84

Setting up a component

85

Overview

86

Creating a SQLite table

89

Evaluating SBN expressions

91

Encrypting properties

91

Modifying components

92

Data blocks and visualization

92

Managing port structures

93

DB Data Provider Index Load

97

Text Data Provider

99

Properties

100

CHAPTER 6 Components

101

XML via SQL Data Provider

102

Optional properties

103

Source components

104

Transformation components

107

Character Mapper

113

Using Lookup components

115

Required properties

116

DB Lookup Dynamic component

118

Staging components

121

Processing components

123

Destination components

124

DB Data Sink Update component

127

DB Data Sink Delete component

129

Text Data Sink

130

Job components

135

Synchronizer component

136

Multi-Project component

137

Finish component

138

Error component

138

Function Reference

139

Aggregation functions

140

Bit functions

141

Boolean functions

142

Sybase IQ ETL 4.1

144

1 if the parameter is null

145

Conversion functions

146

Date and time functions

151

now modifier

154

Errorhandling functions

163

File functions

166

Formatting functions

168

Fuzzy search functions

170

Lookup functions

171

IF construct:

172

Miscellaneous functions

174

166 Sybase IQ ETL 4.1

180

168 Sybase IQ ETL 4.1

182

170 Sybase IQ ETL 4.1

184

Network functions

185

Numeric functions

186

Script functions

191

String functions

191

Operator functions

200

Trigonometric functions

202

Sybase ETL Server

205

Communication

206

Using the server

206

GRID Engine Server

206

Stop a server

207

Install as a System Service

207

Troubleshooting

208

Command line parameters

209

INI file settings

210

Default.ini

211

GridNode.ini

211

198 Sybase IQ ETL 4.1

212

Queuing and Executing

213

Process Calls

213

Configuring ProcessQ calls

214

202 Sybase IQ ETL 4.1

216

204 Sybase IQ ETL 4.1

218

206 Sybase IQ ETL 4.1

220

208 Sybase IQ ETL 4.1

222

Inhaltsverzeichnis

EAServer

1

DC38032-01-0550-01

2

September 2006

2

Contents

3

New features in EAServer 5.5

7

Upgrade to Eclipse 3.1.2

9

4 EAServer

10

New features in EAServer 5.3

11

Named classloader support

12

Oracle 10g support

12

JDK 1.5 support

13

Unicode datatype support

14

Upgrade to Eclipse 3.0.1

14

New features in EAServer 5.2

15

EAServer Manager enhancements

16

In-memory mirror caching

16

What’s New 11

17

FIPS and TLS support

18

What’s New 13

19

14 EAServer

20

New features in EAServer 5.1

21

Log file viewer enhancements

22

Running components externally

23

IPV6 support

24

Server performance monitoring

24

Systems Management

25

Jagtool enhancements

26

What’s New 21

27

22 EAServer

28

New features in EAServer 5.0

29

New wizards

30

HTTP directory browsing

32

EAServer Transaction Manager

32

JCMCache.getConnection

34

What’s New 29

35

Server logging enhancements

36

Logging APIs

37

Managing log profiles

37

Admin role granularity

38

Web Services Toolkit

39

Partial page caching

41

36 EAServer

42

New Features in EAServer

43

New features in version 4.2.3

44

New features in version 4.2.2

47

What’s New 43

49

Multiple listener hosts

50

Standalone jagtool

50

What’s New 45

51

CMP isolation level

53

Table-level timestamps

53

EJB session bean passivation

54

Message service enhancements

54

New features in version 4.2.1

55

New features in version 4.2

56

New features in version 4.1.3

58

Lightweight EJB container

59

CMP JDBC wrapper drivers

59

Thread monitors

59

New server properties

60

New features in version 4.1.2

61

Flow control

63

Servlet buffer pool

63

Servlet Java cache

63

Client connection timeouts

65

EAServer

66

New features in version 4.1.1

67

New features in version 4.1

68

What’s New 63

69

Web services support

70

Message Bridge for Java™

70

Deployment enhancements

70

What’s New 65

71

What’s New 67

73

68 EAServer

74

New Features in EAServer 4.0

75

Performance enhancements

76

EJB 2.0 support

77

Home interface methods

78

Local interfaces

78

Message-driven bean support

80

JSP 1.2 support

81

Standard extensions

81

Java XML parser integration

82

J2EE connectors

82

J2EE naming enhancements

82

J2EE security enhancements

83

Enhanced transaction support

83

HTTP 1.1 support

84

Java deployment enhancements

84

Java class file consolidation

86

Repository versioning

87

82 EAServer

88