CData Software - Knowledge Base
Recent Articles
-
Connect to Blackbaud FE NXT in SpagoBI
Create reports featuring live Blackbaud FE NXT in SpagoBI Studio. Host Blackbaud FE NXT reports on SpagoBI Server.
-
Build MVC Applications with Connectivity to Raisers Edge NXT Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Raisers Edge NXT from an ASP.NET MVC application.
-
How to Use a Microsoft Access Database to Update Cvent Data in Real Time
Update Cvent data by creating a linked table in Microsoft Access with the CData Cvent ODBC Driver.
-
Getting Started with the CData Python Connector for LinkedIn
Learn to install and license the CData Python Connector
-
Access Live Pipedrive Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Pipedrive from your Google Sheets.
-
Query HubSpot Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume HubSpot entities in PHP by modeling them as objects.
-
Use the CData ODBC Driver for CouchDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CouchDB to connect to Apache CouchDB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache CouchDB in Excel.
-
How to Connect to Live IBM Cloud Object Storage Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your IBM Cloud Object Storage for you.
-
Automated Continuous Mailgun Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Mailgun replication to delimited files (CSV/TSV).
-
Connect to SAS Data Sets in SpagoBI
Create reports featuring live SAS Data Sets in SpagoBI Studio. Host SAS Data Sets reports on SpagoBI Server.
-
Integrating Antigravity CLI with Twitter Ads via CData CLI
Connect Twitter Ads to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to JDBC-ODBC Bridge from a Connection Pool in WebLogic
Use the CData JDBC Driver for JDBC-ODBC Bridge to connect to JDBC-ODBC Bridge from Web applications running on WebLogic.
-
Integrating Antigravity CLI with Stack Exchange via CData CLI
Connect Stack Exchange to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Query Outreach.io Data in DataGrip
Create a Data Source for Outreach.io in DataGrip and use SQL to query live Outreach.io.
-
Build Azure Analysis Services-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Azure Analysis Services Data and create custom apps in Mendix.
-
Visualize Live Sage 200 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sage 200 using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to Webex
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Webex.
-
Use Manus AI to Talk to Your Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Oracle Eloqua.
-
Query Bright Data Data in ColdFusion
Write standard ColdFusion data access code to connect to Bright Data.
-
Automated Continuous PagerDuty Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PagerDuty replication to Azure SQL Database.
-
Connect to Paylocity Data in HULFT Integrate
Connect to Paylocity as a JDBC data source in HULFT Integrate
-
Create Reports from EnterpriseDB Data in Looker Studio
Use CData Connect AI to gain access to live EnterpriseDB and create custom reports in Looker Studio.
-
Integrating LlamaIndex with Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle Financials Cloud in real time.
-
How to integrate Insightly with Apache Airflow
Access and process Insightly in Apache Airflow using the CData JDBC Driver.
-
Use Grok to Talk to Your Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Slack for you.
-
How to Connect to Live Google Directory 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 Google Directory for you.
-
Automated Continuous HDFS Replication to Oracle
Use CData Sync for automated, continuous, customizable HDFS replication to Oracle.
-
Integrating Codex CLI with JotForm 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 Optimizely Data from MySQL in Amazon QuickSight
Connect to Optimizely and build visualizations of Optimizely using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Figshare Replication to MongoDB
Use CData Sync for automated, continuous, customizable Figshare replication to MongoDB.
-
Automate iContact Data Replication to Azure Synapse
Use CData Sync to customize and automate iContact replication to Azure Synapse.
-
Build Teamgate-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Teamgate.
-
Connect OneNote to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect OneNote with IBM WebSphere for seamless data integration and connectivity.
-
Build Automated Outreach.io-Connected Workflows in Zapier
Use CData Connect AI to connect to live Outreach.io and build automated workflows in Zapier.
-
How to Create Power BI Visual Reports with Real-Time Tally Data
Use CData Power BI Connectors to visualize Tally ERP in Power BI.
-
Getting Started with the CData SSIS Components for SharePoint
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SharePoint.
-
Automated Continuous Optimizely Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Optimizely replication to AlloyDB.
-
Replicate Quaderno Data in Heroku for Use in Salesforce Connect
Replicate Quaderno to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Visualize Live Redis Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Redis.
-
Connect to ConvertAPI from a Connection Pool in WebLogic
Use the CData JDBC Driver for ConvertAPI to connect to ConvertAPI from Web applications running on WebLogic.
-
Sage Intacct Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sage Intacct facts in real time.
-
Automated Continuous ActiveCampaign Replication to MongoDB
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to MongoDB.
-
Create Datasets from Cvent in Domo Workbench and Build Visualizations of Cvent Data in Domo
Use the CData Software ODBC Driver for Cvent to create datasets from Cvent in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Raisers Edge NXT Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Raisers Edge NXT from Filemaker Pro on Mac.
-
Build ADP-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ADP and build web apps with connectivity to live ADP.
-
Use the CData Software ODBC Driver for Act CRM in MicroStrategy Desktop
Connect to Act CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Act CRM.
-
Build HubDB-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for HubDB to explore live HubDB Data in GitHub Copilot to assist with building HubDB-powered applications.
-
Integrating Kiro CLI with Google Drive 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.
-
Import Real-Time Omnisend Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Omnisend in ColdFusion.
-
Import Real-Time ChargeOver Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ChargeOver in ColdFusion.
-
Automated Continuous Acumatica Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Acumatica replication to Apache Kafka.
-
Integrating LangChain with SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Concur within automated workflows.
-
Automated Continuous SAP Netweaver Gateway Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to AlloyDB.
-
Build Apps with Live Oracle HCM Cloud Data Using the Low-Code Development Platform of Mendix
Connect Oracle HCM Cloud with Mendix to build apps using the CData JDBC Driver for Oracle HCM Cloud.
-
How to connect and process ZohoExpense from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZohoExpense.
-
Feed Pipeliner CRM Data into FineReport
How to set Pipeliner CRM as a JDBC data source in FineReport.
-
Connect to Toggl Data from PowerBuilder via ADO.NET
This article demonstrates how to access Toggl from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Dynamic SharePoint Grids Using the Infragistics XamDataGrid
Learn how you can connect SharePoint to Infragistics XamDataGrid to build dynamic grids.
-
How to Create Power BI Visual Reports with Real-Time Toggl Data
Use CData Power BI Connectors to visualize Toggl in Power BI.
-
How to connect to OpenWeatherMap Data in DBVisualizer
Integrate OpenWeatherMap with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Query Live Pinterest Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pinterest data in natural language using Python.
-
Build SpaceX-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SpaceX and build web apps with connectivity to live SpaceX.
-
Integrate Todoist Data in Pentaho Data Integration
Build ETL pipelines based on Todoist in the Pentaho Data Integration tool.
-
Automated Continuous SAS xpt Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAS xpt replication to IBM DB2.
-
Connect to PhantomBuster Data in RapidMiner
Integrate PhantomBuster with standard components and data source configuration wizards in RapidMiner Studio.
-
Connecting GenSpark with Facebook Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Facebook Ads without any replication or custom integration required.
-
Use Dash to Build to Web Apps on Planio Data
Create Python applications that use pandas and Dash to build Planio-connected web apps.
-
Connect to Campaigner Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Campaigner as an External Source in Dremio.
-
Access Live HelloSign Data in Coginiti Pro
Connect to and query live HelloSign from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Seamlessly Import Elasticsearch Data into IBM SPSS Modeler
Integrate Elasticsearch data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Analyze Live SAP Fieldglass Data in SAS Viya
Use CData Connect AI to connect to SAP Fieldglass from SAS Viya and deploy self-service analytics using live SAP Fieldglass.
-
Migrating data from Redshift to Snowflake using CData SSIS Components.
Easily push Amazon Redshift to Snowflake using the CData SSIS Tasks for Redshift and Snowflake.
-
DataBind Controls to Cassandra Data in C++Builder
DataBind to Apache Cassandra in C++Builder with standard components and controls.
-
Connect to BambooHR from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from BambooHR, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Validate xBase Data with QuerySurge
Access and validate xBase in QuerySurge using the CData JDBC Driver.
-
Integrating GitHub Copilot CLI with Google BigQuery 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.
-
Integrate with live SharePoint Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft SharePoint in Jitterbit.
-
Build Automated HubSpot-Connected Workflows in Zapier
Use CData Connect AI to connect to live HubSpot and build automated workflows in Zapier.
-
How to Create Power BI Visual Reports with Real-Time Facebook Ads Data
Use CData Power BI Connectors to visualize Facebook Ads in Power BI.
-
Connect to Amazon Athena Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Amazon Athena Data and connect to Amazon Athena in Akorbi Digital RunMyProcess.
-
How to load Freshservice data into Elasticsearch via Logstash
Introducing a simple method to load Freshservice data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Add Apollo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Apollo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Procore Data in RapidMiner
Integrate Procore with standard components and data source configuration wizards in RapidMiner Studio.
-
How to create Visio diagrams from Dropbox Data
Automatically update Dropbox with the changes you make to Visio master shapes.
-
Integrate Live Delighted Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Delighted to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Microsoft Ads Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Microsoft Ads facts in real time.
-
Query Google Spanner Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Spanner entities in PHP by modeling them as objects.
-
Automated Avalara AvaTax Data Replication to Teradata
Use CData Sync to Customize and automate Avalara AvaTax replication to Teradata.
-
Integrate SAS xpt Data in Pentaho Data Integration
Build ETL pipelines based on SAS XPORT in the Pentaho Data Integration tool.
-
Integrating Gumloop with FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on FreshBooks within automated workflows.
-
Getting Started with the CData JDBC Driver for Opsgenie
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Opsgenie.
-
Use the CData SSIS Components to Insert New or Update Existing HubSpot Records from SQL Server
Easily push SQL Server data to HubSpot using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into HubSpot or update existing records with data from a SQL Server database.
-
Integrate Cursor with Live Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apache Spark SQL from within the editor.
-
Connect to Workday 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 Workday.
-
Build a Singer.io Tap for Exa With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Exa data using
-
Create Cloudant-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Cloudant Data from OutSystems and build custom enterprise apps using live IBM Cloudant.
-
Replicate Elasticsearch Data from PowerShell
Write a quick PowerShell script to query Elasticsearch. Use connectivity to the live data to replicate Elasticsearch to SQL Server.
-
Integrating Antigravity CLI with QuickBooks Online via CData CLI
Connect QuickBooks Online to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automate Vimeo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Vimeo from PowerShell? This article demonstrates how to utilize the Vimeo Cmdlets for tasks like connecting to Vimeo, automating operations, downloading data, and more.
-
Create Oracle-Connected Business Apps in AppSheet
Connect to Oracle Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle Database.