CData Software - Knowledge Base
Recent Articles
-
Automated Salesloft Replication to Teradata
Use CData Sync to Customize and automate Salesloft replication to Teradata.
-
Model Confluence Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Confluence, enabling the direct import of real-time Atlassian Confluence.
-
How to Connect to & Open SAP Business One in Microsoft Excel
This article uses the CData ODBC driver for SAP Business One to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Operational Reporting on Pipedrive from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pipedrive.
-
Work with Live Tableau CRM Analytics in Power Query
Use CData Connect AI to connect to Tableau CRM Analytics and work with live Tableau CRM Analytics in Microsoft Power Query.
-
DataBind Drift to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Drift with the DevExpress Windows Forms and Web controls to provide Drift to a chart.
-
Connect to SAP Ariba Procurement from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Ariba Procurement to connect to SAP Ariba Procurement from Web applications running on WebLogic.
-
How to connect to XML from IntelliJ
Integrate connectivity to XML Files with wizards in IntelliJ.
-
Provide OData Services of FTP from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for FTP Servers by developing a WCF Service Application.
-
How to connect to WooCommerce from IntelliJ
Integrate connectivity to WooCommerce with wizards in IntelliJ.
-
Connect to Acumatica in Google Apps Script via Connect AI
Use CData Connect AI to access Acumatica ERP in Google Apps Script.
-
Use CData Connect AI to Access Microsoft Dataverse in Microsoft Power Pivot
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) in the Power Pivot business intelligence tool.
-
Connect to Snowflake as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Snowflake.
-
How to create CouchDB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Apache CouchDB in MySQL .
-
Automated Continuous SAP Fieldglass Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Google BigQuery.
-
Automated Continuous DocuSign Replication to SQL Server
Use CData Sync for automated, continuous, customizable DocuSign replication to SQL Server.
-
Integrate Azure Active Directory in Pentaho Data Integration
Build ETL pipelines based on Azure Active Directory in the Pentaho Data Integration tool.
-
How to Query Tally in MySQL Workbench
Execute MySQL queries against live Tally ERP from MySQL Workbench.
-
Build Oracle HCM Cloud-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle HCM Cloud.
-
Connect to TigerGraph in NetBeans
Connect to TigerGraph in NetBeans with the data source configuration wizard.
-
Automated Continuous Clio Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Clio replication to Amazon Redshift.
-
Automated Continuous Twitter Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Twitter replication to Apache Kafka.
-
Automated Continuous Tableau CRM Analytics Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to Microsoft Access.
-
Create Power BI Reports on Real-Time Jira Assets
Use the CData ODBC Driver for Jira Assets to visualize Jira Assets in Power BI Desktop.
-
Connect to Hive from a Connection Pool in JBoss
Integrate Apache Hive into Java servlets: Use the Management Console in JBoss to install the Hive JDBC Driver.
-
How to connect SharePoint with ClickUp through external lists
Provide ClickUp to SharePoint users as an external list.
-
Integrate with Live Asana in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Asana from the MuleSoft Anypoint Platform to integrate live Asana into custom reports and dashboards.
-
Access Asana from MySQL in PHP
Connect to Asana through the standard MySQL libraries in PHP.
-
Automated Continuous Databricks Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Databricks replication to AlloyDB.
-
Visualize WooCommerce in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load WooCommerce into TIBCO Spotfire.
-
Migrating data from Sage 300 to Snowflake using CData SSIS Components.
Easily push Sage 300 to Snowflake using the CData SSIS Tasks for Sage 300 and Snowflake.
-
Deploy the ADO.NET Provider for Email on an SSRS Report Server
Connect to Email from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automated Continuous Shopify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Shopify replication to SingleStore.
-
Connect to Zoho Projects from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho Projects using standard SQL.
-
Build Automated Google Calendar-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Calendar and build automated workflows in Zapier.
-
How to integrate Azure Data Lake Storage with Apache Airflow
Access and process Azure Data Lake Storage in Apache Airflow using the CData JDBC Driver.
-
How to create Zoho Creator federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Creator in MySQL .
-
Create PingOne Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to SAP Concur from Asprova with CData Software ODBC Driver for SAP Concur
This article shows how to connect faster to SAP Concur data from Asprova.
-
Connect to Elasticsearch in DBArtisan
Use wizards in DBArtisan to configure Elasticsearch as a data source.
-
Write a Simple Go Application to work with Zoom on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoom.
-
Automated Continuous Oracle Eloqua Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to OneLake in Microsoft Fabric.
-
Write a Simple Go Application to work with Oracle Service Cloud on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle Service Cloud.
-
Connect to Azure Data Lake Storage from Crystal Reports
Use CData Connect AI to connect to and report on live Azure Data Lake Storage from Crystal Reports.
-
Connect ActiveCampaign to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ActiveCampaign using the CData Python MCP Server.
-
How to Work with Azure Data Catalog in AWS Glue Jobs Using JDBC
Connect to Azure Data Catalog from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Sage 50 UK Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sage 50 UK replication to PostgreSQL.
-
Integrate Twilio in the Pentaho Report Designer
Publish reports based on Twilio in the Pentaho BI tool.
-
Getting Started with the CData JDBC Driver for Microsoft Planner
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft Planner.
-
How to Import Data from SQL Analysis Services into Google Sheets
Import SQL Analysis Services into a Google spreadsheet that is automatically refreshed.
-
Integrate CSV with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate CSV with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to CSV/TSV Files.
-
SQL Gateway: Superior SQL Linked Server Integration through SQL TDS
Using a TDS remoting service is superior to the OLE DB Provider when working with ODBC data in SQL Server.
-
PowerShell Scripting to Replicate Oracle Service Cloud to MySQL
Write a simple PowerShell script to replicate Oracle Service Cloud to a MySQL database.
-
Access Raisers Edge NXT 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 Raisers Edge NXT.
-
Create Reports with SuiteCRM in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SuiteCRM.
-
Connect to Google Search Results from AWS Glue
Use CData Connect AI to gain access to live Google Search from your AWS Glue jobs.
-
Integrate ServiceNow in Pentaho Data Integration
Build ETL pipelines based on ServiceNow in the Pentaho Data Integration tool.
-
How to Query Live Microsoft OneDrive in Claude Desktop
Connect to and query live Microsoft OneDrive in Claude Desktop using the CData MCP Server.
-
Migrating data from Facebook to Databricks using CData SSIS Components.
Easily push Facebook to Databricks using the CData SSIS Tasks for Facebook and Databricks.
-
Using the CData Software ODBC Driver for Splunk in PyCharm
Connect to Splunk as an ODBC data source in PyCharm using the CData Software ODBC Driver for Splunk.
-
Use the CData Software ODBC Driver for Wave Financial in MicroStrategy
Connect to Wave Financial in MicroStrategy Developer using the CData Software ODBC Driver for Wave Financial.
-
Excel Spreadsheet Automation on Kintone with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect to Stripe as an External Source in Dremio
Use the CData JDBC Driver to connect to Stripe as an External Source in Dremio.
-
Connect to Aha in SpagoBI
Create reports featuring live Aha! in SpagoBI Studio. Host Aha reports on SpagoBI Server.
-
How to Connect to Live Paylocity Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Paylocity securely in real time.
-
Integrate with live Tableau CRM Analytics in Jitterbit
Use CData Connect AI to connect to and integrate live Tableau CRM Analytics in Jitterbit.
-
ETL SharePoint in Oracle Data Integrator
This article shows how to transfer Microsoft SharePoint into a data warehouse using Oracle Data Integrator.
-
Connect to Excel in Aqua Data Studio
Access Microsoft Excel from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Bind Live Smartsheet Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Smartsheet data
-
Query Calendly from Node.js
Use the OData endpoint of the CData API Server to connect to your Calendly and perform CRUD operations on Calendly from Node.js.
-
Use the CData Software JDBC Driver for Klaviyo in MicroStrategy Desktop
Connect to Klaviyo in MicroStrategy Desktop using the CData Software JDBC Driver for Klaviyo.
-
Use the CData Software JDBC Driver for Zoho Inventory in MicroStrategy Desktop
Connect to Zoho Inventory in MicroStrategy Desktop using the CData Software JDBC Driver for Zoho Inventory.
-
Use the CData Software ODBC Driver for Sybase IQ in MicroStrategy Web
Connect to Sybase IQ in MicroStrategy Web using the CData Software ODBC Driver for Sybase IQ.
-
Create Vault CRM-Connected Applications in Appsmith
Connect to Vault CRM via CData Connect AI in Appsmith and create custom business applications with real-time access to Veeva Vault & Vault CRM.
-
Visualize Adobe Commerce in Sisense
Create an ElastiCube in Sisense app with access to Adobe Commerce.
-
Build AI Agents with Square Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Work with Azure Table in FoxPro
Load Azure Table Storage into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData SSIS Components for JSON
Complete guide to installing, licensing, and connecting with the CData SSIS Components for JSON.
-
Automated Continuous SAP ByDesign Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to IBM DB2.
-
Integrate Outreach.io in Pentaho Data Integration
Build ETL pipelines based on Outreach.io in the Pentaho Data Integration tool.
-
How to use SQLAlchemy ORM to access Sugar CRM in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sugar CRM.
-
Access Live Marketo in AWS Lambda (with IntelliJ IDEA)
Connect to live Marketo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Freshdesk in DBArtisan
Use wizards in DBArtisan to configure Freshdesk as a data source.
-
Connect to Real-Time CockroachDB Data in Power Apps Using Dataflows to Build Custom Applications
-