• Print  |
  • Feedback  |

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

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.

Supported bridges for SAS 9.2M3

I - Import Bridge

E - Export Bridge

SAS Metadata Bridge Name SAS Metadata Bridge Contents
SAS Metadata Bridge for IBM WebSphere DataStage I E IBM WebSphere DataStage
  I E IBM DB2 Data Warehouse Edition / OLAP acceleration (Cube Views)
SAS Metadata Bridge for Business Objects I   Business Objects Crystal Reports XI (File)
  I   Business Objects Crystal Reports XI (Repository)
  I   Business Objects Designer (Repository)
  I E Business Objects Designer (File)
SAS Metadata Bridge for CA I   CA COOL:Enterprise (ADW) 2.7
      CA COOL:Biz 5.1
  I E CA Gen 4.1a to 7.5
    E Embarcadero ER/Studio (via ERX)
    E Microsoft Office Visio Database (via ERX)
    E Sybase PowerDesigner 7.0 (via ERX)
  I E CA ERwin 3.x (ERX)
      Microsoft Office Visio Database (via ERX)
  I E CA ERwin 4.x Data Modeler
  I   CA ERwin 7.x Data Modeler (Model Manager)
  I E CA ERwin 7.x Data Modeler (File)
  I   CA COOL:BusinessTeam (GroundWorks) 2.2.1
  I   CA Model Manager 7.x
  I E CA Component Modeler 3.52 (ParadigmPlus)
  I E CA Repository for Distributed Systems
      CA Repository for z/OS
  I   CA COOL:DBA (Terrain for DB2) 5.3.2
  I   CA COOL:Xtras Mapper (TerrainMap for DB2)
SAS Metadata Bridge for Cognos I   Cognos Series 7 Impromptu
  I E Cognos ReportNet Framework Manager
  I E Cognos 8 Framework Manager Services
SAS Metadata Bridge for Embarcadero Technologies I E Embarcadero ER/Studio
      Embarcadero EA/Studio (via DM1)
SAS Metadata Bridge for Hummingbird I E Open Text eDOCS Data Integration (Hummingbird) Genio
SAS Metadata Bridge for Hyperion I E Oracle Hyperion Essbase Integration Services
SAS Metadata Bridge for IBM Rational Rose I E IBM Rational Data Architect (RDA)
      IBM DB2 Data Warehouse Edition / Rational Data Architect
  I E IBM Rational Rose; 4.0
  I E IBM Rational Rose; 98(i) to 2000
      Microsoft Visual Studio / Modeler 2.0 (via MDL)
  I E IBM Rational Rose 2000e to 2003
    E IBM Rational Software Architect (RSA) (via Rose MDL)
    E IBM Rational Software Modeler (RSM) (via Rose MDL)
    E IBM Rational Rose XDE Developer (via Rose MDL)
SAS Metadata Bridge for Informatica I E Informatica PowerCenter (File)
  I   Informatica PowerCenter (Repository)
