CData Software - Knowledge Base
Recent Articles
-
Connect to BigQuery Data in DBArtisan
Use wizards in DBArtisan to configure BigQuery data as a data source.
-
Visualize Live FreeAgent Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live FreeAgent data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Apps with Live Highrise data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Highrise data into the Adalo platform and build custom mobile and web applications with real-time Highrise data.
-
Build Google Ads-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Ads data.
-
Migrating data from Clio to Snowflake using CData SSIS Components.
Easily push Clio data to Snowflake using the CData SSIS Tasks for Clio and Snowflake.
-
Analyze Google Analytics Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Analytics data and visualize live Google Analytics data in Infragistics Reveal.
-
How to Visualize Redshift Data in Python with pandas
Use pandas and other modules to analyze and visualize live Redshift data in Python.
-
Connect to JotForm Data in NetBeans
Connect to JotForm data in NetBeans with the data source configuration wizard.
-
How to integrate Metabase with Basecamp Data
Use CData Connect AI to connect to live Basecamp data and create an interactive dashboard in Metabase from Basecamp data.
-
Integrate with HDFS Data in JReport Designer
Create charts and reports based on HDFS data in JReport Designer.
-
Use the CData ODBC Driver for Facebook Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Facebook Ads to connect to Facebook Ads data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Facebook Ads data in Excel.
-
Use the CData ODBC Driver for Act-On from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Act-On to connect to Act-On data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Act-On data in Excel.
-
Work with ZendeskSell Data in FoxPro
Load ZendeskSell data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Using the CData Software ODBC Driver for ServiceDesk Plus in PyCharm
Connect to ServiceDesk Plus as an ODBC data source in PyCharm using the CData Software ODBC Driver for ServiceDesk Plus.
-
Access Live Suadeo 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 Suadeo data through MCP integration.
-
Create Informatica Mappings From/To a JDBC Data Source for Invoiced
Create Invoiced data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Replicate Google Contacts Data to Multiple Databases
Replicate Google Contacts data to disparate databases with a point-and-click configuration.
-
How to integrate SAP ByDesign with Apache Airflow
Access and process SAP ByDesign data in Apache Airflow using the CData JDBC Driver.
-
How to Build an ETL App for MailerSend Data in Python with CData
Create ETL applications and real-time data pipelines for MailerSend data in Python with petl.
-
Build Dashboards with SAP Hybris C4C Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Hybris C4C data in DBxtra.
-
Analyze Amplitude Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Amplitude data with the CData JDBC Driver for Amplitude.
-
Automated Continuous GraphQL Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable GraphQL replication to PostgreSQL.
-
Trigger Odoo IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Odoo with standard wizards in Logic Apps.
-
Connect to Bitly Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Bitly and work with Bitly data in your FileMaker application.
-
Automated Continuous MailerLite Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MailerLite replication to Apache Kafka.
-
Import Monday.com Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Monday.com Data and provide access to live Monday.com data for custom reports in the Power BI Service.
-
Connect to Eventbrite Data in RapidMiner
Integrate Eventbrite data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to Printify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Printify data. Leverage the pyodbc module for ODBC in Python.
-
Use Azure AI Foundry to Talk to Your Oracle Service Cloud 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 Oracle Service Cloud data for you.
-
Process & Analyze Chargebee Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Chargebee Data.
-
How to Visualize Jira Assets Data in Python with pandas
Use pandas and other modules to analyze and visualize live Jira Assets data in Python.
-
Consume Pipedrive OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Pipedrive feeds that reflect any changes in SAP Lumira.
-
Build AI Agents with Email 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 Email data through CData Connect AI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ZarMoney
Provide connectivity to ZarMoney data through an SAP BusinessObjects universe.
-
Integrate Theia IDE with Live Typeform Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Typeform data from within the development environment.
-
Write a Simple Go Application to work with Foursquare Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Foursquare data.
-
Build a Simple VCL Application for HCL Domino Data
How to build a simple VCL Application to view HCL Domino data in RAD Studio using the CData ODBC Driver for HCL Domino.
-
Replicate Multiple Zoho Books Accounts
Replicate multiple Zoho Books accounts to one or many databases.
-
Integrate with Databricks Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Databricks data in SnapLogic.
-
Create Email-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Email Data from Klipfolio and build custom visualizations using live Email data.
-
Import Real-Time SAP BusinessObjects BI Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP BusinessObjects BI data in ColdFusion.
-
Automated Continuous Reply.io Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Reply.io replication to Amazon Redshift.
-
Analyze Live Smartsheet Data in SAS Viya
Use CData Connect AI to connect to Smartsheet data from SAS Viya and deploy self-service analytics using live Smartsheet data.
-
Connect to Vercel Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Vercel as an External Source in Dremio.
-
Build Pipelines with Live Zoho Books Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Zoho Books from Google Cloud Data Fusion, enabling the integration of live Zoho Books data into the building and management of effective data pipelines.
-
Visualize Live Landbot Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Landbot data.
-
Query Wave Financial Data as a MySQL Database in Node.js
Execute MySQL queries against Wave Financial data from Node.js.
-
Create Dynamic Retently Grids Using the Infragistics XamDataGrid
Learn how you can connect Retently to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect Flowise AI Agents to Live HBase Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live HBase data without replication.
-
Connect to HBase from a Connection Pool in WebLogic
Use the CData JDBC Driver for HBase to connect to HBase data from Web applications running on WebLogic.
-
Add Cohere Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Cohere with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Eventbrite in SpagoBI
Create reports featuring live Eventbrite data in SpagoBI Studio. Host Eventbrite reports on SpagoBI Server.
-
Connect to Zoho CRM Data in DBArtisan
Use wizards in DBArtisan to configure Zoho CRM data as a data source.
-
Access Oracle Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle data from HeidiSQL.
-
Analyze Live Reckon Accounts Hosted Data in SAS Viya
Use CData Connect AI to connect to Reckon Accounts Hosted data from SAS Viya and deploy self-service analytics using live Reckon Accounts Hosted data.
-
Automated Continuous Jodoo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Jodoo replication to SQL Server.
-
Build a PostgreSQL Interface for Mode Data using the CData JDBC Driver
Use the Remoting features of the Mode JDBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Humanity Data in Power BI Report Server
Use the CData ODBC Driver for Humanity to visualize Humanity data in Power BI Desktop and then publish them to Power BI Report Server.
-
Edit and Search External Oracle Service Cloud Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Oracle Service Cloud data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Oracle Service Cloud Data objects that you can access from apps and the dashboard.
-
Create Mistral AI Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Mistral AI from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Parallel Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Parallel data replication to OneLake in Microsoft Fabric.
-
Integrate CampaignMonitor Data in the Pentaho Report Designer
Publish reports based on CampaignMonitor data in the Pentaho BI tool.
-
Build AI/ML Models with Live Exa Data using Dataiku
Connect Exa Data with Dataiku using the CData API Driver for JDBC.
-
How to Visualize Hacker News Data in Python with pandas
Use pandas and other modules to analyze and visualize live Hacker News data in Python.
-
Link Jumpseller with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Jumpseller data in Filemaker Pro for Mac or Windows.
-
Automated Continuous ServiceDesk Plus Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to PostgreSQL.
-
Connect to Mistral AI Data in CloverDX (formerly CloverETL)
Transfer Mistral AI data using the visual workflow in the CloverDX data integration tool.
-
How to import Azure Analysis Services Data into Apache Solr
Use the CData Software JDBC Driver for Azure Analysis Services in Data Import Handler and create an automated import of Azure Analysis Services data to Apache Solr Enterprise Search platform.
-
Use ChatGPT to Talk to Your Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Sage Intacct data for you.
-
How to connect to Sentry Data from Spring Boot
Connect to Sentry in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze SAP Netweaver Gateway Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SAP Netweaver Gateway data with the CData JDBC Driver for SAP Netweaver Gateway.
-
Access Live Microsoft OneDrive Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft OneDrive data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live Jira 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 Jira data for you.
-
Getting Started with the CData Power BI Connector for ZohoPeople
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to JSON Services from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live JSON services from Filemaker Pro on Mac.
-
Integrating Antigravity CLI with Bitbucket data via CData CLI
Connect Bitbucket data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Microsoft Entra ID Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to SQLite.
-
Choosing the Best Method to Connect AfterShip to SQL Server: 5 Options Explained
Discover multiple ways to connect and use AfterShip data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect Dynamics 365 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Dynamics 365 data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create ShipStation-Connected Applications in Appsmith
Connect to ShipStation Data via CData Connect AI in Appsmith and create custom business applications with real-time access to ShipStation data.
-
Autopilot Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Autopilot facts in real time.
-
Integrate Open WebUI with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Phoenix data from within the chat interface.
-
Build Semantic Layer Views for Google Sheets Data in APOS Live Data Gateway
Use the CData Connector for Google Sheets in APOS Live Data Gateway to build Semantic Layer Views for Google Sheets data.
-
Automated Continuous Microsoft Dataverse Replication to Snowflake
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Snowflake.
-
Integrating Codex with ConvertKit 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 Rootly Data from MySQL in Amazon QuickSight
Connect to Rootly and build visualizations of Rootly data using a MySQL Connection in Amazon QuickSight.
-
Use Dash to Build Web Apps on Mode Data via CData Connect AI
Build interactive Dash web apps on live Mode data using pandas and the CData Connect AI Python SDK.
-
DataBind Charts to Wrike Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Wrike data 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.
-
Integrate Goose with Live ZohoDesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ZohoDesk data from within the local AI agent.
-
Connect to Neo4J Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Neo4J Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Live Google Campaign Manager 360 Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google Campaign Manager 360 data through MCP integration.
-
Replicate QuickBooks Online Data in Heroku for Use in Salesforce Connect
Replicate QuickBooks Online data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
DataBind Slack Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Slack with the DevExpress Windows Forms and Web controls to provide Slack data to a chart.
-
Build Apps with Live Google Calendar Data Using the Low-Code Development Platform of Mendix
Connect Google Calendar data with Mendix to build apps using the CData JDBC Driver for Google Calendar.
-
Easily Integrate eBay Analytics Data in Lazarus Pascal IDE
Learn how to easily integrate live eBay Analytics data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
DataBind Controls to HubDB Data in Delphi
DataBind to HubDB data in Delphi with standard data access components and controls.
-
Visualize Live CockroachDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live CockroachDB data into custom reports in Power BI.
-
Build Dashboards with Klaviyo Data in DBxtra
Create dynamic dashboards and perform analytics based on Klaviyo data in DBxtra.
-
Integrating Antigravity CLI with ChartMogul data via CData CLI
Connect ChartMogul data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build AI/ML Models with Live Zendesk Data using Dataiku
Connect Zendesk Data with Dataiku using the CData JDBC Driver for Zendesk.