CData Software - Knowledge Base
Recent Articles
-
Connect to Amazon Marketplace from a Connection Pool in WebLogic
Use the CData JDBC Driver for Amazon Marketplace to connect to Amazon Marketplace from Web applications running on WebLogic.
-
Connect to Mixpanel Data from PowerBuilder via ADO.NET
This article demonstrates how to access Mixpanel from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Analyze Cvent Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Cvent in Microsoft R Open.
-
Replicate Zendesk Data in Heroku for Use in Salesforce Connect
Replicate Zendesk to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Reports from Blackbaud FE NXT Data in Looker Studio
Use CData Connect AI to gain access to live Blackbaud FE NXT and create custom reports in Looker Studio.
-
Query, Visualize, and Share live Azure Synapse Data in Redash
Use CData Connect AI to connect to live Azure Synapse in Redash for querying, visualizing, and sharing.
-
Connect to Google Campaign Manager 360 Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Campaign Manager 360 from HeidiSQL.
-
Use the CData Software ODBC Driver for Productboard in MicroStrategy Desktop
Connect to Productboard in MicroStrategy Desktop using the CData Software ODBC Driver for Productboard.
-
Integrating LangGraph with Microsoft Exchange Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Exchange within automated workflows.
-
How to Build an ETL App for Printful Data in Python with CData
Create ETL applications and real-time data pipelines for Printful in Python with petl.
-
Prepare, Blend, and Analyze HubSpot Data in Alteryx Designer (Connect AI)
Build workflows to access live HubSpot for self-service data analytics.
-
How to Work with Oracle Financials Cloud Data in AWS Glue Jobs Using JDBC
Connect to Oracle Financials Cloud from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate iContact Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live iContact from Informatica Cloud.
-
How to connect PolyBase to PagerDuty
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PagerDuty.
-
Use the CData Software ODBC Driver for Chargebee in SAS for Real-Time Reporting and Analytics
Connect to real-time Chargebee in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Chargebee.
-
How to connect PolyBase to Jira Assets
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Jira Assets.
-
Build Vimeo-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Vimeo Data in GitHub Copilot to assist with building Vimeo-powered applications.
-
Integrating ConvertAPI Data in Talend Cloud Data Management Platform
Connect ConvertAPI Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Dynamic Missive Grids Using the Infragistics XamDataGrid
Learn how you can connect Missive to Infragistics XamDataGrid to build dynamic grids.
-
Publish Crystal Reports on Splunk Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Splunk.
-
Visualize Live AgileCRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live AgileCRM.
-
Easily Integrate Elorus Data in Lazarus Pascal IDE
Learn how to easily integrate live Elorus in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use ChatGPT to Talk to Your Sybase IQ 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 Sybase IQ for you.
-
Query Dynamics NAV Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Dynamics NAV entities in PHP by modeling them as objects.
-
Create Couchbase-Connected Business Apps in AppSheet
Connect to Couchbase Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Couchbase.
-
Build Apps with Live Spotify Data Using the Low-Code Development Platform of Mendix
Connect Spotify with Mendix to build apps using the CData API Driver for JDBC.
-
Access Live GitLab Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live GitLab from your Excel spreadsheets.
-
Connect to Salesforce Data 360 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Salesforce Data 360 and the SQL Gateway to access Salesforce Data 360 from Google Apps Script.
-
Connect OnePageCrm to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect OnePageCrm with IBM WebSphere for seamless data integration and connectivity.
-
Prepare, Blend, and Analyze Twitter Ads Data in Alteryx Designer (Connect AI)
Build workflows to access live Twitter Ads for self-service data analytics.
-
Using the CData Software ODBC Driver for Pingdom in PyCharm
Connect to Pingdom as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pingdom.
-
Extract, Transform, and Load BambooHR Data in Informatica PowerCenter
Create a simple Workflow for BambooHR in Informatica PowerCenter.
-
Visualize Live LightSpeedRetail Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LightSpeedRetail.
-
Access Live SQL Server Data in AWS Lambda
Connect to live Microsoft SQL Server in AWS Lambda using the CData JDBC Driver.
-
Use Dash to Build to Web Apps on Bright Data Data
Create Python applications that use pandas and Dash to build Bright Data-connected web apps.
-
Integrate Live Cvent Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Connect Jira Assets 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 Jira Assets data in real time using natural language.
-
How to Access Live Trello Data in Visual Studio Code via Cline
Run CData MCP Server for Trello on Windows Subsytem for Linux (WSL) and connect to live Trello from the Cline extension in Visual Studio Code.
-
Automate Dotmailer Data Replication to Azure Data Lake
Use CData Sync to customize and automate Dotmailer replication to Azure Data Lake.
-
Connect to Outreach.io Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Outreach.io as an External Source in Dremio.
-
Connect to Google Tasks Data in CloverDX (formerly CloverETL)
Transfer Google Tasks using the visual workflow in the CloverDX data integration tool.
-
Create Power BI Reports on Real-Time Epicor Kinetic Data
Use the CData ODBC Driver for Epicor Kinetic to visualize Epicor Kinetic in Power BI Desktop.
-
DataBind Charts to Nethunt Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Nethunt 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.
-
Deploy the ADO.NET Provider for Sendwithus on an SSRS Report Server
Connect to Sendwithus 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.
-
Automate MessageBird Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live MessageBird and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connecting Pipedream with Paylocity 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 Paylocity data in real time.
-
Automated Continuous Planio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Planio replication to Apache Kafka.
-
Use the CData Software ODBC Driver for Reply.io in MicroStrategy Desktop
Connect to Reply.io in MicroStrategy Desktop using the CData Software ODBC Driver for Reply.io.
-
Create Azure Data Catalog Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Azure Data Catalog from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to import Planio Data into Apache Solr
Use the CData Software JDBC Driver for Planio in Data Import Handler and create an automated import of Planio to Apache Solr Enterprise Search platform.
-
Create Dynamic OneNote Grids Using the Infragistics XamDataGrid
Learn how you can connect OneNote to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to Printful Data with Squirrel SQL client
Connect to Printful and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData SSIS Components for Strava
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Strava.
-
Visualize Live Pinecone Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pinecone using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for Apify Data using the CData ODBC Driver
Use the SQL Gateway and Apify ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Calendly Data in AWS Lambda
Connect to live Calendly in AWS Lambda using the CData JDBC Driver.
-
Connect to Salesforce Data in CloverDX (formerly CloverETL)
Transfer Salesforce & Force.com using the visual workflow in the CloverDX data integration tool.
-
How to Connect to & Open Teamwork Data in Microsoft Excel
This article uses the CData ODBC driver for Teamwork to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live PivotalTracker Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a PivotalTracker data source in TIBCO Data Virtualization Studio and gain access to live PivotalTracker from your TDV Server.
-
How to Connect to Live Freshdesk 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 Freshdesk for you.
-
How to Access Adobe Analytics Data Using Entity Framework
This article shows how to access Adobe Analytics using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Work with SurveyMonkey Data in FoxPro
Load SurveyMonkey into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for SAP Ariba Source in MicroStrategy Desktop
Connect to SAP Ariba Source in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Ariba Source.
-
Create Dynamic Bugsnag Grids Using the Infragistics XamDataGrid
Learn how you can connect Bugsnag to Infragistics XamDataGrid to build dynamic grids.
-
Use Azure AI Foundry to Talk to Your ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your ShipStation for you.
-
Use the CData Software ODBC Driver for AgileCRM in MicroStrategy Desktop
Connect to AgileCRM in MicroStrategy Desktop using the CData Software ODBC Driver for AgileCRM.
-
Automated Continuous JotForm Replication to SQL Server
Use CData Sync for automated, continuous, customizable JotForm replication to SQL Server.
-
Automated Continuous SAP ByDesign Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Vertica.
-
DataBind Charts to Blackbaud FE NXT Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Blackbaud FE NXT 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.
-
DataBind LinkedIn Ads Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for LinkedIn Ads with the DevExpress Windows Forms and Web controls to provide LinkedIn Ads to a chart.
-
Build Automated Shopify-Connected Workflows in Zapier
Use CData Connect AI to connect to live Shopify and build automated workflows in Zapier.
-
Import and Visualize LaunchDarkly Data in Power View
Create data visualizations based on LaunchDarkly in Excel.
-
Automated Continuous IBM Cloud Object Storage Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to OneLake in Microsoft Fabric.
-
Publish SurveyMonkey-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SurveyMonkey.
-
DataBind Controls to Coinbase Data in C++Builder
DataBind to Coinbase in C++Builder with standard components and controls.
-
Build ZohoPeople-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZohoPeople and build web apps with connectivity to live ZohoPeople.
-
Connect to Deel Data from PowerBuilder via JDBC
This article demonstrates how to access Deel from PowerBuilder using the Deel JDBC Driver.
-
Create Azure DevOps-Connected Applications in Appsmith
Connect to Azure DevOps Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Azure DevOps.
-
Create MarkLogic-Connected Business Apps in AppSheet
Connect to MarkLogic Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MarkLogic.
-
How to create Front federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Front in MySQL .
-
Create Power BI Reports on Real-Time PagerDuty Data
Use the CData ODBC Driver for PagerDuty to visualize PagerDuty in Power BI Desktop.
-
Bidirectional Access to Adobe Target Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Adobe Target in Filemaker Pro for Mac or Windows.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Kintone to Power BI dashboards. Simply drag and drop Kintone into data visuals on the Power BI canvas.
-
Connect to Google Ad Manager Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Ad Manager.
-
Build Dynamics 365-Connected Apps in Choreo
Use CData Connect AI to connect to Dynamics 365 Data from Choreo and build custom apps using live Microsoft Dynamics 365.
-
Bidirectional Access to Dynamics NAV Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dynamics NAV in Filemaker Pro for Mac or Windows.
-
Build a Singer.io Tap for Workable With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Workable data using
-
Replicate Multiple Klaviyo Accounts
Replicate multiple Klaviyo accounts to one or many databases.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce for you.
-
Connect to iContact Data in CloverDX (formerly CloverETL)
Transfer iContact using the visual workflow in the CloverDX data integration tool.
-
How to connect SharePoint with Perplexity Data through external lists
Provide Perplexity to SharePoint users as an external list.
-
How to Connect to Live Salesforce Pardot 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 Salesforce Pardot through natural language.
-
Connect to Live Jira Assets Data in MicroStrategy through CData Connect AI
Create a live connection to Jira Assets Data in CData Connect AI and connect to your Jira Assets from MicroStrategy.
-
How to Design Bullhorn CRM Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Bullhorn CRM from mobile and tablet Power Apps.
-
Rapidly Develop SAP Ariba Source-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SAP Ariba Source.
-
Connect to OneNote Data in HULFT Integrate
Connect to OneNote as a JDBC data source in HULFT Integrate
-
Analyze Microsoft Planner Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Planner and visualize live Microsoft Planner in Infragistics Reveal.
-
Query Google Analytics Data in DataGrip
Create a Data Source for Google Analytics in DataGrip and use SQL to query live Google Analytics.
-
Integrating Dataiku with Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Exchange.
-
Access Live ZarMoney Data in AWS Lambda
Connect to live ZarMoney in AWS Lambda using the CData JDBC Driver.