RESOURCES / SAS PRODUCTS & SOLUTIONS
 

SAS Metadata Bridges

SAS Metadata Bridges are available through the software offerings SAS Enterprise Data Integration Server and SAS Data Integration Server. You can use SAS Metadata Bridges to import and export metadata through SAS Management Console or SAS Data Integration Studio, which are components in these offerings. If you are licensing one of these offerings for the first time, you get the choice of several SAS Metadata Bridges and a number of generic components that are included in the SAS Metadata Bridge for General Industry Standards.

The SAS Metadata Bridge Relationship Loader, new with the third maintenance release for SAS 9.4, enables you to use SAS Metadata Bridges to load third-party lineage information to the relationship database. All objects and relationships that are supported by Meta Integration Model Bridge are available to be loaded. For information about using the SAS Metadata Bridge Relationship Loader, see SAS 9.4 Intelligence Platform: System Administration Guide, Fourth Edition.

To purchase additional bridges or to purchase bridges to use with another SAS offering, please contact your SAS Sales Account Executive or request a follow-up call. You can locate contact information at www.sas.com/contact.



Release 9.4M8

Expand/Collapse AllExpand All Expand/Collapse AllCollapse All

expand sectionSAS Metadata Bridges for 3rd Party Data Management Tools
Import Bridge Export Bridge SAS Metadata Bridge Contents
I   EMC ProActivity 3.x & 4.0
I   Grandite Silverrun-RDM 2.4.4 to 2.8.6
I E IDERA ER/Studio Business Architect (via DM1)
I E IDERA ER/Studio Data Architect
I   IDERA ER/Studio Repository
  E IRI CoSORT RowGen Data Definition File
  E IRI CoSORT SortCL Data Definition File
I   Pentaho Data Integration - Unsupported Beta Bridge
I   Select SE
I E Talend Data Integration
I   Talend Data Preparation
I E Talend Master Data Management (MDM)
I   Visible IE: Advantage 6.1

expand sectionSAS Metadata Bridges for CA
Import Bridge Export Bridge SAS Metadata Bridge Contents
I   CA COOL:Biz 5.1
I   CA COOL:Enterprise (ADW) 2.7
I E CA Gen
I   erwin 3.x (ERX)
I   Microsoft Office Visio Database Diagram (via ERX)
I   erwin 4.x Data Modeler
I   erwin 7.x Data Modeler (Single Model from Model Manager)
I E erwin 7.x Data Modeler (File)
I   erwin 8.x Data Modeler (Single Model from mart)
I E erwin 8.x Data Modeler (File)
I   erwin 9.x to 2020 Data Modeler (Single Model from mart)
I E erwin 9.x to 2020 Data Modeler (File)
I   CA COOL:BusinessTeam (GroundWorks) 2.2.1
I   erwin 9.x to 2020 Mart
I   erwin 7.x Model Manager
I   erwin 8.x Mart
I E CA Component Modeler 3.52 (ParadigmPlus)
I   CA COOL:DBA (Terrain for DB2) 5.3.2
I E CA COOL:Xtras Mapper (TerrainMap for DB2)

expand sectionSAS Metadata Bridges for General Industry Standards
Import Bridge Export Bridge SAS Metadata Bridge Contents
I   Actian Vector (Vectorwise) Database (via JDBC)
  E Altova XMLSpy
I   Amazon Web Services (AWS) Aurora Database (via JDBC)
I   Amazon Web Services (AWS) RedShift Database (via JDBC)
I   Apache Avro File (JSON)
I   Apache CouchDb Database (JSON)
I   Apache Hadoop Hive Database SQL DDL Script
I   Apache Hadoop Hive Database SQL DML (DI/ETL) Script (HiveQL)
I E Borland Together (via UML 2.x XMI)
I E CA Component Modeler 4.x (via UML 1.x XMI)
I   Cloudera Enterprise Hadoop Hive Database SQL DDL Script
I   Cloudera Enterprise Hadoop Hive Database SQL DML (DI/ETL) Script (HiveQL)
I   Cloudera Impala Hadoop Hive Database SQL DDL Script
I   Cloudera Impala Hadoop Hive Database SQL DML (DI/ETL) Script (HiveQL)
I   COBOL Copybook File
I   Database (via JDBC)
  E Database SQL DDL Script
