CData Software - Knowledge Base
Recent Articles
-
Edit and Search GraphQL External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of GraphQL to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create GraphQL objects that you can access from apps and the dashboard.
-
Connect to and Query Helpscout Data in QlikView over ODBC
Create data visualizations with Helpscout in QlikView.
-
Build Sage Cloud Accounting-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Sage Cloud Accounting to explore live Sage Cloud Accounting Data in Gemini Code Assist to assist with building Sage Cloud Accounting-powered applications.
-
Build Dashboards with ServiceNow Data in DBxtra
Create dynamic dashboards and perform analytics based on ServiceNow in DBxtra.
-
Migrating data from GraphQL to Google BigQuery using CData SSIS Components.
Easily push GraphQL to Google BigQuery using the CData SSIS Tasks for GraphQL and Google BigQuery.
-
Access Live Facebook Ads Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Facebook Ads data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Oracle Financials Cloud-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Oracle Financials Cloud to explore live Oracle Financials Cloud Data in Gemini Code Assist to assist with building Oracle Financials Cloud-powered applications.
-
Validate ZohoSubscriptions Data with QuerySurge
Access and validate ZohoSubscriptions in QuerySurge using the CData JDBC Driver.
-
Connect to PDFMonkey Data in RazorSQL
Connect to PDFMonkey from wizards and query PDFMonkey from the GUI in the RazorSQL database management tool.
-
Excel Spreadsheet Automation on CapsuleCRM Data with the QUERY Formula
Pull data from CapsuleCRM, automate spreadsheets, and more with the QUERY formula.
-
How to Use a Microsoft Access Database to Update Cosmos DB Data in Real Time
Update Cosmos DB data by creating a linked table in Microsoft Access with the CData Cosmos DB ODBC Driver.
-
Integrating Kiro CLI with MongoDB 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.
-
Building Dynamic Web Pages with ActiveCampaign Data Using AngularJS
Create single-page applications with live connectivity to ActiveCampaign using the CData API Server.
-
Access Live SAP SuccessFactors Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP SuccessFactors in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Excel Spreadsheet Automation on BambooHR Data with the QUERY Formula
Pull data from BambooHR, automate spreadsheets, and more with the QUERY formula.
-
Visualize Stripe Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Stripe.
-
Enable the Zoho Creator JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zoho Creator.
-
How to Connect to Live Greenhouse Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Greenhouse without replication.
-
Automated Continuous JotForm Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable JotForm replication to Apache Kafka.
-
How to Create Power BI Visual Reports with Real-Time Optimizely Data
Use CData Power BI Connectors to visualize Optimizely in Power BI.
-
Automated Continuous SendGrid Replication to MySQL
Use CData Sync for automated, continuous, customizable SendGrid replication to MySQL.
-
Query Raisers Edge NXT Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Raisers Edge NXT from Node.js.
-
Access Google Analytics Data from MySQL in Amazon QuickSight
Connect to Google Analytics and build visualizations of Google Analytics using a MySQL Connection in Amazon QuickSight.
-
DataBind Controls to Google Directory Data in Delphi
DataBind to Google Directory in Delphi with standard data access components and controls.
-
Automate Tasks in Power Automate Using the CData API Server
Automate MongoDB actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Work with Salesloft Data in FoxPro
Load Salesloft into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Dashboards with Freshteam Data in Dundas BI
Create dynamic dashboards and perform analytics based on Freshteam in Dundas BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SendInBlue
Provide connectivity to SendInBlue through an SAP BusinessObjects universe.
-
Build MariaDB-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for MariaDB to explore live MariaDB Data in Gemini Code Assist to assist with building MariaDB-powered applications.
-
Use the CData Software ODBC Driver for SendPulse in MicroStrategy Web
Connect to SendPulse in MicroStrategy Web using the CData Software ODBC Driver for SendPulse.
-
Manage QuickBooks Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for QuickBooks.
-
Publish Reports with Miro Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Miro.
-
Automated Continuous Microsoft Entra ID Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Amazon Redshift.
-
Integrate Live CouchDB Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Apache CouchDB to Blue Prism using the CData ODBC Driver for CouchDB to create automated workflows for repetitive business tasks.
-
Connect to CSV Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for CSV/TSV Files in the Denodo Virtual DataPort Administrator.
-
Replicate Multiple Acumatica Accounts via the CData Sync CLI
Replicate multiple Acumatica accounts to one or many databases.
-
Create Zoho CRM-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Zoho CRM Data from Klipfolio and build custom visualizations using live Zoho CRM.
-
Automate Landbot Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Landbot from PowerShell? This article demonstrates how to utilize the Landbot Cmdlets for tasks like connecting to Landbot, automating operations, downloading data, and more.
-
How to create an RPA flow for Microsoft Dataverse Data in UiPath Studio
Use the Microsoft Dataverse ODBC Driver to create workflows that access real-time Microsoft Dataverse (CDS) without any coding.
-
Automated Continuous MongoDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MongoDB replication to Amazon S3.
-
Object-Relational Mapping (ORM) with Calendly Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Calendly into a Java-based ORM framework, Hibernate.
-
Seamlessly Bring SAP SuccessFactors LMS Data into Retool Using CData Connect AI
Integrate SAP SuccessFactors LMS data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Gmail Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Gmail.
-
Load Sage Intacct Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sage Intacct to a database.
-
Connect to Power BI XMLA Data in DBArtisan
Use wizards in DBArtisan to configure Power BI XMLA as a data source.
-
Create SSAS Tabular Models from Short.io Data
How to build a SQL Server Analysis Service Tabular Model from Short.io using CData drivers.
-
Integrate Templated with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Templated with External Services.
-
Build Dashboards with Shippo Data in DBxtra
Create dynamic dashboards and perform analytics based on Shippo in DBxtra.
-
Use ChatGPT to Talk to Your PostgreSQL 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 PostgreSQL for you.
-
How to connect SharePoint with MarkLogic Data through external lists
Provide MarkLogic to SharePoint users as an external list.
-
How to connect and process Exa from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Exa.
-
Import Real-Time NASA Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use NASA in ColdFusion.
-
How to Connect to Live Sage 200 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 200 for you.
-
How to connect to Discourse Data from IntelliJ
Integrate connectivity to Discourse with wizards in IntelliJ.
-
Replicate SQL Server Data to Multiple Databases
Replicate Microsoft SQL Server to disparate databases with a point-and-click configuration.
-
Integrating Kiro CLI with Brex 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.
-
Build Voice Agents in ElevenLabs with access to Live Sugar CRM Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sugar CRM.
-
Working with Okta Data in LINQPad
Execute LINQ queries to Okta in LINQPad.
-
Automated Continuous Oracle HCM Cloud Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to IBM DB2.
-
How to Connect to Live Amazon S3 Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Amazon S3 without replication.
-
Visualize Drip Data in TIBCO Spotfire through ADO.NET
Integrate Drip into dashboards in TIBCO Spotfire.
-
Visualize Live Rebilly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Rebilly.
-
Visualize Nuclia Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Nuclia.
-
Connecting GenSpark with CockroachDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to CockroachDB without any replication or custom integration required.
-
Automated Continuous PayPal Replication to SQL Server
Use CData Sync for automated, continuous, customizable PayPal replication to SQL Server.
-
Replicate Multiple RSS Accounts via the CData Sync CLI
Replicate multiple RSS accounts to one or many databases.
-
How to create Visio diagrams from Excel Online Data
Automatically update Microsoft Excel Online with the changes you make to Visio master shapes.
-
Access Klipfolio Data from MySQL in Amazon QuickSight
Connect to Klipfolio and build visualizations of Klipfolio using a MySQL Connection in Amazon QuickSight.
-
Query Facebook Ads Data as a MySQL Database in Node.js
Execute MySQL queries against Facebook Ads from Node.js.
-
Automated Continuous Excel Replication to MongoDB
Use CData Sync for automated, continuous, customizable Excel replication to MongoDB.
-
Build iContact-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to iContact and build web apps with connectivity to live iContact.
-
Connect to and Query Adobe Experience Manager Data in QlikView over ODBC
Create data visualizations with Adobe Experience Manager in QlikView.
-
Connect to Google Ads Data in HULFT Integrate
Connect to Google Ads as a JDBC data source in HULFT Integrate
-
Build Visualizations of ElevenLabs Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ElevenLabs in Birst.
-
Access Live Zoho Projects Data in AWS Lambda
Connect to live Zoho Projects in AWS Lambda using the CData JDBC Driver.
-
Access Live Chargebee Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Chargebee into the statistical analysis tools available in SAS JMP. This article shows how to use Chargebee in the Graph Builder and Query Builder.
-
Access CockroachDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live CockroachDB from HeidiSQL.
-
How to Connect to Live Presto Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Presto without replication.
-
Create Datasets from Act CRM in Domo Workbench and Build Visualizations of Act CRM Data in Domo
Use the CData Software ODBC Driver for Act CRM to create datasets from Act CRM in Domo Workbench and then build visualizations in the Domo service.
-
Use Biml to Build SSIS Tasks to Replicate Raisers Edge NXT Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Raisers Edge NXT to SQL Server.
-
Create Dashboards and Visualize Live Active Directory Data in Geckoboard
Use CData Connect AI to connect to live Active Directory and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build a PostgreSQL Interface for Tanda Data using the CData JDBC Driver
Use the Remoting features of the Tanda JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to HubSpot Data from PowerBuilder via JDBC
This article demonstrates how to access HubSpot from PowerBuilder using the HubSpot JDBC Driver.
-
Access Office 365 Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Microsoft Office 365.
-
Automated Continuous Freshdesk Replication to Oracle
Use CData Sync for automated, continuous, customizable Freshdesk replication to Oracle.
-
Bind Live Neo4J Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Neo4J data
-
Publish Reports with Google Contacts Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Contacts.
-
Use the CData Software ODBC Driver for Azure Synapse in MicroStrategy
Connect to Azure Synapse in MicroStrategy Developer using the CData Software ODBC Driver for Azure Synapse.
-
Bidirectional Access to Freshservice Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Freshservice in Filemaker Pro for Mac or Windows.
-
Build JSON-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for JSON to explore live JSON Services in GitHub Copilot to assist with building JSON-powered applications.
-
Automated Continuous GitHub Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable GitHub replication to Apache Cassandra.
-
How to Connect the Power BI Service to MailerSend: Complete Guide
Connect to the CData Software Power BI Connector for MailerSend from PowerBI.com to provide real-time MailerSend across the organization.
-
Use JayDeBeApi to access Billsby Data in Python
Use standard Python scripting and the development environment of your choice to access live Billsby.
-
Connect to Microsoft Planner in SpagoBI
Create reports featuring live Microsoft Planner in SpagoBI Studio. Host Microsoft Planner reports on SpagoBI Server.
-
Object-Relational Mapping (ORM) with Notion Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Notion into a Java-based ORM framework, Hibernate.
-
Connect to MessageBird Data in RazorSQL
Connect to MessageBird from wizards and query MessageBird from the GUI in the RazorSQL database management tool.
-
Configure the CData JDBC Driver for Aha! in a Connection Pool in Tomcat
Connect to Aha! from a connection pool in Tomcat.
-
How to connect to Typeform Data with Squirrel SQL client
Connect to Typeform and execute queries in the Squirrel SQL Client.
-
Automated Continuous MYOB AccountRight Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Azure SQL Database.
-
Create Informatica Mappings From/To a JDBC Data Source for ZeroBounce
Create ZeroBounce data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.