CData Software - Knowledge Base
Recent Articles
-
Build a Simple VCL Application for Mailgun Data
How to build a simple VCL Application to view Mailgun data in RAD Studio using the CData ODBC Driver for Mailgun.
-
Integrate LibreChat with Live Tavily Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Tavily data from within the chat interface.
-
Replicate PDFMonkey Data from PowerShell
Write a quick PowerShell script to query PDFMonkey data. Use connectivity to the live data to replicate PDFMonkey data to SQL Server.
-
Explore Geographical Relationships in RabbitMQ Data with Power Map
Create data visualizations with RabbitMQ data in Power Map.
-
Connect PDFMonkey Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PDFMonkey data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Marketo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Marketo data in the Denodo Virtual DataPort Administrator.
-
Automate Adobe Analytics Data Replication to Couchbase
Use CData Sync to Customize and automate Adobe Analytics data replication to Couchbase.
-
Consume RSS OData Feeds in SAP Lumira
Use the API Server to create data visualizations on RSS feeds that reflect any changes in SAP Lumira.
-
Replicate Multiple SAP Business One Accounts via the CData Sync CLI
Replicate multiple SAP Business One accounts to one or many databases.
-
Connecting Agentforce with Zoho Inventory 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 Zoho Inventory data for you.
-
Use the CData Software JDBC Driver for Yelp in MicroStrategy Web
Connect to Yelp data in MicroStrategy Web using the CData Software JDBC Driver for Yelp.
-
Use the CData Software ODBC Driver for Zoom in MicroStrategy Web
Connect to Zoom data in MicroStrategy Web using the CData Software ODBC Driver for Zoom.
-
Integrate Trae with Live Neo4J Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Neo4J data from within the AI-powered IDE.
-
Build a PostgreSQL Interface for Invoiced Data using the CData JDBC Driver
Use the Remoting features of the Invoiced JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build FHIR-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to FHIR data and build web apps with connectivity to live FHIR data.
-
Build Automated Workflows with Live Google Ad Manager Data in Workato
Use CData Connect AI to connect to live Google Ad Manager data and build automated workflows in Workato.
-
Getting Started with the CData Power BI Connector for Postmark
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData Python Connector for Pipedrive
Learn to install and license the CData Python Connector and configure a connection to live Pipedrive data.
-
How to connect to Lakebase Data from Spring Boot
Connect to Lakebase in a Spring Boot Application using the CData JDBC Driver for Lakebase
-
Build Charts with Invoiced Data in Clear Analytics
Create dynamic charts and perform analytics based on Invoiced data in Clear Analytics.
-
Create Reports from Campaigner Data in Looker Studio
Use CData Connect AI to gain access to live Campaigner data and create custom reports in Looker Studio.
-
Build Agents in Relevance AI with Access to Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on QuickBooks Time data within intelligent agent workflows.
-
Analyze HDFS Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze HDFS data in Microsoft R Open.
-
Connect to Live Microsoft Planner Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Microsoft Planner in CData Connect AI and connect to your Microsoft Planner data from PostgreSQL.
-
Connecting Moonlit Workflow with TaxJar 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 TaxJar data in real time.
-
How to Build an ETL App for Splunk Data in Python with CData
Create ETL applications and real-time data pipelines for Splunk data in Python with petl.
-
Use Dash to Build Web Apps on AfterShip Data via CData Connect AI
Build interactive Dash web apps on live AfterShip data using pandas and the CData Connect AI Python SDK.
-
Connect to Rebilly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Rebilly as an External Source in Dremio.
-
Visualize Microsoft OneDrive Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft OneDrive data.
-
Create Dynamic Mistral AI Grids Using the Infragistics XamDataGrid
Learn how you can connect Mistral AI to Infragistics XamDataGrid to build dynamic grids.
-
Analyze ZohoExpense Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZohoExpense from Power Pivot. You will use the Table Import Wizard to load ZohoExpense data. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Cursor with QuickBooks 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.
-
How to Build an ETL App for Azure Synapse Data in Python with CData
Create ETL applications and real-time data pipelines for Azure Synapse data in Python with petl.
-
Connect to Quaderno Data in DBArtisan
Use wizards in DBArtisan to configure Quaderno data as a data source.
-
Automated Continuous Gumroad Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Gumroad replication to IBM DB2.
-
Connect to CapsuleCRM Data from a Connection Pool in JBoss
Integrate CapsuleCRM data into Java servlets: Use the Management Console in JBoss to install the CapsuleCRM JDBC Driver.
-
Excel Spreadsheet Automation on Dotmailer Data with the QUERY Formula
Pull data from Dotmailer, automate spreadsheets, and more with the QUERY formula.
-
Integrating Boomi Agentstudio with ShipEngine Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to ShipEngine data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Live Microsoft Ads Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft Ads data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Power BI Reports on Real-Time Excel Data
Use the CData ODBC Driver for Excel to visualize Excel data in Power BI Desktop.
-
Create Informatica Mappings From/To an ODBC Data Source for ZarMoney
Create an ODBC connection to ZarMoney in Informatica and browse and transfer ZarMoney data.
-
Feed Paymo Data into FineReport
How to set Paymo data as a JDBC data source in FineReport.
-
Use the CData ODBC Driver for Avaza from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Avaza to connect to Avaza data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Avaza data in Excel.
-
Connect to ElevenLabs from Asprova with CData Software ODBC Driver for ElevenLabs
This article shows how to connect faster to ElevenLabs data from Asprova.
-
Build Apps with Live FTP data in Adalo using CData Connect AI
Use CData Connect AI to integrate live FTP data into the Adalo platform and build custom mobile and web applications with real-time FTP data.
-
Connect and Query Live Azure Data Lake Storage Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Data Lake Storage data into Databricks and enable direct, live querying and analysis without replication.
-
Use the CData Software JDBC Driver for Freshteam in MicroStrategy Web
Connect to Freshteam data in MicroStrategy Web using the CData Software JDBC Driver for Freshteam.
-
Connect to Google Directory from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Directory data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use Dash to Build to Web Apps on Teamwork Data
Create Python applications that use pandas and Dash to build Teamwork-connected web apps.
-
Use the CData ODBC Driver for Raisers Edge NXT from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Raisers Edge NXT to connect to Raisers Edge NXT data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Raisers Edge NXT data in Excel.
-
Migrating data from Bitbucket to Snowflake using CData SSIS Components.
Easily push Bitbucket data to Snowflake using the CData SSIS Tasks for Bitbucket and Snowflake.
-
Build Amazon Marketplace-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 Amazon Marketplace data without replication.
-
Build Samanage-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 Samanage data without replication.
-
Access Live RSS Feeds in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live RSS feeds from your Excel spreadsheets.
-
Automate Pinecone Data Replication to Azure Data Lake
Use CData Sync to customize and automate Pinecone data replication to Azure Data Lake.
-
Connect to Cloudant Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Cloudant and the SQL Gateway to access Cloudant data from Google Apps Script.
-
Connect to Xero Data in Jaspersoft Studio
Execute SQL to remote Xero data in Jaspersoft Studio.
-
Back Up Authorize.Net data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Authorize.Net. In this article, we will employ an SSIS workflow to populate a database with Authorize.Net data data.
-
Analyze Greenhouse Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Greenhouse data and visualize live Greenhouse data in Infragistics Reveal.
-
Integrate Live Act CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Act CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Act CRM data.
-
Build SageHR-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SageHR data and build SageHR-connected web apps with Axios.
-
Automated Continuous Gong Replication to Snowflake
Use CData Sync for automated, continuous, customizable Gong replication to Snowflake.
-
Automated Continuous CapsuleCRM Replication to Databricks
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Databricks.
-
Build Automated Workflows with Live SFTP Data in Workato
Use CData Connect AI to connect to live SFTP data and build automated workflows in Workato.
-
Connect to JobNimbus from Asprova with CData Software ODBC Driver for JobNimbus
This article shows how to connect faster to JobNimbus data from Asprova.
-
Connect to Outlook Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Outlook data in the Denodo Virtual DataPort Administrator.
-
Build AI/ML Models with Live Salesforce Marketing Data using Dataiku
Connect Salesforce Marketing Data with Dataiku using the CData JDBC Driver for Salesforce Marketing.
-
Build Apps with Live Twilio data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Twilio data into the Adalo platform and build custom mobile and web applications with real-time Twilio data.
-
Publish Reports with LightSpeedRetail Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LightSpeedRetail data.
-
Rapidly Develop Aha!-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 Aha!.
-
How to Work with FHIR Data in ETL Validator JDBC
Connect to FHIR from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate Zoho Creator Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho Creator data replication to Azure Data Lake.
-
Automated Continuous SAP Fieldglass Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Amazon Redshift.
-
How to load TigerGraph data into Elasticsearch via Logstash
Introducing a simple method to load TigerGraph data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Dashboards with BigQuery Data in DBxtra
Create dynamic dashboards and perform analytics based on BigQuery data in DBxtra.
-
Integrate Devin with Live Epicor Kinetic Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Epicor Kinetic data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pushbullet
Provide connectivity to Pushbullet data through an SAP BusinessObjects universe.
-
Migrating data from Anaplan to Google BigQuery using CData SSIS Components.
Easily push Anaplan data to Google BigQuery using the CData SSIS Tasks for Anaplan and Google BigQuery.
-
Integrate Odoo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Odoo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Odoo data.
-
Integrate Google's Vertex AI Agent with Live SAP BusinessObjects BI 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 BusinessObjects BI data within intelligent workflows.
-
Operational Reporting on Egnyte Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Egnyte data.
-
Build Apps with Live ZarMoney Data Using the Low-Code Development Platform of Mendix
Connect ZarMoney data with Mendix to build apps using the CData API Driver for JDBC.
-
Analyze Microsoft Planner Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft Planner Data from Cognos Analytics and analyze live Microsoft Planner data.
-
Feed Azure Synapse Data into FineReport
How to set Azure Synapse data as a JDBC data source in FineReport.
-
Add Wistia Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Wistia with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect Flowise AI Agents to Live Moosend 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 Moosend data without replication.
-
How to update Act CRM from Excel
This article explains how to transfer data from Excel to Act CRM using the Excel Add-In for Act CRM.
-
Connect to PabblySubscriptions Data in Jaspersoft Studio
Execute SQL to remote PabblySubscriptions data in Jaspersoft Studio.
-
How to Connect to Live Freshservice 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 Freshservice data for you.
-
Access Live Microsoft Entra ID Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Entra ID data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Mailjet-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Mailjet Data from Zoho Analytics and import live Mailjet data.
-
Visualize Live Datadog Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Datadog data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build AI/ML Models with Live ZohoDesk Data using Dataiku
Connect ZohoDesk Data with Dataiku using the CData API Driver for JDBC.
-
Elasticsearch Reporting in OBIEE with the Elasticsearch JDBC Driver
Deploy the Elasticsearch JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Campaigner Data in Talend Cloud Data Management Platform
Connect Campaigner Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Vercel
Provide connectivity to Vercel data through an SAP BusinessObjects universe.
-
Connecting GenSpark with Salesforce Pardot Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Salesforce Pardot data without any replication or custom integration required.
-
Validate Adobe Target Data with QuerySurge
Access and validate Adobe Target data in QuerySurge using the CData JDBC Driver.
-
Process & Analyze Amazon S3 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Amazon S3 Data.
-
Connect Facebook Ads to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Facebook Ads with IBM WebSphere for seamless data integration and connectivity.