SAS® Data Management Advanced
A complete solution to meet the full spectrum of enterprise data integration needs
SAS Data Management Advanced enables you to manage virtually all data sources (including big data); extract, cleanse, transform, aggregate, load and govern data; support data warehousing, migration, synchronization and federation initiatives; support both batch-oriented and real-time master data management solutions; and create real-time data integration services in support of service-oriented architectures.
Benefits
- Always access the data you need.
- Reuse work by others.
- Improve productivity.
- Manage security and administration at all levels.
- Meet time constraints even within decreasing windows of availability.
- Deliver consistent, trusted and verifiable information.
- Eliminate overlapping, redundant tools and systems with one solution.
Features
- Interactive data integration development environment
- Connectivity and data access
- Metadata management
- Data cleansing and enrichment
- ETL and ELT
- Migration and synchronization
- Data federation
- Business data network
- Business rules management
- Reference data manager
- Master data management support
- SOA and message queue integration
Screenshot
Developing data integration flows is faster and easier with the redesigned Job editor.
Screenshots
How SAS® Is Different
- The value of business analytics relies heavily on the ability to integrate analytics with operational systems and decision-making processes. SAS is the only data integration solution that provides the processes and procedures to integrate analytics into all aspects of your operational and decision-support systems.
- Only SAS provides a single, integrated and easy-to-use solution, reducing delays and high costs associated with custom coding each data integration project or piecing together non-integrated technologies.
- SAS eliminates the problem of inaccurate, contradictory and inconsistent data by embedding data quality within data integration processes and providing a single view of your customers, products and other entities.
- SAS combines parallel processing, grid capabilities and in-database support to provide unrivaled scalability that can handle complex big data. From simple range, list and hash-based partitioning to complex distributed processing, SAS Data Management Advanced can scale to handle growing data volumes and smaller windows of processing time.
- Core to all SAS solutions is an open and integrated metadata environment that provides a single source for all of your applications, eliminating the need to replicate and manage multiple instances of metadata.
Benefits
- Always access the data you need. From older legacy systems to the latest ERP applications, data from virtually any hardware platform or operating system can be accessed and processed. New source systems can easily be added and security managed centrally. This saves time, shortens learning curves and gives decision makers the information they need.
- Reuse work by others. A common repository enables the centralized storage, management and reuse of work based on user authorizations, reducing both development and maintenance time.
- Improve productivity. A GUI environment that is easy to use provides a standard interface for building and documenting work. Collaboration is encouraged and manual coding is available when needed. New team members can get up to speed quickly on work done by others, which is important when documentation is inadequate or missing.
- Manage security and administration at all levels. Reusable templates make it quick and easy to provide role-based authorizations and administrative privileges at the user, department or enterprise level.
- Meet time constraints even within decreasing windows of availability. SAS processes data fast! Organizations can take advantage of the grid-enabled, load-balanced, multithreaded parallel processing architecture that can quickly process, transform and move data between different platforms and systems. SAS also supports zero data movement by using SQL pass-through into popular databases and appliances including Oracle, DB2, Teradata, Netezza, SQL Server, Aster and Hadoop.
- Deliver consistent, trusted and verifiable information. Consistently getting correct data when and where it is needed provides increased confidence in the accuracy and timeliness of operational and business information. Data quality auditing tools monitor the quality of data in processes and source systems. Users can see where data originated and how it was transformed. Optional enrichment components can add value and ensure the best possible data.
- Eliminate overlapping, redundant tools and systems with one solution. SAS offers the only comprehensive enterprise data integration solution that is built from the ground up to meet the full spectrum of data integration needs. It eliminates the piecemeal approach of linking and managing technologies from different vendors and provides lower overall cost, reduced risk and faster results.
- Ensure data quality as part of the ELT/ETL process. SAS Data Management Advanced includes DataFlux technologies to ensure data quality throughout the ETL/ELT process. This helps you analyze and validate your data integration projects, and incorporates data cleansing and standardization as part of the transformation and load process, providing clean data for analysis.
Features
- Interactive data integration development environment
-
- Simplify the construction, execution and maintenance of enterprise data integration processes.
- Connectivity and data access
-
- Use all data, regardless of source.
- Metadata management
-
- Provide centralized definition, storage, analysis and management of enterprise metadata.
- Data cleansing and enrichment
-
- Profile, cleanse and augment data to create consistent, reliable information.
- ETL and ELT
-
- Extract, transform and load data from across the enterprise to create consistent, accurate information, or add in-database processing to execute transformations within your database.
- Migration and synchronization
-
- Capture and propagate data changes in real time to ensure data integrity, consistency and credibility.
- Data federation
-
- Query and use data across multiple systems without the physical movement of source data.
- Business data network
-
- Create and manage a common business data repository.
- Business rules management
-
- Create, deploy and manage complex business rules within a single environment.
- Reference data manager
-
- Manage critical reference data to build and organize hierarchies across data elements.
- Master data management support
-
- Quickly and reliably create a unified view of enterprise data from multiple sources.
- SOA and message queue integration
-
- Improve the flow of information across your organization.
Screenshots
Developing data integration flows is faster and easier with the redesigned Job editor.
The Job editor makes the process of developing high-performing data integration flows easier and faster. This screenshot shows an example of an open job in the Job editor.
The propagation of information from table to table is easily defined.
In any transformation, the Mappings panel allows you to define the propagation of information from table to table in your job. Here is an example of the default mapping rules being applied when mapping numeric to character columns, and character to numeric columns.
Integrated debugging helps ensure the results you expect.
SAS Data Integration Studio brings a new world of integrated debugging to make sure your job produces the results that you expect and that it meets design requirements. This screenshot shows a snapshot of a running job. Transformation step "Analyze" is currently running, while the "Rank variables" step has completed successfully. The "Filter results" step failed.
Runtime statistics help validate how well your code performs.
When working with large data flows, it is important to ensure that the job performs well. SAS Data Integration Studio can capture runtime statistics on jobs to help you validate how well your code performs. Saved statistics are available for each transformation step and can be viewed graphically or in a tabular report.
Embed business rules in operational data flows.
This screenshot shows how a data flow within SAS Data Integration software embeds a business rule to filter and route the incoming data to five different targets, depending on the business rule that is defined.
System Requirements
Please contact your local SAS sales representative for details on configurations and system requirements.
Ready to learn more?
Call us at 1-800-727-0025 (US and Canada) or request more information.
