Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Apache MetaModel is a library that encapsulates the differences and enhances the capabilities of different datastores. Rich querying abilities are offered to datastores that do not otherwise support advanced querying and a unified view of the datastore structure is offered through a single model of the schemas, tables, columns and relationships.  

Key concepts:

Knowledge base and background information

...

:

...

Details about Connectors / DataContext implementations:

Datastore typeDataContext class nameProperties "type" valueVariants supported/available

JDBC / Relational Databases

JdbcDataContextjdbc

PostgreSQL, MySQL, Microsoft SQL Server, Oracle DB, IBM DB2
Apache Hive, Apache Derby, SQLite, Ingres, H2, HSQLDB
(... and many more)

CSV files

CsvDataContextcsv

Comma-separated
Tab-separated
Anything-separated files

Fixed width value filesFixedWidthDataContextfixed-width

Fixed width
EBCDIC

Microsoft Excel spreadsheetsExcelDataContextexcel

.xls
.xlsx 

Microsoft Access database filesAccessDataContext-

.mdb
.accdb

OpenOffice.org database filesOpenOfficeDataContext-.odb
XML filesXmlDomDataContext
XmlSaxDataContext 
xml

DOM-based parsing (all in-memory)
SAX-based parsing (streaming) 

JSON filesJsonDataContextjson 
ElasticSearch

ElasticSearchDataContext
ElasticSearchRestDataContext

elasticsearch

Native Java API
RESTful JSON API

MongoDBMongoDbDataContext-MongoDB 2.x
MongoDB 3.x 
Apache CouchDBCouchDbDataContext

...

couchdb 
Apache CassandraCassandraDataContextcassandra 
Apache HBaseHBaseDataContexthbase 
Apache KafkaKafkaDataContext

Neo4jNeo4jDataContext- 
Salesforce.comSalesforceDataContextsalesforce 
SugarCRM

...

SugarCrmDataContext- 
Java collectionsPojoDataContextpojo

Collection<Object[]>
Collection<Map<String, Object>>
Collection<JavaBean> 

Collections of other datastoresCompositeDataContext  

...

Additional information for the interested: