Just Go with the Flow! with SAS® Data Integration Studio
Goals of the Presentation Background Information Define SAS Data Integration Define SAS Data Integration (DI) Studio Major Features and Advantages of Data Integration
Studio. Disadvantages of SAS Data Integration Studio. Above all, to encourage you to “just go with the flow” and give SAS Data Integration Studio a try.
2015-04-09
Statistique Canada • Statistics Canada
2
Background Information Statistics Canada 350 Surveys SAS Data Integration Studio is a natural fit Research Project
2015-04-09
Statistique Canada • Statistics Canada
3
What is Data Integration? Imagine two puzzles
2015-04-09
Statistique Canada • Statistics Canada
4
What is SAS Data Integration Studio According to my SAS course notes, “it is a visual design
tool for building processes, Implementing processes AND managing processes
Regardless Of: Data sources, Applications, OR Platforms 2015-04-09
Statistique Canada • Statistics Canada
5
Advantages of DI Studio Meta Data rich ($) – Meta data on just about any object you
use in Data Integration Studio. Visual – It is almost like working on a flow chart.
2015-04-09
Statistique Canada • Statistics Canada
6
Advantages of DI Studio Can be Integrated with SAS® Dataflux (More Integration
with the release of SAS 9.3 suite of products). Ability to create stored processes and SOA modules. Ability to schedule jobs via the SAS® Platform Scheduler (an industrial strength scheduler).
2015-04-09
Statistique Canada • Statistics Canada
7
Advantages of DI Studio Import Existing Code. Ability to push the processing to the database
2015-04-09
Statistique Canada • Statistics Canada
8
Advantages of DI Studio Import Existing Code. Ability to push the processing to the database
2015-04-09
Statistique Canada • Statistics Canada
9
Advantages of DI Studio Integration of Third Party Source Control starting with
SAS Data Integration Studio 9.3. SAS Data Integration Studio can leverage the security that
is set up from within the SAS platform. Can build tables quickly by importing column definitions
from other tables.
2015-04-09
Statistique Canada • Statistics Canada
10
Advantages of DI Studio
2015-04-09
Statistique Canada • Statistics Canada
11
Advantages of DI Studio Impact Analysis
2015-04-09
Statistique Canada • Statistics Canada
12
Advantages of DI Studio Performance Statistics Start Time, End Time, Duration CPU Time CPU Time, Current Memory System Memory Number of threads. Can run jobs on a grid
2015-04-09
Statistique Canada • Statistics Canada
13
Some Disadvantages of DI Studio Not Many….. Installation is more complex. There is a learning curve. Training is required. MetaData administrator required.
2015-04-09
Statistique Canada • Statistics Canada
14
DI Studio Summary In summary, DI Studio is the ideal tool for integrating data across the organization. DI Studio accomplishes task in a very transparent, organized and secure fashion. It has many advantages and very few disadvantages. Questions?
2015-04-09
Statistique Canada • Statistics Canada
15
Contact Information David Dean Technical Consultant, Statistics Canada R.H. Coats 14O Tunney’s Pasture, Ottawa, Ontario Canada 1-613-951-5052
[email protected]
2015-04-09
Statistique Canada • Statistics Canada
16