CData Software - Knowledge Base
Recent Articles
-
Integrating LangChain with Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Gmail within automated workflows.
-
Getting Started with the CData ADO.NET Provider for Slack
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Slack.
-
Visualize PDFMonkey Data in Sisense
Create an ElastiCube in Sisense app with access to PDFMonkey.
-
How to Connect to Live Monday.com Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Monday.com for you.
-
Connect and Visualize Live Exact Online Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Exact Online into the Databricks platform and create visualization dashboards with real-time Exact Online.
-
Publish Microsoft Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Ads.
-
Build Data Flows from SQL Server to Highrise through SSIS
Easily push SQL Server data to Highrise using the CData SSIS Tasks for Highrise.
-
Integrate with Live Smartsheet Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Smartsheet from the MuleSoft Anypoint Platform to integrate live Smartsheet into custom reports and dashboards.
-
Use the CData Software ODBC Driver for Reckon Accounts Hosted in MicroStrategy Web
Connect to Reckon Accounts Hosted in MicroStrategy Web using the CData Software ODBC Driver for Reckon Accounts Hosted.
-
Access Live Google Tasks Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Tasks into the statistical analysis tools available in SAS JMP. This article shows how to use Google Tasks in the Graph Builder and Query Builder.
-
Integrating Antigravity CLI with Recurly via CData CLI
Connect Recurly to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Real-Time Tanda Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Tanda in Power Apps.
-
Create Facebook-Connected Applications in Appsmith
Connect to Facebook Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Facebook.
-
Integrating Kiro CLI with Jira Assets 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.
-
View Reports on Real-Time HBase Data in Power BI Report Server
Use the CData ODBC Driver for HBase to visualize Apache HBase in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate Intercom Data Replication to Couchbase
Use CData Sync to Customize and automate Intercom replication to Couchbase.
-
Use Agno to Talk to Your Email 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 Email for you.
-
Access Avaza Data from MySQL in PHP
Connect to Avaza through the standard MySQL libraries in PHP.
-
Build Voice Agents in ElevenLabs with access to Live Okta Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Okta.
-
Load Zoho Inventory Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoho Inventory to a database.
-
Create Okta-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Okta Data from OutSystems and build custom enterprise apps using live Okta.
-
Query Quickbase Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Quickbase entities in PHP by modeling them as objects.
-
Visualize Freshsales Data in Tableau
The CData ODBC driver for Freshsales enables you integrate Freshsales into Tableau dashboards.
-
Import WooCommerce Data Using Azure Data Factory
Use CData Connect AI to connect to WooCommerce Data from Azure Data Factory and import live WooCommerce.
-
Access Mixpanel Data from MySQL in Amazon QuickSight
Connect to Mixpanel and build visualizations of Mixpanel using a MySQL Connection in Amazon QuickSight.
-
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 in Power Apps.
-
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy
Connect to Microsoft Teams 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 with wizards in IntelliJ.
-
Work with Live Zoho Inventory Data in Power Query
Use CData Connect AI to connect to Zoho Inventory and work with live Zoho Inventory in Microsoft Power Query.
-
Build Apps with Live Instantly Data Using the Low-Code Development Platform of Mendix
Connect Instantly 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.
-
How to Query PayPal Data in MySQL Workbench
Execute MySQL queries against live PayPal from MySQL Workbench.
-
How to Access Jumpseller Data Using Entity Framework
This article shows how to access Jumpseller using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Antigravity CLI with Aha! via CData CLI
Connect Aha! 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 in ColdFusion.
-
Automated Continuous AlloyDB Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google AlloyDB 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 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 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.
-
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 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.
-
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
-
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 for you.
-
Prepare, Blend, and Analyze Salesloft Data in Alteryx Designer (ODBC)
Build workflows to access live Salesloft for self-service data analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ZeroBounce
Provide connectivity to ZeroBounce through an SAP BusinessObjects universe.
-
How to Access Live Raisers Edge NXT Data in Visual Studio Code via Cline
Run CData MCP Server for Raisers Edge NXT on Windows Subsytem for Linux (WSL) and connect to live Raisers Edge NXT from the Cline extension in Visual Studio Code.
-
Use Dash to Build Web Apps on Act CRM Data via CData Connect AI
Build interactive Dash web apps on live Act CRM 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 in Microsoft R Open.
-
Connect to Okta Data in NetBeans
Connect to Okta 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 Database 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 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create a Data Access Object for CircleCI Data using JDBI
A brief overview of creating a SQL Object API for CircleCI 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.
-
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. Leverage the native support for ODBC in PHP.
-
Build an OLAP Cube in SSAS from Databricks Data
Establish a connection to Databricks 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 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.
-
Connect to Landbot Data in RapidMiner
Integrate Landbot with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to ShipStation Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live ShipStation.
-
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 ERP via CData CLI
Connect Odoo ERP 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 in Domo Workbench and then build visualizations in the Domo service.
-
Bidirectional Access to Omnisend Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Omnisend 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 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.
-
Build Apps with Live Authorize.Net Data Using the Low-Code Development Platform of Mendix
Connect Authorize.Net 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 from Google Apps Script.
-
Connect to Dynamics CRM Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Dynamics CRM 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 to Apache Solr Enterprise Search platform.
-
Automated Continuous Intercom Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Intercom replication to Azure SQL Database.
-
Integrating OpenCode Terminal 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.
-
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 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 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 into the statistical analysis tools available in SAS JMP. This article shows how to use Rebilly 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 without any coding.
-
Automate Clockify Data Replication to Azure Synapse
Use CData Sync to customize and automate Clockify 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
-
Connect to Google Calendar Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Calendar in Google Apps Script.
-
Connect to Google Contacts Data from a Connection Pool in JBoss
Integrate Google Contacts 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 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 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 from Informatica Cloud.
-
Replicate Microsoft OneLake Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft OneLake to disparate databases with a single configuration.
-
How to connect Amazon QuickSight to Stripe Data
Create a connection to Stripe in CData Connect AI and insert Stripe into Amazon QuickSight SPICE to build interactive dashboards.
-
Migrating data from EnterpriseDB to Google BigQuery using CData SSIS Components.
Easily push EnterpriseDB 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 Pivotal GreenPlum.
-
Query Microsoft Teams Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft Teams and perform CRUD operations on Microsoft Teams from Node.js.