CData Software - Knowledge Base
Recent Articles
-
Replicate Float Data to Multiple Databases via the CData Sync CLI
Replicate Float data to disparate databases with a single configuration.
-
Use the CData Software JDBC Driver for Excel Online in MicroStrategy Desktop
Connect to Excel Online data in MicroStrategy Desktop using the CData Software JDBC Driver for Excel Online.
-
Create CockroachDB-Connected Nintex Workflows
Use CData Connect AI to connect to CockroachDB Data from Nintex Workflow Cloud and build custom workflows using live CockroachDB data.
-
Connect BigCommerce Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your BigCommerce data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automate HubDB Data Replication to Couchbase
Use CData Sync to Customize and automate HubDB data replication to Couchbase.
-
Connect to Real-Time CloudConvert Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use CloudConvert data in Power Apps.
-
Natively Connect to Google Ads Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Ads data. Leverage the native support for ODBC in PHP.
-
Import Real-Time Contentful Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Contentful data in ColdFusion.
-
How to publish and share Drip Data dashboards with Tableau Server
The CData ODBC driver for Drip enables you integrate Drip data into Tableau dashboards.
-
Connect to OnePageCrm Data in CloverDX (formerly CloverETL)
Transfer OnePageCrm data using the visual workflow in the CloverDX data integration tool.
-
Integrating Boomi Agentstudio with ADP Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ADP data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Deploy the ADO.NET Provider for Oracle Service Cloud on an SSRS Report Server
Connect to Oracle Service Cloud 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.
-
How to Connect to Phoenix Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Phoenix data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Dropbox Data in NetBeans
Connect to Dropbox data in NetBeans with the data source configuration wizard.
-
Automate SAP Ariba Source Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Ariba Source data replication to Azure Data Lake.
-
Work with Live Cvent Data in Power Query
Use CData Connect AI to connect to Cvent data and work with live Cvent data in Microsoft Power Query.
-
How to create an RPA flow for Pinterest Data in UiPath Studio
Use the Pinterest ODBC Driver to create workflows that access real-time Pinterest data without any coding.
-
Publish Crystal Reports on Airtable Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Airtable data.
-
Connect to Real-Time Float Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Float data in Power Apps.
-
How to connect Amazon QuickSight to Dynamics 365 Business Central Data
Create a connection to Dynamics 365 Business Central data in CData Connect AI and insert Dynamics 365 Business Central data into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate LeadDesk Data from PowerShell
Write a quick PowerShell script to query LeadDesk data. Use connectivity to the live data to replicate LeadDesk data to SQL Server.
-
Work with Live Oracle Service Cloud Data in Power Query
Use CData Connect AI to connect to Oracle Service Cloud data and work with live Oracle Service Cloud data in Microsoft Power Query.
-
Connect to Cosmos DB Data from PowerBuilder via JDBC
This article demonstrates how to access Cosmos DB data from PowerBuilder using the Cosmos DB JDBC Driver.
-
Visualize Live PhantomBuster Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PhantomBuster data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate OpenCode with Live SAP Ariba Procurement Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SAP Ariba Procurement data from within your AI coding agent.
-
Create Sentry Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sentry from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Crystal Reports on Snapchat Ads Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Snapchat Ads data.
-
Build Salesloft-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Salesloft data and build Salesloft-connected web apps with Axios.
-
A PostgreSQL Interface for Printify Data using the CData ODBC Driver
Use the SQL Gateway and Printify ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Bannerbear Replication to Oracle
Use CData Sync for automated, continuous, customizable Bannerbear replication to Oracle.
-
Getting Started with the CData Excel Add-In for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for IBM Cloud Object Storage.
-
Use Dash to Build Web Apps on SAP BusinessObjects BI Data via CData Connect AI
Build interactive Dash web apps on live SAP BusinessObjects BI data using pandas and the CData Connect AI Python SDK.
-
Getting Started with the CData Tableau Connector for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate Sage Cloud Accounting Data to Multiple Databases via the CData Sync CLI
Replicate Sage Cloud Accounting data to disparate databases with a single configuration.
-
Use Grok to Talk to Your Printify 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 Printify data for you.
-
Migrating data from CouchDB to Snowflake using CData SSIS Components.
Easily push CouchDB data to Snowflake using the CData SSIS Tasks for CouchDB and Snowflake.
-
Integrating Codex with Postmark 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.
-
Query Optimizely Data as a SQL Server Database in Node.js
Execute SQL Server queries against Optimizely data from Node.js.
-
Access Mode Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mode data from HeidiSQL.
-
Automated Continuous Cvent Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Cvent replication to delimited files (CSV/TSV).
-
Query Office 365 Data in ColdFusion
Write standard ColdFusion data access code to connect to Office 365 data.
-
Connect to Yelp Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Yelp data in the Denodo Virtual DataPort Administrator.
-
Create SAP ByDesign-Connected Applications in Appsmith
Connect to SAP ByDesign Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP ByDesign data.
-
Access Bugsnag Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Bugsnag data from your Oracle system.
-
Build Coinbase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Coinbase data and build web apps with connectivity to live Coinbase data.
-
Create Power BI Reports on Real-Time Typeform Data
Use the CData ODBC Driver for Typeform to visualize Typeform data in Power BI Desktop.
-
How to use SQLAlchemy ORM to access SAP Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP data.
-
How to load Mouseflow data into Elasticsearch via Logstash
Introducing a simple method to load Mouseflow data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Dashboards with Databricks Data in Dundas BI
Create dynamic dashboards and perform analytics based on Databricks data in Dundas BI.
-
Getting Started with the CData ODBC Driver for Everhour
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Everhour.
-
Getting Started with the CData Tableau Connector for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Business Warehouse.
-
Create Data Visualizations Based On GitLab Data in Mode
Use CData Connect AI to connect to GitLab Data from Mode and build visualizations using live GitLab data.
-
Integrating LlamaIndex with Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle data in real time.
-
Import Apify Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Apify Data and provide access to live Apify data for custom reports in the Power BI Service.
-
Choosing the Best Method to Connect Google Contacts to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Contacts data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Pipeliner CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Pipeliner CRM data in the Denodo Virtual DataPort Administrator.
-
Access Live Google Drive Data in TIBCO Data Virtualization
Use the Google Drive Tibco DV Adapter to create a Google Drive data data source in TIBCO Data Virtualization Studio and gain access to live Google Drive data from your TDV Server.
-
How to Easily Query Webflow Data in OpenOffice Base
Connect to Webflow data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData Software JDBC Driver for SAS xpt in MicroStrategy
Connect to SAS xpt data in MicroStrategy Developer using the CData Software JDBC Driver for SAS xpt.
-
Publish Stripe-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Stripe data.
-
Explore Geographical Relationships in Parallel Data with Power Map
Create data visualizations with Parallel data in Power Map.
-
Create SAP Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze Databricks Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Databricks data and visualize Databricks data in SAP Analytics Cloud.
-
Connect to Productboard Data in RapidMiner
Integrate Productboard data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build an OLAP Cube in SSAS from Cvent Data
Establish a connection to Cvent data data from SQL Server Analysis Services, and use the Cvent Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Microsoft Entra ID Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft Entra ID entities in PHP by modeling them as objects.
-
Object-Relational Mapping (ORM) with Oracle Eloqua Reporting 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 Oracle Eloqua Reporting data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Zoho Books Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Books replication to Azure SQL Database.
-
Connect to ActiveCampaign Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ActiveCampaign data in Airbyte.
-
Build a Singer.io Tap for Google Contacts With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Contacts data using the CData Python Connector.
-
Integrate Google's Vertex AI Agent with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP ByDesign data within intelligent workflows.
-
Work with Live Oracle Financials Cloud Data in Power Query
Use CData Connect AI to connect to Oracle Financials Cloud data and work with live Oracle Financials Cloud data in Microsoft Power Query.
-
Connect to Reckon Data in DBeaver
Use the CData ODBC Driver to connect to Reckon data in DBeaver.
-
Connect to Zoho Recruit in SpagoBI
Create reports featuring live Zoho Recruit data in SpagoBI Studio. Host Zoho Recruit reports on SpagoBI Server.
-
Automated Continuous YouTube Analytics Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable YouTube Analytics data replication to OneLake in Microsoft Fabric.
-
How to Visualize Samanage Data in Python with pandas
Use pandas and other modules to analyze and visualize live Samanage data in Python.
-
How to Seamlessly Import ZohoPeople Data into IBM SPSS Modeler
Integrate ZohoPeople data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to SAP Ariba Procurement Data in RapidMiner
Integrate SAP Ariba Procurement data with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Mailjet Data from PowerShell
Write a quick PowerShell script to query Mailjet data. Use connectivity to the live data to replicate Mailjet data to SQL Server.
-
Connect to Live Cloudant Data in MicroStrategy through CData Connect AI
Create a live connection to Cloudant Data in CData Connect AI and connect to your Cloudant data from MicroStrategy.
-
Connect to CSV Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for CSV data in Airbyte.
-
Use the CData Software ODBC Driver for Coinbase in MicroStrategy
Connect to Coinbase data in MicroStrategy Developer using the CData Software ODBC Driver for Coinbase.
-
Rapidly Develop Productboard-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 Productboard.
-
Import and Visualize Parallel Data in Power View
Create data visualizations based on Parallel data in Excel.
-
Integrate with Bitbucket Data in JReport Designer
Create charts and reports based on Bitbucket data in JReport Designer.
-
Create ZohoDesk-Connected Nintex Workflows
Use CData Connect AI to connect to ZohoDesk Data from Nintex Workflow Cloud and build custom workflows using live ZohoDesk data.
-
Connect to ConvertAPI Data in Ruby
Connect to ConvertAPI data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Zoho Books Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zoho Books data and build visualizations in Tableau.
-
Connecting Pipedream with Shopify 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 Shopify data in real time.
-
Access Live Dotmailer Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dotmailer data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Dash to Build to Web Apps on ServiceDesk Plus Data
Create Python applications that use pandas and Dash to build ServiceDesk Plus-connected web apps.
-
DataBind FTP Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for FTP with the DevExpress Windows Forms and Web controls to provide FTP data to a chart.
-
Easily Integrate Microsoft Dataverse Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Dataverse data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connecting Agentforce with Salesforce CRM Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Salesforce CRM Analytics data for you.
-
Build Apps with Live Freshservice Data Using the Low-Code Development Platform of Mendix
Connect Freshservice data with Mendix to build apps using the CData API Driver for JDBC.
-
Natively Connect to Jira Assets Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Jira Assets data. Leverage the native support for ODBC in PHP.
-
How to Work with TaxJar Data in AWS Glue Jobs Using JDBC
Connect to TaxJar from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate with Google Ad Manager Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Ad Manager data in SnapLogic.
-
Build AI Agents with Acumatica 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 Acumatica data through CData Connect AI.
-
Use Agno to Talk to Your SAS xpt 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 SAS xpt data for you.