CData Software - Knowledge Base
Recent Articles
-
Connect to Nethunt Data in Ruby
Connect to Nethunt data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Microsoft Dataverse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Microsoft Dataverse data access from reports, embedded analytics, and more.
-
Automate RabbitMQ Integration Tasks from PowerShell
Are you in search of a quick and easy way to access RabbitMQ data from PowerShell? This article demonstrates how to utilize the RabbitMQ Cmdlets for tasks like connecting to RabbitMQ data, automating operations, downloading data, and more.
-
Automated Continuous Telegram Replication to Oracle
Use CData Sync for automated, continuous, customizable Telegram replication to Oracle.
-
Connect to Live Campaigner Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Campaigner in CData Connect AI and connect to your Campaigner data from PostgreSQL.
-
Use ChatGPT to Talk to Your Sage 200 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 Sage 200 data for you.
-
Create Reports from Discord Data in Looker Studio
Use CData Connect AI to gain access to live Discord data and create custom reports in Looker Studio.
-
Automate Reply.io Data Replication to Azure Data Lake
Use CData Sync to customize and automate Reply.io data replication to Azure Data Lake.
-
Getting Started with the CData Power BI Connector for Wistia
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to create an RPA flow for IBM Cloud Object Storage Data in UiPath Studio
Use the IBM Cloud Object Storage ODBC Driver to create workflows that access real-time IBM Cloud Object Storage data without any coding.
-
Build a PostgreSQL Interface for Mailgun Data using the CData JDBC Driver
Use the Remoting features of the Mailgun JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Excel Add-In for Spark
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Spark.
-
Bidirectional Access to Gmail Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Gmail data in Filemaker Pro for Mac or Windows.
-
How to Easily Query ZohoExpense Data in OpenOffice Base
Connect to ZohoExpense data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Validate Mocean Data with QuerySurge
Access and validate Mocean data in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live Oracle Eloqua 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 Oracle Eloqua data for you.
-
Extract, Transform, and Load MessageBird Data in Informatica PowerCenter
Create a simple Workflow for MessageBird data in Informatica PowerCenter.
-
Integrating Cursor with Mocean 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.
-
Work with SAP Netweaver Gateway Data in FoxPro
Load SAP Netweaver Gateway data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Live Harvest Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Harvest data.
-
Recurly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Recurly facts in real time.
-
How to work with Redis Data in Apache Spark using SQL
Access and process Redis Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate with live MongoDB Data in Jitterbit
Use CData Connect AI to connect to and integrate live MongoDB data in Jitterbit.
-
Publish Attio-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Attio data.
-
How to integrate Metabase with Microsoft Ads Data
Use CData Connect AI to connect to live Microsoft Ads data and create an interactive dashboard in Metabase from Microsoft Ads data.
-
Automate Recurly Data Replication to Azure Synapse
Use CData Sync to customize and automate Recurly data replication to Azure Synapse.
-
DataBind WooCommerce Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for WooCommerce with the DevExpress Windows Forms and Web controls to provide WooCommerce data to a chart.
-
Bind Live Odoo Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Odoo data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate LibreChat with Live Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Timely data from within the chat interface.
-
Build Printify-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Printify data and build web apps with connectivity to live Printify data.
-
Integrate Live Dotmailer Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Dotmailer data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Live Cloudant Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Cloudant data to Blue Prism using the CData ODBC Driver for Cloudant to create automated workflows for repetitive business tasks.
-
Connect to Sendwithus Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sendwithus data.
-
Use the CData ODBC Driver for Salesforce CRM Analytics from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce CRM Analytics to connect to Salesforce CRM Analytics data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce CRM Analytics data in Excel.
-
Automated Continuous Billsby Replication to Vertica
Use CData Sync for automated, continuous, customizable Billsby replication to Vertica.
-
Connect to GraphQL Data in RapidMiner
Integrate GraphQL data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Bitbucket Data in DBArtisan
Use wizards in DBArtisan to configure Bitbucket data as a data source.
-
Connect to Campaigner Data from a Connection Pool in Jetty
The Campaigner JDBC Driver supports connection pooling: This article shows how to connect faster to Campaigner data from Web apps in Jetty.
-
Access Facebook Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Facebook data from your Oracle system.
-
Automate Mouseflow Data Replication to Couchbase
Use CData Sync to Customize and automate Mouseflow data replication to Couchbase.
-
How to Visualize DocuSign Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live DocuSign data in Python.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LaunchDarkly
Provide connectivity to LaunchDarkly data through an SAP BusinessObjects universe.
-
Integrate Live Act-On Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Act-On from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Act-On data.
-
Use the CData Software ODBC Driver for PostgreSQL in MicroStrategy Web
Connect to PostgreSQL data in MicroStrategy Web using the CData Software ODBC Driver for PostgreSQL.
-
Access Live RSS Feeds in Excel 365 Online (Excel for the web)
Connect to RSS feeds from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Dashboards with Instagram Data in Dundas BI
Create dynamic dashboards and perform analytics based on Instagram data in Dundas BI.
-
How to Connect to SurveyMonkey Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SurveyMonkey data. Leverage the pyodbc module for ODBC in Python.
-
Analyze Azure Data Catalog Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Azure Data Catalog data in Microsoft R Open.
-
Feed Dynamics 365 Data into FineReport
How to set Dynamics 365 data as a JDBC data source in FineReport.
-
How to Seamlessly Import Close Data into IBM SPSS Modeler
Integrate Close data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to DB2 Data in ACL Analytics
Connect to DB2 data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to DB2 data.
-
Splunk Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Splunk facts in real time.
-
Integrating Kiro with Jira 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.
-
Access Live Timely Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Timely data through MCP integration.
-
How to Connect to Live Zendesk Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Zendesk data through natural language.
-
Access Clockify Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Clockify data.
-
Visualize Avalara AvaTax Data in Sisense
Create an ElastiCube in Sisense app with access to Avalara AvaTax data.
-
Superchat Reporting in OBIEE with the Superchat JDBC Driver
Deploy the Superchat JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Apify Data in ACL Analytics
Connect to Apify data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apify data.
-
Use Biml to Build SSIS Tasks to Replicate LaunchDarkly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate LaunchDarkly data to SQL Server.
-
Connect to Acumatica Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Acumatica data.
-
Enable the ZeroBounce JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZeroBounce data.
-
Getting Started with the CData SSIS Components for SuiteCRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SuiteCRM.
-
How to connect to Teamgate Data in DBVisualizer
Integrate Teamgate data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Trello Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Trello replication to Azure SQL Database.
-
Automated Continuous NetSuite SuiteAnalytics Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics data replication to OneLake in Microsoft Fabric.
-
Visualize VWO Data in TIBCO Spotfire through ADO.NET
Integrate VWO data into dashboards in TIBCO Spotfire.
-
Automated Continuous HBase Replication to MongoDB
Use CData Sync for automated, continuous, customizable HBase replication to MongoDB.
-
Replicate MariaDB Data to Multiple Databases
Replicate MariaDB data to disparate databases with a point-and-click configuration.
-
How to connect to Customer.io Data with Squirrel SQL client
Connect to Customer.io data and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData ODBC Driver for MongoDB
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for MongoDB.
-
How to Connect to Live Xero Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Xero data for you.
-
How to Visualize SparkPost Data in Python with pandas
Use pandas and other modules to analyze and visualize live SparkPost data in Python.
-
View Reports on Real-Time CouchDB Data in Power BI Report Server
Use the CData ODBC Driver for CouchDB to visualize CouchDB data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build AI Agents with Typeform Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Typeform data through CData Connect AI.
-
Integrating LlamaIndex with IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on IBM Informix data in real time.
-
Use Microsoft Copilot Studio to talk to your HDFS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your HDFS data for you.
-
Automated Continuous Google Ad Manager Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to SQL Server.
-
Analyze Live Presto Data in SAS Viya
Use CData Connect AI to connect to Presto data from SAS Viya and deploy self-service analytics using live Presto data.
-
Automated Continuous SpaceX Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SpaceX replication to Google BigQuery.
-
How to create an RPA flow for Bullhorn CRM Data in UiPath Studio
Use the Bullhorn CRM ODBC Driver to create workflows that access real-time Bullhorn CRM data without any coding.
-
Analyze xBase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of xBase data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Sage 200 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sage 200 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Dashboards with Parquet Data in Dundas BI
Create dynamic dashboards and perform analytics based on Parquet data in Dundas BI.
-
Replicate Multiple Active Directory Accounts via the CData Sync CLI
Replicate multiple Active Directory accounts to one or many databases.
-
A PostgreSQL Interface for Jira Data using the CData ODBC Driver
Use the SQL Gateway and Jira ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LangGraph with Figshare Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Figshare data within automated workflows.
-
Build Dashboards with BambooHR Data in Dundas BI
Create dynamic dashboards and perform analytics based on BambooHR data in Dundas BI.
-
Import Real-Time FormSite Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use FormSite data in ColdFusion.
-
Publish Crystal Reports on Amazon DynamoDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Amazon DynamoDB data.
-
Design BIRT Reports on Coinbase Data
Provide current Coinbase data to your embedded analytics.
-
Build Oracle Service Cloud-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Oracle Service Cloud data.
-
Build Dashboards with Twilio Data in DBxtra
Create dynamic dashboards and perform analytics based on Twilio data in DBxtra.
-
Access Live AlloyDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live AlloyDB data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate OpenCode with Live Google Ads Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Google Ads data from within your AI coding agent.
-
Create Power BI Reports on Real-Time MongoDB Data
Use the CData ODBC Driver for MongoDB to visualize MongoDB data in Power BI Desktop.
-
How to Access Twilio Data Using Entity Framework
This article shows how to access Twilio data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Consume Avalara AvaTax OData Feeds in PowerBuilder
This article demonstrates how to consume Avalara AvaTax data as OData feeds from PowerBuilder using the API Server.
-
Automate Greenplum Data Replication to Azure Data Lake
Use CData Sync to customize and automate Greenplum data replication to Azure Data Lake.
-
Automated Continuous SendInBlue Replication to MySQL
Use CData Sync for automated, continuous, customizable SendInBlue replication to MySQL.