CData Software - Knowledge Base
Recent Articles
-
Connect to JSON Services from a Connection Pool in Jetty
The JSON JDBC Driver supports connection pooling: This article shows how to connect faster to JSON from Web apps in Jetty.
-
How to connect Amazon QuickSight to Cassandra
Create a connection to Apache Cassandra in CData Connect AI and insert Apache Cassandra into Amazon QuickSight SPICE to build interactive dashboards.
-
Feed Azure Analysis Services into FineReport
How to set Azure Analysis Services as a JDBC data source in FineReport.
-
Provide OData Services of REST from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for REST by developing a WCF Service Application.
-
Connect and Query Live GitHub Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live GitHub into Databricks
-
Getting Started with the CData Python Connector for Sybase
Learn to install and license the CData Python Connector
-
How to work with DB2 in Apache Spark using SQL
Access and process DB2 in Apache Spark using the CData Software JDBC Driver.
-
Analyze Live Amazon Marketplace in SAS Viya
Use CData Connect AI to connect to Amazon Marketplace from SAS Viya and deploy self-service analytics using live Amazon Marketplace.
-
Creating WooCommerce-Connected Applications in Unqork
You can use CData Connect AI to feed WooCommerce to Unqork and build custom business apps.
-
How to Query HubDB in MySQL Workbench
Execute MySQL queries against live HubDB from MySQL Workbench.
-
Object-Relational Mapping (ORM) with Salesforce Pardot Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Salesforce Pardot into a Java-based ORM framework, Hibernate.
-
Automated Continuous SharePoint Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft SharePoint replication to OneLake in Microsoft Fabric.
-
Migrating data from Google Data Catalog to Databricks using CData SSIS Components.
Easily push Google Data Catalog to Databricks using the CData SSIS Tasks for Google Data Catalog and Databricks.
-
Use the CData Software JDBC Driver for Office 365 in MicroStrategy Desktop
Connect to Microsoft Office 365 in MicroStrategy Desktop using the CData Software JDBC Driver for Office 365.
-
Automated Continuous Tableau CRM Analytics Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to Apache Kafka.
-
How to Connect to Live Oracle HCM Cloud from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Oracle HCM Cloud for you.
-
Connect to Salesforce Marketing from PowerBuilder via JDBC
This article demonstrates how to access Salesforce Marketing Cloud from PowerBuilder using the Salesforce Marketing JDBC Driver.
-
Use the CData ODBC Driver for HCL Domino from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HCL Domino to connect to HCL Domino from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HCL Domino in Excel.
-
How to Connect the Power BI Service to SAP HANA XS Advanced: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Build Agents in Relevance AI with Access to Live Twilio via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Twilio within intelligent agent workflows.
-
Getting Started with the CData ODBC Driver for Quickbase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Quickbase.
-
Connect to Marketo as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Marketo.
-
Connect and Query Live Blackbaud FE NXT Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Blackbaud FE NXT into Databricks
-
ETL Clio in Oracle Data Integrator
This article shows how to transfer Clio into a data warehouse using Oracle Data Integrator.
-
View Reports on Real-Time Dynamics 365 in Power BI Report Server
Use the CData ODBC Driver for Dynamics 365 to visualize Microsoft Dynamics 365 in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Reckon-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Reckon and create custom apps in Mendix.
-
Query ShipStation from Node.js
Use the OData endpoint of the CData API Server to connect to your ShipStation and perform CRUD operations on ShipStation from Node.js.
-
Access Dropbox from MySQL in PHP
Connect to Dropbox through the standard MySQL libraries in PHP.
-
Analyze Elasticsearch in Cognos Analytics
Use CData Connect AI to connect to Elasticsearch from Cognos Analytics and analyze live Elasticsearch.
-
Use Azure AI Foundry to Talk to Your SAP Business One via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAP Business One for you.
-
Build Visualizations of Google Contacts in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Contacts in Birst.
-
Connect to Salesforce from PowerBuilder via JDBC
This article demonstrates how to access Salesforce & Force.com from PowerBuilder using the Salesforce JDBC Driver.
-
How to Query Live Avalara AvaTax in Claude Desktop
Connect to and query live Avalara AvaTax in Claude Desktop using the CData MCP Server.
-
Access Access as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Access from your Oracle system.
-
Integrate SQL Server with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SQL Server with External Services.
-
Build Agents in Relevance AI with Access to Live Google Contacts via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Contacts within intelligent agent workflows.
-
Connect to and Query Reckon Accounts Hosted in QlikView over ODBC
Create data visualizations with Reckon Accounts Hosted in QlikView.
-
Use JayDeBeApi to access FTP in Python
Use standard Python scripting and the development environment of your choice to access live FTP Servers.
-
A PostgreSQL Interface for Excel Online using the CData ODBC Driver
Use the SQL Gateway and Excel Online ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to publish and share Avro dashboards with Tableau Server
The CData ODBC driver for Avro enables you integrate Apache Avro into Tableau dashboards.
-
How to publish and share HarperDB dashboards with Tableau Server
The CData ODBC driver for HarperDB enables you integrate HarperDB into Tableau dashboards.
-
Automated Continuous Tally Replication to SQLite
Use CData Sync for automated, continuous, customizable Tally replication to SQLite.
-
Natively Connect to Kintone in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Kintone. Leverage the native support for ODBC in PHP.
-
Query Clio through ODBC in Node.js
Use node-odbc to execute SQL queries against Clio from Node.js.
-
Build IBM Cloud Object Storage-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live IBM Cloud Object Storage.
-
Use Microsoft Copilot Studio to talk to your SAP BusinessObjects BI via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP BusinessObjects BI for you.
-
Create Dashboards and Visualize Live Zoho Projects in Geckoboard
Use CData Connect AI to connect to live Zoho Projects and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access QuickBooks Time from MySQL in Amazon QuickSight
Connect to QuickBooks Time and build visualizations of QuickBooks Time using a MySQL Connection in Amazon QuickSight.
-
ETL Harvest in Oracle Data Integrator
This article shows how to transfer Harvest into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData JDBC Driver for Sage 200
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sage 200.
-
Automate Dynamics NAV Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Dynamics NAV and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to integrate ConstantContact with Apache Airflow
Access and process ConstantContact in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous JSON Replication to Snowflake
Use CData Sync for automated, continuous, customizable JSON replication to Snowflake.
-
Integrate with Tally in JReport Designer
Create charts and reports based on Tally ERP in JReport Designer.
-
A PostgreSQL Interface for Shopify (MySQL Remoting via JDBC)
Use the Remoting features of the Shopify JDBC Driver to create a PostgreSQL entry-point for data access.
-
Add Cassandra to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Cassandra with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect to Azure DevOps from IntelliJ
Integrate connectivity to Azure DevOps with wizards in IntelliJ.
-
Getting Started with the CData SSIS Components for Sage 200
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sage 200.
-
Automated Continuous SAP ByDesign Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to SQL Server.
-
Create Zoho Projects-Connected Business Apps in AppSheet
Connect to Zoho Projects via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Zoho Projects.
-
Query Splunk from Node.js
Use the OData endpoint of the CData API Server to connect to your Splunk and perform CRUD operations on Splunk from Node.js.
-
Query, Visualize, and Share live Dynamics 365 Business Central in Redash
Use CData Connect AI to connect to live Dynamics 365 Business Central in Redash for querying, visualizing, and sharing.
-
Sage Intacct Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sage Intacct through CData Connect AI using different applications and tools.
-
Visualize Live QuickBooks Time in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live QuickBooks Time into custom reports in Power BI.
-
Process & Analyze Certinia in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Certinia .
-
Integrating LangChain with Google Spanner via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Spanner within automated workflows.
-
How to Access Live Hive in Visual Studio Code via Cline
Run the CData MCP Server for Hive on Windows Subsytem for Linux (WSL) and connect to live Apache Hive from the Cline extension in Visual Studio Code.
-
Work with Live Excel Online in Power Query
Use CData Connect AI to connect to Microsoft Excel Online and work with live Microsoft Excel Online in Microsoft Power Query.
-
Automated Continuous Zoho Projects Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Google Cloud SQL.
-
How to integrate Metabase with Sage Cloud Accounting
Use CData Connect AI to connect to live Sage Business Cloud Accounting and create an interactive dashboard in Metabase from Sage Business Cloud Accounting.
-
Working with Zoho Books in LINQPad
Execute LINQ queries to Zoho Books in LINQPad.
-
Build Apps with Live Pivotal GreenPlum in Adalo using CData Connect AI
Use CData Connect AI to integrate live Pivotal GreenPlum into the Adalo platform and build custom mobile and web applications with real-time Pivotal GreenPlum.
-
Automated Continuous SharePoint Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SharePoint replication to Apache Cassandra.
-
HCL Domino REST API Part 1: How to set up the environment
The first article in an article series that goes over the HCL Domino REST API. This article is a guide for how to get started with and setup the Domino REST API.
-
Create Apps from Reckon Accounts Hosted in Qlik Sense Cloud
Use CData Connect AI to connect to Reckon Accounts Hosted and build apps from live Reckon Accounts Hosted in Qlik Sense Cloud.
-
How to Connect to Live ServiceNow from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your ServiceNow for you.
-
Bind Live Asana Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Asana data
-
How to Connect to Live Azure Analysis Services Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Azure Analysis Services securely in real time.
-
Migrating data from LDAP to Google BigQuery using CData SSIS Components.
Easily push LDAP to Google BigQuery using the CData SSIS Tasks for LDAP and Google BigQuery.
-
How to connect SharePoint with Sage Cloud Accounting through external lists
Provide Sage Business Cloud Accounting to SharePoint users as an external list.
-
Create Salesforce Marketing Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce Marketing data access from reports, embedded analytics, and more.
-
DataBind Charts to Microsoft Dataverse
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Dataverse (CDS) from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use the CData Software JDBC Driver for Freshdesk in MicroStrategy Desktop
Connect to Freshdesk in MicroStrategy Desktop using the CData Software JDBC Driver for Freshdesk.
-
Provide OData Services of SharePoint from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft SharePoint by developing a WCF Service Application.
-
Access Freshdesk as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Freshdesk from your Oracle system.
-
Visualize Shopify in TIBCO Spotfire through OData
Integrate Shopify into dashboards in TIBCO Spotfire.
-
Automated Continuous HCL Domino Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HCL Domino replication to Amazon Redshift.
-
Zuora Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zuora facts in real time.
-
Validate Microsoft Planner with QuerySurge
Access and validate Microsoft Planner in QuerySurge using the CData JDBC Driver.
-
Visualize Google Search Results in Sisense
Create an ElastiCube in Sisense app with access to Google Search.
-
Use CData Connect AI to Access SAP Business One in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Business One in the Power Pivot business intelligence tool.
-
Create Parquet Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous SAP ByDesign Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Databricks.
-
Use the CData API Server to Access Azure DevOps in Microsoft PowerPivot
Use the CData API Server to connect to live Azure DevOps in the Power Pivot business intelligence tool.
-
Publish Crystal Reports on xBase
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date xBase.
-
Create QuickBooks Online-Connected Nintex Workflows
Use CData Connect AI to connect to QuickBooks Online from Nintex Workflow Cloud and build custom workflows using live QuickBooks Online.
-
Connect to ClickUp in Jaspersoft Studio
Execute SQL to remote ClickUp in Jaspersoft Studio.
-
Visualize Live WooCommerce of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live WooCommerce using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Data Visualizations in Cognos BI with Dynamics CRM
Access Microsoft Dynamics CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to and Query QuickBooks Online in QlikView over ODBC
Create data visualizations with QuickBooks Online in QlikView.