CData Software - Knowledge Base
Recent Articles
-
Integrate with Live HCL Domino Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to HCL Domino from the MuleSoft Anypoint Platform to integrate live HCL Domino data into custom reports and dashboards.
-
Salesforce Data 360 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesforce Data 360 facts in real time.
-
Integrate SingleStore Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SingleStore data and integrate live SingleStore data into your Power Automate tasks.
-
How to connect to SharePoint Excel Services Data from IntelliJ
Integrate connectivity to SharePoint Excel Services data with wizards in IntelliJ.
-
Building Dynamic Web Pages with SAP Data Using AngularJS
Create single-page applications with live connectivity to SAP using the CData API Server.
-
Automated Continuous Toggl Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Toggl replication to Apache Cassandra.
-
How to Connect to Live Typeform Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Typeform data securely in real time.
-
A PostgreSQL Interface for Zoho Recruit Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Recruit JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Google's Vertex AI Agent with Live Salesforce Marketing 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 Salesforce Marketing data within intelligent workflows.
-
Connect to Microsoft Exchange Data in Ruby
Connect to Microsoft Exchange data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Work with Nuclia Data in AWS Glue Jobs Using JDBC
Connect to Nuclia from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Odoo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Odoo data from your Oracle system.
-
Query, Visualize, and Share live Amazon S3 Data in Redash
Use CData Connect AI to connect to live Amazon S3 data in Redash for querying, visualizing, and sharing.
-
Create Power BI Reports on Real-Time ActiveCampaign Data
Use the CData ODBC Driver for ActiveCampaign to visualize ActiveCampaign data in Power BI Desktop.
-
Import Real-Time Oracle Service Cloud Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle Service Cloud data in ColdFusion.
-
Provide OData Services of Quickbase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Quickbase data by developing a WCF Service Application.
-
Connecting Pipedream with CouchDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on CouchDB data in real time.
-
Link Productboard with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Productboard data in Filemaker Pro for Mac or Windows.
-
Build a Singer.io Tap for Bright Data With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Bright Data data using the CData Python Connector.
-
LINQ to FHIR 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 FHIR Data Provider.
-
Stream Cvent Data into Apache Kafka Topics
Access and stream Cvent data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize SFTP Data in Sisense
Create an ElastiCube in Sisense app with access to SFTP data.
-
DataBind Autopilot Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Autopilot data to a chart.
-
Create Informatica Mappings From/To a JDBC Data Source for SAS Data Sets
Create SAS Data Sets data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Nethunt Data in DBArtisan
Use wizards in DBArtisan to configure Nethunt data as a data source.
-
Query Live Okta 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 Okta data through a conversational interface.
-
Connect to Cvent Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Cvent data.
-
How to Create Power BI Visual Reports with Real-Time Qualaroo Data
Use CData Power BI Connectors to visualize Qualaroo data in Power BI.
-
Integrating GitHub Copilot with Amazon Athena 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.
-
Create Reports with IBM Informix Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date IBM Informix data.
-
Access BigQuery Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live BigQuery data from HeidiSQL.
-
Connect to BigCommerce Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time BigCommerce data using standard SQL.
-
Build Visualizations of Bitly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bitly data in Birst.
-
Connect to Wistia Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Wistia Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Trae with Live SharePoint Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SharePoint data from within the AI-powered IDE.
-
How to connect to HelloSign Data with Squirrel SQL client
Connect to HelloSign data and execute queries in the Squirrel SQL Client.
-
Use the CData Software JDBC Driver for SuiteCRM in MicroStrategy Desktop
Connect to SuiteCRM data in MicroStrategy Desktop using the CData Software JDBC Driver for SuiteCRM.
-
Easily Integrate JotForm Data in Lazarus Pascal IDE
Learn how to easily integrate live JotForm data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Query ConvertAPI Data in DataGrip
Create a Data Source for ConvertAPI in DataGrip and use SQL to query live ConvertAPI data.
-
Automated Continuous Dotmailer Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Dotmailer replication to AlloyDB.
-
Analyze Todoist Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Todoist from Power Pivot. You will use the Table Import Wizard to load Todoist data. You can visually build the import query or use any SQL supported by the driver.
-
Operational Reporting on SAP Fieldglass Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP Fieldglass data.
-
Create Splunk-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Splunk Data from Klipfolio and build custom visualizations using live Splunk data.
-
Use Agno to Talk to Your Zendesk 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 Zendesk data for you.
-
Integrating Claude Code CLI with Blackbaud FE NXT 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.
-
Automated Continuous Kintone Replication to SingleStore
Use CData Sync for automated, continuous, customizable Kintone replication to SingleStore.
-
Use ChatGPT to Talk to Your MailChimp 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 MailChimp data for you.
-
Access Live Beeminder Data in Coginiti Pro
Connect to and query live Beeminder data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Dotmailer in MicroStrategy Desktop
Connect to Dotmailer data in MicroStrategy Desktop using the CData Software ODBC Driver for Dotmailer.
-
Integrate with Salesforce CRM Analytics Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Salesforce CRM Analytics data in SnapLogic.
-
Automated Continuous CSV Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable CSV replication to Apache Kafka.
-
Choosing the Best Method to Connect Scrapfly to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Scrapfly data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Explore Geographical Relationships in Insightly Data with Power Map
Create data visualizations with Insightly data in Power Map.
-
How to create an RPA flow for Azure Data Lake Storage Data in UiPath Studio
Use the Azure Data Lake Storage ODBC Driver to create workflows that access real-time Azure Data Lake Storage data without any coding.
-
ETL SharePoint Excel Services in Oracle Data Integrator
This article shows how to transfer SharePoint Excel Services data into a data warehouse using Oracle Data Integrator.
-
How to connect PolyBase to Mailjet
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Mailjet data.
-
Build Chargebee-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Chargebee data and build web apps with connectivity to live Chargebee data.
-
Automated Continuous Xero Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Xero replication to AlloyDB.
-
Automated Continuous Paymo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Paymo replication to Amazon Redshift.
-
Automate Confluence Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Confluence data from PowerShell? This article demonstrates how to utilize the Confluence Cmdlets for tasks like connecting to Confluence data, automating operations, downloading data, and more.
-
Automate Calendly Data Replication to SAP HANA
Use CData Sync to customize and automate Calendly data replication to SAP HANA.
-
Automated Continuous ClickTime Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ClickTime replication to Amazon Redshift.
-
Connect to ZeroBounce Data in Aqua Data Studio
Access ZeroBounce data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live Avalara AvaTax Data in Coginiti Pro
Connect to and query live Avalara AvaTax data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query Shopify Data in ColdFusion
Write standard ColdFusion data access code to connect to Shopify data.
-
Create Data Visualizations in Cognos BI with Zendesk Data
Access Zendesk data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Data Flows from Raisers Edge NXT to SQL Server using SSIS
Easily back up Raisers Edge NXT data to SQL Server using the SSIS components for Raisers Edge NXT.
-
Analyze Live SageHR Data in SAS Viya
Use CData Connect AI to connect to SageHR data from SAS Viya and deploy self-service analytics using live SageHR data.
-
Model Tally Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Tally, enabling the direct import of real-time Tally data.
-
Integrate SAP HANA Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP HANA data and integrate live SAP HANA data into your Power Automate tasks.
-
Build SuiteCRM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SuiteCRM data and build visualizations in Tableau.
-
Object-Relational Mapping (ORM) with RSS Feeds 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 RSS feeds into a Java-based ORM framework, Hibernate.
-
How to connect to Attio Data from Spring Boot
Connect to Attio in a Spring Boot Application using the CData API Driver for JDBC
-
Visualize EmailOctopus Data in TIBCO Spotfire through ADO.NET
Integrate EmailOctopus data into dashboards in TIBCO Spotfire.
-
Replicate ZohoExpense Data to Multiple Databases
Replicate ZohoExpense data to disparate databases with a point-and-click configuration.
-
Query Live MYOB AccountRight 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 MYOB AccountRight data through a conversational interface.
-
DataBind Controls to Zoho CRM Data in Delphi
DataBind to Zoho CRM data in Delphi with standard data access components and controls.
-
Use ChatGPT to Talk to Your MongoDB 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 MongoDB data for you.
-
How to Connect to Live ActiveCampaign Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ActiveCampaign data without replication.
-
Automated Basecamp Data Replication to Teradata
Use CData Sync to Customize and automate Basecamp data replication to Teradata.
-
Connect to AlloyDB Data in RapidMiner
Integrate AlloyDB data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Visualizations of PabblySubscriptions Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PabblySubscriptions data in Birst.
-
Integrate OpenCode with Live GetResponse Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live GetResponse data from within your AI coding agent.
-
Using the CData Software ODBC Driver for Sage Intacct in PyCharm
Connect to Sage Intacct as an ODBC data source in PyCharm using the CData Software ODBC Driver for Sage Intacct.
-
Automated Continuous WordPress Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable WordPress replication to Google BigQuery.
-
Connect to SAP Business One from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Business One data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Deel Data in TIBCO Spotfire through ADO.NET
Integrate Deel data into dashboards in TIBCO Spotfire.
-
Replicate eBay Analytics Data from PowerShell
Write a quick PowerShell script to query eBay Analytics data. Use connectivity to the live data to replicate eBay Analytics data to SQL Server.
-
Use the CData Software ODBC Driver for Everhour in MicroStrategy Web
Connect to Everhour data in MicroStrategy Web using the CData Software ODBC Driver for Everhour.
-
Automate Microsoft OneLake Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft OneLake data replication to Azure Synapse.
-
Integrate with SAP Concur Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Concur data to a JSON file on disk.
-
Create Quickbase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Quickbase data access from reports, embedded analytics, and more.
-
Automated Continuous Close Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Close replication to delimited files (CSV/TSV).
-
Use Grok to Talk to Your ClickUp 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 ClickUp data for you.
-
How to Access ZendeskSell Data Using Entity Framework
This article shows how to access ZendeskSell data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with Amazon Athena Data in JReport Designer
Create charts and reports based on Amazon Athena data in JReport Designer.
-
Connect to MYOB AccountRight Data in RapidMiner
Integrate MYOB AccountRight data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to load Drip data into Elasticsearch via Logstash
Introducing a simple method to load Drip data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Visualize HBase Data in Python with pandas
Use pandas and other modules to analyze and visualize live HBase data in Python.
-
How to integrate Metabase with Oracle Financials Cloud Data
Use CData Connect AI to connect to live Oracle Financials Cloud data and create an interactive dashboard in Metabase from Oracle Financials Cloud data.