Products & Solutions / SAS Data Integration for Midsize Business

SAS® Data Integration for Midsize Business

Make data access and integration easy and cost-effective

SAS Data Integration for Midsize Busi­ness provides a simple and flexible solution to handle the challenges of distributed and rapidly increasing data volumes, inconsistently defined data across disparate IT systems and the high expectations of data consumers who depend on data to be correct, complete and available when they need it. SAS Data Integration for Midsize Business does this in a timely, cost-ef­fective manner, which ensures data credibility and consistency and gives organiza­tions of all sizes the ability to easily manage data integration projects, increasing overall productivity.

Benefits

  • Leverage work by others.
  • Work collaboratively in groups or teams.
  • Remove technology obstacles that endanger project deadlines and credibility.
  • Manage security and administration at all levels.
  • Meet delivery constraints in ever-decreasing windows of availability.
  • Always access the data you need.
  • Deliver consistent, trusted and verifiable information.

Read more

Features

  • Interactive data integration development environment
  • Access to virtually all data sources
  • Extraction, transformation and load (ETL) and extraction, load and transformation (ELT)
  • Metadata management
  • Migration and synchronizations
  • Data federation
  • Reusable data integration support services

Read more

How SAS® Is Different

SAS Data Integration for Midsize Business, featuring DataFlux® technology, is a powerful, configurable and affordable solution that can meet a wide variety of data integration requirements, from small departmental projects to strategic business initiatives. It provides:
  • A collaborative design environment promoting object reuse and sharing, administrative controls, a wizard-driven design process workflow and ease of use and maintenance.
  • A flexible, reliable solution that can access data from virtually any system in any form, trans­form and cleanse data even in real time, and handle data migration, synchronization and federation projects all through a versatile services environment that is easy to deploy and maintain.
  • All the capabilities and flexibility to scale with growing data and changing business requirements.

Benefits

  • Leverage work by others. A common repository enables the centralized storage, management and reuse of work created by all users based on their authorizations, so it is easy to create, share and use jobs developed by others. This reduces both development and maintenance time.
  • Work collaboratively in groups or teams. The common repository supports multiuser development capabilities. In addition, using a common set of tools among developers shortens learning curves and makes maintenance easier. The advanced GUI environment and centralized metadata repository capture and manage the work so that it is easy to see and understand, making it easier for new team members to become productive right away.
  • Remove technology obstacles that endanger project deadlines and credibility. Easy to learn and work in, the advanced GUI environment provides developers with a standard interface for building and documenting their work. Manual coding, though available when wanted, is minimized. Users are provided with hundreds of prebuilt capabilities as well as the ability to create their own new data integration services, all from within the SAS environment.
  • Manage security and administration at all levels. With its centralized common metadata repository, SAS enables security and a single point of administration for all levels. Reusable templates make it quick and easy to provide role-based authorizations and administrative privileges at the user, departmental or organizational level.
  • Meet delivery constraints in ever-decreasing windows of availability. SAS processes data fast. Organizations can take advantage of the load-balanced, multithreaded parallel-processing architecture that can quickly process, transform and move data between different platforms and systems.
  • Always access the data you need. From legacy systems, Excel or the latest ERP applications, data from virtually any hardware platform or operating system can be accessed and processed using SAS/ACCESS® engines. New source systems can easily be added and security man­aged centrally. This saves time, shortens learning curves and gives decision makers the information and data confidence they really need.
  • Deliver consistent, trusted and verifiable information. Consistently getting correct data when and where it is needed provides increased confi­dence in the accuracy and timeliness of information. Powerful data lineage tools enable developers and users to see where data originated and how it has been transformed. In addition, DataFlux data profiling tools provide insights into the quality of processes and source systems so business users are assured they are using the best data possible.
  • Eliminate overlapping, redundant tools and complex transformations from multiple systems. SAS Data Integration for Midsize Business is a flexible, reliable and complete solution that supports all the needs of a midsize organiza­tion, including both operational and decision support/business analytic solutions. It eliminates the piecemeal approach of linking and managing technologies from different vendors, ensures data credibility, reduces risk and speeds results.

Features

