CData Software - Knowledge Base
Recent Articles
-
Viewing CSV Data in RAD Studio Data Explorer
How to view CSV data in RAD Studio Data Explorer using the CData ODBC Driver for CSV.
-
Automated Continuous Wrike Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Wrike data replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData Tableau Connector for SendPulse
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Back Up Grafana 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 Grafana data data.
-
Extract, Transform, and Load Google Directory Data in Informatica PowerCenter
Create a simple Workflow for Google Directory data in Informatica PowerCenter.
-
Connect Insightly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Insightly data using the CData Python MCP Server.
-
Query, Visualize, and Share live Trello Data in Redash
Use CData Connect AI to connect to live Trello data in Redash for querying, visualizing, and sharing.
-
Connect to Cloudant Data in CloverDX (formerly CloverETL)
Transfer Cloudant data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Harvest Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Harvest replication to PostgreSQL.
-
Feed Facebook Data into FineReport
How to set Facebook data as a JDBC data source in FineReport.
-
Automated Continuous xBase Replication to IBM DB2
Use CData Sync for automated, continuous, customizable xBase replication to IBM DB2.
-
Build Dashboards with Excel Online Data in Dundas BI
Create dynamic dashboards and perform analytics based on Excel Online data in Dundas BI.
-
Viewing Stack Exchange Data in RAD Studio Data Explorer
How to view Stack Exchange data in RAD Studio Data Explorer using the CData ODBC Driver for Stack Exchange.
-
Access Live Copper Data in AWS Lambda
Connect to live Copper data in AWS Lambda using the CData JDBC Driver.
-
Connect to Freshservice from a Connection Pool in WebLogic
Use the CData JDBC Driver for Freshservice to connect to Freshservice data from Web applications running on WebLogic.
-
Integrate ShipEngine Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to ShipEngine data and integrate live ShipEngine data into your Power Automate tasks.
-
Integrate Live Outlook Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Outlook data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Import Office 365 Data Using Azure Data Factory
Use CData Connect AI to connect to Office 365 Data from Azure Data Factory and import live Office 365 data.
-
Automated Continuous OnePageCrm Replication to SQL Server
Use CData Sync for automated, continuous, customizable OnePageCrm replication to SQL Server.
-
Build Data Flows from SAP Fieldglass to SQL Server using SSIS
Easily back up SAP Fieldglass data to SQL Server using the SSIS components for SAP Fieldglass.
-
Query, Visualize, and Share live Adobe Experience Manager Data in Redash
Use CData Connect AI to connect to live Adobe Experience Manager data in Redash for querying, visualizing, and sharing.
-
Connecting Agentforce with Amazon Athena 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 Amazon Athena data for you.
-
DataBind Controls to Microsoft Planner Data in Delphi
DataBind to Microsoft Planner data in Delphi with standard data access components and controls.
-
Automate Missive Data Replication to Azure Synapse
Use CData Sync to customize and automate Missive data replication to Azure Synapse.
-
How to Connect to Live Zoho Creator Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho Creator data securely in real time.
-
Analyze BenchmarkEmail Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for BenchmarkEmail from Power Pivot. You will use the Table Import Wizard to load BenchmarkEmail data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Teamwork Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Teamwork replication to delimited files (CSV/TSV).
-
Build MVC Applications with Connectivity to Notion Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Notion from an ASP.NET MVC application.
-
Connect to Exa Data in ACL Analytics
Connect to Exa data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Exa data.
-
Replicate Multiple ServiceDesk Plus Accounts
Replicate multiple ServiceDesk Plus accounts to one or many databases.
-
How to Visualize MYOB AccountRight Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live MYOB AccountRight data in Python.
-
Connect to Amazon DynamoDB Data in RazorSQL
Connect to Amazon DynamoDB from wizards and query Amazon DynamoDB data from the GUI in the RazorSQL database management tool.
-
Connect and Query Live Phoenix Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Phoenix data into Databricks and enable direct, live querying and analysis without replication.
-
Edit and Search External SAP Concur Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Concur data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Concur Data objects that you can access from apps and the dashboard.
-
Import Epicor Kinetic Data Using Azure Data Factory
Use CData Connect AI to connect to Epicor Kinetic Data from Azure Data Factory and import live Epicor Kinetic data.
-
How to create an RPA flow for Exa Data in UiPath Studio
Use the Exa ODBC Driver to create workflows that access real-time Exa data without any coding.
-
Publish Sentry-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sentry data.
-
How to publish and share Google Tasks Data dashboards with Tableau Server
The CData ODBC driver for Google Tasks enables you integrate Google Tasks data into Tableau dashboards.
-
Import Redis Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Redis Data and provide access to live Redis data for custom reports in the Power BI Service.
-
Query Vercel Data in DataGrip
Create a Data Source for Vercel in DataGrip and use SQL to query live Vercel data.
-
How to Connect to & Open Marketo Data in Microsoft Excel
This article uses the CData ODBC driver for Marketo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
DataBind Controls to Drip Data in Delphi
DataBind to Drip data in Delphi with standard data access components and controls.
-
Bridge Perigon Connectivity with Apache NiFi
Access and process Perigon data in Apache NiFi using the CData JDBC Driver.
-
Provide OData Services of Zoho Recruit Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho Recruit data by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for Reply.io in MicroStrategy
Connect to Reply.io data in MicroStrategy Developer using the CData Software ODBC Driver for Reply.io.
-
Build Airtable-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 Airtable data without replication.
-
Prepare, Blend, and Analyze Wistia Data in Alteryx Designer (Connect AI)
Build workflows to access live Wistia data for self-service data analytics.
-
Integrate Cursor with Live Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Active Directory data from within the editor.
-
Automated Continuous MYOB AccountRight Replication to SQL Server
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to SQL Server.
-
Publish Crystal Reports on ZohoExpense Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZohoExpense data.
-
Replicate Hacker News Data to Multiple Databases via the CData Sync CLI
Replicate Hacker News data to disparate databases with a single configuration.
-
LINQ to Microsoft Ads 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 Microsoft Ads Data Provider.
-
Analyze Webflow Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Webflow data with the CData JDBC Driver for Webflow.
-
Build Dashboards with SAP Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP data in DBxtra.
-
Automated Continuous LightSpeedRetail Replication to MongoDB
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to MongoDB.
-
Integrate with Live Microsoft Ads Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Ads from the MuleSoft Anypoint Platform to integrate live Microsoft Ads data into custom reports and dashboards.
-
Create Informatica Mappings From/To a JDBC Data Source for Tavily
Create Tavily data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Live Facebook Ads Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Facebook Ads data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Oracle Eloqua Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Oracle Eloqua data with the CData JDBC Driver for Oracle Eloqua.
-
Add TigerGraph Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for TigerGraph with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software ODBC Driver for Paylocity in MicroStrategy Desktop
Connect to Paylocity data in MicroStrategy Desktop using the CData Software ODBC Driver for Paylocity.
-
Access Live MongoDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MongoDB data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Basecamp Data in Google Apps Script via Connect AI
Use CData Connect AI to access Basecamp data in Google Apps Script.
-
Operational Reporting on Sybase IQ Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sybase IQ data.
-
Analyze Redis Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Redis data with the CData JDBC Driver for Redis.
-
Connecting GenSpark with Redis Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Redis data without any replication or custom integration required.
-
Connect to SharePoint Data in Claris FileMaker Pro
Use the CData ODBC Driver for SharePoint in FileMaker Pro to connect to SharePoint and work with SharePoint data in your FileMaker applications.
-
Create Basecamp Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Basecamp data access from reports, embedded analytics, and more.
-
Automated Continuous PabblySubscriptions Replication to Databricks
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Databricks.
-
Integrate Open WebUI with Live Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Asana data from within the chat interface.
-
A PostgreSQL Interface for Gumroad Data using the CData ODBC Driver
Use the SQL Gateway and Gumroad ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Visualize Live eBay Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live eBay data into the Databricks platform and create visualization dashboards with real-time eBay data.
-
Write a Simple Go Application to work with Drip Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Drip data.
-
How to Access Shopify Data Using Entity Framework
This article shows how to access Shopify data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Open WebUI with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Data Lake Storage data from within the chat interface.
-
Automated Continuous Scrapfly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Scrapfly replication to IBM DB2.
-
Work with Microsoft Dataverse Data in FoxPro
Load Microsoft Dataverse data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Phoenix Data in Heroku for Use in Salesforce Connect
Replicate Phoenix data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use Dash to Build to Web Apps on Sybase Data
Create Python applications that use pandas and Dash to build Sybase-connected web apps.
-
Build Visualizations of Oracle Eloqua Reporting Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle Eloqua Reporting data in Birst.
-
Integrate Live SAP Hybris C4C Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Hybris C4C from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Hybris C4C data.
-
Integrating ScrapingBee Data in Talend Cloud Data Management Platform
Connect ScrapingBee Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrating GitHub Copilot with FreeAgent 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 Connect the Power BI Service to Brex: Complete Guide
Connect to the CData Software Power BI Connector for Brex from PowerBI.com to provide real-time Brex data across the organization.
-
Visualize Testmonitor Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Testmonitor data.
-
Build AI/ML Models with Live Oracle Data using Dataiku
Connect Oracle Data with Dataiku using the CData JDBC Driver for Oracle.
-
Integrate Devin with Live Sugar CRM 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 Sugar CRM data.
-
Connect to BigCommerce Data in Claris FileMaker Pro
Use the CData ODBC Driver for BigCommerce in FileMaker Pro to connect to BigCommerce and work with BigCommerce data in your FileMaker applications.
-
How to Connect to Live LinkedIn Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live LinkedIn Ads data securely in real time.
-
Integrating GitHub Copilot with Notion 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.
-
Replicate Multiple GraphQL Accounts
Replicate multiple GraphQL accounts to one or many databases.
-
A PostgreSQL Interface for Microsoft Teams Data using the CData ODBC Driver
Use the SQL Gateway and Microsoft Teams ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Nethunt Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Nethunt data into TIBCO Spotfire.
-
Use CData Connect AI to Access BigCommerce Data in Microsoft Power Pivot
Use CData Connect AI to connect to live BigCommerce data in the Power Pivot business intelligence tool.
-
Create XML-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to XML Data from Klipfolio and build custom visualizations using live XML data.
-
Access Live Eventbrite Data in AWS Lambda
Connect to live Eventbrite data in AWS Lambda using the CData JDBC Driver.
-
Salesforce CRM Analytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Salesforce CRM Analytics data through CData Connect AI using different applications and tools.
-
Use the CData Software ODBC Driver for Perigon in MicroStrategy
Connect to Perigon data in MicroStrategy Developer using the CData Software ODBC Driver for Perigon.
-
Connect to Xero Data in HULFT Integrate
Connect to Xero as a JDBC data source in HULFT Integrate
-
Build Square-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Square data and build web apps with connectivity to live Square data.