CData Software - Knowledge Base
Recent Articles
-
How to Connect DBeaver to DB2 via a JDBC Driver
Manage IBM DB2 with visual tools in DBeaver like the query browser.
-
Rapidly Develop Jira Assets-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Query Marketo from Node.js
Use the OData endpoint of the CData API Server to connect to your Marketo and perform CRUD operations on Marketo from Node.js.
-
Visualize Live Pinterest of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pinterest using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Crystal Reports on HubDB
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HubDB.
-
ETL Splunk in Oracle Data Integrator
This article shows how to transfer Splunk into a data warehouse using Oracle Data Integrator.
-
Analyze Sugar CRM with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sugar CRM from Power Pivot. You will use the Table Import Wizard to load Sugar CRM. You can visually build the import query or use any SQL supported by the driver.
-
Connect MongoDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MongoDB using the CData Python MCP Server.
-
Getting Started with the CData Python Connector for Hive
Learn to install and license the CData Python Connector
-
Connect to Google Search Results in NetBeans
Connect to Google Search in NetBeans with the data source configuration wizard.
-
Use Biml to Build SSIS Tasks to Replicate Box to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Box to SQL Server.
-
Use the CData ODBC Driver for Trello from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Trello to connect to Trello from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Trello in Excel.
-
Query CouchDB from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache CouchDB and perform CRUD operations on CouchDB from Node.js.
-
Natively Connect to QuickBooks in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to QuickBooks Desktop. Leverage the native support for ODBC in PHP.
-
Build Amazon S3-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon S3 from Zoho Analytics and import live Amazon S3.
-
Prepare, Blend, and Analyze Invoiced in Alteryx Designer (ODBC)
Build workflows to access live Invoiced for self-service data analytics.
-
Integrate with SAP Ariba Procurement in JReport Designer
Create charts and reports based on SAP Ariba Procurement in JReport Designer.
-
Automated Continuous Zoho Creator Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Amazon S3.
-
Integrate Microsoft OneDrive in the Pentaho Report Designer
Publish reports based on Microsoft OneDrive in the Pentaho BI tool.
-
Query LDAP Objects in DataGrip
Create a Data Source for LDAP in DataGrip and use SQL to query live LDAP.
-
How to integrate Metabase with Gmail
Use CData Connect AI to connect to live Gmail and create an interactive dashboard in Metabase from Gmail.
-
Query Microsoft Exchange through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Exchange from Node.js.
-
Build Semantic Layer Views for REST in APOS Live Data Gateway
Use the CData Connector for REST in APOS Live Data Gateway to build Semantic Layer Views for REST.
-
How to Work with Jira Service Management in AWS Glue Jobs Using JDBC
Connect to Jira Service Management from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData Tableau Connector for Sugar CRM
-