CData Software - Knowledge Base
Recent Articles
-
Integrate with live Mailjet Data in Jitterbit
Use CData Connect AI to connect to and integrate live Mailjet data in Jitterbit.
-
Create VWO-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to VWO Data from Klipfolio and build custom visualizations using live VWO data.
-
Automated Continuous QuickBooks Time Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Azure SQL Database.
-
Integrate Eventbrite Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Eventbrite data from Informatica Cloud.
-
Automated Continuous Spark Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Spark replication to AlloyDB.
-
Automate Perplexity Data Replication to Azure Data Lake
Use CData Sync to customize and automate Perplexity data replication to Azure Data Lake.
-
Trigger Facebook IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Facebook with standard wizards in Logic Apps.
-
Access Gong Data 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 Gong data.
-
Visualize Live Xero Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Xero data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to ShipStation Data in RazorSQL
Connect to ShipStation from wizards and query ShipStation data from the GUI in the RazorSQL database management tool.
-
Analyze Bannerbear Data in Cognos Analytics
Use CData Connect AI to connect to Bannerbear Data from Cognos Analytics and analyze live Bannerbear data.
-
Visualize Sage Cloud Accounting Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sage Cloud Accounting data.
-
Use Dash to Build to Web Apps on REST Data
Create Python applications that use pandas and Dash to build REST-connected web apps.
-
Visualize ActiveCampaign Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ActiveCampaign data.
-
Access Live Gong Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Gong data through MCP integration.
-
Integrate Stripe Data in the Pentaho Report Designer
Publish reports based on Stripe data in the Pentaho BI tool.
-
Getting Started with the CData Python Connector for PDFMonkey
Learn to install and license the CData Python Connector and configure a connection to live PDFMonkey data.
-
Feed ADP Data into FineReport
How to set ADP data as a JDBC data source in FineReport.
-
Deploy the ADO.NET Provider for Stripe on an SSRS Report Server
Connect to Stripe data 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.
-
Integrate Cline with Live Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Azure Data Catalog data from within your IDE.
-
Build Charts with Dynamics 365 Business Central Data in Clear Analytics
Create dynamic charts and perform analytics based on Dynamics 365 Business Central data in Clear Analytics.
-
Integrate with Avro Data in JReport Designer
Create charts and reports based on Avro data in JReport Designer.
-
Connect to Couchbase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Couchbase and the SQL Gateway to access Couchbase data from Google Apps Script.
-
Connect ConstantContact to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ConstantContact with IBM WebSphere for seamless data integration and connectivity.
-
How to connect and process Zoho CRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho CRM data.
-
Automated Continuous Tally Replication to Databricks
Use CData Sync for automated, continuous, customizable Tally replication to Databricks.
-
Excel Spreadsheet Automation on DocuSign Data with the QUERY Formula
Pull data from DocuSign, automate spreadsheets, and more with the QUERY formula.
-
How to Build an ETL App for Tally Data in Python with CData
Create ETL applications and real-time data pipelines for Tally data in Python with petl.
-
How to connect to Act CRM Data from IntelliJ
Integrate connectivity to Act CRM data with wizards in IntelliJ.
-
Connect to Parquet Data from a Connection Pool in JBoss
Integrate Parquet data into Java servlets: Use the Management Console in JBoss to install the Parquet JDBC Driver.
-
How to Access Azure Data Catalog Data Using Entity Framework
This article shows how to access Azure Data Catalog data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Devin with Live Omnisend Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Omnisend data.
-
Visualize SAP HANA XS Advanced Data in TIBCO Spotfire through ADO.NET
Integrate SAP HANA XS Advanced data into dashboards in TIBCO Spotfire.
-
Analyze Live Adobe Target Data in SAS Viya
Use CData Connect AI to connect to Adobe Target data from SAS Viya and deploy self-service analytics using live Adobe Target data.
-
Replicate Lakebase Data to Multiple Databases via the CData Sync CLI
Replicate Lakebase data to disparate databases with a single configuration.
-
Write a Simple Go Application to work with Testmonitor Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Testmonitor data.
-
How to Connect to & Open Anaplan Data in Microsoft Excel
This article uses the CData ODBC driver for Anaplan to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData ODBC Driver for ConvertKit from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ConvertKit to connect to ConvertKit data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ConvertKit data in Excel.
-
Connect to SendPulse Data from PowerBuilder via JDBC
This article demonstrates how to access SendPulse data from PowerBuilder using the SendPulse JDBC Driver.
-
Integrating LlamaIndex with ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ADP data in real time.
-
Integrating LlamaIndex with Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft Exchange data in real time.
-
Rapidly Develop ZarMoney-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by ZarMoney.
-
Visualize ZohoInvoice Data in Sisense
Create an ElastiCube in Sisense app with access to ZohoInvoice data.
-
Create Dashboards and Visualize Live Marketo Data in Geckoboard
Use CData Connect AI to connect to live Marketo data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Replicate Bullhorn CRM Data to Multiple Databases
Replicate Bullhorn CRM data to disparate databases with a point-and-click configuration.
-
Automated Continuous Zoho Projects Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoho Projects replication to PostgreSQL.
-
Getting Started with the CData Power BI Connector for Salesforce Data 360
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Salesforce Data 360.
-
Connect to SAP Netweaver Gateway 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 SAP Netweaver Gateway data.
-
Query, Visualize, and Share live ZohoMarketingHub Data in Redash
Use CData Connect AI to connect to live ZohoMarketingHub data in Redash for querying, visualizing, and sharing.
-
Connect to Zoho Books Data in DBeaver
Use the CData ODBC Driver to connect to Zoho Books data in DBeaver.
-
Back Up Office 365 data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Office 365. In this article, we will employ an SSIS workflow to populate a database with Office 365 data data.
-
Easily Integrate Twilio Data in Lazarus Pascal IDE
Learn how to easily integrate live Twilio data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Live Placid Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Placid data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to YouTube Analytics Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time YouTube Analytics data using standard SQL.
-
Replicate Mistral AI Data to Multiple Databases via the CData Sync CLI
Replicate Mistral AI data to disparate databases with a single configuration.
-
Edit and Search External Google Spanner Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Spanner data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Spanner Data objects that you can access from apps and the dashboard.
-
Import Real-Time Jira Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Jira data in ColdFusion.
-
How to Connect to Live Authorize.Net Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Authorize.Net data through natural language.
-
How to connect to Outreach.io Data with Squirrel SQL client
Connect to Outreach.io data and execute queries in the Squirrel SQL Client.
-
How to create an RPA flow for Google Spanner Data in UiPath Studio
Use the Google Spanner ODBC Driver to create workflows that access real-time Google Spanner data without any coding.
-
Automated Continuous Facebook Ads Replication to Databricks
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Databricks.
-
Connect to Cloudflare Data in Jaspersoft Studio
Execute SQL to remote Cloudflare data in Jaspersoft Studio.
-
Build Perplexity-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Perplexity Data from Zoho Analytics and import live Perplexity data.
-
Automated Continuous Airtable Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Airtable data replication to OneLake in Microsoft Fabric.
-
Integrating Claude Code CLI with Sage Intacct 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.
-
Build Agents in Relevance AI with Access to Live Amazon DynamoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Amazon DynamoDB data within intelligent agent workflows.
-
Use CData Connect AI to Access Epicor Kinetic Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Epicor Kinetic data in the Power Pivot business intelligence tool.
-
Model CapsuleCRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and CapsuleCRM, enabling the direct import of real-time CapsuleCRM data.
-
Connect to and Visualize Live Amazon Athena Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon Athena data.
-
Connect MYOB AccountRight to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MYOB AccountRight with IBM WebSphere for seamless data integration and connectivity.
-
Replicate HCL Domino Data in Heroku for Use in Salesforce Connect
Replicate HCL Domino data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData ODBC Driver for ZohoPeople in Microsoft Power Query
You can use the CData ZohoPeople ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ZohoPeople data into Microsoft Power Query.
-
Model, Search, and Visualize Live Office 365 Data in ThoughtSpot
Use CData Connect AI to connect to live Office 365 data for modeling, searching, and visualizing.
-
Publish Reports with Optimizely Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Optimizely data.
-
Connect to Tally Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Tally as an External Source in Dremio.
-
Link Discord with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Discord data in Filemaker Pro for Mac or Windows.
-
Integrate Theia IDE with Live LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live LinkedIn Ads data from within the development environment.
-
Build MVC Applications with Connectivity to Teradata Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Teradata from an ASP.NET MVC application.
-
Connect to Snapchat Ads Data from PowerBuilder via JDBC
This article demonstrates how to access Snapchat Ads data from PowerBuilder using the Snapchat Ads JDBC Driver.
-
Back Up ChartMogul data 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 ChartMogul data data.
-
Manage Teamwork Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Teamwork.
-
Connect to Shippo Data from PowerBuilder via JDBC
This article demonstrates how to access Shippo data from PowerBuilder using the Shippo JDBC Driver.
-
Automated Continuous ZohoPeople Replication to Databricks
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Databricks.
-
Analyze LinkedIn Ads Data in Cognos Analytics
Use CData Connect AI to connect to LinkedIn Ads Data from Cognos Analytics and analyze live LinkedIn Ads data.
-
Connect to Live Oracle SCM Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle SCM Data in CData Connect AI and connect to your Oracle SCM data from MicroStrategy.
-
Connecting Pipedream with Confluence Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Confluence data in real time.
-
Create Wistia Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Wistia from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Azure Synapse from Asprova with CData Software ODBC Driver for Azure Synapse
This article shows how to connect faster to Azure Synapse data from Asprova.
-
Connect to Zoom Data from PowerBuilder via JDBC
This article demonstrates how to access Zoom data from PowerBuilder using the Zoom JDBC Driver.
-
Operational Reporting on EmailOctopus Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote EmailOctopus data.
-
Automated Continuous Spotify Replication to Databricks
Use CData Sync for automated, continuous, customizable Spotify replication to Databricks.
-
Connect MySQL Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MySQL data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate Multiple Google Ads Accounts via the CData Sync CLI
Replicate multiple Google Ads accounts to one or many databases.
-
How to Connect to Live Adobe Experience Manager Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Adobe Experience Manager data for you.
-
Use Dash to Build to Web Apps on SpaceX Data
Create Python applications that use pandas and Dash to build SpaceX-connected web apps.
-
Build Apps with Live Sybase Data Using the Low-Code Development Platform of Mendix
Connect Sybase data with Mendix to build apps using the CData JDBC Driver for Sybase.
-
How to Connect the Power BI Service to DB2: Complete Guide
Connect to the CData Software Power BI Connector for DB2 from PowerBI.com to provide real-time DB2 data across the organization.
-
Use Dash to Build Web Apps on Microsoft Exchange Data via CData Connect AI
Build interactive Dash web apps on live Microsoft Exchange data using pandas and the CData Connect AI Python SDK.
-
How to Use a Microsoft Access Database to Update YouTube Analytics Data in Real Time
Update YouTube Analytics data by creating a linked table in Microsoft Access with the CData YouTube Analytics ODBC Driver.
-
Automate Gorgias Data Replication to Couchbase
Use CData Sync to Customize and automate Gorgias data replication to Couchbase.