CData Software - Knowledge Base
Recent Articles
-
Use Agno to Talk to Your ActiveCampaign 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 ActiveCampaign data for you.
-
Access Live PingOne Data in Excel 365 Online (Excel for the web)
Connect to PingOne data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Odoo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Odoo replication to Snowflake.
-
Analyze Pipeline CRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Pipeline CRM data with the CData JDBC Driver for Pipeline CRM.
-
Connect to Live Suadeo Data in MicroStrategy through CData Connect AI
Create a live connection to Suadeo Data in CData Connect AI and connect to your Suadeo data from MicroStrategy.
-
Integrate LibreChat with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Procore data from within the chat interface.
-
Integrate Monday.com with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Monday.com with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Monday.com data.
-
Automated Continuous Quaderno Replication to Vertica
Use CData Sync for automated, continuous, customizable Quaderno replication to Vertica.
-
Provide OData Services of Missive Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Missive data by developing a WCF Service Application.
-
Build Salesforce-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Salesforce data and build Salesforce-connected web apps with Axios.
-
DataBind Webflow Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Webflow data to a chart.
-
Automated Continuous Landbot Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Landbot replication to Azure SQL Database.
-
Use Microsoft Copilot Studio to talk to your Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Zoom data for you.
-
How to connect Amazon QuickSight to Amazon DynamoDB Data
Create a connection to Amazon DynamoDB data in CData Connect AI and insert Amazon DynamoDB data into Amazon QuickSight SPICE to build interactive dashboards.
-
LINQ to QuickBooks
LINQ provides general-purpose query facilities in .NET Framework 3.0 and above and provides one easy way to programmatically access data through from CData Data Providers for ADO.NET. This example uses LINQ to access information from the QuickBooks Data Provider.
-
Connect to Power BI XMLA Data in Claris FileMaker Pro
Use the CData ODBC Driver for Power BI XMLA in FileMaker Pro to connect to Power BI XMLA and work with Power BI XMLA data in your FileMaker applications.
-
A PostgreSQL Interface for Pinterest Data using the CData ODBC Driver
Use the SQL Gateway and Pinterest ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Tavily Data from PowerBuilder via ADO.NET
This article demonstrates how to access Tavily data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Aweber-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Aweber data without replication.
-
Build Semantic Layer Views for Pinterest Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Pinterest data.
-
Analyze Adobe Analytics Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Adobe Analytics data and visualize Adobe Analytics data in SAP Analytics Cloud.
-
Analyze Azure Synapse Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Synapse data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Real-Time Access to WooCommerce in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to WooCommerce data in real time.
-
Automated Continuous Act CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Act CRM replication to SingleStore.
-
Connect to Freshsales Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Freshsales and work with Freshsales data in your FileMaker applications.
-
Publish Crystal Reports on Email Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Email data.
-
Connect to Mouseflow Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Mouseflow and work with Mouseflow data in your FileMaker applications.
-
Create Apps from Printify Data in Qlik Sense Cloud
Use CData Connect AI to connect to Printify Data and build apps from live Printify data in Qlik Sense Cloud.
-
Connect to eBay Analytics Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with eBay Analytics Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Build an ETL App for Excel Online Data in Python with CData
Create ETL applications and real-time data pipelines for Excel Online data in Python with petl.
-
Perform Batch Operations with Presto Data in Apache NiFi
Connect to Presto data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Marketo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Marketo and the SQL Gateway to access Marketo data from Google Apps Script.
-
How to Seamlessly Import Discord Data into IBM SPSS Modeler
Integrate Discord data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Apps with Live Amazon DynamoDB data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Amazon DynamoDB data into the Adalo platform and build custom mobile and web applications with real-time Amazon DynamoDB data.
-
Integrating Kiro with OData Services 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.
-
How to integrate Authorize.Net with Apache Airflow
Access and process Authorize.Net data in Apache Airflow using the CData JDBC Driver.
-
How to create Instantly federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Instantly data in MySQL .
-
Connect to Pinterest from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pinterest to connect to Pinterest data from Web applications running on WebLogic.
-
Perform Batch Operations with Act-On Data in Apache NiFi
Connect to Act-On data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Query Live Monday.com Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Monday.com data through a conversational interface.
-
Replicate Multiple Avalara AvaTax Accounts
Replicate multiple Avalara AvaTax accounts to one or many databases.
-
Work with DB2 Data in FoxPro
Load DB2 data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize iContact Data in TIBCO Spotfire through ADO.NET
Integrate iContact data into dashboards in TIBCO Spotfire.
-
Prepare, Blend, and Analyze Pipeline CRM Data in Alteryx Designer (ODBC)
Build workflows to access live Pipeline CRM data for self-service data analytics.
-
Connect and Visualize Live Instagram Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Instagram data into the Databricks platform and create visualization dashboards with real-time Instagram data.
-
How to Connect to Google Directory Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Directory data. Leverage the pyodbc module for ODBC in Python.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Discourse
Provide connectivity to Discourse data through an SAP BusinessObjects universe.
-
Connect to Azure Analysis Services Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Analysis Services and the Script function in FileMaker Pro to connect to Azure Analysis Services and work with Azure Analysis Services data in your FileMaker application.
-
Import Real-Time Gorgias Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Gorgias data in ColdFusion.
-
Validate Clockify Data with QuerySurge
Access and validate Clockify data in QuerySurge using the CData JDBC Driver.
-
Integrate with Live SAP HANA XS Advanced Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP HANA XS Advanced from the MuleSoft Anypoint Platform to integrate live SAP HANA XS Advanced data into custom reports and dashboards.
-
Facebook Ads Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Facebook Ads data through CData Connect AI using different applications and tools.
-
Access Live Klaviyo Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Klaviyo data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software JDBC Driver for Greenhouse in MicroStrategy Web
Connect to Greenhouse data in MicroStrategy Web using the CData Software JDBC Driver for Greenhouse.
-
Connect to Hugging Face Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Hugging Face data.
-
Deploy the ADO.NET Provider for Drip on an SSRS Report Server
Connect to Drip 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.
-
ETL LinkedIn in Oracle Data Integrator
This article shows how to transfer LinkedIn data into a data warehouse using Oracle Data Integrator.
-
Connect to Factorial Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Factorial to connect to Factorial data and execute queries in PowerBuilder.
-
Create Informatica Mappings From/To a JDBC Data Source for Strava
Create Strava data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Webex Data in Ruby
Connect to Webex data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Factorial Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Factorial replication to Google BigQuery.
-
Automated Continuous Impala Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Impala replication to PostgreSQL.
-
Use CData Connect AI to Access DocuSign Data in Microsoft Power Pivot
Use CData Connect AI to connect to live DocuSign data in the Power Pivot business intelligence tool.
-
Choosing the Best Method to Connect Mouseflow to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Mouseflow data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Access SparkPost Data Using Entity Framework
This article shows how to access SparkPost data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Office 365 Replication to Oracle
Use CData Sync for automated, continuous, customizable Office 365 replication to Oracle.
-
Analyze GitHub Data in Cognos Analytics
Use CData Connect AI to connect to GitHub Data from Cognos Analytics and analyze live GitHub data.
-
Viewing MYOB AccountRight Data in RAD Studio Data Explorer
How to view MYOB AccountRight data in RAD Studio Data Explorer using the CData ODBC Driver for MYOB AccountRight.
-
Comparing Connectivity to Salesforce.com Data in Tableau
An article comparing the native support for Salesforce.com in Tableau to connecting using the CData Software ODBC Driver for Salesforce.
-
Integrating Codex with Pinterest 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.
-
Visualize REST Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load REST data into TIBCO Spotfire.
-
Using the CData Software ODBC Driver for Workable in PyCharm
Connect to Workable as an ODBC data source in PyCharm using the CData Software ODBC Driver for Workable.
-
Connect to SAP SuccessFactors Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP SuccessFactors data using standard SQL.
-
Rapidly Develop Rebilly-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 Rebilly.
-
Enable the Gmail JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Gmail data.
-
Create Apps from DocuSign Data in Qlik Sense Cloud
Use CData Connect AI to connect to DocuSign Data and build apps from live DocuSign data in Qlik Sense Cloud.
-
A PostgreSQL Interface for CSV Data using the CData ODBC Driver
Use the SQL Gateway and CSV ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Brex Data Replication to Azure Data Lake
Use CData Sync to customize and automate Brex data replication to Azure Data Lake.
-
Use the CData Software ODBC Driver for Zoho Projects in MicroStrategy Web
Connect to Zoho Projects data in MicroStrategy Web using the CData Software ODBC Driver for Zoho Projects.
-
Automated ZohoSubscriptions Data Replication to Teradata
Use CData Sync to Customize and automate ZohoSubscriptions data replication to Teradata.
-
Connect to Invoiced Data from a Connection Pool in Jetty
The Invoiced JDBC Driver supports connection pooling: This article shows how to connect faster to Invoiced data from Web apps in Jetty.
-
Stream ChartMogul Data into Apache Kafka Topics
Access and stream ChartMogul data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Kiro with Okta 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.
-
Use the CData Software JDBC Driver for Cloudant in MicroStrategy Web
Connect to Cloudant data in MicroStrategy Web using the CData Software JDBC Driver for Cloudant.
-
Query Vimeo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Vimeo data from Node.js.
-
Object-Relational Mapping (ORM) with Jumpseller 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 Jumpseller data into a Java-based ORM framework, Hibernate.
-
Airtable Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Airtable facts in real time.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP BusinessObjects BI
Create SAP BusinessObjects BI data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
DataBind Controls to SAP Hybris C4C Data in Delphi
DataBind to SAP Hybris C4C data in Delphi with standard data access components and controls.
-
Visualize Figshare Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Figshare data into TIBCO Spotfire.
-
Automated Continuous Google Tasks Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Tasks replication to MySQL.
-
How to use SQLAlchemy ORM to access PolarTeamPro Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PolarTeamPro data.
-
Create Power BI Reports on Real-Time TaxJar Data
Use the CData ODBC Driver for TaxJar to visualize TaxJar data in Power BI Desktop.
-
Automated Continuous Demio Replication to SQL Server
Use CData Sync for automated, continuous, customizable Demio replication to SQL Server.
-
Access Live AfterShip Data in AWS Lambda (with IntelliJ IDEA)
Connect to live AfterShip data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Microsoft OneDrive Data in HULFT Integrate
Connect to Microsoft OneDrive as a JDBC data source in HULFT Integrate
-
Connect to Square Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Square data in the Denodo Virtual DataPort Administrator.
-
Migrating data from Google Campaign Manager 360 to Databricks using CData SSIS Components.
Easily push Google Campaign Manager 360 data to Databricks using the CData SSIS Tasks for Google Campaign Manager 360 and Databricks.
-
Create LinkedIn Ads-Connected Nintex Workflows
Use CData Connect AI to connect to LinkedIn Ads Data from Nintex Workflow Cloud and build custom workflows using live LinkedIn Ads data.
-
How to Connect Oracle Financials Cloud 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 Oracle Financials Cloud data in real time using natural language.