MetaMatrix Products
MetaMatrix Connectors
MetaMatrix offers multiple connector families to provide data access to a variety of source systems. These connectors plug into the MetaMatrix connector framework, and are used by the query engine to interface with data sources when processing federated queries.
Connectors are classified by the type of source ("relational"-style or XML/hierarchical-style) and by the form the information is treated in MetaMatrix (relational or XML/hierarchical).
In addition to these "out of the box" connectors provided by MetaMatrix, MetaMatrix Enterprise is architected with an extensible connector framework to allow for development of custom connectors. See also MetaMatrix product suites.
Relational Database Sources
These connectors all interface with relational database sources, and have a relational-style interface with MetaMatrix (relational model type). The importers create Relational models.
| Connector Type | DBMS | Versions | Importer? | Available with ... |
|---|---|---|---|---|
| OracleANSI | Oracle | 9i, 10g | Y | All |
| Oracle8 | Oracle | 8i | Y | All |
| SQL Server | SQL Server | 2000, 2005 | Y | All |
| DB2 | DB2 | 8 | Y | All |
| Sybase | Sybase Adaptive Server Enterprise | 12.0, 12.5 | Y | All |
| Sybase11 | Sybase Adaptive Server Enterprise | 11.5, 11.9 | Y | All |
| PostgreSQL | PostgreSQL | 7.2, 7.3, 7.4, 8.0, 8.1 | Y | All |
| MySQL | MySQL | 4.1, 5.0 | Y | All |
| Derby Server | Derby | 10.1.2.1 | Y | All |
| MetaMatrix | MetaMatrix | 4.*, 5.0 | Y | Enterprise |
| JDBC | Any JDBC source | Y | Dimension, Enterprise | |
| JDBC-ODBC Bridge | Any ODBC source (Access, Excel, etc) | Y | All |
XML / Web Services Sources (Relational Representation)
These connectors all interface with XML sources, but have a relational-style interface with MetaMatrix (relational model type). The importers create Relational models.
| Connector Type | Access Protocol | Description | Importer? | Available with ... |
|---|---|---|---|---|
| XML-Relational HTTP | HTTP | Accesses XML data over HTTP, 'flattens' it into related relational tables. | Y | Dimension, Enterprise |
| XML-Relational File | File system | Accesses XML data from the file system, 'flattens' it into related relational tables. | Y | Dimension, Enterprise |
| Web Services-Relational | SOAP | Accesses XML data over SOAP, 'flattens' it into related relational tables. | Y | Dimension, Enterprise |
XML / Web Services Sources (XML Representation)
These connectors all interface with XML sources, and have an XML-style interface with MetaMatrix (XML Service model type).
| Connector Type | Access Protocol | Description | Importer? | Available with ... |
|---|---|---|---|---|
| XML File | File system | Accesses XML data from the file system and returns XML through an XML Service model. | N | Dimension, Enterprise |
| Web Services | SOAP | Accesses XML data through a SOAP interface and returns XML through an XML Service model. | N | Dimension, Enterprise |
Text Sources
These connectors interface with text files, but have a relational-style interface with MetaMatrix (relational model type). The importers create Relational models.
| Connector Type | Description | Importer? | Available with ... |
|---|---|---|---|
| Excel | Accesses data in a Microsoft Excel spreadsheet | Y | All |
| Text File | Reads columnar information from delimited text files (csv, etc) | N | Dimension, Enterprise |
Packaged Application Sources
These connectors all interface with packaged applications, but have a relational-style interface with MetaMatrix (relational model type). The importers create Relational models.
| Connector Type | System | Versions | Required from Customer | Importer? | Available with ... |
|---|---|---|---|---|---|
| SAP | SAP R/3 | Most versions are supported; tested on 4.6c | SAP Java Connectivity (JCo) | Y | Enterprise |
| Siebel | Siebel | Most versions are supported; tested on 7.7 | Y | Enterprise | |
| PeopleSoft | PeopleSoft | Most versions are supported; tested on 8.4 | PeopleSoft Java Client (psjoa.jar) | Y | Enterprise |
| Others... | Available on demand | Enterprise |
Specialized Sources
These connectors interface with specialized source types, but have a relational-style interface with MetaMatrix (relational model type).
| Connector Type | Description | Importer? | Available with ... |
|---|---|---|---|
| Oracle Geospatial | Accesses information in Oracle Geospatial database | N | Enterprise |
Miscellaneous Sources
The loopback connector connects to no data source, but emits 'dummy' data conforming to the relational model it is bound to.
| Connector Type | Description | Importer? | Available with ... |
|---|---|---|---|
| Loopback | Dummy source, yields result sets in response to queries | N | Dimension, Enterprise |