CData Software - Knowledge Base
Recent Articles
-
Create Dashboards and Visualize Live IBM Informix Data in Geckoboard
Use CData Connect AI to connect to live IBM Informix data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Operational Reporting on Microsoft Ads Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Ads data.
-
Build Apps with Live Snowflake data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Snowflake data into the Adalo platform and build custom mobile and web applications with real-time Snowflake data.
-
Design BIRT Reports on Oracle Data
Provide current Oracle data to your embedded analytics.
-
Connect to Microsoft Entra ID Data in JRuby
Create a simple JRuby app with access to live Microsoft Entra ID data.
-
How to Connect FHIR Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live FHIR data in real time using natural language.
-
Integrate Trae with Live ADP Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ADP data from within the AI-powered IDE.
-
Access Live Wave Financial 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 Wave Financial data through MCP integration.
-
Integrate with Live Salesforce Marketing Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Salesforce Marketing from the MuleSoft Anypoint Platform to integrate live Salesforce Marketing data into custom reports and dashboards.
-
Automated Perplexity Data Replication to Teradata
Use CData Sync to Customize and automate Perplexity data replication to Teradata.
-
Create Datasets from Exact Online in Domo Workbench and Build Visualizations of Exact Online Data in Domo
Use the CData Software ODBC Driver for Exact Online to create datasets from Exact Online data in Domo Workbench and then build visualizations in the Domo service.
-
Use Dash to Build to Web Apps on PolarTeamPro Data
Create Python applications that use pandas and Dash to build PolarTeamPro-connected web apps.
-
Publish Reports with Spark Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Spark data.
-
Build a PostgreSQL Interface for Kintone Data using the CData JDBC Driver
Use the Remoting features of the Kintone JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code with Act CRM Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Act CRM data within assisted coding and automated development workflows.
-
Connecting Mastra with Paymo Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Paymo data, no replication required.
-
Automated Continuous Chargebee Replication to Snowflake
Use CData Sync for automated, continuous, customizable Chargebee replication to Snowflake.
-
Search External Guru Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Guru data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Guru Data objects that you can access from apps and the dashboard.
-
Connect to Raisers Edge NXT Data in CloverDX (formerly CloverETL)
Transfer Raisers Edge NXT data using the visual workflow in the CloverDX data integration tool.
-
Connect to TaxJar Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to TaxJar.
-
Integrating LangChain with Aweber Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Aweber data within automated workflows.
-
How to Visualize PDFMonkey Data in Python with pandas
Use pandas and other modules to analyze and visualize live PDFMonkey data in Python.
-
How to connect Amazon QuickSight to WooCommerce Data
Create a connection to WooCommerce data in CData Connect AI and insert WooCommerce data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Blackbaud FE NXT-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Blackbaud FE NXT data without replication.
-
How to load LaunchDarkly data into Elasticsearch via Logstash
Introducing a simple method to load LaunchDarkly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Instagram Replication to Databricks
Use CData Sync for automated, continuous, customizable Instagram replication to Databricks.
-
Create Informatica Mappings From/To an ODBC Data Source for VWO
Create an ODBC connection to VWO in Informatica and browse and transfer VWO data.
-
How to connect and process Redshift data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Redshift data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Netweaver Gateway
Provide connectivity to SAP Netweaver Gateway data through an SAP BusinessObjects universe.
-
View Reports on Real-Time Avalara AvaTax Data in Power BI Report Server
Use the CData ODBC Driver for Avalara AvaTax to visualize Avalara AvaTax data in Power BI Desktop and then publish them to Power BI Report Server.
-
Design BIRT Reports on WooCommerce Data
Provide current WooCommerce data to your embedded analytics.
-
Use Microsoft Copilot Studio to talk to your SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP SuccessFactors LMS data for you.
-
Create Data Visualizations Based On Certinia Data in Mode
Use CData Connect AI to connect to Certinia Data from Mode and build visualizations using live Certinia data.
-
How to import Couchbase Data into Apache Solr
Use the CData Software JDBC Driver for Couchbase in Data Import Handler and create an automated import of Couchbase data to Apache Solr Enterprise Search platform.
-
Natively Connect to Printful Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Printful data. Leverage the native support for ODBC in PHP.
-
How to publish and share Teradata Data dashboards with Tableau Server
The CData ODBC driver for Teradata enables you integrate Teradata data into Tableau dashboards.
-
Manage ConvertKit Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ConvertKit.
-
Build Clio-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Clio data and build web apps with connectivity to live Clio data.
-
Access Live Pinterest Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Pinterest data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Automated Workflows with Live Google Contacts Data in Workato
Use CData Connect AI to connect to live Google Contacts data and build automated workflows in Workato.
-
Integrating Sendwithus Data in Talend Cloud Data Management Platform
Connect Sendwithus Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Query Sugar CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Sugar CRM data from Node.js.
-
How to connect PolyBase to Greenplum
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Greenplum data.
-
DataBind Controls to Azure Synapse Data in C++Builder
DataBind to Azure Synapse data in C++Builder with standard components and controls.
-
Search External Raisers Edge NXT Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Raisers Edge NXT data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Raisers Edge NXT Data objects that you can access from apps and the dashboard.
-
How to connect to SharePoint Data from IntelliJ
Integrate connectivity to SharePoint data with wizards in IntelliJ.
-
Automated Continuous BigCommerce Replication to MongoDB
Use CData Sync for automated, continuous, customizable BigCommerce replication to MongoDB.
-
Automated Continuous Lakebase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Lakebase replication to PostgreSQL.
-
Moving Data from Google Sheets to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Sheets data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect Teradata Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Teradata data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Semantic Layer Views for Reckon Accounts Hosted Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Reckon Accounts Hosted data.
-
Connect to ZohoSubscriptions Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZohoSubscriptions data in the Denodo Virtual DataPort Administrator.
-
Migrating data from Snowflake to Google BigQuery using CData SSIS Components.
Easily push Snowflake data to Google BigQuery using the CData SSIS Tasks for Snowflake and Google BigQuery.
-
Integrating Kiro with MailerLite 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.
-
Integrate ZendeskSell Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZendeskSell data from Informatica Cloud.
-
How to connect to SAP Concur Data with Squirrel SQL client
Connect to SAP Concur data and execute queries in the Squirrel SQL Client.
-
Create Apps from Freshservice Data in Qlik Sense Cloud
Use CData Connect AI to connect to Freshservice Data and build apps from live Freshservice data in Qlik Sense Cloud.
-
Automated Continuous Pushbullet Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Pushbullet replication to Azure SQL Database.
-
Connect to BambooHR Data from Crystal Reports
Use CData Connect AI to connect to and report on live BambooHR data from Crystal Reports.
-
Access Zoho Recruit 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 Zoho Recruit data.
-
Access Live XML Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live XML data from your Excel spreadsheets.
-
Getting Started with the CData SSIS Components for Azure Analysis Services
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure Analysis Services.
-
Work with Live Facebook Data in Power Query
Use CData Connect AI to connect to Facebook data and work with live Facebook data in Microsoft Power Query.
-
How to Connect to & Open Webex Data in Microsoft Excel
This article uses the CData ODBC driver for Webex to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Load Toggl Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Toggl data to a database.
-
Build a PostgreSQL Interface for Discourse Data using the CData JDBC Driver
Use the Remoting features of the Discourse JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live SuiteCRM Data 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 SuiteCRM data for you.
-
Connect to VWO Data from a Connection Pool in Jetty
The VWO JDBC Driver supports connection pooling: This article shows how to connect faster to VWO data from Web apps in Jetty.
-
Connect LinkedIn to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect LinkedIn with IBM WebSphere for seamless data integration and connectivity.
-
Query MessageBird Data in ColdFusion
Write standard ColdFusion data access code to connect to MessageBird data.
-
Use JayDeBeApi to access Flowlu Data in Python
Use standard Python scripting and the development environment of your choice to access live Flowlu data.
-
ETL Zoho CRM in Oracle Data Integrator
This article shows how to transfer Zoho CRM data into a data warehouse using Oracle Data Integrator.
-
Integrate Live Twitter Ads Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Twitter Ads data and integrate live Twitter Ads data into apps built in Microsoft Power Apps.
-
BambooHR Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on BambooHR facts in real time.
-
Create Typeform-Connected Nintex Workflows
Use CData Connect AI to connect to Typeform Data from Nintex Workflow Cloud and build custom workflows using live Typeform data.
-
Analyze Google Campaign Manager 360 Data in Cognos Analytics
Use CData Connect AI to connect to Google Campaign Manager 360 Data from Cognos Analytics and analyze live Google Campaign Manager 360 data.
-
Create Sage 200-Connected Applications in Appsmith
Connect to Sage 200 Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sage 200 data.
-
Automated Continuous Confluence Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Confluence replication to Google Cloud SQL.
-
How to work with MessageBird Data in Apache Spark using SQL
Access and process MessageBird Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating LangChain with Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Smartsheet data within automated workflows.
-
Analyze SFTP Data in Cognos Analytics
Use CData Connect AI to connect to SFTP Data from Cognos Analytics and analyze live SFTP data.
-
Connect to MailChimp Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MailChimp to connect to MailChimp data and execute queries in PowerBuilder.
-
Integrating Eventbrite Data in Talend Cloud Data Management Platform
Connect Eventbrite Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use Agno to Talk to Your ZohoPeople 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 ZohoPeople data for you.
-
How to Query Live Humanity Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Humanity data data in natural language using Python.
-
Use Claude to Talk to Your MailerLite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your MailerLite data for you.
-
Connect to VWO Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for VWO to connect to VWO data and execute queries in PowerBuilder.
-
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 data.
-
Automated Continuous Salesloft Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Salesloft replication to delimited files (CSV/TSV).
-
Getting Started with the CData Power BI Connector for Testmonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Teamgate-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Teamgate data and build web apps with connectivity to live Teamgate data.
-
DataBind Charts to Insightly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Insightly data 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.
-
Replicate Google Spanner Data in Heroku for Use in Salesforce Connect
Replicate Google Spanner data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Bridge Tavily Connectivity with Apache NiFi
Access and process Tavily data in Apache NiFi using the CData JDBC Driver.
-
Query, Visualize, and Share live Box Data in Redash
Use CData Connect AI to connect to live Box data in Redash for querying, visualizing, and sharing.
-
How to create an RPA flow for SAP Concur Data in UiPath Studio
Use the SAP Concur ODBC Driver to create workflows that access real-time SAP Concur data without any coding.
-
Model, Search, and Visualize Live Azure Table Data in ThoughtSpot
Use CData Connect AI to connect to live Azure Table data for modeling, searching, and visualizing.
-
How to Connect to Live Azure Analysis Services 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 Azure Analysis Services data without replication.
-
How to Connect to Live ConstantContact 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 ConstantContact data for you.
-
Build a PostgreSQL Interface for PagerDuty Data using the CData JDBC Driver
Use the Remoting features of the PagerDuty JDBC Driver to create a PostgreSQL entry-point for data access.