Interactive data integration development environment
  • Wizards for accessing source systems, creating target structures, importing and exporting metadata, and building and executing data access, trans­formation and load process flows.
  • Dedicated GUI to profile data in order to identify and repair source system issues while retaining the business rules for later use in ETL processes.
  • Multiuser design environment supports collaboration on large projects.
  • Ability to distribute data integration tasks to nearly any platform and to connect virtually any source or target data store.
  • Integrated workflow scheduling, automatic load balancing and grid computing support.
  • Design time and run-time visualization and monitoring.
  • Job statistics and logging.
  • Enhanced GUI-based debugging.
  • Push-down indicators that show when transformation processing is being passed to and performed by a connected database/data warehouse/data storage system.
  • Checkpoint/restart so that job and data load processes are tracked (checkpointed), enabling interrupted processes to be restarted at the point where they were interrupted.
  • Powerful DataFlux data profiling.
  • Ability to import existing SAS programs and convert them to GUI-based jobs by automatically defining metadata attributes and creating the associ­ated process job flows.
Access to virtually all data sources
  • Database sources: AS400, ODBC, IBM DB2/UDB, Informix, Microsoft Access, Microsoft Excel, Microsoft SQL Server, MySQL, Netezza, DATAIIegro, HP NeoView, OLE/DB, Oracle, Sybase, Sybase ASIQ, SAS data sets, SAS® Scalable Performance Data Server®, SAS Scalable Performance Data Engine, Teradata, Greenplum Aster Data and more.
  • Mainframe data sources (OS/390 and z/OS): ADABAS, CA-Datacom, CA-IDMS, COBOL, IBM DB2, IMS-DL/I, ISAM files, Oracle, SYSTEM 2000, Tera­data, VSAM (KSDS and ESDS) and other file formats.
  • Enterprise applications: EPICOR, NetSuite, Oracle, PeopleSoft, SAP BW, SAP R/3, Sage, Salesforce.com and Siebel.
  • File formats: text, standard and delimited; XML and standard flat files; COBOL Copybooks; and FTP and URL-based. Reads and writes other external data representations, such as ASCII, Binary, EBCDIC, Hexadecimal and Octal.
  • Direct support for message-oriented middleware, including WebSphere MQ from IBM and MSMQ from Microsoft. In addition, Tibco's Rendezvous is supported with SAS Integration Technologies (included).
  • Support for unstructured and semistructured data to parse and process files.
  • Access to static and streaming data for sending and receiving through Web services.
Extraction, transformation and load (ETL) and extraction, load and transformation (ELT)
  • Transformation library with more than 300 predefined table and column-level transformations.
  • Transformation Generator wizard or Java plug-in design templates for creating reusable and repeatable transformations that are tracked and regis­tered in metadata.
  • Framework for publishing information to archives, a publishing channel, e-mail or various message-queuing middleware.
  • Metadata is captured and documented throughout transformation and data integration processes, and is available for immediate reuse.
  • Flexible deployment: Transformations can run on all supported platforms with all data sources. Transformations and data integration processes can be deployed easily as embedded business logic or as Web services for use by other applications as part of a service-oriented architecture.
  • Optimized loaders designed to leverage the various load techniques and bulk-loading utilities.
  • A specially designed loader to provide additional optimized support for Teradata.
Metadata management
  • Sophisticated metadata mapping technologies for quickly propagating column definitions from sources to targets, and for creating automated intel­ligent table joins.
  • Impact analysis for assessing the scope and impact of making changes to existing objects, such as columns, tables and process jobs.
  • Data lineage (reverse impact analysis) is critical for both validating processes that are working correctly and for building user confidence in data.
  • Multiuser collaboration support includes object check-in and check-out and DEV/TEST/PROD promotion management.
  • Wizard-driven metadata importing and exporting.
  • Metadata-driven deployment flexibility: Using process metadata, process jobs can be deployed for batch execution, as reusable stored processes and as Web services.
  • Metadata reports that provide an easy-to-understand view of the metadata in HTML format for developers, designers and business users to view the content.
