CData Software - Knowledge Base
Recent Articles
-
How to Query MailChimp Data in MySQL Workbench
Execute MySQL queries against live MailChimp data from MySQL Workbench.
-
Integrate Reckon Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Reckon data from Informatica Cloud.
-
Explore Geographical Relationships in Jodoo Data with Power Map
Create data visualizations with Jodoo data in Power Map.
-
Use the CData Software JDBC Driver for QuickBooks Time in MicroStrategy
Connect to QuickBooks Time data in MicroStrategy Developer using the CData Software JDBC Driver for QuickBooks Time.
-
Operational Reporting on Adobe Target Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Adobe Target data.
-
How to Connect to & Open Paylocity Data in Microsoft Excel
This article uses the CData ODBC driver for Paylocity to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Cursor with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle SCM data from within the editor.
-
Create Reports with Google Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Ads data.
-
Integrate Goose with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP ByDesign data from within the local AI agent.
-
DataBind Controls to Parallel Data in C++Builder
DataBind to Parallel data in C++Builder with standard components and controls.
-
Build a PostgreSQL Interface for RSS Feeds using the CData JDBC Driver
Use the Remoting features of the RSS JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Real-Time Microsoft Entra ID Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Microsoft Entra ID and Dataflow to import and use Microsoft Entra ID data in Power Apps.
-
Connect to Outlook Data in JRuby
Create a simple JRuby app with access to live Outlook data.
-
Automate iContact Data Replication to SAP HANA
Use CData Sync to customize and automate iContact data replication to SAP HANA.
-
Visualize Live FTP Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live FTP data.
-
How to Seamlessly Import Humanity Data into IBM SPSS Modeler
Integrate Humanity data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Access Live OneNote Data in Power Automate Desktop via ODBC
The CData ODBC Driver for OneNote enables you to integrate OneNote data into workflows built using Microsoft Power Automate Desktop.
-
Model, Search, and Visualize Live Freshservice Data in ThoughtSpot
Use CData Connect AI to connect to live Freshservice data for modeling, searching, and visualizing.
-
Deploy the ADO.NET Provider for DocuSign on an SSRS Report Server
Connect to DocuSign 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.
-
Migrating data from LinkedIn to Snowflake using CData SSIS Components.
Easily push LinkedIn data to Snowflake using the CData SSIS Tasks for LinkedIn and Snowflake.
-
Automated Box Data Replication to Teradata
Use CData Sync to Customize and automate Box data replication to Teradata.
-
Build SuiteCRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SuiteCRM data and build visualizations in Tableau Cloud.
-
Access Live OData Services in Excel 365 Online (Excel for the web)
Connect to OData services from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Data Visualizations Based On DB2 Data in Mode
Use CData Connect AI to connect to DB2 Data from Mode and build visualizations using live DB2 data.
-
Feed OData Services into FineReport
How to set OData services as a JDBC data source in FineReport.
-
Seamlessly Bring SQL Server Data into Retool Using CData Connect AI
Integrate SQL Server data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Pipelines with Live SparkPost Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SparkPost from Google Cloud Data Fusion, enabling the integration of live SparkPost data into the building and management of effective data pipelines.
-
Visualize Live Clio Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Clio data.
-
Establish a Live Connection with Contentful Data using Tableau Bridge
The CData ODBC Driver for Contentful enables you to integrate live Contentful data into Tableau Cloud dashboards using the Tableau Bridge.
-
Using the CData Software ODBC Driver for Retently in PyCharm
Connect to Retently as an ODBC data source in PyCharm using the CData Software ODBC Driver for Retently.
-
Create Datasets from FTP in Domo Workbench and Build Visualizations of FTP Data in Domo
Use the CData Software ODBC Driver for FTP to create datasets from FTP data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Act CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Act CRM data from Appeon PowerBuilder using the CData ADO.NET Provider for Act CRM.
-
Connect to and Visualize Live Sugar CRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sugar CRM data.
-
Automated Salesloft Data Replication to Teradata
Use CData Sync to Customize and automate Salesloft data replication to Teradata.
-
Replicate SurveyMonkey Data to Multiple Databases via the CData Sync CLI
Replicate SurveyMonkey data to disparate databases with a single configuration.
-
Create Informatica Mappings From/To a JDBC Data Source for CockroachDB
Create CockroachDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Process & Analyze Vimeo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Vimeo Data.
-
Automated Continuous Float Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Float replication to PostgreSQL.
-
Connect to Amazon Athena Data in Aqua Data Studio
Access Amazon Athena data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Live Bullhorn CRM Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Bullhorn CRM in CData Connect AI and connect to your Bullhorn CRM data from PostgreSQL.
-
Create Reports with Amazon DynamoDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon DynamoDB data.
-
Integrating LangChain with ZohoInvoice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ZohoInvoice data within automated workflows.
-
Working with Azure Table Data in LINQPad
Execute LINQ queries to Azure Table data in LINQPad.
-
Access Live Microsoft Ads Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Ads data into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Ads data in the Graph Builder and Query Builder.
-
Import Real-Time Salesloft Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesloft data in ColdFusion.
-
Choosing the Best Method to Connect Google Calendar to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Calendar data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build SAP SuccessFactors-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP SuccessFactors data and build SAP SuccessFactors-connected web apps with Axios.
-
Using the CData Software ODBC Driver for Cloudflare in PyCharm
Connect to Cloudflare as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cloudflare.
-
Integrating Cursor with Pushbullet 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.
-
Load BambooHR Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load BambooHR data to a database.
-
Build Pipelines with Live Instagram Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Instagram from Google Cloud Data Fusion, enabling the integration of live Instagram data into the building and management of effective data pipelines.
-
Integrating Gumloop with GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on GetResponse data within automated workflows.
-
Query, Visualize, and Share live Avro Data in Redash
Use CData Connect AI to connect to live Avro data in Redash for querying, visualizing, and sharing.
-
Build Semantic Layer Views for AfterShip Data in APOS Live Data Gateway
Use the CData Connector for AfterShip in APOS Live Data Gateway to build Semantic Layer Views for AfterShip data.
-
Stream Superchat Data into Apache Kafka Topics
Access and stream Superchat data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData Excel Add-In for Auth0
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Auth0.
-
Integrating Dataiku with Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Twilio data.
-
How to connect Amazon QuickSight to Wave Financial Data
Create a connection to Wave Financial data in CData Connect AI and insert Wave Financial data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Open WebUI with Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Drive data from within the chat interface.
-
Integrate Real-Time Access to Tally in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Tally data in real time.
-
Build Apps with Live Oracle Data Using the Low-Code Development Platform of Mendix
Connect Oracle data with Mendix to build apps using the CData JDBC Driver for Oracle.
-
Build a Simple VCL Application for Azure Synapse Data
How to build a simple VCL Application to view Azure Synapse data in RAD Studio using the CData ODBC Driver for Azure Synapse.
-
Build MVC Applications with Connectivity to Access Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Access from an ASP.NET MVC application.
-
Connecting Mastra with ConstantContact Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time ConstantContact data, no replication required.
-
Connecting Agentforce with MailChimp 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 MailChimp data for you.
-
Integrate Theia IDE with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SAP Ariba Source data from within the development environment.
-
Automated Continuous Certinia Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Certinia replication to Apache Cassandra.
-
Connect to Paddle Data in RazorSQL
Connect to Paddle from wizards and query Paddle data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData Tableau Connector for JotForm
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build a PostgreSQL Interface for Couchbase Data using the CData JDBC Driver
Use the Remoting features of the Couchbase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Databricks-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Databricks data.
-
Replicate Dynamics 365 Data to Multiple Databases
Replicate Dynamics 365 data to disparate databases with a point-and-click configuration.
-
Query Live HCL Domino Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live HCL Domino data through a conversational interface.
-
Model PolarTeamPro Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and PolarTeamPro, enabling the direct import of real-time PolarTeamPro data.
-
Oracle Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle data through CData Connect AI using different applications and tools.
-
Working with ConstantContact Data in LINQPad
Execute LINQ queries to ConstantContact data in LINQPad.
-
How to integrate Metabase with QuickBooks Data
Use CData Connect AI to connect to live QuickBooks data and create an interactive dashboard in Metabase from QuickBooks data.
-
Replicate Dotmailer Data to Multiple Databases via the CData Sync CLI
Replicate Dotmailer data to disparate databases with a single configuration.
-
Add SAP SuccessFactors LMS Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP SuccessFactors LMS with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Codex with Superchat 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.
-
Integrating Kiro with Google Analytics 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.
-
Getting Started with the CData ADO.NET Provider for Spark
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Spark.
-
Build AI/ML Models with Live Greenplum Data using Dataiku
Connect Greenplum Data with Dataiku using the CData JDBC Driver for Greenplum.
-
Create Data Visualizations Based On Zoho Projects Data in Mode
Use CData Connect AI to connect to Zoho Projects Data from Mode and build visualizations using live Zoho Projects data.
-
How to Connect to Live HCL Domino Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live HCL Domino data securely in real time.
-
How to integrate Deel with Apache Airflow
Access and process Deel data in Apache Airflow using the CData JDBC Driver.
-
Build Visualizations of ZohoInvoice Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZohoInvoice data in Birst.
-
Publish Azure Data Catalog-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure Data Catalog data.
-
Access Live CSV Data in Coginiti Pro
Connect to and query live CSV data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Work with Rebilly Data in AWS Glue Jobs Using JDBC
Connect to Rebilly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Redis-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Redis Data from OutSystems and build custom enterprise apps using live Redis data.
-
Access Live Raisers Edge NXT Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Raisers Edge NXT data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP HANA
Create an ODBC connection to SAP HANA in Informatica and browse and transfer SAP HANA data.
-
Replicate Multiple SageHR Accounts via the CData Sync CLI
Replicate multiple SageHR accounts to one or many databases.
-
Integrate with Google Calendar Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Calendar data in SnapLogic.
-
Connect to Microsoft Exchange Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Exchange to connect to Microsoft Exchange data and execute queries in PowerBuilder.
-
Create a Data Access Object for ConvertKit Data using JDBI
A brief overview of creating a SQL Object API for ConvertKit data in JDBI.
-
Connect and Visualize Live Paylocity Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Paylocity data into the Databricks platform and create visualization dashboards with real-time Paylocity data.
-
Consume SingleStore OData Feeds in PowerBuilder
This article demonstrates how to consume SingleStore data as OData feeds from PowerBuilder using the API Server.
-
Connect to Google Spanner Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Spanner Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.