CData Software - Knowledge Base
Recent Articles
-
Access Live Epicor Kinetic Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Epicor Kinetic from your Excel spreadsheets.
-
DataBind Charts to Redshift Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amazon Redshift 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.
-
Automated Continuous Neo4J Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Neo4J replication to Apache Cassandra.
-
Connect to Jodoo Data in RazorSQL
Connect to Jodoo from wizards and query Jodoo from the GUI in the RazorSQL database management tool.
-
Process & Analyze Monday.com Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Monday.com Data.
-
Import Real-Time Reckon Accounts Hosted Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Reckon Accounts Hosted in ColdFusion.
-
Replicate Zoom Data to Multiple Databases
Replicate Zoom to disparate databases with a point-and-click configuration.
-
Import Real-Time Paddle Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Paddle in ColdFusion.
-
Create Data Visualizations in Cognos BI with Dynamics 365 Business Central Data
Access Dynamics 365 Business Central as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Data Flows from Egnyte to SQL Server using SSIS
Easily back up Egnyte to SQL Server using the SSIS components for Egnyte.
-
Integrating Kiro CLI with Shippo Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Migrating data from ZeroBounce to Snowflake using CData SSIS Components.
Easily push ZeroBounce to Snowflake using the CData SSIS Tasks for ZeroBounce and Snowflake.
-
Perform Batch Operations with Workday Data in Apache NiFi
Connect to Workday and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Edit and Search External Cassandra Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Apache Cassandra to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Cassandra Data objects that you can access from apps and the dashboard.
-
Create Apps from Google Directory Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Directory Data and build apps from live Google Directory in Qlik Sense Cloud.
-
Viewing Zoho Creator Data in RAD Studio Data Explorer
How to view Zoho Creator in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Creator.
-
How to connect to Zoho CRM Data in DBVisualizer
Integrate Zoho CRM with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Oracle Financials Cloud Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle Financials Cloud from Informatica Cloud.
-
Import and Visualize ZohoInvoice Data in Power View
Create data visualizations based on ZohoInvoice in Excel.
-
How to integrate Metabase with IBM Informix Data
Use CData Connect AI to connect to live IBM Informix and create an interactive dashboard in Metabase from IBM Informix.
-
Connect to MailerLite Data in RazorSQL
Connect to MailerLite from wizards and query MailerLite from the GUI in the RazorSQL database management tool.
-
Use Agno to Talk to Your Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Zoho Inventory for you.
-
Build Automated Workflows with Live Adobe Commerce Data in Workato
Use CData Connect AI to connect to live Adobe Commerce and build automated workflows in Workato.
-
Access Google Ad Manager Data from MySQL in PHP
Connect to Google Ad Manager through the standard MySQL libraries in PHP.
-
Use the CData ODBC Driver for ZohoInvoice from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ZohoInvoice to connect to ZohoInvoice from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZohoInvoice in Excel.
-
Publish Act CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Act CRM.
-
Automated Continuous Exact Online Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Exact Online replication to Apache Cassandra.
-
Connect to Bright Data Data from PowerBuilder via ADO.NET
This article demonstrates how to access Bright Data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Manage Sybase Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sybase.
-
Integrate Cursor with Live Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho CRM from within the editor.
-
Integrate with live Zuora Data in Jitterbit
Use CData Connect AI to connect to and integrate live Zuora in Jitterbit.
-
Automated Continuous Typeform Replication to SQLite
Use CData Sync for automated, continuous, customizable Typeform replication to SQLite.
-
Build Semantic Layer Views for Float Data in APOS Live Data Gateway
Use the CData Connector for Float in APOS Live Data Gateway to build Semantic Layer Views for Float.
-
Use the CData Software JDBC Driver for Hacker News in MicroStrategy
Connect to Hacker News in MicroStrategy Developer using the CData Software JDBC Driver for Hacker News.
-
Access Live Bitbucket Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bitbucket into the statistical analysis tools available in SAS JMP. This article shows how to use Bitbucket in the Graph Builder and Query Builder.
-
Work with Live Zoom Data in Power Query
Use CData Connect AI to connect to Zoom and work with live Zoom in Microsoft Power Query.
-
Connect to Smartsheet Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Smartsheet Data and connect to Smartsheet in Akorbi Digital RunMyProcess.
-
Build Data Flows from SAP HANA to SQL Server using SSIS
Easily back up SAP HANA to SQL Server using the SSIS components for SAP HANA.
-
Connect to Zoho Inventory Data from a Connection Pool in Jetty
The Zoho Inventory JDBC Driver supports connection pooling: This article shows how to connect faster to Zoho Inventory from Web apps in Jetty.
-
Build Mailgun-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Mailgun.
-
Connect to Microsoft Exchange Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Microsoft Exchange Data and connect to Microsoft Exchange in Akorbi Digital RunMyProcess.
-
Automated Continuous Shippo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Shippo replication to PostgreSQL.
-
How to Create Power BI Visual Reports with Real-Time Sugar CRM Data
Use CData Power BI Connectors to visualize Sugar CRM in Power BI.
-
Use the CData Software JDBC Driver for Splunk in MicroStrategy Desktop
Connect to Splunk in MicroStrategy Desktop using the CData Software JDBC Driver for Splunk.
-
Load Delighted Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Delighted to a database.
-
Use Grok to Talk to Your Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Xero Accounting for you.
-
Create GraphQL-Connected Applications in Appsmith
Connect to GraphQL Data via CData Connect AI in Appsmith and create custom business applications with real-time access to GraphQL.
-
Connect to ZeroBounce Data in CloverDX (formerly CloverETL)
Transfer ZeroBounce using the visual workflow in the CloverDX data integration tool.
-
Consume Okta OData Feeds in PowerBuilder
This article demonstrates how to consume Okta as OData feeds from PowerBuilder using the API Server.
-
Use Dash to Build to Web Apps on Telegram Data
Create Python applications that use pandas and Dash to build Telegram-connected web apps.
-
Getting Started with the CData Power BI Connector for Avalara AvaTax
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Avalara AvaTax.
-
How to Work with Quaderno Data in AWS Glue Jobs Using JDBC
Connect to Quaderno from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Biml to Build SSIS Tasks to Replicate Slack Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Slack to SQL Server.
-
Query Vercel Data as a MySQL Database in Node.js
Execute MySQL queries against Vercel from Node.js.
-
Write a Simple Go Application to work with Samanage Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Samanage.
-
How to connect and process Bitly from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Bitly.
-
Add MailerLite Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MailerLite with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query Basecamp Data in MySQL Workbench
Execute MySQL queries against live Basecamp from MySQL Workbench.
-
View Reports on Real-Time Google Forms Data in Power BI Report Server
Use the CData ODBC Driver for Google Forms to visualize Google Forms in Power BI Desktop and then publish them to Power BI Report Server.
-
Seamlessly Bring SAP Business One Data into Retool Using CData Connect AI
Integrate SAP Business One data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize Outreach.io Data in TIBCO Spotfire through ADO.NET
Integrate Outreach.io into dashboards in TIBCO Spotfire.
-
Connect to ZeroBounce Data from PowerBuilder via JDBC
This article demonstrates how to access ZeroBounce from PowerBuilder using the ZeroBounce JDBC Driver.
-
Import Real-Time Cohere Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Cohere in ColdFusion.
-
Connect to JobNimbus Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for JobNimbus to connect to JobNimbus and execute queries in PowerBuilder.
-
How to Connect to Live Instagram Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Instagram for you.
-
Automated Continuous eBay Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable eBay replication to Amazon Redshift.
-
Visualize Lakebase Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Lakebase into TIBCO Spotfire.
-
Connect to Factorial Data from PowerBuilder via ADO.NET
This article demonstrates how to access Factorial from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build PingOne-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for PingOne to explore live PingOne Data in Claude Code to assist with building PingOne-powered applications.
-
How to Access FreeAgent Data Using Entity Framework
This article shows how to access FreeAgent using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Migrating data from SAP Ariba Procurement to Google BigQuery using CData SSIS Components.
Easily push SAP Ariba Procurement to Google BigQuery using the CData SSIS Tasks for SAP Ariba Procurement and Google BigQuery.
-
How to Connect the Power BI Service to Sage Cloud Accounting: Complete Guide
Connect to the CData Software Power BI Connector for Sage Cloud Accounting from PowerBI.com to provide real-time Sage Business Cloud Accounting across the organization.
-
Connect to Google Ad Manager Data in ACL Analytics
Connect to Google Ad Manager via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Ad Manager.
-
Connect LinkedIn Ads Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your LinkedIn Ads using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Query Live JSON Services in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live JSON directly from the development environment.
-
View Reports on Real-Time Facebook Ads Data in Power BI Report Server
Use the CData ODBC Driver for Facebook Ads to visualize Facebook Ads in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Chargebee Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Chargebee replication to Apache Cassandra.
-
How to create Visio diagrams from Cosmos DB Data
Automatically update Azure Cosmos DB with the changes you make to Visio master shapes.
-
Rebilly Reporting in OBIEE with the Rebilly JDBC Driver
Deploy the Rebilly JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Supabase Data in DBArtisan
Use wizards in DBArtisan to configure Supabase as a data source.
-
Feed Humanity Data into FineReport
How to set Humanity as a JDBC data source in FineReport.
-
Connect to Airtable Data 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 Airtable.
-
Design BIRT Reports on Freshteam Data
Provide current Freshteam to your embedded analytics.
-
How to Access Delighted Data Using Entity Framework
This article shows how to access Delighted using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create a Data Access Object for Freshservice Data using JDBI
A brief overview of creating a SQL Object API for Freshservice in JDBI.
-
Object-Relational Mapping (ORM) with ChargeOver Data 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 ChargeOver into a Java-based ORM framework, Hibernate.
-
Use the CData Software JDBC Driver for Access in MicroStrategy Desktop
Connect to Microsoft Access in MicroStrategy Desktop using the CData Software JDBC Driver for Access.
-
Use the CData Software JDBC Driver for Amazon Marketplace in MicroStrategy Desktop
Connect to Amazon Marketplace in MicroStrategy Desktop using the CData Software JDBC Driver for Amazon Marketplace.
-
Analyze Bannerbear Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bannerbear from Power Pivot. You will use the Table Import Wizard to load Bannerbear. You can visually build the import query or use any SQL supported by the driver.
-
Publish Reports with SAP Hybris C4C Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Hybris C4C.
-
Prepare, Blend, and Analyze ServiceNow Data in Alteryx Designer (Connect AI)
Build workflows to access live ServiceNow for self-service data analytics.
-
Access Stripe Data from MySQL in Amazon QuickSight
Connect to Stripe and build visualizations of Stripe using a MySQL Connection in Amazon QuickSight.
-
Work with BigCommerce Data in FoxPro
Load BigCommerce into a FoxPro database. This article includes full code and a walk-through of the process.
-
Bridge PagerDuty Connectivity with Apache NiFi
Access and process PagerDuty in Apache NiFi using the CData JDBC Driver.
-
Connect to ZohoPeople Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZohoPeople.
-
How to create an RPA flow for Highrise Data in UiPath Studio
Use the Highrise ODBC Driver to create workflows that access real-time Highrise CRM without any coding.
-
Build Acumatica-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Acumatica Data and create custom apps in Bubble.
-
Back Up Foursquare to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Foursquare data.
-
How to connect and process Front from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Front.
-
Replicate Jodoo Data from PowerShell
Write a quick PowerShell script to query Jodoo. Use connectivity to the live data to replicate Jodoo to SQL Server.