Migration and synchronizations
  • Metadata-driven access to sources and targets.
  • Extensive library of predefined transformations for migration and synchronization that can be extended and shared with other integration processes.
  • Embedded, reusable data quality business rules can clean data as it is moved.
  • Ability to migrate or synchronize data between database structures, enterprise applications, mainframe legacy files, text, XML, message queues and a host of other sources.
  • Integrated scheduler allows changes made in one or more systems to be propagated on a scheduled basis out to other systems in a reliable manner.
  • In addition to SAS' own change data capture (CDC) capabilities, when combined with technology from partner Attunity, enhanced CDC recognizes changes to key fields and replicates/synchronizes changes across multiple, heterogeneous databases. CDC capabilities provided by Oracle and DB2 are also supported.
Data federation
  • Virtual access to database structures, enterprise applications, mainframe legacy files, text, XML, message queues and a host of other sources.
  • Ability to join data across data sources for access and analysis.
  • Instant access to a real-time view of the data using the built-in data viewer.
  • Query optimization is provided both automatically as part of DBMS requests, and manually within the advanced SQL editor, and can be used for both homogenous and heterogeneous data sources.
Reusable data integration support services
  • Features and capabilities provided by SAS Data Integration for Midsize Business can be modularized into an array of supporting data integration services.
  • Easy-to-use wizards for creating services, including scheduling, connectivity, administration, data enrichment, data movement, grid support, data parsing, data cleansing, data auditing, data profiling, data lineage and data transformation.
  • These supporting services leverage the integrated SAS metadata environment and administrative functions.

System Requirements

Client environment

SAS Data Integration for Midsize Business clients include SAS Data Integration Studio, SAS Management Console and DataFlux® dfPower® Profile. The following client operating systems are supported:

  •   SAS Data Integration Studio
    • Microsoft Windows (x86-32): Windows XP Professional, Windows Server 2003 family, Windows Server 2008, Windows Vista*
    • Microsoft Windows on x64 (EM64T/AMD64): Windows XP Professional for x64, Windows Server 2003 for x64, Windows Server 2008 for x64, Windows Vista* for x64
  • SAS Data Quality components
    • Microsoft Windows (x86-32): Windows XP Professional, Windows Server 2003 family, Windows Server 2008, Windows Vista*

  • SAS Management Console
    • AIX: Version 5.3 and Version 6.1 on POWER architectures
    • HP-UX Itanium: HP-UX 11iv2 (11.23), 11iv3 (11.31)
    • HP-UX PA-RISC: HP-UX 11iv2 (11.23), 11iv3 (11.31)
    • Linux for x86 (x86-32): RHEL 4 and 5, SuSE SLES 9 and 10
    • Linux for x64 (EM64T/AMD64): RHEL 4 and 5, SuSE SLES 9 and 10
    • Microsoft Windows (x86-32): Windows XP Professional, Windows Server 2003 family, Windows Server 2008, Windows Vista*
    • Microsoft Windows (on Itanium): Windows Server 2003 for Itanium-based systems
    • Solaris on SPARC: Version 9, 10
    • Solaris on x64: Version 10
    • z/OS: V1R7, V1R8, V1R9 and higher
Server environment
  • AIX: Version 5.3 and 6.1 on POWER architectures
  • HP-UX Itanium: HP-UX 11iv2 (11.23), 11iv3 (11.31)
  • HP-UX PA-RISC: HP-UX 11iv2 (11.23), 11iv3 (11.31)
  • Linux for x86 (x86-32): RHEL 4 and 5, SuSE SLES 9 and 10
  • Linux for x64 (EM64T/AMD64): RHEL 4 and 5, SuSE SLES 9 and 10
  • Microsoft Windows (x86-32): Windows XP Professional, Windows Server 2003, Windows Server 2008, Windows Vista*
  • Microsoft Windows (on Itanium): Windows Server 2003 for Itanium-based systems
  • Solaris on SPARC: Version 9, 10
  • Solaris on x64: Version 10
  • z/OS: V1R7, V1R8, V1R9 and higher

* NOTE: Windows Vista editions that are supported include Enterprise, Business and Ultimate.

Optional add-on components
  • DataFlux® dfPower® Explorer
  • DataFlux® dfPower® Monitor
  • DataFlux® dfPower® Quality
  • DataFlux® dfPower® Customize 

Ready to learn more?

Call us at 01628 486 933 (UK) or request more information.