Advance ETL 2 Pentaho Data Integration

BySunny Okoro

1

2

3

4

5

6

7

8

Switching to JDBC

I encountered many errors with the original ODBC which prompted me to change to Java Database Connectivity (JDBC) using IBM DB2 and MYSQL JDBC drivers as illustrated below since these drivers has to be deployed manually. JDBC works well with java based applications like Talend, Pentaho, Oracle Developer, SQL Developer and Data Modeler. Most of the JDBC are available from the database vendor with exception of JTDS which are used by Sybase and SQL Server as alternative to JDBC from Sybase or SQL Server.

9

10

Flat File Destination

11

12

13

14

15

16

17

18

19

Joins-Merge (Inner)

20

21

22

23

24

25

26

27

Joins Merger (outer)

28

29

30

31

32

Join Cartesian

33

34

35

36

Join Multiway-Inner

37

Join Mulitway Merge-Full Outer

38

39

String Operations

40

41

42

43

44

45

46

47

48

Microsoft SSAS

An OLAP connection in Pentaho does not require a JDBC driver rather a HTTP access is needed to establish the connection. Microsoft SQL Server Analysis Services site was created embedded with the

49

user credentials and the instance using Internet Information Services (IIS). The URL can also be applied to SAP Business Objects when establishing connection for reports.

50

51

Microsoft SSRS View

52

53

54

55

56

57

58

59