ETL tools

[Former Member]

Hello guys,

I'm preparing for my upcoming project with ETL tools Informatica, I got pretty much the information of ETL and what it is, but how to use and configurate it?

If you can give me the full link to a good complete tutorial that would be highly appreciated and full points given, thank you so much in advance!

[Former Member]

Go through the links for Lucid explanations

Infopackage -

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/03808225cf5167e10000000a1553f6/content.htm

DTP

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/f98e07cc483255e10000000a1553f7/frameset.htm

Creating DTP

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/fa50e40f501a77e10000000a422035/content.htm

Pre-requisite-

You have used transformations to define the data flow between the source and target object.

Creating transformations-

http://help.sap.com/saphelp_nw2004s/helpdata/en/f8/7913426e48db2ce10000000a1550b0/content.htm

ODS to Cube -

http://help.sap.com/saphelp_nw2004s/helpdata/en/ce/dc87c1d711f846b34e0e42ede5ebb7/content.htm

Migration

/thread/377643 [original link is broken]

-

---

Migrate Transformations

/message/3034624#3034624 [original link is broken]

/thread/178564 [original link is broken]

-

---

Presentations

https://www.sdn.sap.com/irj/sdn/bi?rid=/webcontent/uuid/e78a5148-0701-0010-7da9-a6c721c6112e [original link is broken]

-

---

Reporting Methods nw2004s

You can use the BEx Analyzer, the Web Applications and the Web Analyzer for the Business Explorer for free multidimensional data analysis as a part of Enterprise reporting.

Bex Analyzer

http://help.sap.com/saphelp_nw2004s/helpdata/en/ba/45583ca544eb51e10000000a114084/frameset.htm

Web Applications

http://help.sap.com/saphelp_nw2004s/helpdata/en/05/4b583cf7388362e10000000a114084/frameset.htm

Web Analyzer

http://help.sap.com/saphelp_nw2004s/helpdata/en/0d/af12403dbedd5fe10000000a155106/frameset.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70e18305-2356-2910-4bbe-9c1ebd75...

-

---

Debug DTP

/people/community.user/blog/2007/03/29/sap-netweaver-70-bi-extended-capabilities-to-debug-a-data-transfer-process-dtp-request

-

---

NW2004s and 3.X Design Considerations

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6fe0f064-0901-0010-d4b2-86ac9f95...

-

---

Workbook Revert Back nw2004s

/message/3137036#3137036 [original link is broken]

-

---

There r diff. ETL tools available in market. All of the below tools are for Extractions, Transfer and Loading Purposes.

Eg: ETL Tools. Cognas, Informatica, Erwin, Microstrategy...

Internal Tables :(used only for runtime)

Basically there are 5 types of Internal tables.

1. Standared,

2. Sorted,

3. Indexed,

4. Hashed and

5. Any

Please check this document

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/15c48e90-0201-0010-bebe-b57...

You can get complete detials of ETL in BW350 book . Here you can get in depth knowledge on Extraction types used in BW (how to extract from COPA, LO, CRM & NON SAP systems etc) and some sample scenarios. For data staging you can find more detials in BW365 book.

Try to get these 2 books or soft copies. or else you can but ETL book from SAP PRESS (www.sappress.com).

Pls check the document in the link attached.

http://www.informatica.com//solutions/technology/sap/connectsapbw_0304_tn1431_b.pdf

http://www.iwaysoftware.com/etl-tools.html

http://www.1keydata.com/datawarehousing/tooletl.html

1) BW it self facilitates to do the ETL (Extraction Transformation Loading) steps:

example:

Extraction - from SAP or other data bases

Transformation - using transfer rules, Updates rules

Loading - Loading into ODS, Cube, master data

2) Typically used ETL tools in the industry are:

a) datastage from Ascential (owned by IBM)

b) Informatica

c) Mercator

ETL: Extracting , transforming and loading is the process of reading (extracting) from heterogeneous sources and transform them so that discrete data from different sources gets integrated and then loading into the data warehouse.

Extracting: Reading and understanding the source data and copying the parts that are needed to the data staging area for further work.

Transforming: Data transformations are often the most complex and, in terms of processing time, the most costly part of the ETL process.

Loading: Discrete data from different sources gets integrated and then loading into the data warehouse

Rewards if useful...............

Minal

null

[Former Member]

Perfect Minal, that's what I need, thank you, full points rewarded. Cheers