I   Database SQL DML (DI/ETL) Script
I   Data Mapping Script
I   Delimited File (CSV)
I   (DI/ETL) Script (SnowSQL)
I   File System (Delimited, Fixed Width, Excel, XML, JSON, Avro, Parquet, ORC, COBOL Copybook)
I   Fixed Width File
I E Gentleware Poseidon (via UML 1.x XMI)
I   Google Spanner Database (via JDBC)
I   Hortonworks Hadoop Hive Database SQL DDL Script
I   Hortonworks Hadoop Hive Database SQL DML (DI/ETL) Script (HiveQL)
I   HP Vertica Database (via JDBC)
I   IBM DB2 Universal Database (UDB) (via JDBC)
  E IBM DB2 Universal Database (UDB) SQL DDL Script
I   IBM DB2 Universal Database (UDB) SQL DML (DI/ETL) Script
I   IBM InfoSphere Federation Server (via JDBC)
I   IBM Lotus Notes (via JDBC-ODBC)
  E IBM Netezza Database SQL DDL Script
I   IBM PureData System for Analytics - Netezza Database
I E IBM Rational Software Architect (RSA) (via UML 2.x XMI)
I E IBM Telelogic Tau (via UML 1.x XMI)
I   JSON File
I   MapR Hadoop Hive Database SQL DDL Script
I   MapR Hadoop Hive Database SQL DML (DI/ETL) Script (HiveQL)
I   MarkLogic NoSQL Database (for JSON only)
I   Meta Integration Repository (MIR) Multi Model (XMI) - Vendor Internal Bridge
I   Meta Integration Repository (MIR) Single Model (XMI) - Vendor Internal Bridge
I   Micro Focus (Merant) AppMaster Builder
I   Microsoft Azure SQL Database (via JDBC)
I   Microsoft Azure SQL Data Warehouse (via JDBC)
I   Microsoft Office Visio UML Class Diagram (via UML 1.x XMI)
I   Microsoft SQL Server Analysis Services (SSAS) 7.0 to 2000 (via ODBO) - Unsupported EOL Bridge
I   Microsoft SQL Server Database (via JDBC)
I   Microsoft SQL Server Database SQL DDL Script
I   Microsoft SQL Server Database SQL DML (DI/ETL) Script (Transact-SQL)
I   Microsoft SQL Server XML Data Reduced (XDR) Schema
I   MicroStrategy MDX Adapter (via ODBO) - Unsupported EOL Bridge
I   MongoDB NoSQL Database (JSON)
I E NoMagic MagicDraw (via UML 2.x XMI)
I E OMG CWM 1.x XMI 1.x
I   OMG CWM Pre-1.0 XMI 1.1 - Unsupported EOL Bridge
I E OMG UML 1.x XMI 1.x
I E OMG UML 2.x XMI 2.x
I   OpenAPI Specification (OAS)
I   OpenStack Swift Object Store - New Beta Bridge
I E Oracle Database SQL DDL Script
I   Oracle Database (via JDBC)
I   Oracle Database SQL DML (DI/ETL) Script (PL/SQL)
I   Oracle MySQL Database (via JDBC)
I   PostgreSQL Database (via JDBC)
I   PostgreSQL Database SQL DML (DI/ETL) Script
I   Presto Database (via JDBC)
I   SAP HANA Database (via JDBC)
I   Snowflake Database (via JDBC)
I E SAP PowerDesigner OOM 9.x to 15.x (via UML 2.x XMI)
  E SAP PowerDesigner XSM 10.x to 15.x
I   SAP Sybase ASE Database (via JDBC)
I   SAS Base SAS Code
I   SAS OLAP Server (via ODBO) - Unsupported EOL Bridge
I   Snowflake Database SQL DML
I E Sparx Enterprise Architect (EA) (via UML 2.x XMI)
I   Teradata Database (via JDBC)
I E Teradata Database SQL DDL Script
I   Teradata Database Parallel Transporter (TPT) Script
I   Teradata Database SQL DML (DI/ETL) Script (BTEQ, Fastload, etc.)
I E Tigris ArgoUML (via UML 1.x XMI)
I   VMware Tanzu Greenplum Database
I   W3C Semantic Web Ontology (OWL/RDF)
I   W3C Web Service Definition Language (WSDL) - Beta Bridge
I   W3C XML
I   W3C XML Document Type Definition (DTD) 1.0
I   W3C XML Schema Definition (XSD) 1.0
I E W3C XML Schema Definition (XSD) 1.0 Forward Engineering
I E W3C XML Schema Definition (XSD) 1.0 Reverse Engineering

