CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Vercel Replication to SQL Server
Use CData Sync for automated, continuous, customizable Vercel replication to SQL Server.
-
Connect to and Visualize Live HubSpot Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live HubSpot data.
-
Use the CData Software JDBC Driver for Pipeliner CRM in MicroStrategy Desktop
Connect to Pipeliner CRM data in MicroStrategy Desktop using the CData Software JDBC Driver for Pipeliner CRM.
-
Connect to SAP Hybris C4C from Asprova with CData Software ODBC Driver for SAP Hybris C4C
This article shows how to connect faster to SAP Hybris C4C data from Asprova.
-
Automated Continuous Testmonitor Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Testmonitor replication to Google Cloud SQL.
-
Integrate Open WebUI with Live Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Spark data from within the chat interface.
-
Integrate with live Oracle Data in Jitterbit
Use CData Connect AI to connect to and integrate live Oracle data in Jitterbit.
-
How to Connect Flowise AI Agents to Live Salesforce Marketing 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 Salesforce Marketing data without replication.
-
Build Visualizations of CampaignMonitor Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CampaignMonitor data in Birst.
-
Connect to Auth0 Data in Ruby
Connect to Auth0 data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData ODBC Driver for JobNimbus
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for JobNimbus.
-
Visualize Cassandra Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Cassandra data.
-
How to Easily Query MailerLite Data in OpenOffice Base
Connect to MailerLite data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect Oracle SCM Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Oracle SCM data in real time using natural language.
-
Visualize Everhour Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Everhour data.
-
Visualize Webflow Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Webflow data.
-
Analyze Snapchat Ads Data in Cognos Analytics
Use CData Connect AI to connect to Snapchat Ads Data from Cognos Analytics and analyze live Snapchat Ads data.
-
Build Dashboards with PostgreSQL Data in DBxtra
Create dynamic dashboards and perform analytics based on PostgreSQL data in DBxtra.
-
How to Connect to Live Sage 300 Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Sage 300 data for you.
-
Integrate Live SAP SuccessFactors LMS Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP SuccessFactors LMS data and integrate live SAP SuccessFactors LMS data into apps built in Microsoft Power Apps.
-
Validate Hacker News Data with QuerySurge
Access and validate Hacker News data in QuerySurge using the CData JDBC Driver.
-
Build Azure Analysis Services-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Analysis Services data.
-
A PostgreSQL Interface for Discord Data (MySQL Remoting via JDBC)
Use the Remoting features of the Discord JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Automated ZohoSubscriptions-Connected Workflows in Zapier
Use CData Connect AI to connect to live ZohoSubscriptions data and build automated workflows in Zapier.
-
Automated Continuous Sage 300 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sage 300 replication to Apache Cassandra.
-
How to Work with Simplesat Data in AWS Glue Jobs Using JDBC
Connect to Simplesat from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Live Pinterest Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Pinterest data to Blue Prism using the CData ODBC Driver for Pinterest to create automated workflows for repetitive business tasks.
-
Build Oracle HCM Cloud-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle HCM Cloud data.
-
Migrating data from XML to Databricks using CData SSIS Components.
Easily push XML data to Databricks using the CData SSIS Tasks for XML and Databricks.
-
Automated Continuous Templated Replication to Snowflake
Use CData Sync for automated, continuous, customizable Templated replication to Snowflake.
-
Migrating data from MySQL to Databricks using CData SSIS Components.
Easily push MySQL data to Databricks using the CData SSIS Tasks for MySQL and Databricks.
-
Connect to LeadDesk in SpagoBI
Create reports featuring live LeadDesk data in SpagoBI Studio. Host LeadDesk reports on SpagoBI Server.
-
Connect to SurveyMonkey Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SurveyMonkey as an External Source in Dremio.
-
Integrate Goose with Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Authorize.Net data from within the local AI agent.
-
Build Dashboards with SAS Data Sets Data in DBxtra
Create dynamic dashboards and perform analytics based on SAS Data Sets data in DBxtra.
-
Replicate Testmonitor Data in Heroku for Use in Salesforce Connect
Replicate Testmonitor data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build an OLAP Cube in SSAS from Shippo Data
Establish a connection to Shippo data data from SQL Server Analysis Services, and use the Shippo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Spark Data in Excel 365 Online (Excel for the web)
Connect to Spark data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Kintone Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Kintone data access from reports, embedded analytics, and more.
-
Connect to Lakebase Data from a Connection Pool in Jetty
The Lakebase JDBC Driver supports connection pooling: This article shows how to connect faster to Lakebase data from Web apps in Jetty.
-
Use the CData Software JDBC Driver for Amplitude in MicroStrategy
Connect to Amplitude data in MicroStrategy Developer using the CData Software JDBC Driver for Amplitude.
-
Validate FHIR Data with QuerySurge
Access and validate FHIR data in QuerySurge using the CData JDBC Driver.
-
Integrate Live Avalara AvaTax Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Avalara AvaTax from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Avalara AvaTax data.
-
Query Oracle Sales Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Sales data.
-
Integrate Live Pinterest 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 Pinterest data from within the IDE.
-
How to load Templated data into Elasticsearch via Logstash
Introducing a simple method to load Templated data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to MongoDB Data from Crystal Reports
Use CData Connect AI to connect to and report on live MongoDB data from Crystal Reports.
-
Automated Continuous Highrise Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Highrise replication to Azure SQL Database.
-
How to connect and process Elasticsearch data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Elasticsearch data.
-
Integrating Dataiku with Figshare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Figshare data.
-
Operational Reporting on Microsoft Dataverse Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Dataverse data.
-
How to create Visio diagrams from SAP Business One Data
Automatically update SAP Business One data with the changes you make to Visio master shapes.
-
Getting Started with the CData ADO.NET Provider for Landbot
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Semantic Layer Views for Sendwithus Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sendwithus data.
-
LINQ to Bright Data 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 Bright Data Data Provider.
-
Replicate MailerLite Data from PowerShell
Write a quick PowerShell script to query MailerLite data. Use connectivity to the live data to replicate MailerLite data to SQL Server.
-
Creating Trello-Connected Applications in Unqork
You can use CData Connect AI to feed Trello data to Unqork and build custom business apps.
-
Connect to Pipedrive Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Pipedrive data using standard SQL.
-
Connect to NetSuite Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live NetSuite data.
-
Automated Continuous Apify Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apify data replication to OneLake in Microsoft Fabric.
-
Validate ClickUp Data with QuerySurge
Access and validate ClickUp data in QuerySurge using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Dynamics NAV in MicroStrategy Desktop
Connect to Dynamics NAV data in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics NAV.
-
Getting Started with the CData Excel Add-In for Spotify
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Spotify.
-
Analyze Couchbase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Couchbase data in Microsoft R Open.
-
View Reports on Real-Time Todoist Data in Power BI Report Server
Use the CData ODBC Driver for Todoist to visualize Todoist data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Clari from a Connection Pool in WebLogic
Use the CData JDBC Driver for Clari to connect to Clari data from Web applications running on WebLogic.
-
Migrating data from Nethunt to Snowflake using CData SSIS Components.
Easily push Nethunt data to Snowflake using the CData SSIS Tasks for Nethunt and Snowflake.
-
Build Charts with Oracle Data in Clear Analytics
Create dynamic charts and perform analytics based on Oracle data in Clear Analytics.
-
Use the CData Software ODBC Driver for FTP in SAS for Real-Time Reporting and Analytics
Connect to real-time FTP data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for FTP.
-
Use Agno to Talk to Your Act CRM 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 Act CRM data for you.
-
Connect to MariaDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for MariaDB and the Script function in FileMaker Pro to connect to MariaDB and work with MariaDB data in your FileMaker application.
-
DataBind Controls to Freshservice Data in C++Builder
DataBind to Freshservice data in C++Builder with standard components and controls.
-
Connect to GitLab Data in DBArtisan
Use wizards in DBArtisan to configure GitLab data as a data source.
-
Replicate Multiple Salesforce Pardot Accounts via the CData Sync CLI
Replicate multiple Salesforce Pardot accounts to one or many databases.
-
Analyze FHIR Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of FHIR data and visualize live FHIR data in Infragistics Reveal.
-
Back Up Toggl 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 Toggl data data.
-
Connect to Apollo Data in HULFT Integrate
Connect to Apollo as a JDBC data source in HULFT Integrate
-
Replicate Multiple Typeform Accounts
Replicate multiple Typeform accounts to one or many databases.
-
DataBind Hive Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Hive with the DevExpress Windows Forms and Web controls to provide Hive data to a chart.
-
Build a Simple VCL Application for Mouseflow Data
How to build a simple VCL Application to view Mouseflow data in RAD Studio using the CData ODBC Driver for Mouseflow.
-
Create SSAS Tabular Models from Workday Data
How to build a SQL Server Analysis Service Tabular Model from Workday data using CData drivers.
-
Integrating Antigravity CLI with Cloudflare data via CData CLI
Connect Cloudflare data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to HubSpot Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live HubSpot data.
-
Query Zoho Projects Data in DataGrip
Create a Data Source for Zoho Projects in DataGrip and use SQL to query live Zoho Projects data.
-
Perform Batch Operations with Oracle Service Cloud Data in Apache NiFi
Connect to Oracle Service Cloud data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Working with Blackbaud FE NXT Data in LINQPad
Execute LINQ queries to Blackbaud FE NXT data in LINQPad.
-
How to Connect to Live CSV 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 CSV data for you.
-
Connect to SAP Business Warehouse Data in HULFT Integrate
Connect to SAP Business Warehouse as a JDBC data source in HULFT Integrate
-
Integrate SparkPost Data in the Pentaho Report Designer
Publish reports based on SparkPost data in the Pentaho BI tool.
-
Integrate Trae with Live HDFS Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live HDFS data from within the AI-powered IDE.
-
How to Create Power BI Visual Reports with Real-Time Humanity Data
Use CData Power BI Connectors to visualize Humanity data in Power BI.
-
Extract, Transform, and Load Webflow Data in Informatica PowerCenter
Create a simple Workflow for Webflow data in Informatica PowerCenter.
-
Automated Continuous ChargeOver Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ChargeOver replication to IBM DB2.
-
Process & Analyze SAP Fieldglass Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Fieldglass Data.
-
Integrating Dataiku with Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Jira Assets data.
-
Process & Analyze SurveyMonkey Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SurveyMonkey Data.
-
Use ChatGPT to Talk to Your Google Ads 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 Google Ads data for you.
-
Use the CData SSIS Components to Insert New or Update Existing Google Calendar Records from SQL Server
Easily push SQL Server data to Google Calendar using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Calendar or update existing records with data from a SQL Server database.
-
Feed Clari Data into FineReport
How to set Clari data as a JDBC data source in FineReport.
-
How to Create Power BI Visual Reports with Real-Time ConvertKit Data
Use CData Power BI Connectors to visualize ConvertKit data in Power BI.