CData Software - Knowledge Base
Recent Articles
-
How to connect Amazon QuickSight to HubSpot Data
Create a connection to HubSpot data in CData Connect AI and insert HubSpot data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to use SQLAlchemy ORM to access Apify Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apify data.
-
Use Biml to Build SSIS Tasks to Replicate MailChimp Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MailChimp data to SQL Server.
-
Working with Apollo Data in LINQPad
Execute LINQ queries to Apollo data in LINQPad.
-
Automated Continuous Jira Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Jira replication to Google Cloud SQL.
-
Integrate Couchbase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Couchbase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Couchbase data.
-
Connecting Agentforce with SAP Ariba Source 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 SAP Ariba Source data for you.
-
Using the CData Software ODBC Driver for SAP Ariba Source in PyCharm
Connect to SAP Ariba Source as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Ariba Source.
-
Connect to Mocean Data from PowerBuilder via JDBC
This article demonstrates how to access Mocean data from PowerBuilder using the Mocean JDBC Driver.
-
How to Visualize PhantomBuster Data in Python with pandas
Use pandas and other modules to analyze and visualize live PhantomBuster data in Python.
-
Build Neo4J-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Neo4J Data and create custom apps in Mendix.
-
Use CData Connect AI to Access Zuora Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zuora data in the Power Pivot business intelligence tool.
-
Connect ZohoPeople to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZohoPeople data using the CData Python MCP Server.
-
ETL Azure Table in Oracle Data Integrator
This article shows how to transfer Azure Table data into a data warehouse using Oracle Data Integrator.
-
Access Presto Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Presto data from your Oracle system.
-
Connecting Mastra with Kafka 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 Kafka data, no replication required.
-
Connect to and Query Tickspot Data in QlikView over ODBC
Create data visualizations with Tickspot data in QlikView.
-
Getting Started with the CData JDBC Driver for Outreach.io
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Outreach.io.
-
Build a PostgreSQL Interface for JobNimbus Data using the CData JDBC Driver
Use the Remoting features of the JobNimbus JDBC Driver to create a PostgreSQL entry-point for data access.
-
LINQ to Hubstaff 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 Hubstaff Data Provider.
-
Build Voice Agents in ElevenLabs with access to Live DocuSign Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live DocuSign data.
-
Integrating Claude Code with Bitly Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Bitly data within assisted coding and automated development workflows.
-
Build Greenhouse-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Greenhouse data.
-
Integrating Claude Code with JSON Services via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on JSON services within assisted coding and automated development workflows.
-
Integrating SFTP Data in Talend Cloud Data Management Platform
Connect SFTP Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SFTP.
-
Add Phoenix Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Phoenix with the Informatica Enterprise Data Catalog to classify and organize data.
-
Using the CData Software ODBC Driver for Elorus in PyCharm
Connect to Elorus as an ODBC data source in PyCharm using the CData Software ODBC Driver for Elorus.
-
Query Sugar CRM Data as a MySQL Database in Node.js
Execute MySQL queries against Sugar CRM data from Node.js.
-
Connect to Zoho CRM Data in RapidMiner
Integrate Zoho CRM data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live FormSite Data in AWS Lambda (with IntelliJ IDEA)
Connect to live FormSite data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Semantic Layer Views for Pinecone Data in APOS Live Data Gateway
Use the CData Connector for Pinecone in APOS Live Data Gateway to build Semantic Layer Views for Pinecone data.
-
Use the CData Software ODBC Driver for EmailOctopus in MicroStrategy
Connect to EmailOctopus data in MicroStrategy Developer using the CData Software ODBC Driver for EmailOctopus.
-
How to Connect Flowise AI Agents to Live Wave Financial 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 Wave Financial data without replication.
-
Integrating Boomi Agentstudio with Oracle SCM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle SCM data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Zoho CRM from Asprova with CData Software ODBC Driver for Zoho CRM
This article shows how to connect faster to Zoho CRM data from Asprova.
-
Integrate Facebook Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Facebook Ads with External Services.
-
Integrate Mistral AI Data in Pentaho Data Integration
Build ETL pipelines based on Mistral AI data in the Pentaho Data Integration tool.
-
Consume Cosmos DB OData Feeds in PowerBuilder
This article demonstrates how to consume Cosmos DB data as OData feeds from PowerBuilder using the API Server.
-
Build AI/ML Models with Live SAP ByDesign Data using Dataiku
Connect SAP ByDesign Data with Dataiku using the CData JDBC Driver for SAP ByDesign.
-
Design BIRT Reports on Pingdom Data
Provide current Pingdom data to your embedded analytics.
-
Automated Continuous Vercel Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Vercel replication to Apache Cassandra.
-
How to Connect to Live Zoho Projects 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 Zoho Projects data for you.
-
Create Dynamic Google Analytics Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Analytics to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Active Directory Data in Sisense
Create an ElastiCube in Sisense app with access to Active Directory data.
-
Build Charts with HCL Domino Data in Clear Analytics
Create dynamic charts and perform analytics based on HCL Domino data in Clear Analytics.
-
Query, Visualize, and Share live Square Data in Redash
Use CData Connect AI to connect to live Square data in Redash for querying, visualizing, and sharing.
-
Automated Continuous RabbitMQ Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable RabbitMQ replication to Google BigQuery.
-
Getting Started with the CData JDBC Driver for Elorus
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Elorus.
-
Connect to SFTP Data in RapidMiner
Integrate SFTP data with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Demio Data in ColdFusion
Write standard ColdFusion data access code to connect to Demio data.
-
Choosing the Best Method to Connect Grafana to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Grafana data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Claude Code with Samanage Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Samanage data within assisted coding and automated development workflows.
-
How to Seamlessly Import Clari Data into IBM SPSS Modeler
Integrate Clari data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData Python Connector for Highrise
Learn to install and license the CData Python Connector and configure a connection to live Highrise data.
-
How to Visualize Smartsheet Data in Python with pandas
Use pandas and other modules to analyze and visualize live Smartsheet data in Python.
-
Integrate Live Coda 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 Coda data from within the IDE.
-
Publish Crystal Reports on GitHub Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date GitHub data.
-
Connect to Real-Time TigerGraph Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for TigerGraph and Dataflow to import and use TigerGraph data in Power Apps.
-
Connect to SpaceX from a Connection Pool in WebLogic
Use the CData JDBC Driver for SpaceX to connect to SpaceX data from Web applications running on WebLogic.
-
Create Dynamic CampaignMonitor Grids Using the Infragistics XamDataGrid
Learn how you can connect CampaignMonitor to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Live Sage 300 Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sage 300 in CData Connect AI and connect to your Sage 300 data from PostgreSQL.
-
Integrating LlamaIndex with Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Adobe Analytics data in real time.
-
How to connect to Azure Data Lake Storage Data from Spring Boot
Connect to Azure Data Lake Storage in a Spring Boot Application using the CData JDBC Driver for Azure Data Lake Storage
-
How to Connect to Live ActiveCampaign Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your ActiveCampaign data for you.
-
Getting Started with the CData Excel Add-In for Adobe Target
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Target.
-
Build Voice Agents in ElevenLabs with access to Live SAP BusinessObjects BI Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP BusinessObjects BI data.
-
Analyze Paylocity Data in Cognos Analytics
Use CData Connect AI to connect to Paylocity Data from Cognos Analytics and analyze live Paylocity data.
-
How to connect Amazon QuickSight to Google Contacts Data
Create a connection to Google Contacts data in CData Connect AI and insert Google Contacts data into Amazon QuickSight SPICE to build interactive dashboards.
-
Analyze Zoho Inventory Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoho Inventory data in Microsoft R Open.
-
Access Live HubDB Data in Coginiti Pro
Connect to and query live HubDB data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Salesforce Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesforce replication to Google BigQuery.
-
Connect to Procore Data in NetBeans
Connect to Procore data in NetBeans with the data source configuration wizard.
-
Manage Google Calendar Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Calendar.
-
Use Dash to Build to Web Apps on Opsgenie Data
Create Python applications that use pandas and Dash to build Opsgenie-connected web apps.
-
Connecting Mastra with Elasticsearch 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 Elasticsearch data, no replication required.
-
How to create HelloSign federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for HelloSign data in MySQL .
-
Getting Started with the CData Tableau Connector for Superchat
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Access Sybase IQ Data Using Entity Framework
This article shows how to access Sybase IQ data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Choosing the Best Method to Connect Contentful to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Contentful data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Tickspot Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Tickspot and work with Tickspot data in your FileMaker application.
-
Connecting Moonlit Workflow with Salesforce Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Salesforce data in real time.
-
Configure the CData JDBC Driver for Onfleet in a Connection Pool in Tomcat
Connect to Onfleet data from a connection pool in Tomcat.
-
Work with BambooHR Data in FoxPro
Load BambooHR data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Oracle Sales Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle Sales Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Live AgileCRM Data in PostGresSQL Interface through CData Connect AI
Create a live connection to AgileCRM in CData Connect AI and connect to your AgileCRM data from PostgreSQL.
-
Getting Started with the CData ODBC Driver for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Elasticsearch.
-
Model, Search, and Visualize Live SendPulse Data in ThoughtSpot
Use CData Connect AI to connect to live SendPulse data for modeling, searching, and visualizing.
-
Visualize Live SAP Netweaver Gateway Data in the Power BI Service
Use CData Connect AI to connect to live SAP Netweaver Gateway data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to Mocean
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mocean data.
-
Create Reports from Redshift Data in Looker Studio
Use CData Connect AI to gain access to live Redshift data and create custom reports in Looker Studio.
-
Connect to ZarMoney Data from a Connection Pool in Jetty
The ZarMoney JDBC Driver supports connection pooling: This article shows how to connect faster to ZarMoney data from Web apps in Jetty.
-
Use the CData Software ODBC Driver for LinkedIn Ads in MicroStrategy
Connect to LinkedIn Ads data in MicroStrategy Developer using the CData Software ODBC Driver for LinkedIn Ads.
-
Visualize HBase 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 HBase data into TIBCO Spotfire.
-
Prepare, Blend, and Analyze Outreach.io Data in Alteryx Designer (ODBC)
Build workflows to access live Outreach.io data for self-service data analytics.
-
Deploy the ADO.NET Provider for Aha! on an SSRS Report Server
Connect to Aha! 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.
-
Integrate Google's Vertex AI Agent with Live Tally 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 Tally data within intelligent workflows.
-
Automated Continuous ChartMogul Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ChartMogul replication to Apache Cassandra.
-
Automated Continuous ServiceDesk Plus Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ServiceDesk Plus data replication to OneLake in Microsoft Fabric.
-
Integrating Antigravity CLI with Dropbox data via CData CLI
Connect Dropbox data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Azure Synapse-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Azure Synapse data without replication.