Transcript SAP & SQL Server 2005 Integration Services Integration (Advanced level) Microsoft Corporation SAP-Microsoft Competence Center (Tokyo)

SAP & SQL Server 2005
Integration Services
Integration (Advanced level)
Microsoft Corporation
SAP-Microsoft Competence Center (Tokyo)
1
Landscape
1. Starting to create SSIS project
2. Retrieving product info from SAP
3. Retrieving customer info from SAP
4. Retrieving sales info from SAP
5. Completing SSIS project
6. Executing SSIS project
2
1. Starting to create SSIS project
SAP
Reporting
on Web browser
SAP R/3
Enterprise 4.7
Master
(Product)
Master
(Customer)
Master
(Product
type)
Master
(Region)
Master
(Country)
Transaction
(Sales
header)
Transaction
(Sales
detail)
Master
(Product)
Master
(Product
type)
Master
(Customer
all)
Transaction
(Sales all)
* Major : Sales
* Dimension :
Product, Customer, Time
Multi dimensional
add-hoc analysis
on Excel Pivot table
3
1. Starting to create SSIS project (1)
4
1. Starting to create SSIS project (2)
5
1. Starting to create SSIS project (3)
6
1. Starting to create SSIS project (4)
7
1. Starting to create SSIS project (5)
8
1. Starting to create SSIS project (6)
9
2. Retrieving product info from SAP
SAP
Reporting
on Web browser
SAP R/3
Enterprise 4.7
Master
(Product)
Master
(Customer)
Master
(Product
type)
Master
(Region)
Master
(Country)
Transaction
(Sales
header)
Transaction
(Sales
detail)
Master
(Product)
Master
(Product
type)
Master
(Customer
all)
Transaction
(Sales all)
* Major : Sales
* Dimension :
Product, Customer, Time
Multi dimensional
add-hoc analysis
on Excel Pivot table
10
2. Retrieving product info from SAP (1)
11
2. Retrieving product info from SAP (2)
12
2. Retrieving product info from SAP (3)
13
2. Retrieving product info from SAP (4)
14
2. Retrieving product info from SAP (5)
15
2. Retrieving product info from SAP (6)
16
2. Retrieving product info from SAP (7)
17
2. Retrieving product info from SAP (8)
18
2. Retrieving product info from SAP (9)
19
2. Retrieving product info from SAP (10)
20
2. Retrieving product info from SAP (11)
21
2. Retrieving product info from SAP (12)
22
2. Retrieving product info from SAP (13)
23
2. Retrieving product info from SAP (14)
24
2. Retrieving product info from SAP (15)
25
3. Retrieving customer info from SAP
SAP
Reporting
on Web browser
SAP R/3
Enterprise 4.7
Master
(Product)
Master
(Customer)
Master
(Product
type)
Master
(Region)
Master
(Country)
Transaction
(Sales
header)
Transaction
(Sales
detail)
Master
(Product)
Master
(Product
type)
Master
(Customer
all)
Transaction
(Sales all)
* Major : Sales
* Dimension :
Product, Customer, Time
Multi dimensional
add-hoc analysis
on Excel Pivot table
26
3. Retrieving customer info from SAP (1)
27
3. Retrieving customer info from SAP (2)
28
3. Retrieving customer info from SAP (3)
29
3. Retrieving customer info from SAP (4)
30
3. Retrieving customer info from SAP (5)
31
3. Retrieving customer info from SAP (6)
32
3. Retrieving customer info from SAP (7)
33
3. Retrieving customer info from SAP (8)
34
3. Retrieving customer info from SAP (9)
35
3. Retrieving customer info from SAP (10)
36
3. Retrieving customer info from SAP (11)
37
3. Retrieving customer info from SAP (12)
38
3. Retrieving customer info from SAP (13)
39
3. Retrieving customer info from SAP (14)
40
3. Retrieving customer info from SAP (15)
41
3. Retrieving customer info from SAP (16)
42
3. Retrieving customer info from SAP (17)
43
4. Retrieving sales info from SAP
SAP
Reporting
on Web browser
SAP R/3
Enterprise 4.7
Master
(Product)
Master
(Customer)
Master
(Product
type)
Master
(Region)
Master
(Country)
Transaction
(Sales
header)
Transaction
(Sales
detail)
Master
(Product)
Master
(Product
type)
Master
(Customer
all)
Transaction
(Sales all)
* Major : Sales
* Dimension :
Product, Customer, Time
Multi dimensional
add-hoc analysis
on Excel Pivot table
44
4. Retrieving sales info from SAP (1)
45
4. Retrieving sales info from SAP (2)
46
4. Retrieving sales info from SAP (3)
47
4. Retrieving sales info from SAP (4)
48
4. Retrieving sales info from SAP (5)
49
4. Retrieving sales info from SAP (6)
50
4. Retrieving sales info from SAP (7)
51
4. Retrieving sales info from SAP (8)
52
4. Retrieving sales info from SAP (9)
53
4. Retrieving sales info from SAP (10)
54
4. Retrieving sales info from SAP (11)
55
4. Retrieving sales info from SAP (12)
56
4. Retrieving sales info from SAP (13)
57
4. Retrieving sales info from SAP (14)
58
4. Retrieving sales info from SAP (15)
59
4. Retrieving sales info from SAP (16)
60
5. Completing SSIS project
SAP
Reporting
on Web browser
SAP R/3
Enterprise 4.7
Master
(Product)
Master
(Customer)
Master
(Product
type)
Master
(Region)
Master
(Country)
Transaction
(Sales
header)
Transaction
(Sales
detail)
Master
(Product)
Master
(Product
type)
Master
(Customer
all)
Transaction
(Sales all)
* Major : Sales
* Dimension :
Product, Customer, Time
Multi dimensional
add-hoc analysis
on Excel Pivot table
61
5. Completing SSIS project (1)
62
5. Completing SSIS project (2)
63
5. Completing SSIS project (3)
64
6. Executing SSIS project
SAP
Reporting
on Web browser
SAP R/3
Enterprise 4.7
Master
(Product)
Master
(Customer)
Master
(Product
type)
Master
(Region)
Master
(Country)
Transaction
(Sales
header)
Transaction
(Sales
detail)
Master
(Product)
Master
(Product
type)
Master
(Customer
all)
Transaction
(Sales all)
* Major : Sales
* Dimension :
Product, Customer, Time
Multi dimensional
add-hoc analysis
on Excel Pivot table
65
6. Executing SSIS project (1)
66
6. Executing SSIS project (2)
67
6. Executing SSIS project (3)
68
6. Executing SSIS project (4)
69
6. Executing SSIS project (5)
70
6. Executing SSIS project (6)
71
6. Executing SSIS project (7)
72
6. Executing SSIS project (8)
73
74