CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Blackbaud FE NXT Replication to Databricks
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Databricks.
-
Build Automated SAP Business Warehouse-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Business Warehouse data and build automated workflows in Zapier.
-
Connect to Real-Time ConstantContact Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ConstantContact data in Power Apps.
-
Query Outlook Data as a MySQL Database in Node.js
Execute MySQL queries against Outlook data from Node.js.
-
How to connect to Google Ads Data from IntelliJ
Integrate connectivity to Google Ads data with wizards in IntelliJ.
-
How to Create Power BI Visual Reports with Real-Time Google Ad Manager Data
Use CData Power BI Connectors to visualize Google Ad Manager data in Power BI.
-
How to publish and share Webex Data dashboards with Tableau Server
The CData ODBC driver for Webex enables you integrate Webex data into Tableau dashboards.
-
Build Voice Agents in ElevenLabs with access to Live QuickBooks Time Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live QuickBooks Time data.
-
Connect to Billsby Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Billsby and work with Billsby data in your FileMaker applications.
-
Access xBase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live xBase data from HeidiSQL.
-
Stream Pushbullet Data into Apache Kafka Topics
Access and stream Pushbullet data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Manage Monday.com Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Monday.com.
-
Build MVC Applications with Connectivity to Copper Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Copper from an ASP.NET MVC application.
-
How to use SQLAlchemy ORM to access BigQuery Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of BigQuery data.
-
Use the CData Software ODBC Driver for Invoiced in SAS for Real-Time Reporting and Analytics
Connect to real-time Invoiced data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Invoiced.
-
Getting Started with the CData Power BI Connector for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP HANA XS Advanced.
-
Excel Spreadsheet Automation on Productboard Data with the QUERY Formula
Pull data from Productboard, automate spreadsheets, and more with the QUERY formula.
-
Integrate Cline with Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live IBM Cloud Object Storage data from within your IDE.
-
Build Voice Agents in ElevenLabs with access to Live FHIR Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live FHIR data.
-
Create Microsoft Teams Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft Teams from PowerBI.com to create Power BI Dataflows with real-time data.
-
Natively Connect to Dropbox Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Dropbox data. Leverage the native support for ODBC in PHP.
-
How to connect to Invoiced Data from Spring Boot
Connect to Invoiced in a Spring Boot Application using the CData API Driver for JDBC
-
DataBind Charts to Bullhorn CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bullhorn CRM 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.
-
Automated Continuous Microsoft Teams Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to PostgreSQL.
-
Create SAS Data Sets-Connected Dashboards in Grafana
Connect to SAS Data Sets Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAS Data Sets data.
-
Provide OData Services of Retently Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Retently data by developing a WCF Service Application.
-
Create a Data Access Object for Avaza Data using JDBI
A brief overview of creating a SQL Object API for Avaza data in JDBI.
-
Getting Started with the CData Excel Add-In for Clockify
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Clockify.
-
Connecting Moonlit Workflow with Freshservice 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 Freshservice data in real time.
-
How to create SAP Ariba Source federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Ariba Source data in MySQL .
-
Build Dashboards with Freshteam Data in DBxtra
Create dynamic dashboards and perform analytics based on Freshteam data in DBxtra.
-
Connect to Miro Data in CloverDX (formerly CloverETL)
Transfer Miro data using the visual workflow in the CloverDX data integration tool.
-
Connect CockroachDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CockroachDB data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build MVC Applications with Connectivity to CampaignMonitor Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CampaignMonitor from an ASP.NET MVC application.
-
Automated Continuous TaxJar Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable TaxJar replication to Amazon Redshift.
-
Connect to LeadDesk Data in NetBeans
Connect to LeadDesk data in NetBeans with the data source configuration wizard.
-
Integrate with Live MariaDB Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MariaDB from the MuleSoft Anypoint Platform to integrate live MariaDB data into custom reports and dashboards.
-
How to Seamlessly Import Deel Data into IBM SPSS Modeler
Integrate Deel data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Build an ETL App for Microsoft Dataverse Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Dataverse data in Python with petl and the CData Connect AI Python SDK.
-
Replicate PostgreSQL Data in Heroku for Use in Salesforce Connect
Replicate PostgreSQL data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Slack from Asprova with CData Software ODBC Driver for Slack
This article shows how to connect faster to Slack data from Asprova.
-
Load Google Forms Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Forms data to a database.
-
Access SendInBlue Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SendInBlue data from your Oracle system.
-
Connect to VWO Data from AWS Glue
Use CData Connect AI to gain access to live VWO data from your AWS Glue jobs.
-
How to connect to Oracle Data with Squirrel SQL client
Connect to Oracle data and execute queries in the Squirrel SQL Client.
-
Publish Reports with Active Directory Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Active Directory data.
-
Connect to Harvest Data from a Connection Pool in JBoss
Integrate Harvest data into Java servlets: Use the Management Console in JBoss to install the Harvest JDBC Driver.
-
Import Epicor Kinetic Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Epicor Kinetic Data and provide access to live Epicor Kinetic data for custom reports in the Power BI Service.
-
Use JayDeBeApi to access Slack Data in Python
Use standard Python scripting and the development environment of your choice to access live Slack data.
-
Integrate with Salesforce Pardot Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Salesforce Pardot data in SnapLogic.
-
Import Real-Time Sendwithus Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sendwithus data in ColdFusion.
-
Manage Microsoft OneDrive Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft OneDrive.
-
Getting Started with the CData SSIS Components for GitHub
Complete guide to installing, licensing, and connecting with the CData SSIS Components for GitHub.
-
Trigger IBM Informix IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for IBM Informix with standard wizards in Logic Apps.
-
Natively Connect to Salesforce Pardot Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce Pardot data. Leverage the native support for ODBC in PHP.
-
Integrate Browserless Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Browserless data from Informatica Cloud.
-
DataBind Charts to Beeminder Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Beeminder 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.
-
How to Build an ETL App for Salesloft Data in Python with CData
Create ETL applications and real-time data pipelines for Salesloft data in Python with petl.
-
Build Google Analytics-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Analytics data and build Google Analytics-connected web apps with Axios.
-
Create Informatica Mappings From/To an ODBC Data Source for Perplexity
Create an ODBC connection to Perplexity in Informatica and browse and transfer Perplexity data.
-
A PostgreSQL Interface for Twitter Ads Data using the CData ODBC Driver
Use the SQL Gateway and Twitter Ads ODBC Driver to create a PostgreSQL entry-point for data access.
-
View Reports on Real-Time Sybase IQ Data in Power BI Report Server
Use the CData ODBC Driver for Sybase IQ to visualize Sybase IQ data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Klaviyo-Connected Dashboards in Grafana
Connect to Klaviyo Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Klaviyo data.
-
Replicate REST Data from PowerShell
Write a quick PowerShell script to query REST data. Use connectivity to the live data to replicate REST data to SQL Server.
-
Build SAS xpt Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAS xpt data and build visualizations in Tableau.
-
How to Connect to Live Azure DevOps Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Azure DevOps data for you.
-
Integrate Live Reckon Accounts Hosted Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Reckon Accounts Hosted data from within the IDE.
-
Connect to Presto Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Presto and the SQL Gateway to access Presto data from Google Apps Script.
-
Automate Tickspot Data Replication to Azure Synapse
Use CData Sync to customize and automate Tickspot data replication to Azure Synapse.
-
How to import Dynamics NAV Data into Apache Solr
Use the CData Software JDBC Driver for Dynamics NAV in Data Import Handler and create an automated import of Dynamics NAV data to Apache Solr Enterprise Search platform.
-
Visualize Live PingOne Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PingOne data.
-
Getting Started with the CData Tableau Connector for Brex
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to connect PolyBase to Harvest
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Harvest data.
-
How to Query Jodoo Data in MySQL Workbench
Execute MySQL queries against live Jodoo data from MySQL Workbench.
-
Connect to Bitly Data in JRuby
Create a simple JRuby app with access to live Bitly data.
-
Visualize Square Data in Sisense
Create an ElastiCube in Sisense app with access to Square data.
-
Connect to GetResponse Data from Crystal Reports
Use CData Connect AI to connect to and report on live GetResponse data from Crystal Reports.
-
Build an OLAP Cube in SSAS from Webflow Data
Establish a connection to Webflow data data from SQL Server Analysis Services, and use the Webflow Data Provider to build OLAP cubes for use in analytics and reporting.
-
Add Google Drive Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Drive with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to and Visualize Live SharePoint Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SharePoint data.
-
How to connect to Float Data in DBVisualizer
Integrate Float data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Live Zendesk Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zendesk from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zendesk data.
-
How to connect to Clio Data in DBVisualizer
Integrate Clio data with visual data analysis tools and data connection wizards in DBVisualizer
-
View Reports on Real-Time Wrike Data in Power BI Report Server
Use the CData ODBC Driver for Wrike to visualize Wrike data in Power BI Desktop and then publish them to Power BI Report Server.
-
Link JobNimbus with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate JobNimbus data in Filemaker Pro for Mac or Windows.
-
Integrate Live Freshteam Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Freshteam data and integrate live Freshteam data into apps built in Microsoft Power Apps.
-
How to connect PolyBase to Invoiced
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Invoiced data.
-
Explore Geographical Relationships in Optimizely Data with Power Map
Create data visualizations with Optimizely data in Power Map.
-
Connect to Zuora Data from PowerBuilder via ADO.NET
This article demonstrates how to access Zuora data from Appeon PowerBuilder using the CData ADO.NET Provider for Zuora.
-
Build Apps with Live Google Calendar data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Calendar data into the Adalo platform and build custom mobile and web applications with real-time Google Calendar data.
-
Interact with Live Zoho Books Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Zoho Books data.
-
Connect to DB2 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for DB2 and the Script function in FileMaker Pro to connect to DB2 and work with DB2 data in your FileMaker application.
-
How to Query Paylocity Data in MySQL Workbench
Execute MySQL queries against live Paylocity data from MySQL Workbench.
-
Create DB2 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for DB2 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Vault CRM Replication to Oracle
Use CData Sync for automated, continuous, customizable Vault CRM replication to Oracle.
-
Integrate Theia IDE with Live PayPal 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 PayPal data from within the development environment.
-
Back Up LaunchDarkly data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with LaunchDarkly data data.
-
Integrate Live eBay Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to eBay from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live eBay data.
-
Query Live Amazon Marketplace 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 Amazon Marketplace data through a conversational interface.
-
Use Dash to Build Web Apps on SAP Concur Data via CData Connect AI
Build interactive Dash web apps on live SAP Concur data using pandas and the CData Connect AI Python SDK.