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.
Knowi
Knowi is an analytics platform that provides native integration to Couchbase. Create charts and visualizations in minutes and provide business users with a natural language self-service interface so they can easily find the answers they need. For advanced use cases, Knowi includes machine learning and alerting so you can drive predictive actions directly from your Couchbase data.
Getting startedCData
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 startedMOLO17
GlueSync connector is a native Couchbase connector that connects Couchbase to most common RDBMS products. GlueSync enables two-way data streaming in real time with Microsoft SQL Server and Oracle Database and will be soon available for other SQL databases.
Getting startedBI and Visualization
Tableau
Use Tableau and the Couchbase ODBC driver to analyze and visualize your Couchbase data.
TutorialQlik
Leverage your Couchbase data by using Qlik to create business-critical visualizations, dashboards, and applications.
TutorialExcel
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