Administering SAS Data Integration Studio

Overview of Administering SAS Data Integration Studio

SAS Data Integration Studio is a visual design tool that enables data integration specialists to consolidate and manage enterprise data from a variety of source systems, applications, and technologies. This software enables these users to create process flows that accomplish the following tasks:

extract, transform, and load (ETL) data for use in data warehouses and data marts
cleanse, migrate, synchronize, replicate, and promote data for applications and business services

SAS Data Integration Studio enables users to integrate information from any platform that is accessible to SAS and from any format that is accessible to SAS.

The following table introduces the administrative tasks that are associated with SAS Data Integration Studio:

Administrative Tasks for SAS Data Integration Studio
Administrative Task	Purpose of Task
Connect to SAS servers	Make sure that your data integration specialists can connect to the necessary SAS servers. For example, each user must be able to connect to the SAS Metadata Server to register data sources and other objects.
Connect to data servers	Make sure that your data integration specialists can connect to the necessary data servers.
Set up change management	Set up a change-managed folder in the Folders tree, if desired. This enables individual users to check objects out of a foundation repository and place them in a private repository. The private repository, called a project repository, provides a location where the users can test changes.
Set up multi-tier environments	Set up SAS Data Integration Studio to work in a multi-tier configuration. Almost all configurations have multiple tiers.
Administer message queues	Install third-party message queue software, define queues, and register queues for inter-process communication.
Configure stored process servers for the deployment of stored process jobs or Web service jobs	Install SAS Stored Process Servers as needed for jobs that are deployed as stored processes or Web services that generate XML output.
Configure the SAS Workspace Server to enable the bulk loading of data	Enable SAS Workspace Servers to execute external commands so that jobs can rapidly load data into a DBMS.
Test the Platform Computing Scheduling Server	Test the servers (and clients) that enable your users to schedule sets of SAS Data Integration Studio jobs.
Set up the SAS Data Quality Server software	Set up the infrastructure necessary for your users to use data-quality transformations.
Redirect output and logging information to a file	Specify alternative destinations for the SAS log and SAS output.
Configure status code handling	Configure jobs to send status codes via e-mail, to files, or by executing a SAS program.
Use FTP or HTTP servers to access external files	Install a content server to access external files.

Top of Page