CData Software - Knowledge Base
Recent Articles
-
Work with Zoho Inventory Data in FoxPro
Load Zoho Inventory data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create a Data Access Object for Salesforce Data using JDBI
A brief overview of creating a SQL Object API for Salesforce data in JDBI.
-
Connect to HelloSign Data from a Connection Pool in JBoss
Integrate HelloSign data into Java servlets: Use the Management Console in JBoss to install the HelloSign JDBC Driver.
-
Create Adobe Experience Manager Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Adobe Experience Manager data access from reports, embedded analytics, and more.
-
Manage MongoDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MongoDB.
-
Query RSS Feeds as a SQL Server Database in Node.js
Execute SQL Server queries against RSS feeds from Node.js.
-
Automated Continuous SAP Ariba Source Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Oracle.
-
How to import Google Analytics Data into Apache Solr
Use the CData Software JDBC Driver for Google Analytics in Data Import Handler and create an automated import of Google Analytics data to Apache Solr Enterprise Search platform.
-
Connect to QuickBooks Data in CloverDX (formerly CloverETL)
Transfer QuickBooks data using the visual workflow in the CloverDX data integration tool.
-
Access Live Timely Data in Coginiti Pro
Connect to and query live Timely data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData SSIS Components for Cassandra
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Cassandra.
-
Visualize Live Printify Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Printify data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to & Open Salesforce Data 360 Data in Microsoft Excel
This article uses the CData ODBC driver for Salesforce Data 360 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize Klaviyo Data in Tableau
The CData ODBC driver for Klaviyo enables you integrate Klaviyo data into Tableau dashboards.
-
How to Easily Query SAP SuccessFactors Data in OpenOffice Base
Connect to SAP SuccessFactors data in OpenOffice Base using the CData ODBC Driver for SAP SuccessFactors and generate reports with live data insights.
-
Automated Continuous Nuclia Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Nuclia replication to Apache Cassandra.
-
Import and Visualize Placid Data in Power View
Create data visualizations based on Placid data in Excel.
-
Automated SparkPost Data Replication to Teradata
Use CData Sync to Customize and automate SparkPost data replication to Teradata.
-
Integrate Greenhouse Data in the Pentaho Report Designer
Publish reports based on Greenhouse data in the Pentaho BI tool.
-
Use Manus AI to Talk to Your Wave Financial 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 Wave Financial data.
-
Query Zendesk Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zendesk entities in PHP by modeling them as objects.
-
Connecting GenSpark with MariaDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to MariaDB data without any replication or custom integration required.
-
How to create PolarTeamPro federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PolarTeamPro data in MySQL .
-
Integrate with PabblySubscriptions Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PabblySubscriptions data to a JSON file on disk.
-
Build Voice Agents in ElevenLabs with access to Live GitHub Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live GitHub data.
-
Design BIRT Reports on Zoho Inventory Data
Provide current Zoho Inventory data to your embedded analytics.
-
Access Live SendPulse Data in Excel 365 Online (Excel for the web)
Connect to SendPulse data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Strava Data in Heroku for Use in Salesforce Connect
Replicate Strava data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to load LDAP data into Elasticsearch via Logstash
Introducing a simple method to load LDAP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live HubSpot Data in AWS Lambda
Connect to live HubSpot data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Asana Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Asana replication to PostgreSQL.
-
How to Access Rootly Data Using Entity Framework
This article shows how to access Rootly data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Configure the CData JDBC Driver for Cohere in a Connection Pool in Tomcat
Connect to Cohere data from a connection pool in Tomcat.
-
How to Connect Yelp Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Yelp data in real time using natural language.
-
Import OneNote Data Using Azure Data Factory
Use CData Connect AI to connect to OneNote Data from Azure Data Factory and import live OneNote data.
-
Use the CData Software JDBC Driver for Snowflake in MicroStrategy Desktop
Connect to Snowflake data in MicroStrategy Desktop using the CData Software JDBC Driver for Snowflake.
-
Getting Started with the CData ODBC Driver for PagerDuty
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for PagerDuty.
-
Write a Simple Go Application to work with Sentry Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sentry data.
-
Analyze Perigon Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Perigon data in Microsoft R Open.
-
Automated Continuous Neo4J Replication to Snowflake
Use CData Sync for automated, continuous, customizable Neo4J replication to Snowflake.
-
Connect to Freshteam Data from Crystal Reports
Use CData Connect AI to connect to and report on live Freshteam data from Crystal Reports.
-
Create Salesforce Marketing-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Salesforce Marketing Data from OutSystems and build custom enterprise apps using live Salesforce Marketing data.
-
Analyze Live IBM Informix Data in SAS Viya
Use CData Connect AI to connect to IBM Informix data from SAS Viya and deploy self-service analytics using live IBM Informix data.
-
Integrate OpenCode with Live DocuSign Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live DocuSign data from within your AI coding agent.
-
Visualize Live SharePoint Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SharePoint data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Google's Vertex AI Agent with Live Avro 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 Avro data within intelligent workflows.
-
Connect to ScrapingBee 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 ScrapingBee and work with ScrapingBee data in your FileMaker application.
-
Automated Continuous Campaigner Replication to MySQL
Use CData Sync for automated, continuous, customizable Campaigner replication to MySQL.
-
Connect to Eventbrite Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Eventbrite data using standard SQL.
-
Connect to Salesforce Data 360 Data in ACL Analytics
Connect to Salesforce Data 360 data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Salesforce Data 360 data.
-
Connect Hive to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Hive data using the CData Python MCP Server.
-
Build Automated Workflows with Live Pinterest Data in Workato
Use CData Connect AI to connect to live Pinterest data and build automated workflows in Workato.
-
Automated Continuous JobNimbus Replication to MongoDB
Use CData Sync for automated, continuous, customizable JobNimbus replication to MongoDB.
-
Integrate with live Workday Data in Jitterbit
Use CData Connect AI to connect to and integrate live Workday data in Jitterbit.
-
Connect Cosmos DB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Cosmos DB data using the CData Python MCP Server.
-
Access Live Adobe Target Data in Excel 365 Online (Excel for the web)
Connect to Adobe Target data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to FHIR Data in RazorSQL
Connect to FHIR from wizards and query FHIR data from the GUI in the RazorSQL database management tool.
-
Use Grok to Talk to Your Aweber 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 Aweber data for you.
-
Visualize Twilio Data in TIBCO Spotfire through OData
Integrate Twilio data into dashboards in TIBCO Spotfire.
-
Validate Microsoft Dataverse Data with QuerySurge
Access and validate Microsoft Dataverse data in QuerySurge using the CData JDBC Driver.
-
How to connect to GitLab Data in DBVisualizer
Integrate GitLab data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to ZohoSubscriptions Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ZohoSubscriptions data in Airbyte.
-
Query Raisers Edge NXT Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Raisers Edge NXT entities in PHP by modeling them as objects.
-
Automated Continuous Cloudant Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Cloudant replication to Amazon Redshift.
-
Automate Cloudflare Data Replication to SAP HANA
Use CData Sync to customize and automate Cloudflare data replication to SAP HANA.
-
Query SAP SuccessFactors Data in DataGrip
Create a Data Source for SAP SuccessFactors in DataGrip and use SQL to query live SAP SuccessFactors data.
-
Replicate Chargebee Data to Multiple Databases via the CData Sync CLI
Replicate Chargebee data to disparate databases with a single configuration.
-
Connect and Visualize Live Microsoft Entra ID Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft Entra ID data into the Databricks platform and create visualization dashboards with real-time Microsoft Entra ID data.
-
Bind Live SAS xpt Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAS xpt data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Model SAP Business Warehouse Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Business Warehouse, enabling the direct import of real-time SAP Business Warehouse data.
-
How to connect to Pinecone Data from IntelliJ
Integrate connectivity to Pinecone data with wizards in IntelliJ.
-
Connect to Pingdom from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pingdom to connect to Pingdom data from Web applications running on WebLogic.
-
Process & Analyze OneNote Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live OneNote Data.
-
Operational Reporting on SAS Data Sets Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAS Data Sets data.
-
Integrating LangChain with Azure Data Catalog Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure Data Catalog data within automated workflows.
-
How to Connect Greenhouse Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Greenhouse data in real time using natural language.
-
Connect to Live Bannerbear Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Bannerbear in CData Connect AI and connect to your Bannerbear data from PostgreSQL.
-
Integrating GitHub Copilot with Sage Intacct 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.
-
Replicate Stack Exchange Data in Heroku for Use in Salesforce Connect
Replicate Stack Exchange data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connecting GenSpark with CSV Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to CSV data without any replication or custom integration required.
-
Create Informatica Mappings From/To an ODBC Data Source for EnterpriseDB
Create an ODBC connection to EnterpriseDB in Informatica and browse and transfer EnterpriseDB data.
-
DataBind Controls to Oracle HCM Cloud Data in C++Builder
DataBind to Oracle HCM Cloud data in C++Builder with standard components and controls.
-
Migrating data from Dotmailer to Google BigQuery using CData SSIS Components.
Easily push Dotmailer data to Google BigQuery using the CData SSIS Tasks for Dotmailer and Google BigQuery.
-
How to use SQLAlchemy ORM to access Elasticsearch Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Elasticsearch data.
-
Getting Started with the CData Excel Add-In for Google Search
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Search.
-
Integrate Theia IDE with Live Databricks 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 Databricks data from within the development environment.
-
Connect Bitly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Bitly with IBM WebSphere for seamless data integration and connectivity.
-
Integrating Codex with Adobe Experience Manager 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.
-
Consume Dynamics 365 Business Central OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Dynamics 365 Business Central feeds that reflect any changes in SAP Lumira.
-
Build an OLAP Cube in SSAS from Mailjet Data
Establish a connection to Mailjet data data from SQL Server Analysis Services, and use the Mailjet Data Provider to build OLAP cubes for use in analytics and reporting.
-
Deploy the ADO.NET Provider for Miro on an SSRS Report Server
Connect to Miro 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.
-
Use ChatGPT to Talk to Your Stripe 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 Stripe data for you.
-
Access Live SQL Server Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SQL Server data through MCP integration.
-
Connect to Templated Data in Ruby
Connect to Templated data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to load WooCommerce data into Elasticsearch via Logstash
Introducing a simple method to load WooCommerce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData ODBC Driver for Parallel from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Parallel to connect to Parallel data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Parallel data in Excel.
-
Use the CData ODBC Driver for Tanda from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Tanda to connect to Tanda data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Tanda data in Excel.
-
Integrate Live Kintone Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Kintone data to Blue Prism using the CData ODBC Driver for Kintone to create automated workflows for repetitive business tasks.
-
Connect to AlloyDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time AlloyDB data using standard SQL.
-
Create Paymo-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Paymo Data from OutSystems and build custom enterprise apps using live Paymo data.