CData Software - Knowledge Base
Recent Articles
-
Connecting Pipedream with ZohoMarketingHub 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 ZohoMarketingHub data in real time.
-
Visualize Live Shippo Data in the Power BI Service
Use CData Connect AI to connect to live Shippo data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Pipelines with Live Microsoft Teams Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Teams from Google Cloud Data Fusion, enabling the integration of live Microsoft Teams data into the building and management of effective data pipelines.
-
Connect to Typeform Data in RapidMiner
Integrate Typeform data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Teradata Replication to Snowflake
Use CData Sync for automated, continuous, customizable Teradata replication to Snowflake.
-
LINQ to Retently 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 Retently Data Provider.
-
Connecting Moonlit Workflow with Anaplan Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Anaplan data in real time.
-
Query Sybase Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Sybase data from Node.js.
-
Access Live PingOne Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PingOne data from your Excel spreadsheets.
-
Automated Continuous Avalara AvaTax Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Amazon Redshift.
-
Create Power BI XMLA Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Power BI XMLA data access from reports, embedded analytics, and more.
-
Automate HubDB Data Replication to SAP HANA
Use CData Sync to customize and automate HubDB data replication to SAP HANA.
-
Visualize Live FTP Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live FTP data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous DB2 for i Replication to AlloyDB
Use CData Sync for automated, continuous, customizable DB2 for i replication to AlloyDB.
-
Build Oracle SCM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle SCM Data and create custom apps in Mendix.
-
Use JayDeBeApi to access Anaplan Data in Python
Use standard Python scripting and the development environment of your choice to access live Anaplan data.
-
How to use SQLAlchemy ORM to access Anaplan Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Anaplan data.
-
Integrating GitHub Copilot with Mode 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.
-
Access Live Avalara AvaTax Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Avalara AvaTax data from your Google Sheets.
-
Integrating Boomi Agentstudio with Google Cloud Storage Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Cloud Storage data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to connect to Short.io Data from Spring Boot
Connect to Short.io in a Spring Boot Application using the CData API Driver for JDBC
-
How to Connect to Live Timely Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Timely data without replication.
-
Build GitHub Visualizations in Tableau Desktop
Use CData Connect AI to connect to live GitHub data and build visualizations in Tableau.
-
Object-Relational Mapping (ORM) with Sage 200 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 Sage 200 data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Webflow Replication to SQL Server
Use CData Sync for automated, continuous, customizable Webflow replication to SQL Server.
-
Build FreshBooks Visualizations in Tableau Cloud
Use CData Connect AI to connect to live FreshBooks data and build visualizations in Tableau Cloud.
-
How to Connect to Live SAP Ariba Source 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 SAP Ariba Source data for you.
-
Query Live Salesforce CRM Analytics 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 Salesforce CRM Analytics data through a conversational interface.
-
How to Build an ETL App for Splunk Data in Python with CData Connect AI
Build ETL pipelines that read and write live Splunk data in Python with petl and the CData Connect AI Python SDK.
-
Natively Connect to Marketo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Marketo data. Leverage the native support for ODBC in PHP.
-
Replicate Flowlu Data in Heroku for Use in Salesforce Connect
Replicate Flowlu data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Back Up DB2 data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for DB2. In this article, we will employ an SSIS workflow to populate a database with DB2 data data.
-
Working with Pushbullet Data in LINQPad
Execute LINQ queries to Pushbullet data in LINQPad.
-
Analyze Salesforce Pardot Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce Pardot data with the CData JDBC Driver for Salesforce Pardot.
-
DataBind Controls to Exact Online Data in Delphi
DataBind to Exact Online data in Delphi with standard data access components and controls.
-
Automated Continuous Outreach.io Replication to SingleStore
Use CData Sync for automated, continuous, customizable Outreach.io replication to SingleStore.
-
Import Real-Time AdRoll Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use AdRoll data in ColdFusion.
-
How to integrate Metabase with OData Services
Use CData Connect AI to connect to live OData services and create an interactive dashboard in Metabase from OData services.
-
Connect to Real-Time Egnyte Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Egnyte data in Power Apps.
-
Explore Geographical Relationships in Aha! Data with Power Map
Create data visualizations with Aha! data in Power Map.
-
How to connect PolyBase to MySQL
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MySQL data.
-
Build Data Flows from Helpscout to SQL Server using SSIS
Easily back up Helpscout data to SQL Server using the SSIS components for Helpscout.
-
Working with Procore Data in LINQPad
Execute LINQ queries to Procore data in LINQPad.
-
How to connect PolyBase to Scrapfly
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Scrapfly data.
-
Establish a Live Connection with ZohoMarketingHub Data using Tableau Bridge
The CData ODBC Driver for ZohoMarketingHub enables you to integrate live ZohoMarketingHub data into Tableau Cloud dashboards using the Tableau Bridge.
-
Enable the Microsoft Exchange JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Exchange data.
-
Getting Started with the CData Tableau Connector for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft OneDrive.
-
Query Confluence Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Confluence entities in PHP by modeling them as objects.
-
Work with Live Sybase Data in Power Query
Use CData Connect AI to connect to Sybase data and work with live Sybase data in Microsoft Power Query.
-
Automated Continuous Google Translate Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Translate replication to Google Cloud SQL.
-
Access ZohoExpense Data from MySQL in Amazon QuickSight
Connect to ZohoExpense and build visualizations of ZohoExpense data using a MySQL Connection in Amazon QuickSight.
-
Interact with Live QuickBooks Online Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live QuickBooks Online data.
-
Replicate Multiple Perplexity Accounts
Replicate multiple Perplexity accounts to one or many databases.
-
Getting Started with the CData Python Connector for Bugsnag
Learn to install and license the CData Python Connector and configure a connection to live Bugsnag data.
-
Replicate SAP Ariba Procurement Data in Heroku for Use in Salesforce Connect
Replicate SAP Ariba Procurement data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Apify Data in Ruby
Connect to Apify data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect the Power BI Service to ZohoSubscriptions: Complete Guide
Connect to the CData Software Power BI Connector for ZohoSubscriptions from PowerBI.com to provide real-time ZohoSubscriptions data across the organization.
-
Enable the OnePageCrm JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with OnePageCrm data.
-
Choosing the Best Method to Connect Trello to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Trello data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Dashboards with Neo4J Data in Dundas BI
Create dynamic dashboards and perform analytics based on Neo4J data in Dundas BI.
-
Automated Twitter Ads Data Replication to Teradata
Use CData Sync to Customize and automate Twitter Ads data replication to Teradata.
-
LINQ to Bullhorn CRM 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 Bullhorn CRM Data Provider.
-
Work with IBM Cloud Object Storage Data in FoxPro
Load IBM Cloud Object Storage data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Using the CData Software ODBC Driver for BigQuery in PyCharm
Connect to BigQuery as an ODBC data source in PyCharm using the CData Software ODBC Driver for BigQuery.
-
Build Exa-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Exa Data and create custom apps in Mendix.
-
Getting Started with the CData ADO.NET Provider for Everhour
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Analyze Mailjet Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Mailjet data and visualize live Mailjet data in Infragistics Reveal.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP ByDesign
Provide connectivity to SAP ByDesign data through an SAP BusinessObjects universe.
-
Replicate Quaderno Data to Multiple Databases
Replicate Quaderno data to disparate databases with a point-and-click configuration.
-
Connect to Autopilot Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Autopilot and work with Autopilot data in your FileMaker applications.
-
Connect to OData Services from AWS Glue
Use CData Connect AI to gain access to live OData services from your AWS Glue jobs.
-
Design BIRT Reports on SurveyMonkey Data
Provide current SurveyMonkey data to your embedded analytics.
-
Bidirectional Access to Vault CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Vault CRM data in Filemaker Pro for Mac or Windows.
-
Visualize Discord Data in Tableau
The CData ODBC driver for Discord enables you integrate Discord data into Tableau dashboards.
-
How to connect to HCL Domino Data with Squirrel SQL client
Connect to HCL Domino data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Google Campaign Manager 360 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to MongoDB.
-
How to connect SharePoint with SAP SuccessFactors Data through external lists
Provide SAP SuccessFactors data to SharePoint users as an external list.
-
Create Reports with Intercom Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Intercom data.
-
How to work with SAP Fieldglass Data in Apache Spark using SQL
Access and process SAP Fieldglass Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live DocuSign Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live DocuSign data from your Google Sheets.
-
Publish Crystal Reports on Microsoft Exchange Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Exchange data.
-
How to Build an ETL App for Email Data in Python with CData
Create ETL applications and real-time data pipelines for Email data in Python with petl.
-
Deploy the ADO.NET Provider for Missive on an SSRS Report Server
Connect to Missive 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.
-
Moving Data from Oracle SCM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Oracle SCM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Kiro with Tanda 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.
-
Connect Grafana to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Grafana data using the CData Python MCP Server.
-
Choosing the Best Method to Connect Snowflake to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Snowflake data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Work with Front Data in ETL Validator JDBC
Connect to Front from ETL Validator jobs using the CData Software JDBC Driver.
-
Easily Integrate Freshdesk Data in Lazarus Pascal IDE
Learn how to easily integrate live Freshdesk data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
DataBind Controls to Chargebee Data in Delphi
DataBind to Chargebee data in Delphi with standard data access components and controls.
-
Using the CData Software ODBC Driver for PayPal in PyCharm
Connect to PayPal as an ODBC data source in PyCharm using the CData Software ODBC Driver for PayPal.
-
Connect to Vault CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Vault CRM data from Appeon PowerBuilder using the CData ADO.NET Provider for Vault CRM.
-
How to connect to Oracle Sales Data from Spring Boot
Connect to Oracle Sales in a Spring Boot Application using the CData JDBC Driver for Oracle Sales
-
Operational Reporting on Hubstaff Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Hubstaff data.
-
Automated Continuous Amplitude Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amplitude replication to AlloyDB.
-
Connect to RabbitMQ in SpagoBI
Create reports featuring live RabbitMQ data in SpagoBI Studio. Host RabbitMQ reports on SpagoBI Server.
-
Automated Continuous Autopilot Replication to SingleStore
Use CData Sync for automated, continuous, customizable Autopilot replication to SingleStore.
-
Getting Started with the CData SSIS Components for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure Synapse.
-
Easily Integrate Avaza Data in Lazarus Pascal IDE
Learn how to easily integrate live Avaza data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Trae with Live Aweber Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Aweber data from within the AI-powered IDE.