Denodo has a wide range of point and click interfaces covering structured,
semi-structured and unstructured data sources. This post will try to list
samples in each of these categories to paint the possibilities with Denodo.
Structured Data:
- RDBMS: Oracle, IBM DB2, Microsoft SQL Server, Sybase, MySQL, Postgre SQL etc
- Data Warehouse appliances and Parallel Databases: Netezza, Teradata, Oracle Exadata, ParAccel, Sybase IQ
- Multidimensional OLAP Engines: SAP BW, MS SSAS, Essbase & Mondrain
- Enterprise Applications : Salesforce, Siebel, Peoplesoft, Oracle E-Business suite, SAP R3 / ECC
- Mainframe / Legacy: Adabas, IMS, DB2, TN5250 / TN3270. Plug-in architecture available for use of third party mainframe / legacy adapters.
Semi-Structured Data:
- SOAP / REST Web Services & data feeds: XML, RSS, JSON, ATOM and CSV formats.
- Directory Services: Can connect and introspect LDAP and Active Directory services as source data
Un-Structured Data:
- Email, MS Word etc
Other data sources supported and which I am yet to categorize
into above categories are as below as it depends on the data that is stored within those data source:
- Semantic repositories in Triple Stores / RDF accessed through SPARQL endpoints.
- Big Data & NoSQL databases: Hadoop, Hive, HBase, Mongo DB, CouchDB, Neo4J, MarkLogic.
- Cloud & SaaS sources:
- Via APIs: Salesforce, Amazon, Google LinkedIn, Facebook, Twitter
- Via Browser Automation: Website, Form, WebApp
- Custom Applications: Connector SDK available to access any custom application through API and procedural interfaces.
- Sophisticated tools to expose Web, Semi & Unstructured data as virtual relational data/service.
