Couchbase and SQL
Digital Economy companies store their operational data in JSON using Couchbase. Integrating that JSON data with the universe of existing relational tools and applications increases productivity, leverages existing skills and resources, and decreases time to market.
Database connectors, like ODBC, JDBC, and ADO.NET are used by millions of applications every day for many purposes including ETL, BI, and reporting. Developers, DevOps, Architects, and End Users all depend on reliable, scalable, high-performance connectors to enable their tools and applications.
Couchbase’s SQL-based query language, called N1QL, provides full SQL access to your JSON data (including joins, aggregates, and optimized index data access). This makes database connectors to Couchbase more efficient, performant, and scalable than other NoSQL providers.
Which integration challenge are you trying to solve? Odds are you’ll find a tool or a connector below that makes it easier.
Magnitude Simba
Simba Technologies provides standard ODBC and JDBC driver connectivity for Couchbase. These drivers are ODBC 3.8 and JDBC 4.0/4.1 compliant, and SQL-92 compatible. With native support for N1QL (our SQL for JSON query language), these drivers empower any ODBC or JDBC-based tool or application to connect to a Couchbase Server cluster.
Getting started
CData
CData Software provides standards-based connector technology for Couchbase Server, including ODBC, JDBC, ADO.NET, OData, SSIS, BizTalk, and Excel. These drivers support direct interaction between a Couchbase Server cluster and almost any client or tool that is compatible with these protocols.
Getting startedBI and Visualization
Tableau
Use Tableau and the Couchbase ODBC driver to analyze and visualize your Couchbase data.
Partner pageCloud9 Charts
Create compelling business charts and visualizations from your Couchbase data using Cloud9 Charts' native Couchbase 4.5 driver.
OverviewQlik
Leverage your Couchbase data by using Qlik to create business-critical visualizations, dashboards, and applications.
VideoSlamData
Think “Tableau for NoSQL.” Get analytics, dashboards, and visualization directly from your Couchbase data (no ETL or data mapping required) with SlamData.
OverviewExcel
Leverage Excel’s native JSON support or Couchbase’s ODBC driver to quickly build business reports, based on your data that is stored in Couchbase.
TutorialPower BI
Create rich business visuals using your Couchbase data via Power BI with native JSON support or via the Couchbase ODBC driver.
Tutorial