CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Act-On Replication to SQL Server
Use CData Sync for automated, continuous, customizable Act-On replication to SQL Server.
-
Connect to and Query Auth0 Data in QlikView over ODBC
Create data visualizations with Auth0 in QlikView.
-
Extend Google Sheets with SendGrid Data
Make calls to SendGrid from Google Apps Script via the API Server.
-
Create Reports with Teradata Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Teradata.
-
Access Amazon Athena Data from MySQL in Amazon QuickSight
Connect to Amazon Athena and build visualizations of Amazon Athena using a MySQL Connection in Amazon QuickSight.
-
Create Smartsheet-Connected Nintex Workflows
Use CData Connect AI to connect to Smartsheet Data from Nintex Workflow Cloud and build custom workflows using live Smartsheet.
-
Automated Continuous Quaderno Replication to Databricks
Use CData Sync for automated, continuous, customizable Quaderno replication to Databricks.
-
Natively Connect to AdRoll Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to AdRoll. Leverage the native support for ODBC in PHP.
-
Connect to Google Forms Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Forms using standard SQL.
-
Build Oracle SCM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle SCM.
-
How to Visualize MariaDB 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 MariaDB in Python.
-
Connect to Tally Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Tally Data and connect to Tally ERP in Akorbi Digital RunMyProcess.
-
Create Asana-Connected Business Apps in AppSheet
Connect to Asana Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Asana.
-
Connecting GenSpark with Lakebase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Lakebase without any replication or custom integration required.
-
How to Access Exa Data Using Entity Framework
This article shows how to access Exa using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to ShipStation Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ShipStation Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Google Analytics Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Analytics using standard SQL.
-
Seamlessly Bring OData Services into Retool Using CData Connect AI
Integrate OData data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Access ClickUp Data Using Entity Framework
This article shows how to access ClickUp using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build MVC Applications with Connectivity to PabblySubscriptions Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access PabblySubscriptions from an ASP.NET MVC application.
-
Build Visualizations of Strava Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Strava in Birst.
-
How to work with Jodoo Data in Apache Spark using SQL
Access and process Jodoo Data in Apache Spark using the CData Software JDBC Driver.
-
ETL Bugsnag in Oracle Data Integrator
This article shows how to transfer Bugsnag into a data warehouse using Oracle Data Integrator.
-
How to Connect to Live SAS Data Sets Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAS Data Sets securely in real time.
-
Connect to ServiceNow from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ServiceNow, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating Codex CLI with Azure Synapse 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Blackbaud FE NXT
Provide connectivity to Blackbaud FE NXT through an SAP BusinessObjects universe.
-
Excel Spreadsheet Automation on Act-On Data with the QUERY Formula
Pull data from Act-On, automate spreadsheets, and more with the QUERY formula.
-
Build Microsoft Planner Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft Planner and build visualizations in Tableau Cloud.
-
Connect to OData Services from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live OData from Filemaker Pro on Mac.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PostgreSQL
Provide connectivity to PostgreSQL through an SAP BusinessObjects universe.
-
Add Pipedrive Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Pipedrive with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Sage Intacct Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage Intacct from your Google Sheets.
-
Analyze Salesforce Marketing Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Salesforce Marketing Cloud in Microsoft R Open.
-
Create Reports with Campaigner Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Campaigner.
-
Create Data Visualizations Based On Shopify Data in Mode
Use CData Connect AI to connect to Shopify Data from Mode and build visualizations using live
-
Extend Google Sheets with MailChimp Data
Make calls to MailChimp from Google Apps Script via the API Server.
-
Connect LightSpeedRetail to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect LightSpeedRetail with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Python Connector for GitHub
Learn to install and license the CData Python Connector
-
How to connect to Tickspot Data with Squirrel SQL client
Connect to Tickspot and execute queries in the Squirrel SQL Client.
-
How to Query Ontraport Data in MySQL Workbench
Execute MySQL queries against live Ontraport from MySQL Workbench.
-
Bidirectional Access to MariaDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate MariaDB in Filemaker Pro for Mac or Windows.
-
Integrating LangChain with DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on IBM DB2 within automated workflows.
-
Choosing the Best Method to Connect Bullhorn CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bullhorn CRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Extract, Transform, and Load Dotmailer Data in Informatica PowerCenter
Create a simple Workflow for Dotmailer in Informatica PowerCenter.
-
Connecting Pipedream with Quickbase 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 Quickbase data in real time.
-
Connect to Google Contacts from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Contacts to connect to Google Contacts from Web applications running on WebLogic.
-
Automated Continuous ConstantContact Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ConstantContact replication to Google BigQuery.
-
How to connect Amazon QuickSight to Splunk Data
Create a connection to Splunk in CData Connect AI and insert Splunk into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate MongoDB Data from PowerShell
Write a quick PowerShell script to query MongoDB. Use connectivity to the live data to replicate MongoDB to SQL Server.
-
Integrating Kiro CLI with Reckon Accounts Hosted 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.
-
Integrating Codex CLI with Veeva Vault & Vault CRM 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 Continuous Tanda Replication to SingleStore
Use CData Sync for automated, continuous, customizable Tanda replication to SingleStore.
-
Process & Analyze Testmonitor Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Testmonitor Data.
-
How to integrate Salesforce Marketing with Apache Airflow
Access and process Salesforce Marketing Cloud in Apache Airflow using the CData JDBC Driver.
-
Design BIRT Reports on Square Data
Provide current Square to your embedded analytics.
-
Build Agents in Relevance AI with Access to Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Shopify within intelligent agent workflows.
-
Create Dynamic OData Grids Using the Infragistics XamDataGrid
Learn how you can connect OData to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous ClickUp Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ClickUp replication to AlloyDB.
-
Automate ZarMoney Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZarMoney from PowerShell? This article demonstrates how to utilize the ZarMoney Cmdlets for tasks like connecting to ZarMoney, automating operations, downloading data, and more.
-
Integrating GitHub Copilot CLI with Mixpanel 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 Easily Query Act CRM Data in OpenOffice Base
Connect to Act CRM data in OpenOffice Base using the CData ODBC Driver for Act CRM and generate reports with live data insights.
-
Integrating OpenCode Terminal with Front 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.
-
Automate YouTube Analytics Data Replication to Couchbase
Use CData Sync to Customize and automate YouTube Analytics replication to Couchbase.
-
Build a Singer.io Tap for YouTube Analytics With the CData Python Connector
Learn how to easily build a Singer.io Tap for live YouTube Analytics data using
-
Integrate Live Redshift Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use the CData Software ODBC Driver for Humanity in SAS for Real-Time Reporting and Analytics
Connect to real-time Humanity in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Humanity.
-
Excel Spreadsheet Automation on Rootly Data with the QUERY Formula
Pull data from Rootly, automate spreadsheets, and more with the QUERY formula.
-
Connect to and Visualize Live Missive Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Missive.
-
Design BIRT Reports on PhantomBuster Data
Provide current PhantomBuster to your embedded analytics.
-
Automate Typeform Data Replication to Azure Data Lake
Use CData Sync to customize and automate Typeform replication to Azure Data Lake.
-
Integrate SAS Data Sets with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAS Data Sets with External Services.
-
Creating GitLab-Connected Applications in Unqork
You can use CData Connect AI to feed GitLab to Unqork and build custom business apps.
-
Connect and Visualize Live SingleStore Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SingleStore into the Databricks platform and create visualization dashboards with real-time SingleStore.
-
Replicate Dynamics CRM Data to Multiple Databases
Replicate Microsoft Dynamics CRM to disparate databases with a point-and-click configuration.
-
Build Automated Google Directory-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Directory and build automated workflows in Zapier.
-
Access Live Facebook Data in AWS Lambda
Connect to live Facebook in AWS Lambda using the CData JDBC Driver.
-
Integrating LlamaIndex with Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Drive in real time.
-
Build QuickBooks Time Visualizations in Tableau Cloud
Use CData Connect AI to connect to live QuickBooks Time and build visualizations in Tableau Cloud.
-
How to Build an ETL App for LinkedIn Ads Data in Python with CData Connect AI
Build ETL pipelines that read and write live LinkedIn Ads in Python with petl and the CData Connect AI Python SDK.
-
Replicate Multiple Drip Accounts
Replicate multiple Drip accounts to one or many databases.
-
Access Live Microsoft Entra ID Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Microsoft Entra ID through MCP integration.
-
Connect to Apify Data from a Connection Pool in JBoss
Integrate Apify into Java servlets: Use the Management Console in JBoss to install the Apify JDBC Driver.
-
Use the CData Software JDBC Driver for Anaplan in MicroStrategy Web
Connect to Anaplan in MicroStrategy Web using the CData Software JDBC Driver for Anaplan.
-
Deploy the ADO.NET Provider for Zoho CRM on an SSRS Report Server
Connect to Zoho CRM 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.
-
Build Reckon-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Reckon.
-
Integrating Qualaroo Data in Talend Cloud Data Management Platform
Connect Qualaroo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Connect to Act-On Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Act-On. Leverage the pyodbc module for ODBC in Python.
-
DataBind Charts to Excel Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Excel 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.
-
Connect to Live MongoDB Data in MicroStrategy through CData Connect AI
Create a live connection to MongoDB Data in CData Connect AI and connect to your MongoDB from MicroStrategy.
-
Integrate with Mocean Data in JReport Designer
Create charts and reports based on Mocean in JReport Designer.
-
Analyze Marketo Data in Cognos Analytics
Use CData Connect AI to connect to Marketo Data from Cognos Analytics and analyze live Marketo.
-
Publish Crystal Reports on DocuSign Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date DocuSign.
-
How to Create Power BI Visual Reports with Real-Time Azure DevOps Data
Use CData Power BI Connectors to visualize Azure DevOps in Power BI.
-
Query Coinbase Data in ColdFusion
Write standard ColdFusion data access code to connect to Coinbase.
-
View Reports on Real-Time Amazon S3 Data in Power BI Report Server
Use the CData ODBC Driver for Amazon S3 to visualize Amazon S3 in Power BI Desktop and then publish them to Power BI Report Server.
-
Deploy the ADO.NET Provider for TaxJar on an SSRS Report Server
Connect to TaxJar 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.
-
Prepare, Blend, and Analyze Supabase Data in Alteryx Designer (ODBC)
Build workflows to access live Supabase for self-service data analytics.
-
Build a Singer.io Tap for Google Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Ads data using
-
Automate Phoenix Data Replication to SAP HANA
Use CData Sync to customize and automate Apache Phoenix replication to SAP HANA.