CData Software - Knowledge Base
Recent Articles
-
Migrating data from xBase to Databricks using CData SSIS Components.
Easily push xBase to Databricks using the CData SSIS Tasks for xBase and Databricks.
-
Connect Printful to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Printful using the CData Python MCP Server.
-
DataBind Controls to Avalara AvaTax in C++Builder
DataBind to Avalara AvaTax in C++Builder with standard components and controls.
-
Create WordPress Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time WordPress data access from reports, embedded analytics, and more.
-
ETL Tableau CRM Analytics in Oracle Data Integrator
This article shows how to transfer Tableau CRM Analytics into a data warehouse using Oracle Data Integrator.
-
Automated Continuous SAP Business One Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Business One replication to Databricks.
-
Replicate Pinterest to Multiple Databases via the CData Sync CLI
Replicate Pinterest to disparate databases with a single configuration.
-
How to Connect to Live NetSuite 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 NetSuite CRM & ERP for you.
-
Build Dashboards with Facebook in Dundas BI
Create dynamic dashboards and perform analytics based on Facebook in Dundas BI.
-
Analyze BigCommerce in Looker
Use CData Connect AI to connect to BigCommerce from Looker and build custom apps using live BigCommerce.
-
Connect to Airtable in NetBeans
Connect to Airtable in NetBeans with the data source configuration wizard.
-
Integrating LangGraph with Oracle HCM Cloud via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle HCM Cloud within automated workflows.
-
How to Connect to Live Slack 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 Slack for you.
-
Connect Pinterest to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Pinterest with IBM WebSphere for seamless data integration and connectivity.
-
Create SAS Data Sets Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAS Data Sets data access from reports, embedded analytics, and more.
-
Automated Continuous Dynamics CRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Azure SQL Database.
-
Integrate with Live Act CRM in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Act CRM from the MuleSoft Anypoint Platform to integrate live Act CRM into custom reports and dashboards.
-
Connect to BigQuery 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 Google BigQuery.
-
Visualize TigerGraph from Tableau
Use the Tableau Desktop business intelligence tool to connect to TigerGraph.
-
How to Connect to Live BigCommerce in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live BigCommerce without replication.
-
Query WordPress from Node.js
Use the OData endpoint of the CData API Server to connect to your WordPress and perform CRUD operations on WordPress from Node.js.
-
Natively Connect to Cloudant in PHP
The CData ODBC driver for Cloudant enables you to create PHP applications with connectivity to IBM Cloudant. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze Shopify in Alteryx Designer (Connect AI)
Build workflows to access live Shopify for self-service data analytics.
-
Access SAP SuccessFactors in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SAP SuccessFactors.
-
Design BIRT Reports on Google Cloud Storage
Provide current Google Cloud Storage to your embedded analytics.
-
How to Work with SAP SuccessFactors LMS in ETL Validator JDBC
Connect to SAP SuccessFactors LMS from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Charts with eBay in Clear Analytics
Create dynamic charts and perform analytics based on eBay in Clear Analytics.
-
Analyze Office 365 with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Office 365 from Power Pivot. You will use the Table Import Wizard to load Microsoft Office 365. You can visually build the import query or use any SQL supported by the driver.
-
How to Query Live SAS Data Sets in Claude Desktop
Connect to and query live SAS Data Sets in Claude Desktop using CData Code Assist MCP.
-
Access Live Avalara AvaTax in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Avalara AvaTax from your Excel spreadsheets.
-
Integrate HBase in the Pentaho Report Designer
Publish reports based on Apache HBase in the Pentaho BI tool.
-
Automate Sugar CRM Replication to SAP HANA
Use CData Sync to customize and automate Sugar CRM replication to SAP HANA.
-
Connect to SAP Business One in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Rapidly Develop Monday.com-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.
-
Presto Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Presto through CData Connect AI using different applications and tools.
-
Build Visualizations of Asana in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Asana in Birst.
-
Build Charts with DB2 in Clear Analytics
Create dynamic charts and perform analytics based on IBM DB2 in Clear Analytics.
-
Build SAP Fieldglass-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP Fieldglass.
-
Connect to CockroachDB in NetBeans
Connect to CockroachDB in NetBeans with the data source configuration wizard.
-
Back Up LinkedIn to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for LinkedIn. In this article, we will employ an SSIS workflow to populate a database with LinkedIn data.
-
Using the CData Software ODBC Driver for Epicor Kinetic in PyCharm
Connect to Epicor Kinetic as an ODBC data source in PyCharm using the CData Software ODBC Driver for Epicor Kinetic.
-
Build Pipelines with Live Azure Data Lake Storage in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Azure Data Lake Storage from Google Cloud Data Fusion, enabling the integration of live Azure Data Lake Storage into the building and management of effective data pipelines.
-
Connect to HBase in HULFT Integrate
Connect to HBase as a JDBC data source in HULFT Integrate
-
Connect to Live Google Contacts in MicroStrategy through CData Connect AI
Create a live connection to Google Contacts in CData Connect AI and connect to your Google Contacts from MicroStrategy.
-
Import FHIR into the Power BI Service for Visualizations
Use CData Connect AI to connect to FHIR and provide access to live FHIR for custom reports in the Power BI Service.
-
Build Agents in Relevance AI with Access to Live eBay via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on eBay within intelligent agent workflows.
-
How to Connect the Power BI Service to Oracle Financials Cloud: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
Access Gmail from MySQL in PHP
Connect to Gmail through the standard MySQL libraries in PHP.
-
Visualize Stripe from Tableau
Use the Tableau Desktop business intelligence tool to connect to Stripe.
-
Use the CData Software ODBC Driver for Pinterest in SAS for Real-Time Reporting and Analytics
Connect to real-time Pinterest in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pinterest.
-
Automate Smartsheet Replication to Azure Data Lake
Use CData Sync to customize and automate Smartsheet replication to Azure Data Lake.
-
Replicate Multiple Excel Online Accounts
Replicate multiple Excel Online accounts to one or many databases.
-
How to integrate Xero with Apache Airflow
Access and process Xero Accounting in Apache Airflow using the CData JDBC Driver.
-
Build Automated Xero-Connected Workflows in Zapier
Use CData Connect AI to connect to live Xero Accounting and build automated workflows in Zapier.
-
Integrate ClickUp with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ClickUp with External Services.
-
Access Live Oracle Eloqua in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Eloqua from your Google Sheets.
-
Build MVC Applications with Connectivity to BigQuery
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access BigQuery from an ASP.NET MVC application.
-
Building Dynamic Web Pages with MariaDB Using AngularJS
Create single-page applications with live connectivity to MariaDB using the CData API Server.
-
Use the CData ODBC Driver for Kintone in Microsoft Power Query
You can use the CData Kintone ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Kintone into Microsoft Power Query.
-
Connect to Zendesk from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zendesk from Filemaker Pro on Mac.
-
Integrate Cline with Live Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle Sales from within your IDE.
-
Import Excel Online Using Azure Data Factory
Use CData Connect AI to connect to Excel Online from Azure Data Factory and import live Microsoft Excel Online.
-
Migrating data from SAP Concur to Snowflake using CData SSIS Components.
Easily push SAP Concur to Snowflake using the CData SSIS Tasks for SAP Concur and Snowflake.
-
Stream Google Directory into Apache Kafka Topics
Access and stream Google Directory in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automate Dynamics CRM Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Dynamics CRM replication to Couchbase.
-
Manage Oracle HCM Cloud in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Oracle HCM Cloud.
-
Create NetSuite-Connected Applications in Appsmith
Connect to NetSuite via CData Connect AI in Appsmith and create custom business applications with real-time access to NetSuite CRM & ERP.
-
Build Klaviyo-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Klaviyo.
-
Import Google Analytics into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Analytics and provide access to live Google Analytics for custom reports in the Power BI Service.
-
Use the CData ODBC Driver for Azure Analysis Services in Microsoft Power Query
You can use the CData Azure Analysis Services ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Analysis Services into Microsoft Power Query.
-
Access Parquet in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Apache Parquet.
-
Building Dynamic Web Pages with Snowflake Using AngularJS
Create single-page applications with live connectivity to Snowflake using the CData API Server.
-
Analyze ShipStation in Cognos Analytics
Use CData Connect AI to connect to ShipStation from Cognos Analytics and analyze live ShipStation.
-
Connect to Zoho Books from Asprova with CData Software ODBC Driver for Zoho Books
This article shows how to connect faster to Zoho Books data from Asprova.
-
Use ChatGPT to Talk to Your Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Search for you.
-
How to connect to BigCommerce from Spring Boot
Connect to BigCommerce in a Spring Boot Application using CData JDBC BigCommerce Driver
-
Build a PostgreSQL Interface for IBM Informix using the CData JDBC Driver
Use the Remoting features of the IBM Informix JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous SAP Hybris C4C Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to delimited files (CSV/TSV).
-
Create eBay-Connected Nintex Workflows
Use CData Connect AI to connect to eBay from Nintex Workflow Cloud and build custom workflows using live eBay.
-
Work with Live Oracle Eloqua in Power Query
Use CData Connect AI to connect to Oracle Eloqua and work with live Oracle Eloqua in Microsoft Power Query.
-
Getting Started with the CData Tableau Connector for Salesloft
-