expand sectionSAS Metadata Bridge for IBM
Import Bridge Export Bridge SAS Metadata Bridge Contents
I   IBM InfoSphere DataStage
I   IBM Cognos Data Module
I   IBM Cognos Dashboard
I   IBM Cognos Series 7 Impromptu
I   IBM Cognos PowerPlay Transformer
I E IBM Cognos Framework Manager (FM) for ReportNet
I E IBM Cognos Framework Manager (FM)
I   IBM Cognos Content Manager Packages
I   IBM Cognos QueryStudio
I   IBM Cognos Content Manager QueryStudio
I   IBM Cognos Content Manager ReportStudio
I   IBM Cognos ReportStudio
I   IBM Cognos Content Manager
I E IBM DB2 Cube Views
I E IBM InfoSphere Data Architect (IDA)
I E IBM InfoSphere Warehouse - InfoSphere Data Architect
I E IBM Rational Rose 4.0
I E IBM Rational Rose 6.0(98i) to 6.5(2000)
I E Microsoft Visual Studio / Modeler 2.0 (via MDL)
  E IBM Rational Rose 7.x (2000e and newer)
  E IBM Rational Rose XDE Developer (via Rose MDL)
  E IBM Rational Software Architect (RSA) (via Rose MDL)
  E IBM Rational Software Modeler (RSM) (via Rose MDL)
I E Unicom (Popkin) System Architect (SA) 10.4 to 11.4 (Encyclopedia)
I E Unicom (Popkin) System Architect (SA) 7.1 to 11.4 (File)

expand sectionSAS Metadata Bridge for Informatica
Import Bridge Export Bridge SAS Metadata Bridge Contents
I E Informatica Big Data Management (BDM) Developer
I E Informatica Big Data Management (BDM) Developer Repository
I E Informatica Data Engineering Integration (DEI) Developer
I E Informatica Data Engineering Integration (DEI) Developer Repository
I E Informatica PowerCenter (File)
I   Informatica PowerCenter (Repository)

expand sectionSAS Metadata Bridge for Microsoft
Import Bridge Export Bridge SAS Metadata Bridge Contents
I   Excel File (XLSX)
I   Microsoft Azure Blob Storage
I   Microsoft Azure Cosmos DB NoSQL Database
  E Microsoft Azure Data Catalog (ADC) - Vendor Internal Bridge
I   Microsoft Azure Data Factory - New Beta Bridge
I   Microsoft Azure Data Lake Storage Gen1
I   Microsoft Azure Data Lake Storage Gen2
I   Microsoft Azure Power BI Service (Repository)
I E Metadata Excel Format
I   Microsoft Power BI (File) - New Beta Bridge
I   Microsoft Power BI Report Server (Repository)
I   Microsoft SQL Server Analysis Services (SSAS) 2016 to 2019 (Tabular Model File)
I   Microsoft SQL Server Analysis Services (SSAS) 7.0 to 2000 (Repository)
I E Microsoft SQL Server Analysis Services (SSAS) (via DSV File)
I E Microsoft SQL Server Data Source View (DSV)
I E Microsoft SQL Server Integration Services (SSIS) (via DSV File)
I E Microsoft SQL Server Integration Services (SSIS) (File)
I   Microsoft SQL Server Repository 3.x (via MDC) - Unsupported EOL Bridge
I E Microsoft SQL Server Analysis Services (SSAS) 2005 to 2017 (Repository)
I   Microsoft SQL Server Analysis (SSAS) and Reporting Services (SSRS) (Repository)
I   Microsoft SQL Server Integration Services (SSIS) (Repository Server)
I   Microsoft SQL Server Integration Services (SSIS) (Repository Database)
I   Microsoft SQL Server Reporting Services (SSRS) (Repository)
I E Microsoft SQL Server Repository 2.1b (via XIF) - Unsupported EOL Bridge
I   Microsoft SQL Server Reporting Services (SSRS) (File)
I   Microsoft SQL Server Analysis Services (SSAS) 2005 to 2017 (File)

