CData Software - Knowledge Base
Recent Articles
-
Access Mixpanel Data from MySQL in Amazon QuickSight
Connect to Mixpanel and build visualizations of Mixpanel data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Landbot Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Landbot replication to PostgreSQL.
-
Create Reports from SAP Business Warehouse Data in Looker Studio
Use CData Connect AI to gain access to live SAP Business Warehouse data and create custom reports in Looker Studio.
-
Connect to Real-Time SAP Business Warehouse Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP Business Warehouse and Dataflow to import and use SAP Business Warehouse data in Power Apps.
-
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy
Connect to Microsoft Teams data in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Teams.
-
How to connect to SAP Concur Data from IntelliJ
Integrate connectivity to SAP Concur data with wizards in IntelliJ.
-
Work with Live Zoho Inventory Data in Power Query
Use CData Connect AI to connect to Zoho Inventory data and work with live Zoho Inventory data in Microsoft Power Query.
-
Build Apps with Live Instantly Data Using the Low-Code Development Platform of Mendix
Connect Instantly data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Jira Assets Data in JRuby
Create a simple JRuby app with access to live Jira Assets data.
-
How to Query PayPal Data in MySQL Workbench
Execute MySQL queries against live PayPal data from MySQL Workbench.
-
How to Access Jumpseller Data Using Entity Framework
This article shows how to access Jumpseller data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Antigravity CLI with Aha! data via CData CLI
Connect Aha! data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Chargebee Data in Talend Cloud Data Management Platform
Connect Chargebee Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Import Real-Time Oracle HCM Cloud Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle HCM Cloud data in ColdFusion.
-
Automated Continuous AlloyDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable AlloyDB data replication to OneLake in Microsoft Fabric.
-
Connect to Pipedrive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Pipedrive and the SQL Gateway to access Pipedrive data from Google Apps Script.
-
How to Work with Salesforce Data in ETL Validator JDBC
Connect to Salesforce from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to Certinia Data in DBVisualizer
Integrate Certinia data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous MYOB AccountRight Replication to SQLite
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to SQLite.
-
Create Monday.com-Connected Nintex Workflows
Use CData Connect AI to connect to Monday.com Data from Nintex Workflow Cloud and build custom workflows using live Monday.com data.
-
Integrating LlamaIndex with Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Reckon Accounts Hosted data in real time.
-
Create Freshdesk-Connected Nintex Workflows
Use CData Connect AI to connect to Freshdesk Data from Nintex Workflow Cloud and build custom workflows using live Freshdesk data.
-
Build Voice Agents in ElevenLabs with access to Live Shortcut Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Shortcut data.
-
Automated Continuous Brex Replication to MongoDB
Use CData Sync for automated, continuous, customizable Brex replication to MongoDB.
-
Integrating RabbitMQ Data in Talend Cloud Data Management Platform
Connect RabbitMQ Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData Python Connector for Landbot
Learn to install and license the CData Python Connector and configure a connection to live Landbot data.
-
Use Dash to Build to Web Apps on Cloudflare Data
Create Python applications that use pandas and Dash to build Cloudflare-connected web apps.
-
Use ChatGPT to Talk to Your WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your WooCommerce data for you.
-
Prepare, Blend, and Analyze Salesloft Data in Alteryx Designer (ODBC)
Build workflows to access live Salesloft data for self-service data analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ZeroBounce
Provide connectivity to ZeroBounce data through an SAP BusinessObjects universe.
-
Use Dash to Build Web Apps on Act CRM Data via CData Connect AI
Build interactive Dash web apps on live Act CRM data using pandas and the CData Connect AI Python SDK.
-
Analyze Billsby Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Billsby data in Microsoft R Open.
-
Connect to Okta Data in NetBeans
Connect to Okta data in NetBeans with the data source configuration wizard.
-
How to import Oracle Data into Apache Solr
Use the CData Software JDBC Driver for Oracle in Data Import Handler and create an automated import of Oracle data to Apache Solr Enterprise Search platform.
-
Access Hacker News Data from MySQL in PHP
Connect to Hacker News through the standard MySQL libraries in PHP.
-
Getting Started with the CData ODBC Driver for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Bullhorn CRM.
-
Replicate Microsoft Entra ID Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Entra ID data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate OpenCode with Live Splunk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Splunk data from within your AI coding agent.
-
Create a Data Access Object for CircleCI Data using JDBI
A brief overview of creating a SQL Object API for CircleCI data in JDBI.
-
Create ADP-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ADP Data from OutSystems and build custom enterprise apps using live ADP data.
-
Natively Connect to Sage 200 Data in PHP
The CData ODBC driver for Sage 200 enables you to create PHP applications with connectivity to Sage 200 data. Leverage the native support for ODBC in PHP.
-
Build an OLAP Cube in SSAS from Databricks Data
Establish a connection to Databricks data data from SQL Server Analysis Services, and use the Databricks Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build AI/ML Models with Live GetResponse Data using Dataiku
Connect GetResponse Data with Dataiku using the CData API Driver for JDBC.
-
Explore Geographical Relationships in SendPulse Data with Power Map
Create data visualizations with SendPulse data in Power Map.
-
Integrate Presto with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Presto with External Services.
-
Build Calendly-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Calendly data.
-
Connect to Landbot Data in RapidMiner
Integrate Landbot data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous ZeroBounce Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZeroBounce replication to SQL Server.
-
Connect to ShipStation Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live ShipStation data.
-
Getting Started with the CData Excel Add-In for Placid
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Placid.
-
Integrating Antigravity CLI with Odoo data via CData CLI
Connect Odoo data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Datasets from Google Directory in Domo Workbench and Build Visualizations of Google Directory Data in Domo
Use the CData Software ODBC Driver for Google Directory to create datasets from Google Directory data in Domo Workbench and then build visualizations in the Domo service.
-
Link Omnisend with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Omnisend data in Filemaker Pro for Mac or Windows.
-
Import Real-Time Google Cloud Storage Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Cloud Storage data in ColdFusion.
-
Publish Crystal Reports on Wrike Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Wrike data.
-
Build Apps with Live Authorize.Net Data Using the Low-Code Development Platform of Mendix
Connect Authorize.Net data with Mendix to build apps using the CData JDBC Driver for Authorize.Net.
-
Connect to ScrapingBee Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ScrapingBee and the SQL Gateway to access ScrapingBee data from Google Apps Script.
-
Integrate LibreChat with Live Supabase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Supabase data from within the chat interface.
-
Connect to Dynamics CRM Data in DBeaver
Use the CData ODBC Driver to connect to Dynamics CRM data in DBeaver.
-
How to import Klaviyo Data into Apache Solr
Use the CData Software JDBC Driver for Klaviyo in Data Import Handler and create an automated import of Klaviyo data to Apache Solr Enterprise Search platform.
-
How to connect Amazon QuickSight to Salesloft Data
Create a connection to Salesloft data in CData Connect AI and insert Salesloft data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Intercom Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Intercom replication to Azure SQL Database.
-
Integrating OpenCode with SuiteCRM 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.
-
Query Superchat Data in ColdFusion
Write standard ColdFusion data access code to connect to Superchat data.
-
Replicate Multiple FHIR Accounts
Replicate multiple FHIR accounts to one or many databases.
-
Integrate Discourse Data in the Pentaho Report Designer
Publish reports based on Discourse data in the Pentaho BI tool.
-
LINQ to Salesforce Data 360 Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Salesforce Data 360 Data Provider.
-
Migrating data from Qualaroo to Databricks using CData SSIS Components.
Easily push Qualaroo data to Databricks using the CData SSIS Tasks for Qualaroo and Databricks.
-
Access Live Rebilly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Rebilly data into the statistical analysis tools available in SAS JMP. This article shows how to use Rebilly data in the Graph Builder and Query Builder.
-
How to create an RPA flow for Pipedrive Data in UiPath Studio
Use the Pipedrive ODBC Driver to create workflows that access real-time Pipedrive data without any coding.
-
Automate Clockify Data Replication to Azure Synapse
Use CData Sync to customize and automate Clockify data replication to Azure Synapse.
-
Getting Started with the CData ADO.NET Provider for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for QuickBooks Online.
-
Build a Singer.io Tap for XML With the CData Python Connector
Learn how to easily build a Singer.io Tap for live XML data using the CData Python Connector.
-
Connect to Google Calendar Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Calendar data in Google Apps Script.
-
Connect to Google Contacts Data from a Connection Pool in JBoss
Integrate Google Contacts data into Java servlets: Use the Management Console in JBoss to install the Google Contacts JDBC Driver.
-
Use the CData Software ODBC Driver for SAP Concur in MicroStrategy
Connect to SAP Concur data in MicroStrategy Developer using the CData Software ODBC Driver for SAP Concur.
-
Migrating data from Epicor Kinetic to Google BigQuery using CData SSIS Components.
Easily push Epicor Kinetic data to Google BigQuery using the CData SSIS Tasks for Epicor Kinetic and Google BigQuery.
-
Integrate AfterShip Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live AfterShip data from Informatica Cloud.
-
Replicate Microsoft OneLake Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft OneLake data to disparate databases with a single configuration.
-
How to connect Amazon QuickSight to Stripe Data
Create a connection to Stripe data in CData Connect AI and insert Stripe data into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate RabbitMQ Data to Multiple Databases via the CData Sync CLI
Replicate RabbitMQ data to disparate databases with a single configuration.
-
Migrating data from EnterpriseDB to Google BigQuery using CData SSIS Components.
Easily push EnterpriseDB data to Google BigQuery using the CData SSIS Tasks for EnterpriseDB and Google BigQuery.
-
Analyze Greenplum Data in Cognos Analytics
Use CData Connect AI to connect to Greenplum Data from Cognos Analytics and analyze live Greenplum data.
-
Automated Continuous Twitter Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Google BigQuery.
-
Build Presto Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Presto data and build visualizations in Tableau Cloud.
-
Migrating data from Salesforce Pardot to Google BigQuery using CData SSIS Components.
Easily push Salesforce Pardot data to Google BigQuery using the CData SSIS Tasks for Salesforce Pardot and Google BigQuery.
-
Connect to PagerDuty Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PagerDuty data.
-
Build MVC Applications with Connectivity to SAP Business Warehouse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Business Warehouse from an ASP.NET MVC application.
-
Create Datasets from Google Ad Manager in Domo Workbench and Build Visualizations of Google Ad Manager Data in Domo
Use the CData Software ODBC Driver for Google Ad Manager to create datasets from Google Ad Manager data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to MessageBird Data with Squirrel SQL client
Connect to MessageBird data and execute queries in the Squirrel SQL Client.
-
Automate Datadog Data Replication to Azure Synapse
Use CData Sync to customize and automate Datadog data replication to Azure Synapse.
-
Design BIRT Reports on CapsuleCRM Data
Provide current CapsuleCRM data to your embedded analytics.
-
How to Connect to Live NetSuite 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 NetSuite data through natural language.
-
Visualize Live Adobe Target Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Adobe Target data into custom reports in Power BI.
-
Connect Azure Analysis Services to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Azure Analysis Services data using the CData Python MCP Server.
-
Work with Quaderno Data in FoxPro
Load Quaderno data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Gmail-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Gmail Data from Zoho Analytics and import live Gmail data.
-
Build Dashboards with Teamgate Data in Dundas BI
Create dynamic dashboards and perform analytics based on Teamgate data in Dundas BI.
-
How to connect to Zoho Books Data with Squirrel SQL client
Connect to Zoho Books data and execute queries in the Squirrel SQL Client.
-
Connect to Teamwork from a Connection Pool in WebLogic
Use the CData JDBC Driver for Teamwork to connect to Teamwork data from Web applications running on WebLogic.