SAS Metadata Bridge for Knightsbridge Solutions   E HP Knightsbridge CDMA
SAS Metadata Bridge for General Industry Standards I   Database (via JDBC)
      IBM Lotus Notes (via JDBC-ODBC)
  I   IBM DB2; Universal Database
      IBM WebSphere Federation Server
  I   Microsoft SQL Server; Database
  I   Database (via ODBC)
      Microsoft Office Access (via JDBC-ODBC)
  I   Oracle Database
  I E Meta Integration Repository (MIR) XMI multimodel content
    E Meta Integration Repository (MIR) Transformations to Views XMI file
      Composite Software Composite Studio (via MIR XMI)
  I E Meta Integration Repository (MIR) XMI file
  I E Adaptive Repository & Foundation (via MIR XMI)
    E Business Objects Metadata Manager (via MIR XMI)
    E RedHat (MetaMatrix) Enterprise Designer (via MIR XMI)
    E SchemaLogic SchemaServer (via MIR XMI)
    E Informatica Metadata Manager (via MIR XMI)
    E Unisys ClearPath (via MIR XMI)
  I   Microsoft SQL Server Analysis Services 7.0 to 9.0 (via ODBO)
      MicroStrategy MDX Adapter (via ODBO)
      SAP Business Warehouse (via ODBO)
      SAS OLAP Server (via ODBO)
  I   W3C XML DTD 1.0
  I E W3C XML Schema 1.0 (XSD)
  I   Microsoft SQL Server XML Data Reduced (XDR) Schema
    E Altova XMLSpy
    E Sybase PowerDesigner XSM 10.x to 15.x
  I E OMG CWM 1.x XMI 1.x
      Adaptive Repository & Foundation (via CWM XMI)
      ASG Rochade (via CWM XMI)
      Business Objects Data Integrator (via CWM XMI)
      Oracle Hyperion Application Builder (via CWM XMI)
      IBM DB2 Warehouse Manager (via CWM XMI)
      Oracle Warehouse Builder (via CWM XMI)
      SAS Data Integration Studio (via CWM XMI)
  I E OMG CWM Pre-1.0 XMI 1.1
  I E OMG UML 1.x XMI 1.x
      Adaptive Repository & Foundation (via UML XMI)
      Borland Together (via UML XMI)
      CA Component Modeler 4.x (via UML XMI)
      Embarcadero Describe (via UML XMI)
      Gentleware Poseidon (via UML XMI)
  I   Microsoft Office Visio UML (via UML XMI)
      Sun Netbeans XMI Writer
      NoMagic MagicDraw (via UML XMI)
      Sparx Enterprise Architect (EA) (via UML XMI)
      Sybase PowerDesigner OOM; 9.x to 15.x (via UML XMI)
      Telelogic Tau (via UML XMI)
  I E Tigris ArgoUML (via UML XMI)
    E Sybase PowerDesigner OOM; 9.x to 15.x (via UML XMI)
SAS Metadata Bridge for Microsoft Excel I E Microsoft Office Excel
SAS Metadata Bridge for Microsoft SQL Server I E Microsoft SQL Server Data Source View
    E Microsoft SQL Server Analysis Services 9.0 (via DSV)
  I E Microsoft SQL Server Integration Services (File)
  I E Microsoft SQL Server Repository 3.x (via MDC)
  I E Microsoft SQL Server Analysis Services 9.0 (Repository)
  I   Microsoft SQL Server Analysis and Reporting Services 9.0 (Repository)
  I   Microsoft SQL Server Integration Services (Repository)
  I   Microsoft SQL Server Reporting Services (Repository)
  I E Microsoft SQL Server Repository 2.1b (via XIF)
SAS Metadata Bridge for MicroStrategy I E MicroStrategy 7.0 to 8.1
SAS Metadata Bridge for Oracle I E Oracle Data Integrator
  I E Oracle Designer
  I E Oracle Warehouse Builder
SAS Metadata Bridge for Telelogic I E Telelogic (Popkin) System Architect 7.1 to 11.x (File)
  I E Telelogic (Popkin) System Architect 10.4 to 11.x (Encyclopedia)
SAS Metadata Bridge for ProActivity I   EMC ProActivity 3.x & 4.0
SAS Metadata Bridge for Select SE I   Select SE
SAS Metadata Bridge for Grandite Silverrun RDM I   Grandite Silverrun-RDM 2.4.4 to 2.7.2
SAS Metadata Bridge for Sybase PowerDesigner I   Sybase PowerDesigner CDM; 6.x
  I E Sybase PowerDesigner CDM; 7.5 to 15.x
  I   Sybase PowerDesigner PDM; 6.1.x
  I E Sybase PowerDesigner PDM; 7.5 to 15.x
SAS Metadata Bridge for Visible Advantage I   Visible IE:Advantage 6.1

 

Supported bridges for SAS 9.3

I - Import Bridge

E - Export Bridge

SAS Metadata Bridge Name SAS Metadata Bridge Contents
SAS Metadata Bridgefor IBM WebSphere DataStage I E IBM WebSphere DataStage
  I E IBM InfoSphere Warehouse /Cubing Services for OLAP
  I E IBM InfoSphere Information Server (Common Model)
  I E IBM InfoSphere Metadata Workbench (Common Model)
SAS Metadata Bridge for Business Objects I   SAP BusinessObjects CrystalReports XI (File)
  I   SAP BusinessObjects CrystalReports XI (Repository)
  I   SAP BusinessObjects DataIntegrator
  I   SAP BusinessObjects Designer(Repository)
  I E SAP BusinessObjects Designer(File)
  I E SAP BusinessObjects DataIntegrator
