CData Software - Knowledge Base
Recent Articles
-
How to Access YouTube Analytics Data Using Entity Framework
This article shows how to access YouTube Analytics data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Dynamics 365 Business Central Data in JRuby
Create a simple JRuby app with access to live Dynamics 365 Business Central data.
-
Natively Connect to Excel Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Excel data. Leverage the native support for ODBC in PHP.
-
Connect to Mailgun Data in NetBeans
Connect to Mailgun data in NetBeans with the data source configuration wizard.
-
Query SageHR Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SageHR data from Node.js.
-
Access Live Adobe Analytics Data in Coginiti Pro
Connect to and query live Adobe Analytics data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Oracle SCM in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle SCM data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle SCM.
-
Use the CData Software ODBC Driver for Mocean in MicroStrategy
Connect to Mocean data in MicroStrategy Developer using the CData Software ODBC Driver for Mocean.
-
Access Cosmos DB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Cosmos DB data from HeidiSQL.
-
Visualize Azure Data Lake Storage Data in TIBCO Spotfire through OData
Integrate Azure Data Lake Storage data into dashboards in TIBCO Spotfire.
-
How to create an RPA flow for Salesforce Pardot Data in UiPath Studio
Use the Salesforce Pardot ODBC Driver to create workflows that access real-time Salesforce Pardot data without any coding.
-
Work with Google Sheets Data in FoxPro
Load Google Sheets data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Data Flows from HBase to SQL Server using SSIS
Easily back up HBase data to SQL Server using the SSIS components for HBase.
-
Connect to RSS Feeds from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time RSS feeds using standard SQL.
-
Use Grok to Talk to Your SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SharePoint data for you.
-
DataBind Charts to LDAP Objects
Use the standard ADO.NET procedures for databinding to provide bidirectional access to LDAP objects 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.
-
Enable the OpenWeatherMap JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with OpenWeatherMap data.
-
Build Pipelines with Live AgileCRM Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to AgileCRM from Google Cloud Data Fusion, enabling the integration of live AgileCRM data into the building and management of effective data pipelines.
-
Write a Simple Go Application to work with ZohoMarketingHub Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZohoMarketingHub data.
-
Replicate Browserless Data to Multiple Databases
Replicate Browserless data to disparate databases with a point-and-click configuration.
-
How to publish and share Unbounce Data dashboards with Tableau Server
The CData ODBC driver for Unbounce enables you integrate Unbounce data into Tableau dashboards.
-
Connect to Apify Data in JRuby
Create a simple JRuby app with access to live Apify data.
-
Working with ZohoDesk Data in LINQPad
Execute LINQ queries to ZohoDesk data in LINQPad.
-
Build Voice Agents in ElevenLabs with access to Live Dynamics CRM Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Dynamics CRM data.
-
View Reports on Real-Time IBM Informix Data in Power BI Report Server
Use the CData ODBC Driver for IBM Informix to visualize IBM Informix data in Power BI Desktop and then publish them to Power BI Report Server.
-
Operational Reporting on Cosmos DB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Cosmos DB data.
-
Explore Geographical Relationships in Humanity Data with Power Map
Create data visualizations with Humanity data in Power Map.
-
Connect to SFTP Data from a Connection Pool in Jetty
The SFTP JDBC Driver supports connection pooling: This article shows how to connect faster to SFTP data from Web apps in Jetty.
-
Automated Continuous BigCommerce Replication to Snowflake
Use CData Sync for automated, continuous, customizable BigCommerce replication to Snowflake.
-
Replicate Workday Data in Heroku for Use in Salesforce Connect
Replicate Workday data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Apps with Live Coda data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Coda data into the Adalo platform and build custom mobile and web applications with real-time Coda data.
-
Create SSAS Tabular Models from FormSite Data
How to build a SQL Server Analysis Service Tabular Model from FormSite data using CData drivers.
-
Integrate Google's Antigravity Agent with Live Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Workday data using the Model Context Protocol.
-
Replicate Raisers Edge NXT Data to Multiple Databases via the CData Sync CLI
Replicate Raisers Edge NXT data to disparate databases with a single configuration.
-
Integrate Open WebUI with Live iContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live iContact data from within the chat interface.
-
Automated Continuous Jodoo Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Jodoo data replication to OneLake in Microsoft Fabric.
-
Connect to Supabase Data in Google Apps Script via Connect AI
Use CData Connect AI to access Supabase data in Google Apps Script.
-
Create Figshare Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Figshare from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to use SQLAlchemy ORM to access Factorial Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Factorial data.
-
Integrate with live Moosend Data in Jitterbit
Use CData Connect AI to connect to and integrate live Moosend data in Jitterbit.
-
Connect to Apify Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Apify and the SQL Gateway to access Apify data from Google Apps Script.
-
Connect to Vault CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Vault CRM data from Crystal Reports.
-
Provide OData Services of Quaderno Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Quaderno data by developing a WCF Service Application.
-
Query Live Excel Online Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Excel Online data directly from the development environment.
-
Build AI Agents with Bitbucket Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Bitbucket data through CData Connect AI.
-
Automated Continuous Dynamics NAV Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Amazon Redshift.
-
Integrating Gumloop with HubDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on HubDB data within automated workflows.
-
How to Connect to AgileCRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to AgileCRM data. Leverage the pyodbc module for ODBC in Python.
-
Integrate with Live Google Contacts Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Contacts from the MuleSoft Anypoint Platform to integrate live Google Contacts data into custom reports and dashboards.
-
Integrate with live Bright Data Data in Jitterbit
Use CData Connect AI to connect to and integrate live Bright Data data in Jitterbit.
-
Integrate OpenCode with Live Cloudant Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Cloudant data from within your AI coding agent.
-
Automated Continuous Eventbrite Replication to MySQL
Use CData Sync for automated, continuous, customizable Eventbrite replication to MySQL.
-
Connect to iContact Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to iContact and work with iContact data in your FileMaker applications.
-
Build Dashboards with Google Tasks Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Tasks data in Dundas BI.
-
Build XML-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live XML data and build XML-connected web apps with Axios.
-
Publish Reports with Paymo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Paymo data.
-
Connect to Google Analytics from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Analytics to connect to Google Analytics data from Web applications running on WebLogic.
-
Use the CData SSIS Components to Insert New or Update Existing Xero Records from SQL Server
Easily push SQL Server data to Xero using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Xero or update existing records with data from a SQL Server database.
-
Prepare, Blend, and Analyze FHIR Data in Alteryx Designer (ODBC)
Build workflows to access live FHIR data for self-service data analytics.
-
Integrate Goose with Live ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ZohoExpense data from within the local AI agent.
-
Connect to PabblySubscriptions Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PabblySubscriptions data.
-
Working with IBM Informix Data in LINQPad
Execute LINQ queries to IBM Informix data in LINQPad.
-
Rapidly Develop SAP-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.
-
How to Connect to Live ActiveCampaign Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your ActiveCampaign data for you.
-
Automated Continuous GetResponse Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable GetResponse replication to Amazon Redshift.
-
Analyze BigQuery Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze BigQuery data in Microsoft R Open.
-
Connect to SendGrid Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SendGrid data in the Denodo Virtual DataPort Administrator.
-
Connect to MYOB AccountRight Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MYOB AccountRight data using standard SQL.
-
Visualize Scrapfly Data in Sisense
Create an ElastiCube in Sisense app with access to Scrapfly data.
-
Integrating GitHub Copilot with VWO 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.
-
Analyze Bitbucket Data in Looker
Use CData Connect AI to connect to Bitbucket Data from Looker and build custom apps using live Bitbucket data.
-
How to create Typeform federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Typeform data in MySQL .
-
Connect to Wrike Data in DBeaver
Use the CData ODBC Driver to connect to Wrike data in DBeaver.
-
Object-Relational Mapping (ORM) with SAP BusinessObjects BI Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP BusinessObjects BI data into a Java-based ORM framework, Hibernate.
-
Connect to Oracle Eloqua Data in CloverDX (formerly CloverETL)
Transfer Oracle Eloqua data using the visual workflow in the CloverDX data integration tool.
-
Connect to Access Data in NetBeans
Connect to Access data in NetBeans with the data source configuration wizard.
-
Connect to Live Stripe Data in MicroStrategy through CData Connect AI
Create a live connection to Stripe Data in CData Connect AI and connect to your Stripe data from MicroStrategy.
-
Connect to Vault CRM Data from a Connection Pool in Jetty
The Vault CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Vault CRM data from Web apps in Jetty.
-
Automated Continuous WooCommerce Replication to Snowflake
Use CData Sync for automated, continuous, customizable WooCommerce replication to Snowflake.
-
Integrate Devin with Live Salesforce Marketing Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Salesforce Marketing data.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Contacts
Create an ODBC connection to Google Contacts in Informatica and browse and transfer Google Contacts data.
-
Use Grok to Talk to Your Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Twitter Ads data for you.
-
View Reports on Real-Time Attio Data in Power BI Report Server
Use the CData ODBC Driver for Attio to visualize Attio data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Dynamic ZohoPeople Grids Using the Infragistics XamDataGrid
Learn how you can connect ZohoPeople to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Jira Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Jira replication to Google BigQuery.
-
Model, Search, and Visualize Live Zoho Books Data in ThoughtSpot
Use CData Connect AI to connect to live Zoho Books data for modeling, searching, and visualizing.
-
Integrate LibreChat with Live Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Power BI XMLA data from within the chat interface.
-
Connect to PhantomBuster Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to PhantomBuster.
-
Create Microsoft Exchange-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft Exchange Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Exchange data.
-
How to Connect to Live Pipedrive 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 Pipedrive data through natural language.
-
Connect OneNote to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live OneNote data using the CData Python MCP Server.
-
Consume DB2 OData Feeds in PowerBuilder
This article demonstrates how to consume DB2 data as OData feeds from PowerBuilder using the API Server.
-
Create Dashboards and Visualize Live Zoho CRM Data in Geckoboard
Use CData Connect AI to connect to live Zoho CRM data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use Dash to Build to Web Apps on Snapchat Ads Data
Create Python applications that use pandas and Dash to build Snapchat Ads-connected web apps.
-
Connect to Salesforce Marketing Data in Ruby
Connect to Salesforce Marketing data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Edit and Search External Wave Financial Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Wave Financial data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Wave Financial Data objects that you can access from apps and the dashboard.
-
Connect to and Visualize Live HubDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live HubDB data.
-
Build Dashboards with AdRoll Data in Dundas BI
Create dynamic dashboards and perform analytics based on AdRoll data in Dundas BI.
-
Automated Continuous Datadog Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Datadog replication to PostgreSQL.
-
How to publish and share Attio Data dashboards with Tableau Server
The CData ODBC driver for Attio enables you integrate Attio data into Tableau dashboards.