CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Salesforce CRM Analytics Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to delimited files (CSV/TSV).
-
Automated Continuous Elasticsearch Replication to Databricks
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Databricks.
-
Automated Continuous Sage 200 Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sage 200 replication to PostgreSQL.
-
Explore Geographical Relationships in Paymo Data with Power Map
Create data visualizations with Paymo data in Power Map.
-
Connecting GenSpark with Zoho Creator Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Zoho Creator data without any replication or custom integration required.
-
Manage Avro Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Avro.
-
Integrate with live AgileCRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live AgileCRM data in Jitterbit.
-
Integrating Claude Code with QuickBooks Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on QuickBooks data within assisted coding and automated development workflows.
-
Model, Search, and Visualize Live Salesforce Pardot Data in ThoughtSpot
Use CData Connect AI to connect to live Salesforce Pardot data for modeling, searching, and visualizing.
-
Connect Jodoo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Jodoo data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to ConstantContact Data in DBArtisan
Use wizards in DBArtisan to configure ConstantContact data as a data source.
-
Create Informatica Mappings From/To an ODBC Data Source for ZohoMarketingHub
Create an ODBC connection to ZohoMarketingHub in Informatica and browse and transfer ZohoMarketingHub data.
-
Access Live MailerLite Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MailerLite data from your Google Sheets.
-
Automated Continuous IBM Informix Replication to Databricks
Use CData Sync for automated, continuous, customizable IBM Informix replication to Databricks.
-
How to Visualize SparkPost Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SparkPost data in Python.
-
Integrate Trae with Live Sugar CRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Sugar CRM data from within the AI-powered IDE.
-
Analyze JSON Services in Cognos Analytics
Use CData Connect AI to connect to JSON Services from Cognos Analytics and analyze live JSON services.
-
Automated Continuous NASA Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable NASA data replication to OneLake in Microsoft Fabric.
-
Use the CData ODBC Driver for Intercom from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Intercom to connect to Intercom data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Intercom data in Excel.
-
Integrate AlloyDB Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to AlloyDB data and integrate live AlloyDB data into your Power Automate tasks.
-
Connect to and Visualize Live Toggl Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Toggl data.
-
Build Pipelines with Live Azure Synapse Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Azure Synapse from Google Cloud Data Fusion, enabling the integration of live Azure Synapse data into the building and management of effective data pipelines.
-
Automated Continuous Avalara AvaTax Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to PostgreSQL.
-
How to create an RPA flow for Templated Data in UiPath Studio
Use the Templated ODBC Driver to create workflows that access real-time Templated data without any coding.
-
Create Power BI Reports on Real-Time DB2 Data
Use the CData ODBC Driver for DB2 to visualize DB2 data in Power BI Desktop.
-
Connect to MySQL through SSH Using the Built-In Client
A detailed overview of the SQL Gateway, its function, and its features.
-
Import Reckon Accounts Hosted Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Reckon Accounts Hosted Data and provide access to live Reckon Accounts Hosted data for custom reports in the Power BI Service.
-
Integrating Google Contacts Data in Talend Cloud Data Management Platform
Connect Google Contacts Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google Contacts.
-
Visualize BigCommerce Data in Sisense
Create an ElastiCube in Sisense app with access to BigCommerce data.
-
Create Data Visualizations in Cognos BI with Square Data
Access Square data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Cursor with Live Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Trello data from within the editor.
-
Automated Continuous Vault CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Vault CRM replication to Amazon Redshift.
-
Establish a Live Connection with Zoho Books Data using Tableau Bridge
The CData ODBC Driver for Zoho Books enables you to integrate live Zoho Books data into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Lakebase Data in Looker
Use CData Connect AI to connect to Lakebase Data from Looker and build custom apps using live Lakebase data.
-
Connect to Google Sheets Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Sheets Data and connect to Google Sheets data in Akorbi Digital RunMyProcess.
-
Import and Visualize Shopify Data in Power View
Create data visualizations based on Shopify data in Excel.
-
Integrating Antigravity CLI with CloudConvert data via CData CLI
Connect CloudConvert data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Tableau Connector for SAS Data Sets
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAS Data Sets.
-
Automate Browserless Data Replication to Azure Synapse
Use CData Sync to customize and automate Browserless data replication to Azure Synapse.
-
How to work with SendGrid Data in Apache Spark using SQL
Access and process SendGrid Data in Apache Spark using the CData Software JDBC Driver.
-
Create Raisers Edge NXT-Connected Nintex Workflows
Use CData Connect AI to connect to Raisers Edge NXT Data from Nintex Workflow Cloud and build custom workflows using live Raisers Edge NXT data.
-
Create Reports with Monday.com Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Monday.com data.
-
Integrating Dataiku with VWO Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live VWO data.
-
Automated Continuous Azure DevOps Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Amazon S3.
-
Establish a Live Connection with xBase Data using Tableau Bridge
The CData ODBC Driver for xBase enables you to integrate live xBase data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Freshteam Data in DBArtisan
Use wizards in DBArtisan to configure Freshteam data as a data source.
-
Analyze Optimizely Data in Looker
Use CData Connect AI to connect to Optimizely Data from Looker and build custom apps using live Optimizely data.
-
Create Power BI Reports on Real-Time Guru Data
Use the CData ODBC Driver for Guru to visualize Guru data in Power BI Desktop.
-
Connect to BigCommerce Data as an External Source in Dremio
Use the CData JDBC Driver to connect to BigCommerce as an External Source in Dremio.
-
Automated Continuous Nuclia Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Nuclia replication to Amazon Redshift.
-
Building Dynamic Web Pages with JSON Services Using AngularJS
Create single-page applications with live connectivity to JSON using the CData API Server.
-
Create Dashboards and Visualize Live Cloudflare Data in Geckoboard
Use CData Connect AI to connect to live Cloudflare data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Dashboards with SQL Analysis Services Data in Dundas BI
Create dynamic dashboards and perform analytics based on SQL Analysis Services data in Dundas BI.
-
Automated Continuous SAP HANA XS Advanced Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to SQLite.
-
Access Live Wave Financial Data in Excel 365 Online (Excel for the web)
Connect to Wave Financial data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Sage Intacct from Asprova with CData Software ODBC Driver for Sage Intacct
This article shows how to connect faster to Sage Intacct data from Asprova.
-
Analyze WordPress Data in Cognos Analytics
Use CData Connect AI to connect to WordPress Data from Cognos Analytics and analyze live WordPress data.
-
Create a Data Access Object for ElevenLabs Data using JDBI
A brief overview of creating a SQL Object API for ElevenLabs data in JDBI.
-
Build AI Agents with Cloudant Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Cloudant data through CData Connect AI.
-
Connect to Zoho Inventory Data in Google Apps Script via Connect AI
Use CData Connect AI to access Zoho Inventory data in Google Apps Script.
-
DataBind Controls to Shopify Data in C++Builder
DataBind to Shopify data in C++Builder with standard components and controls.
-
Establish a Live Connection with Printify Data using Tableau Bridge
The CData ODBC Driver for Printify enables you to integrate live Printify data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Live CockroachDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live CockroachDB data to Blue Prism using the CData ODBC Driver for CockroachDB to create automated workflows for repetitive business tasks.
-
Migrating data from Wrike to Databricks using CData SSIS Components.
Easily push Wrike data to Databricks using the CData SSIS Tasks for Wrike and Databricks.
-
Automated Continuous Wistia Replication to Oracle
Use CData Sync for automated, continuous, customizable Wistia replication to Oracle.
-
Getting Started with the CData ADO.NET Provider for Acumatica
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Acumatica.
-
Natively Connect to Tally Data in PHP
The CData ODBC driver for Tally enables you to create PHP applications with connectivity to Tally data. Leverage the native support for ODBC in PHP.
-
Create Informatica Mappings From/To a JDBC Data Source for FormSite
Create FormSite data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Work with CampaignMonitor Data in ETL Validator JDBC
Connect to CampaignMonitor from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Live Kintone Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Kintone data.
-
Process & Analyze Wistia Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Wistia Data.
-
Build SingleStore-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SingleStore data and build web apps with connectivity to live SingleStore data.
-
Integrate Spotify with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Spotify with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Spotify data.
-
How to create Visio diagrams from GitHub Data
Automatically update GitHub data with the changes you make to Visio master shapes.
-
Use Manus AI to Talk to Your DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on DocuSign data.
-
Integrate Cline with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Adobe Commerce data from within your IDE.
-
How to Connect to Live DB2 Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live DB2 data without replication.
-
Connect to Instagram Data from PowerBuilder via JDBC
This article demonstrates how to access Instagram data from PowerBuilder using the Instagram JDBC Driver.
-
Connect to Deel Data in DBeaver
Use the CData ODBC Driver to connect to Deel data in DBeaver.
-
Publish Google Ads-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Ads data.
-
How to Connect to Live eBay Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live eBay data securely in real time.
-
Connect to Omnisend Data from HeidiSQL
Use CData Connect AI to connect to and query live Omnisend data from HeidiSQL.
-
How to connect to Marketo Data with Squirrel SQL client
Connect to Marketo data and execute queries in the Squirrel SQL Client.
-
Operational Reporting on MariaDB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MariaDB data.
-
Automated Continuous Onfleet Replication to Oracle
Use CData Sync for automated, continuous, customizable Onfleet replication to Oracle.
-
Analyze LaunchDarkly Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze LaunchDarkly data with the CData JDBC Driver for LaunchDarkly.
-
Connect to NetSuite Data from HeidiSQL
Use CData Connect AI to connect to and query live NetSuite data from HeidiSQL.
-
How to work with Mixpanel Data in Apache Spark using SQL
Access and process Mixpanel Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData ODBC Driver for Onfleet
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Onfleet.
-
Connect to Act CRM from Asprova with CData Software ODBC Driver for Act CRM
This article shows how to connect faster to Act CRM data from Asprova.
-
Access Live Google Directory Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Directory data from your Google Sheets.
-
How to Query Live Avalara AvaTax Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Avalara AvaTax data data in natural language using Python.
-
Integrate with live Freshdesk Data in Jitterbit
Use CData Connect AI to connect to and integrate live Freshdesk data in Jitterbit.
-
Connect to Tally Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Tally data.
-
A PostgreSQL Interface for Notion Data using the CData ODBC Driver
Use the SQL Gateway and Notion ODBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze VWO Data in Alteryx Designer (Connect AI)
Build workflows to access live VWO data for self-service data analytics.
-
Use Grok to Talk to Your MailChimp 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 MailChimp data for you.
-
Access CockroachDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access CockroachDB data from your Oracle system.
-
Automated Egnyte Data Replication to Teradata
Use CData Sync to Customize and automate Egnyte data replication to Teradata.
-
Process & Analyze Eventbrite Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Eventbrite Data.