SAS Metadata Bridge for CA I   CA COOL:Enterprise (ADW) 2.7
  I   CA COOL:Biz 5.1
  I E CA Gen 4.1a to 7.6
  I E CA ERwin 3.x (ERX)
  I   Microsoft Office VisioDatabase (via ERX)
    E Microsoft Office VisioDatabase (via ERX)
    E Sybase PowerDesigner 7.0 (viaERX)
  I E CA ERwin 4.x DataModeler
  I   CA ERwin 7.x Data Modeler(via Model Manager)
  I   CA ERwin 7.3 Data Modeler(via Model Manager on Oracle)
  I   CA ERwin 7.3 Data Modeler(via Model Manager on SQLServer 2005)
  I E CA ERwin 7.x Data Modeler(File)
  I E CA ERwin 8.x DataModeler (File)
  I   CA COOL:BusinessTeam(GroundWorks) 2.2.1
  I   CA Model Manager 7.x
  I   CA Model Manager 7.3 onOracle
  I   CA Model Manager 7.3 onSQLServer 2005
  I E CA Component Modeler 3.52(ParadigmPlus)
  I E CA Repository for DistributedSystems
  I E CA Repository for z/OS
  I   CA COOL:DBA (Terrain for DB2)5.3.2
  I   CA COOL:Xtras Mapper(TerrainMap for DB2)
SAS Metadata Bridge for IBM Cognos I   IBM Cognos Series 7Impromptu
  I E IBM Cognos BI Reporting -Framework Manager for ReportNet
  I E IBM Cognos BI Reporting -Framework Manager
SAS Metadata Bridge for EmbarcaderoTechnologies I   Embarcadero ER/Studio DataArchitect
  I   Embarcadero ER/StudioBusiness Architect (via DM1)
    E Embarcadero ER/Studio DataArchitect
    E Embarcadero ER/StudioBusiness Architect (via DM1)
SAS Metadata Bridge for Hummingbird I E Open Text eDOCS DataIntegration (Hummingbird) Genio
SAS Metadata Bridge for Oracle Hyperion I E Oracle Hyperion EssbaseIntegration Services
SAS Metadata Bridge for IBM Rational Rose I E IBM InfoSphere Data Architect
  I E IBM InfoSphere Warehouse /InfoSphere Data Architect
  I E IBM Rational Rose 4.0
  I E IBM Rational Rose 6.0(98i) to6.5(2000)
  I E Microsoft Visual Studio /Modeler 2.0 (via MDL)
  I E IBM Rational Rose 7.x (2000eand newer)
  I E IBM InfoSphere InformationServer (Common Model)
  I   IBM InfoSphere MetadataWorkbench (Common Model)
    E IBM Rational SoftwareArchitect (RSA) (via Rose MDL)
    E IBM Rational Software Modeler(RSM) (via Rose MDL)
    E IBM Rational Rose XDEDeveloper (via Rose MDL)
SAS Metadata Bridge for Informatica I E Informatica Developer - Betabridge
    E Informatica DataAnalyzer
  I   Informatica PowerCenter(File)
    E Informatica Metadata Manager
  I   Informatica PowerCenter(Repository)
