CData Software - Knowledge Base
Recent Articles
-
Validate Paylocity Data with QuerySurge
Access and validate Paylocity data in QuerySurge using the CData JDBC Driver.
-
Connect to Neo4J Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Neo4J to connect to Neo4J data and execute queries in PowerBuilder.
-
Use ChatGPT to Talk to Your Monday.com 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 Monday.com data for you.
-
Use Grok to Talk to Your Neo4J 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 Neo4J data for you.
-
Connect to Oracle HCM Cloud Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle HCM Cloud as an External Source in Dremio.
-
Integrate Cursor with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SQL Server data from within the editor.
-
Integrate Clio Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Clio data from Informatica Cloud.
-
Connect to Twitter Ads Data in CloverDX (formerly CloverETL)
Transfer Twitter Ads data using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData ADO.NET Provider for GraphQL
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for GraphQL.
-
Connect to Discord Data from AWS Glue
Use CData Connect AI to gain access to live Discord data from your AWS Glue jobs.
-
Publish Perigon-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Perigon data.
-
How to Work with Foursquare Data in AWS Glue Jobs Using JDBC
Connect to Foursquare from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use JayDeBeApi to access Greenplum Data in Python
Use standard Python scripting and the development environment of your choice to access live Greenplum data.
-
Replicate Multiple eBay Accounts via the CData Sync CLI
Replicate multiple eBay accounts to one or many databases.
-
Connect to Zoho Books Data in HULFT Integrate
Connect to Zoho Books as a JDBC data source in HULFT Integrate
-
Build Tavily-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Tavily data and build web apps with connectivity to live Tavily data.
-
Analyze Adobe Target Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Adobe Target data with the CData JDBC Driver for Adobe Target.
-
Connect to Quaderno Data in RapidMiner
Integrate Quaderno data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to GetResponse Data from PowerBuilder via ADO.NET
This article demonstrates how to access GetResponse data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Dash to Build to Web Apps on Pipeline CRM Data
Create Python applications that use pandas and Dash to build Pipeline CRM-connected web apps.
-
Visualize Harvest 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 Harvest data into TIBCO Spotfire.
-
Query LeadDesk Data as a MySQL Database in Node.js
Execute MySQL queries against LeadDesk data from Node.js.
-
Publish OData-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live OData services.
-
Integrate PolarTeamPro Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to PolarTeamPro data and integrate live PolarTeamPro data into your Power Automate tasks.
-
How to use SQLAlchemy ORM to access SAP Ariba Procurement Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Ariba Procurement data.
-
Connect to Google Ad Manager Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Ad Manager Data and connect to Google Ad Manager data in Akorbi Digital RunMyProcess.
-
How to Connect to Live ADP 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 ADP data for you.
-
Placid Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Placid facts in real time.
-
Connect to Salesforce Pardot Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce Pardot as an External Source in Dremio.
-
Deploy the ADO.NET Provider for Intercom on an SSRS Report Server
Connect to Intercom data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Impala Data from PowerBuilder via ADO.NET
This article demonstrates how to access Impala data from Appeon PowerBuilder using the CData ADO.NET Provider for Impala.
-
Connect to QuickBooks Time Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time QuickBooks Time data using standard SQL.
-
Use the CData ODBC Driver for Wave Financial in Microsoft Power Query
You can use the CData Wave Financial ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Wave Financial data into Microsoft Power Query.
-
Build Cloudant-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Cloudant Data from Zoho Analytics and import live Cloudant data.
-
Build IBM Cloud Object Storage-Connected Apps in Choreo
Use CData Connect AI to connect to IBM Cloud Object Storage Data from Choreo and build custom apps using live IBM Cloud Object Storage data.
-
Visualize Google Spanner Data in TIBCO Spotfire through OData
Integrate Google Spanner data into dashboards in TIBCO Spotfire.
-
Automated Continuous Close Replication to MySQL
Use CData Sync for automated, continuous, customizable Close replication to MySQL.
-
Integrating Kiro with Demio 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.
-
Working with Google Sheets Data in LINQPad
Execute LINQ queries to Google Sheets data in LINQPad.
-
Create Datasets from Facebook in Domo Workbench and Build Visualizations of Facebook Data in Domo
Use the CData Software ODBC Driver for Facebook to create datasets from Facebook data in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to & Open Elorus Data in Microsoft Excel
This article uses the CData ODBC driver for Elorus to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Google's Vertex AI Agent with Live ZohoPeople 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 ZohoPeople data within intelligent workflows.
-
How to connect to SAP BusinessObjects BI Data in DBVisualizer
Integrate SAP BusinessObjects BI data with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Redis Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Redis data in Microsoft R Open.
-
Automated Continuous Azure Data Catalog Replication to Snowflake
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Snowflake.
-
Create Datasets from Todoist in Domo Workbench and Build Visualizations of Todoist Data in Domo
Use the CData Software ODBC Driver for Todoist to create datasets from Todoist data in Domo Workbench and then build visualizations in the Domo service.
-
Build Act CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Act CRM data.
-
Replicate SAP Ariba Procurement Data to Multiple Databases
Replicate SAP Ariba Procurement data to disparate databases with a point-and-click configuration.
-
Process & Analyze Reply.io Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Reply.io Data.
-
Automated Continuous Google Campaign Manager 360 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Azure SQL Database.
-
Integrate Teradata with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Teradata with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Teradata data.
-
Object-Relational Mapping (ORM) with XML 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 XML data into a Java-based ORM framework, Hibernate.
-
Provide OData Services of Productboard Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Productboard data by developing a WCF Service Application.
-
Explore Geographical Relationships in Instantly Data with Power Map
Create data visualizations with Instantly data in Power Map.
-
Automate HBase Data Replication to Couchbase
Use CData Sync to Customize and automate HBase data replication to Couchbase.
-
Connect to Kafka Data from HeidiSQL
Use CData Connect AI to connect to and query live Kafka data from HeidiSQL.
-
Integrating Gumloop with SuiteCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SuiteCRM data within automated workflows.
-
Build Dashboards with SageHR Data in DBxtra
Create dynamic dashboards and perform analytics based on SageHR data in DBxtra.
-
Analyze HCL Domino Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HCL Domino from Power Pivot. You will use the Table Import Wizard to load HCL Domino data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Auth0 Data in Sisense
Create an ElastiCube in Sisense app with access to Auth0 data.
-
Integrate XML Data into Power Automate Desktop using CData Connect
CData Connect for XML Data enables you to integrate XML data into workflows built using Microsoft Power Automate Desktop.
-
Stream Mocean Data into Apache Kafka Topics
Access and stream Mocean data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Zoho Projects Data in TIBCO Spotfire through OData
Integrate Zoho Projects data into dashboards in TIBCO Spotfire.
-
Query Perplexity Data as a MySQL Database in Node.js
Execute MySQL queries against Perplexity data from Node.js.
-
Model Samanage Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Samanage, enabling the direct import of real-time Samanage data.
-
Connect to Amplitude in SpagoBI
Create reports featuring live Amplitude data in SpagoBI Studio. Host Amplitude reports on SpagoBI Server.
-
Build Semantic Layer Views for Exa Data in APOS Live Data Gateway
Use the CData Connector for Exa in APOS Live Data Gateway to build Semantic Layer Views for Exa data.
-
Connect to Factorial Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Factorial data.
-
Connect to ScrapingBee Data from PowerBuilder via ADO.NET
This article demonstrates how to access ScrapingBee data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to SendPulse Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SendPulse Data and connect to SendPulse data in Akorbi Digital RunMyProcess.
-
Integrate Cline with Live Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Azure Analysis Services data from within your IDE.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ActiveCampaign
Provide connectivity to ActiveCampaign data through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To a JDBC Data Source for EnterpriseDB
Create EnterpriseDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Spark Data into Power Automate Desktop using CData Connect
CData Connect for Spark Data enables you to integrate Spark data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Live Jumpseller Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Jumpseller data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Edit and Search External Google Campaign Manager 360 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Campaign Manager 360 data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Campaign Manager 360 Data objects that you can access from apps and the dashboard.
-
How to Connect to Live Cassandra 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 Cassandra data for you.
-
How to integrate Metabase with Sage Cloud Accounting Data
Use CData Connect AI to connect to live Sage Cloud Accounting data and create an interactive dashboard in Metabase from Sage Cloud Accounting data.
-
Connect to Real-Time FreshBooks Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use FreshBooks data in Power Apps.
-
Use Agno to Talk to Your Cosmos DB 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 Cosmos DB data for you.
-
Access Tally Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Tally data from HeidiSQL.
-
How to Connect DBeaver to Couchbase via a JDBC Driver
Manage Couchbase data with visual tools in DBeaver like the query browser.
-
Choosing the Best Method to Connect ServiceDesk Plus to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ServiceDesk Plus data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Salesforce CRM Analytics Data in RazorSQL
Connect to Salesforce CRM Analytics from wizards and query Salesforce CRM Analytics data from the GUI in the RazorSQL database management tool.
-
Analyze Adobe Commerce Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Adobe Commerce from Power Pivot. You will use the Table Import Wizard to load Adobe Commerce data. You can visually build the import query or use any SQL supported by the driver.
-
Toggl Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Toggl facts in real time.
-
Automated Continuous Samanage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Samanage replication to Google BigQuery.
-
Using the CData Software ODBC Driver for MYOB AccountRight in PyCharm
Connect to MYOB AccountRight as an ODBC data source in PyCharm using the CData Software ODBC Driver for MYOB AccountRight.
-
Connect and Visualize Live FTP Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live FTP data into the Databricks platform and create visualization dashboards with real-time FTP data.
-
Integrate Dify with Live Email Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Email data.
-
Integrating GitHub Copilot with Google Search results 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.
-
Consume Sage 300 OData Feeds in PowerBuilder
This article demonstrates how to consume Sage 300 data as OData feeds from PowerBuilder using the API Server.
-
Connect to EmailOctopus Data in CloverDX (formerly CloverETL)
Transfer EmailOctopus data using the visual workflow in the CloverDX data integration tool.
-
Add Zendesk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zendesk with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Agents in Relevance AI with Access to Live Typeform Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Typeform data within intelligent agent workflows.
-
Integrate with MailerLite Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MailerLite data in SnapLogic.
-
Integrate Devin with Live Blackbaud FE NXT 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 Blackbaud FE NXT data.
-
How to connect to Optimizely Data from IntelliJ
Integrate connectivity to Optimizely data with wizards in IntelliJ.
-
Integrate AlloyDB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live AlloyDB data from Informatica Cloud.
-
How to use SQLAlchemy ORM to access Pinecone Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Pinecone data.