CData Software - Knowledge Base
Recent Articles
-
Connecting Agentforce with Microsoft Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Microsoft Ads for you.
-
Integrate Keap Data in Pentaho Data Integration
Build ETL pipelines based on Keap in the Pentaho Data Integration tool.
-
Getting Started with the CData Excel Add-In for SurveyMonkey
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SurveyMonkey.
-
Access Toggl Data from MySQL in Amazon QuickSight
Connect to Toggl and build visualizations of Toggl using a MySQL Connection in Amazon QuickSight.
-
Visualize Klipfolio Data in TIBCO Spotfire through ADO.NET
Integrate Klipfolio into dashboards in TIBCO Spotfire.
-
Use the CData SSIS Components to Insert New or Update Existing Quickbase Records from SQL Server
Easily push SQL Server data to Quickbase using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Quickbase or update existing records with data from a SQL Server database.
-
Manage Drift Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Drift.
-
Feed OpenWeatherMap Data into FineReport
How to set OpenWeatherMap as a JDBC data source in FineReport.
-
Connect to and Query SingleStore Data in QlikView over ODBC
Create data visualizations with SingleStore in QlikView.
-
Import Real-Time Greenhouse Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Greenhouse in ColdFusion.
-
Connect to Twitter Ads Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import Real-Time Bright Data Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bright Data in ColdFusion.
-
Automate Testmonitor Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Testmonitor from PowerShell? This article demonstrates how to utilize the Testmonitor Cmdlets for tasks like connecting to Testmonitor, automating operations, downloading data, and more.
-
Analyze Live MYOB AccountRight Data in SAS Viya
Use CData Connect AI to connect to MYOB AccountRight from SAS Viya and deploy self-service analytics using live MYOB AccountRight.
-
How to Connect Flowise AI Agents to Live SharePoint Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Microsoft SharePoint without replication.
-
Query Microsoft Ads Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Ads from Node.js.
-
Automate Drip Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Drip from PowerShell? This article demonstrates how to utilize the Drip Cmdlets for tasks like connecting to Drip, automating operations, downloading data, and more.
-
Viewing NASA Data in RAD Studio Data Explorer
How to view NASA in RAD Studio Data Explorer using the CData ODBC Driver for NASA.
-
Integrating Claude Code with Amazon DynamoDB Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Amazon DynamoDB within assisted coding and automated development workflows.
-
Prepare, Blend, and Analyze Azure Analysis Services Data in Alteryx Designer (Connect AI)
Build workflows to access live Azure Analysis Services for self-service data analytics.
-
Connect to Amazon DynamoDB Data from Crystal Reports
Use CData Connect AI to connect to and report on live Amazon DynamoDB from Crystal Reports.
-
Connect to DocuSign Data as an External Source in Dremio
Use the CData JDBC Driver to connect to DocuSign as an External Source in Dremio.
-
Getting Started with the CData Python Connector for Coinbase
Learn to install and license the CData Python Connector
-
Connect to Avalara AvaTax Data in DBArtisan
Use wizards in DBArtisan to configure Avalara AvaTax as a data source.
-
Use the CData Software ODBC Driver for MySQL in MicroStrategy Desktop
Connect to MySQL in MicroStrategy Desktop using the CData Software ODBC Driver for MySQL.
-
Connect to LinkedIn Data in Jaspersoft Studio
Execute SQL to remote LinkedIn in Jaspersoft Studio.
-
Explore Geographical Relationships in Google Search Results with Power Map
Create data visualizations with Google Search in Power Map.
-
Automated Continuous Tanda Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Tanda replication to Azure SQL Database.
-
Getting Started with the CData ADO.NET Provider for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Facebook Ads.
-
Use the CData Software ODBC Driver for RSS in MicroStrategy Web
Connect to RSS Feeds in MicroStrategy Web using the CData Software ODBC Driver for RSS.
-
Model SAS xpt Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAS xpt, enabling the direct import of real-time SAS XPORT.
-
How to connect Amazon QuickSight to Snapchat Ads Data
Create a connection to Snapchat Ads in CData Connect AI and insert Snapchat Ads into Amazon QuickSight SPICE to build interactive dashboards.
-
Automate ChartMogul Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ChartMogul from PowerShell? This article demonstrates how to utilize the ChartMogul Cmdlets for tasks like connecting to ChartMogul, automating operations, downloading data, and more.
-
Visualize PabblySubscriptions Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PabblySubscriptions.
-
Automated Continuous Blackbaud FE NXT Replication to SQLite
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to SQLite.
-
Migrating data from Vercel to Google BigQuery using CData SSIS Components.
Easily push Vercel to Google BigQuery using the CData SSIS Tasks for Vercel and Google BigQuery.
-
Migrating data from Odoo to Snowflake using CData SSIS Components.
Easily push Odoo ERP to Snowflake using the CData SSIS Tasks for Odoo and Snowflake.
-
Automated Continuous Delighted Replication to MongoDB
Use CData Sync for automated, continuous, customizable Delighted replication to MongoDB.
-
Use the CData SSIS Components to Insert New or Update Existing Salesforce CRM Analytics Records from SQL Server
Easily push SQL Server data to Salesforce CRM Analytics using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesforce CRM Analytics or update existing records with data from a SQL Server database.
-
Import Real-Time Elorus Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Elorus in ColdFusion.
-
Natively Connect to Xero Data in PHP
The CData ODBC driver for Xero enables you to create PHP applications with connectivity to Xero Accounting. Leverage the native support for ODBC in PHP.
-
Automated Continuous Oracle HCM Cloud Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Azure SQL Database.
-
Automated Continuous HCL Domino Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable HCL Domino replication to OneLake in Microsoft Fabric.
-
Publish Crystal Reports on Hugging Face Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Hugging Face.
-
Connect to Act CRM Data in DBeaver
Use the CData ODBC Driver to connect to Act CRM in DBeaver.
-
Migrating data from SAP Hybris C4C to Snowflake using CData SSIS Components.
Easily push SAP Hybris C4C to Snowflake using the CData SSIS Tasks for SAP Hybris C4C and Snowflake.
-
Stream Zoho Creator Data into Apache Kafka Topics
Access and stream Zoho Creator in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to create an RPA flow for Sage 200 Data in UiPath Studio
Use the Sage 200 ODBC Driver to create workflows that access real-time Sage 200 without any coding.
-
Access Live Google Contacts 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 Google Contacts through MCP integration.
-
Automated Continuous Google Search Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Search replication to Snowflake.
-
Access Workable Data from MySQL in Amazon QuickSight
Connect to Workable and build visualizations of Workable using a MySQL Connection in Amazon QuickSight.
-
How to Easily Query ADP Data in OpenOffice Base
Connect to ADP data in OpenOffice Base using the CData ODBC Driver for ADP and generate reports with live data insights.
-
Replicate SAP SuccessFactors Data from PowerShell
Write a quick PowerShell script to query SAP SuccessFactors. Use connectivity to the live data to replicate SAP SuccessFactors to SQL Server.
-
Integrating Claude Code CLI with Oracle Sales 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.
-
How to Connect to Live Sybase 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 Sybase through natural language.
-
DataBind Controls to Oracle Service Cloud Data in C++Builder
DataBind to Oracle Service Cloud in C++Builder with standard components and controls.
-
Automated Continuous Jumpseller Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Jumpseller replication to Amazon S3.
-
Connect to Apify Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apify from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to connect to Acumatica Data in DBVisualizer
Integrate Acumatica ERP with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData Python Connector for Facebook
Learn to install and license the CData Python Connector
-
Replicate Codat Data to Multiple Databases
Replicate Codat to disparate databases with a point-and-click configuration.
-
Migrating data from Dynamics 365 to Google BigQuery using CData SSIS Components.
Easily push Microsoft Dynamics 365 to Google BigQuery using the CData SSIS Tasks for Dynamics 365 and Google BigQuery.
-
How to create Amplitude federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Amplitude in MySQL .
-
Connect to HubDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for HubDB.
-
Integrate HCL Domino with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate HCL Domino with External Services.
-
DataBind Controls to Codat Data in C++Builder
DataBind to Codat in C++Builder with standard components and controls.
-
Use the CData ODBC Driver for Google Calendar from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Calendar to connect to Google Calendar from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Calendar in Excel.
-
Integrating GitHub Copilot CLI with Mistral AI 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.
-
Automated Sage 200 Data Replication to Teradata
Use CData Sync to Customize and automate Sage 200 replication to Teradata.
-
Automated Continuous CapsuleCRM Replication to MySQL
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to MySQL.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Cloud Storage
Create Google Cloud Storage data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Presto Replication to Snowflake
Use CData Sync for automated, continuous, customizable Presto replication to Snowflake.
-
Bidirectional Access to SendGrid Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SendGrid in Filemaker Pro for Mac or Windows.
-
Establish a Live Connection with Nethunt Data using Tableau Bridge
The CData ODBC Driver for Nethunt enables you to integrate live Nethunt into Tableau Cloud dashboards using the Tableau Bridge.
-
Create SAP Fieldglass-Connected Nintex Workflows
Use CData Connect AI to connect to SAP Fieldglass Data from Nintex Workflow Cloud and build custom workflows using live SAP Fieldglass.
-
How to Query MessageBird Data in MySQL Workbench
Execute MySQL queries against live MessageBird from MySQL Workbench.
-
Build Apps with Live Freshdesk Data Using the Low-Code Development Platform of Mendix
Connect Freshdesk with Mendix to build apps using the CData JDBC Driver for Freshdesk.
-
Integrating Claude Code CLI with JDBC-ODBC Bridge 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.
-
Use Microsoft Copilot Studio to talk to your Phoenix 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 Apache Phoenix for you.
-
Visualize Pipeline CRM 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 Pipeline CRM into TIBCO Spotfire.
-
Integrate Excel Online with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Excel Online with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft Excel Online.
-
Visualize Redshift Data in TIBCO Spotfire through ADO.NET
Integrate Amazon Redshift into dashboards in TIBCO Spotfire.
-
Import Highrise Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Highrise Data and provide access to live Highrise CRM for custom reports in the Power BI Service.
-
How to Work with Dynamics 365 Business Central Data in AWS Glue Jobs Using JDBC
Connect to Dynamics 365 Business Central from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Boomi Agentstudio with CockroachDB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to CockroachDB, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Publish Redis-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Redis.
-
Replicate Multiple FHIR Accounts via the CData Sync CLI
Replicate multiple FHIR accounts to one or many databases.
-
Automated Continuous Coinbase Replication to SingleStore
Use CData Sync for automated, continuous, customizable Coinbase replication to SingleStore.
-
Back Up WordPress to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for WordPress. In this article, we will employ an SSIS workflow to populate a database with WordPress data.
-
Publish REST-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live REST.
-
ETL Clio in Oracle Data Integrator
This article shows how to transfer Clio into a data warehouse using Oracle Data Integrator.
-
Build a Singer.io Tap for Basecamp With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Basecamp data using
-
Getting Started with the CData Tableau Connector for Pinecone
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to ADP Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ADP and the SQL Gateway to access ADP from Google Apps Script.
-
Automated Continuous Testmonitor Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Testmonitor replication to IBM DB2.
-
Easily Integrate Power BI XMLA Data in Lazarus Pascal IDE
Learn how to easily integrate live Power BI XMLA in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Aha! Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Aha! from Informatica Cloud.
-
Integrate Zoho Books with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Zoho Books with External Services.
-
Manage Discord Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Discord.
-
Publish Crystal Reports on Aweber Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Aweber.