SAS Metadata Bridge for KnightsbridgeSolutions   E HP Knightsbridge CDMA
 SAS Metadata Bridge for General IndustryStandards I   Database (via JDBC)
  I   IBM Lotus Notes (viaJDBC-ODBC)
  I   IBM DB2  Data Server (via JDBC)
  I   IBM InfoSphere FederationServer (via JDBC)
  I   Microsoft Office Access (viaJDBC-ODBC)
  I   Microsoft SQL Server  Database (via JDBC)
  I   Database (via ODBC)
  I   Oracle Database (viaJDBC)
  I   Sybase Database (viaJDBC)
  I   Teradata Database (via JDBC)
  I E Meta Integration Repository(MIR) XMI multimodel content
  I E Meta Integration Repository(MIR) Application Server
  I E Meta Integration Repository(MIR) XMI file
  I E SAS Data Integration Studio(via MIR XMI)
  I E SAS Management Console (viaMIR XMI)
  I E SAS Metadata Management (viaMIR XMI)
    E Informatica Metadata Manager(via MIR XMI)
  I   Microsoft SQL Server AnalysisServices 7.0 to 2000 (via ODBO)
  I   MicroStrategy MDX Adapter(via ODBO)
  I   SAP Business Warehouse (viaODBO)
  I   SAS OLAP Server (viaODBO)
    E Database Data DefinitionLanguage (DDL)
  I E OMG CWM 1.x XMI 1.x
  I E Oracle Hyperion ApplicationBuilder (via CWM XMI)
  I E IBM DB2 Warehouse Manager(via CWM XMI)
  I E Oracle Warehouse Builder (viaCWM XMI)
  I E SAS Data Integration Studio(via CWM XMI)
  I E OMG CWM Pre-1.0 XMI 1.1
  I   OMG UML 2.x XMI 2.x
  I   Borland Together (via UML 2.xXMI)
  I   IBM Rational SoftwareArchitect (RSA) (via UML 2.x XMI)
  I   Sparx Enterprise Architect(EA) (via UML 2.x XMI)
  I E OMG UML 1.x XMI 1.x
  I E Borland Together (via UML 1.xXMI)
  I E CA Component Modeler 4.x (viaUML 1.x XMI)
  I E Embarcadero Describe (via UML1.x XMI)
  I E Gentleware Poseidon (via UML1.x XMI)
  I   Microsoft Office Visio UML(via UML 1.x XMI)
  I E NoMagic MagicDraw (via UML1.x XMI)
  I E Sparx Enterprise Architect(EA) (via UML 1.x XMI)
  I   Sybase PowerDesigner OOM  9.x to 15.x (via UML 1.x XMI)
  I E IBM Telelogic Tau (via UML1.x XMI)
  I E Tigris ArgoUML (via UML 1.xXMI)
    E Sybase PowerDesigner OOM  9.x to 15.x (via UML 1.x XMI)
    E Oracle Data Integrator
  I   W3C XML DTD 1.0
  I E W3C XML Schema 1.0 (XSD)
  I   Microsoft SQL Server XML DataReduced (XDR) Schema
    E Altova XMLSpy
    E Sybase PowerDesigner XSM 10.xto 15.x
SAS Metadata Bridge for Microsoft Excel I E Microsoft Office Excel
  I   Microsoft Office Excel (multi-model)
SAS Metadata Bridge for Microsoft SQLServer I   Microsoft SQL Server AnalysisServices 7.0 to 2000 (Repository)
  I E Microsoft SQL Server DataSource View
  I E Microsoft SQL Server AnalysisServices (via DSV File)
  I E Microsoft SQL ServerIntegration Services (via DSV File)
  I E Microsoft SQL ServerIntegration Services (File)
    E Microsoft SQL ServerIntegration Services (Project)
  I E Microsoft SQL ServerRepository 3.x (via MDC)
  I   Microsoft SQL Server AnalysisServices 2005 to 2008 (Repository)
    E Microsoft SQL Server AnalysisServices (Repository)
  I   Microsoft SQL Server Analysisand Reporting Services (Repository)
  I   Microsoft SQL ServerIntegration Services (Repository)
  I   Microsoft SQL ServerReporting Services (Repository)
  I E Microsoft SQL ServerRepository 2.1b (via XIF)
  I   Microsoft SQL ServerReporting Services (File)
  I   Microsoft SQL Server AnalysisServices 2005 to 2008 (File)
SAS Metadata Bridge for MicroStrategy I   MicroStrategy 7.0 to 9.0
SAS Metadata Bridge for Oracle I   Oracle Data Integrator
  I E Oracle Designer
  I E Oracle Warehouse Builder
SAS Metadata Bridge for IBM RationalSystem Architecht I E IBM Rational System Architect7.1 to 11.x (File)
  I E IBM Rational System Architect10.4 to 11.x (Encyclopedia)
SAS Metadata Bridge for ProActivity I   EMC ProActivity 3.x & 4.0
SAS Metadata Bridge for Select SE I   Select SE
SAS Metadata Bridge for GranditeSilverrun RDM I   Grandite Silverrun-RDM 2.4.4to 2.7.2
SAS Metadata Bridge for SybasePowerDesigner I   Sybase PowerDesigner CDM  6.x
  I   Sybase PowerDesigner CDM  7.5 to 15.x
    E Sybase PowerDesigner CDM  8.0 to 15.x
    E Sybase PowerDesigner PDM  8.x to 15.x
  I   Sybase PowerDesigner PDM  6.1.x
  I   Sybase PowerDesigner PDM  7.5 to 15.x
SAS Metadata Bridge for Visible Advantage I   Visible IE:Advantage 6.1