expand sectionSAS Metadata Bridge for Oracle
Import Bridge Export Bridge SAS Metadata Bridge Contents
I E Oracle Hyperion Essbase Integration Services (EIS)
I   Oracle Hyperion Essbase - Unsupported Beta Bridge
I   Oracle Business Intelligence (OBI) Answers, KPI and Prompt Reports (XML file)
I   Oracle Business Intelligence (OBI) Enterprise Edition (Server)
I   Oracle Business Intelligence (OBI) Repository (RPD file)
I   Oracle Data Warehouse Administration Console (DAC)
I   Oracle Data Integrator (ODI)
I   Oracle Data Modeler (ODM) 4.x
I E Oracle Designer
I E Oracle Warehouse Builder (OWB)

expand sectionSAS Metadata Bridge for SAP
Import Bridge Export Bridge SAS Metadata Bridge Contents
I   SAP BusinessObjects Crystal Reports XI (File)
I   SAP BusinessObjects Crystal Reports XI (Repository)
I E SAP BusinessObjects Designer (Repository)
I E SAP BusinessObjects Designer (File)
I   SAP BusinessObjects Information Design Tool (IDT) (Repository)
I E SAP BusinessObjects Information Design Tool (IDT) (File)
I   SAP BusinessObjects Desktop Intelligence (File)
I E SAP BusinessObjects Desktop Intelligence (Repository)
I   SAP BusinessObjects Repository XI
I E SAP BusinessObjects Repository 6.x
I   SAP BusinessObjects Web Intelligence (Webi) XI
I   SAP Data Services (BODI/BODS)
I E SAP NetWeaver Master Data Management (MDM) - Unsupported Beta Bridge
I   SAP PowerDesigner CDM 8.0 to 16.x
I   SAP PowerDesigner CDM 6.x
I   SAP PowerDesigner CDM 7.5 to 16.x
I   SAP PowerDesigner LDM 15.x to 16.x
I   SAP PowerDesigner PDM 8.x to 16.x
I   SAP PowerDesigner PDM 6.1.x
I   SAP PowerDesigner PDM 7.5 to 16.x

expand sectionSAS Metadata Bridge for Big Data & Cloud Platforms
Import Bridge Export Bridge SAS Metadata Bridge Contents
I   Amazon Web Services (AWS) Athena Database
I   Amazon Web Services (AWS) Aurora Database
I   Amazon Web Services (AWS) Glue ETL (via Apache Spark)
I   Amazon Web Services (AWS) S3 Storage
I E Apache Atlas
I   Apache Druid Database
I   Apache Cassandra NoSQL Database
I   Apache Hadoop Distributed File System (HDFS Java API)
I   Apache Hadoop HBase NoSQL Database (Java API)
I   Apache Hadoop Hive Database (HCatalog and Metastore via JDBC)
I   Apache Kafka
I   Apache ORC File
I   Apache Parquet File
I   Apache Spark (with Python or Scala)
I   Apache Sqoop
I   Cloudera Enterprise Hadoop Hive Database (HCatalog and Metastore via JDBC)
I   Cloudera Impala Hadoop Hive Server
I   Cloudera Navigator
I   Databricks Hive Database (HCatalog and Metastore via JDBC)
I   Databricks Unified Data Services (via Apache Spark)
I   Denodo Virtual DataPort
I   DataStax Enterprise (Cassandra)
I   Google BigQuery Database
I   Google Cloud Storage (GCS) File System
I   Hortonworks Atlas
I   Hortonworks Hadoop Hive Database (HCatalog and Metastore via JDBC)
I   MapR Hadoop Hive Database (HCatalog and Metastore via JDBC)
I   Salesforce (SFDC) Database

expand sectionSAS Metadata Bridge for BI & Visualization Tool
Import Bridge Export Bridge SAS Metadata Bridge Contents
I   Alteryx - Unsupported Beta Bridge
I   Alteryx Repository - Unsupported Beta Bridge
I   (Google) Looker Server
I E MicroStrategy 7.0 to 11.x
I   QlikSense File
I   QlikSense Server
I   QlikView File
I   QlikView
I E Tableau (File)
I   Tableau Server Data Extract
I   Tableau Server (Repository)
I   ThoughtSpot
I   TIBCO Spotfire Analyst (DXP Format) (File)
I   TIBCO Spotfire Binary Data (SBDF Format) (File)
I   TIBCO Spotfire Server (Repository)
I   TIBCO Spotfire Text Data (STDF Format) (File)