CData Software - Knowledge Base
Recent Articles
-
Integrating Cursor with Adobe Target 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.
-
Prepare, Blend, and Analyze SharePoint Excel Services Data in Alteryx Designer (ODBC)
Build workflows to access live SharePoint Excel Services data for self-service data analytics.
-
Access OnePageCrm Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for OnePageCrm data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for TaxJar
Provide connectivity to TaxJar data through an SAP BusinessObjects universe.
-
Integrate Tickspot Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Tickspot data from Informatica Cloud.
-
Integrate Google's Antigravity Agent with Live Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Raisers Edge NXT data using the Model Context Protocol.
-
Connect to Live Exact Online Data in MicroStrategy through CData Connect AI
Create a live connection to Exact Online Data in CData Connect AI and connect to your Exact Online data from MicroStrategy.
-
Integrate SAP HANA XS Advanced Data in Pentaho Data Integration
Build ETL pipelines based on SAP HANA XS Advanced data in the Pentaho Data Integration tool.
-
How to connect to ClickUp Data in DBVisualizer
Integrate ClickUp data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData ODBC Driver for Apollo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Apollo to connect to Apollo data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apollo data in Excel.
-
Build Sybase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Sybase data and build visualizations in Tableau.
-
Build AI Agents with Excel Online 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 Excel Online data through CData Connect AI.
-
Model Jira Assets Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Jira Assets, enabling the direct import of real-time Jira Assets data.
-
Integrating Codex 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.
-
Automated Continuous ZohoInvoice Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to PostgreSQL.
-
Integrating Claude Code CLI with Telegram 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.
-
Publish Crystal Reports on Invoiced Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Invoiced data.
-
Migrating data from Sentry to Databricks using CData SSIS Components.
Easily push Sentry data to Databricks using the CData SSIS Tasks for Sentry and Databricks.
-
Integrate OpenCode with Live Spark Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Spark data from within your AI coding agent.
-
Import Real-Time Aircall Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Aircall data in ColdFusion.
-
Integrating Codex with LDAP objects 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 CockroachDB Replication to MySQL
Use CData Sync for automated, continuous, customizable CockroachDB replication to MySQL.
-
Use Dash to Build to Web Apps on ChartMogul Data
Create Python applications that use pandas and Dash to build ChartMogul-connected web apps.
-
DataBind Controls to Google Forms Data in C++Builder
DataBind to Google Forms data in C++Builder with standard components and controls.
-
DataBind Todoist Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Todoist data to a chart.
-
Use JayDeBeApi to access Testmonitor Data in Python
Use standard Python scripting and the development environment of your choice to access live Testmonitor data.
-
Connect to Rebilly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Rebilly data.
-
Connect to SFTP Data from a Connection Pool in JBoss
Integrate SFTP data into Java servlets: Use the Management Console in JBoss to install the SFTP JDBC Driver.
-
How to use SQLAlchemy ORM to access Coinbase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Coinbase data.
-
Integrate Live Google Search Results into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Search results and integrate live Google Search results into apps built in Microsoft Power Apps.
-
Integrate PostgreSQL with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PostgreSQL with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PostgreSQL data.
-
How to Connect Tally 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 Tally data in real time using natural language.
-
Replicate Access Data from PowerShell
Write a quick PowerShell script to query Access data. Use connectivity to the live data to replicate Access data to SQL Server.
-
Integrate Live Attio Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Attio data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Migrating data from ScrapingBee to Databricks using CData SSIS Components.
Easily push ScrapingBee data to Databricks using the CData SSIS Tasks for ScrapingBee and Databricks.
-
Build Highrise-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Highrise Data from Zoho Analytics and import live Highrise data.
-
Explore Geographical Relationships in Gmail Data with Power Map
Create data visualizations with Gmail data in Power Map.
-
How to Work with Rootly Data in ETL Validator JDBC
Connect to Rootly from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze DocuSign Data in Looker
Use CData Connect AI to connect to DocuSign Data from Looker and build custom apps using live DocuSign data.
-
Connect to Live Salesforce Data 360 Data in MicroStrategy through CData Connect AI
Create a live connection to Salesforce Data 360 Data in CData Connect AI and connect to your Salesforce Data 360 data from MicroStrategy.
-
Consume Zendesk OData Feeds in PowerBuilder
This article demonstrates how to consume Zendesk data as OData feeds from PowerBuilder using the API Server.
-
Consume Google Calendar OData Feeds in PowerBuilder
This article demonstrates how to consume Google Calendar data as OData feeds from PowerBuilder using the API Server.
-
Build Semantic Layer Views for ShipStation Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ShipStation data.
-
Use Azure AI Foundry to Talk to Your Gmail 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 Gmail data for you.
-
Access Live Twilio 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 Twilio data through MCP integration.
-
Access Live Twilio Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Twilio data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
LINQ to HBase 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 HBase Data Provider.
-
Back Up Google Spanner data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Spanner. In this article, we will employ an SSIS workflow to populate a database with Google Spanner data data.
-
Connect to Real-Time Google Tasks Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Google Tasks data in Power Apps.
-
MailerLite Reporting in OBIEE with the MailerLite JDBC Driver
Deploy the MailerLite JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Kintone Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Kintone data and visualize Kintone data in SAP Analytics Cloud.
-
Automated Mistral AI Data Replication to Teradata
Use CData Sync to Customize and automate Mistral AI data replication to Teradata.
-
Access OData Services from MySQL in Amazon QuickSight
Connect to OData and build visualizations of OData services using a MySQL Connection in Amazon QuickSight.
-
Connect to Live Pinterest Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Pinterest in CData Connect AI and connect to your Pinterest data from PostgreSQL.
-
Automated Continuous SAP Netweaver Gateway Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway data replication to OneLake in Microsoft Fabric.
-
Analyze SAP SuccessFactors LMS Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP SuccessFactors LMS data and visualize live SAP SuccessFactors LMS data in Infragistics Reveal.
-
Create Dynamics 365 Business Central-Connected Business Apps in AppSheet
Connect to Dynamics 365 Business Central Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Dynamics 365 Business Central data.
-
Creating OneNote-Connected Applications in Unqork
You can use CData Connect AI to feed OneNote data to Unqork and build custom business apps.
-
Connect to Sage 300 in SpagoBI
Create reports featuring live Sage 300 data in SpagoBI Studio. Host Sage 300 reports on SpagoBI Server.
-
Use Manus AI to Talk to Your Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Marketo data.
-
Prepare, Blend, and Analyze Typeform Data in Alteryx Designer (ODBC)
Build workflows to access live Typeform data for self-service data analytics.
-
How to Access Suadeo Data Using Entity Framework
This article shows how to access Suadeo data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Work with iContact Data in FoxPro
Load iContact data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Typeform-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Typeform data.
-
Replicate Multiple MarkLogic Accounts
Replicate multiple MarkLogic accounts to one or many databases.
-
Connect to SurveyMonkey Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SurveyMonkey data in Airbyte.
-
Connect to Excel Online Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Excel Online and the Script function in FileMaker Pro to connect to Excel Online and work with Excel Online data in your FileMaker application.
-
Using the CData Software ODBC Driver for HDFS in PyCharm
Connect to HDFS as an ODBC data source in PyCharm using the CData Software ODBC Driver for HDFS.
-
Rapidly Develop Hive-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 Hive.
-
Integrating GitHub Copilot with Dynamics 365 Business Central 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.
-
Automated Continuous Snapchat Ads Replication to Oracle
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Oracle.
-
How to Visualize Dynamics CRM 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 Dynamics CRM data in Python.
-
Create Guru-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Guru Data from Klipfolio and build custom visualizations using live Guru data.
-
Integrate Cline with Live Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle HCM Cloud data from within your IDE.
-
Object-Relational Mapping (ORM) with WordPress 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 WordPress data into a Java-based ORM framework, Hibernate.
-
LINQ to Dynamics 365 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 Dynamics 365 Data Provider.
-
Automated Continuous Elorus Replication to Databricks
Use CData Sync for automated, continuous, customizable Elorus replication to Databricks.
-
Connect to Productboard Data in CloverDX (formerly CloverETL)
Transfer Productboard data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous SAP Hybris C4C Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to SQLite.
-
Replicate Supabase Data to Multiple Databases via the CData Sync CLI
Replicate Supabase data to disparate databases with a single configuration.
-
Consume Excel OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Excel feeds that reflect any changes in SAP Lumira.
-
Integrate Cursor with Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Ads data from within the editor.
-
Deploy the ADO.NET Provider for GitHub on an SSRS Report Server
Connect to GitHub data 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.
-
Manage Dotmailer Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Dotmailer.
-
How to Connect to Flowlu Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Flowlu data. Leverage the pyodbc module for ODBC in Python.
-
Access Azure Data Lake Storage Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Azure Data Lake Storage data from HeidiSQL.
-
Connect to Tavily Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Tavily Data and connect to Tavily data in Akorbi Digital RunMyProcess.
-
Access Live LDAP Objects in Excel 365 Online (Excel for the web)
Connect to LDAP objects from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Operational Reporting on ZarMoney Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZarMoney data.
-
Getting Started with the CData SSIS Components for Google Spanner
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Spanner.
-
Connect to Google Campaign Manager 360 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Campaign Manager 360 data from Filemaker Pro on Mac.
-
Build Semantic Layer Views for Testmonitor Data in APOS Live Data Gateway
Use the CData Connector for Testmonitor in APOS Live Data Gateway to build Semantic Layer Views for Testmonitor data.
-
Connect to Amazon Athena Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Amazon Athena data.
-
Automated Continuous Instagram Replication to Vertica
Use CData Sync for automated, continuous, customizable Instagram replication to Vertica.
-
Connect to Onfleet Data in DBArtisan
Use wizards in DBArtisan to configure Onfleet data as a data source.
-
How to Work with Azure DevOps Data in AWS Glue Jobs Using JDBC
Connect to Azure DevOps from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Power BI Reports on Real-Time Gorgias Data
Use the CData ODBC Driver for Gorgias to visualize Gorgias data in Power BI Desktop.
-
Sybase IQ Reporting in OBIEE with the Sybase IQ JDBC Driver
Deploy the Sybase IQ JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Process & Analyze Zendesk Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zendesk Data.
-
Visualize Live Klipfolio Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Klipfolio data.