CData Software - Knowledge Base
Recent Articles
-
Connect to Simplesat in SpagoBI
Create reports featuring live Simplesat in SpagoBI Studio. Host Simplesat reports on SpagoBI Server.
-
Use Microsoft Copilot Studio to talk to your Klaviyo 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 Klaviyo for you.
-
Build AI Agents with Twilio 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 Twilio through CData Connect AI.
-
Load WordPress Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load WordPress to a database.
-
Getting Started with the CData ODBC Driver for Unbounce
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Unbounce.
-
How to import Salesforce Marketing Data into Apache Solr
Use the CData Software JDBC Driver for Salesforce Marketing in Data Import Handler and create an automated import of Salesforce Marketing Cloud to Apache Solr Enterprise Search platform.
-
Analyze EnterpriseDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for EnterpriseDB from Power Pivot. You will use the Table Import Wizard to load EnterpriseDB. You can visually build the import query or use any SQL supported by the driver.
-
Use Manus AI to Talk to Your CSV 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 CSV/TSV Files.
-
DataBind PDFMonkey Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide PDFMonkey to a chart.
-
Connect to Paddle Data in DBArtisan
Use wizards in DBArtisan to configure Paddle as a data source.
-
View Reports on Real-Time Bright Data Data in Power BI Report Server
Use the CData ODBC Driver for Bright Data to visualize Bright Data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Impala Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Apache Impala in Airbyte.
-
Explore Geographical Relationships in Facebook Ads Data with Power Map
Create data visualizations with Facebook Ads in Power Map.
-
Connect to Pipedrive from Asprova with CData Software ODBC Driver for Pipedrive
This article shows how to connect faster to Pipedrive data from Asprova.
-
Integrate with Rootly Data in JReport Designer
Create charts and reports based on Rootly in JReport Designer.
-
Build Spark-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache Spark SQL and build web apps with connectivity to live Apache Spark SQL.
-
How to Access Hubstaff Data Using Entity Framework
This article shows how to access Hubstaff using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Manage Sybase IQ Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sybase IQ.
-
DataBind OData Services to the DevExpress Data Grid
Use the CData ADO.NET Provider for OData with the DevExpress Windows Forms and Web controls to provide OData to a chart.
-
Working with Jira Data in LINQPad
Execute LINQ queries to Atlassian Jira in LINQPad.
-
Automated Continuous PolarTeamPro Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Apache Cassandra.
-
Create Dashboards and Visualize Live Basecamp Data in Geckoboard
Use CData Connect AI to connect to live Basecamp and create dashboards for real-time monitoring and visualization in Geckoboard.
-
DataBind Charts to Tanda Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Tanda from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build Automated Workflows with Live Zoho Inventory Data in Workato
Use CData Connect AI to connect to live Zoho Inventory and build automated workflows in Workato.
-
Automated GetResponse Data Replication to Teradata
Use CData Sync to Customize and automate GetResponse replication to Teradata.
-
Create LinkedIn Ads-Connected Business Apps in AppSheet
Connect to LinkedIn Ads Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to LinkedIn Ads.
-
Back Up Tanda to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Tanda data.
-
Connecting Agentforce with Square 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 Square for you.
-
Automated Continuous CSV Replication to Oracle
Use CData Sync for automated, continuous, customizable CSV replication to Oracle.
-
Getting Started with the CData ODBC Driver for Microsoft Entra ID
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Microsoft Entra ID.
-
How to Visualize Zoho Inventory Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho Inventory in Python.
-
Build Automated Workflows with Live Epicor Kinetic Data in Workato
Use CData Connect AI to connect to live Epicor Kinetic and build automated workflows in Workato.
-
Create Informatica Mappings From/To an ODBC Data Source for MessageBird
Create an ODBC connection to MessageBird in Informatica and browse and transfer MessageBird.
-
Build OneNote-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft OneNote and build OneNote-connected web apps with Axios.
-
Connect to WooCommerce Data from a Connection Pool in JBoss
Integrate WooCommerce into Java servlets: Use the Management Console in JBoss to install the WooCommerce JDBC Driver.
-
Build Apps with Live Aha! Data Using the Low-Code Development Platform of Mendix
Connect Aha! with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Office 365 Data in ACL Analytics
Connect to Microsoft Office 365 via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Office 365.
-
How to Work with Eventbrite Data in ETL Validator JDBC
Connect to Eventbrite from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Twilio Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Twilio and integrate live Twilio into your Power Automate tasks.
-
A PostgreSQL Interface for HubDB Data (MySQL Remoting via JDBC)
Use the Remoting features of the HubDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect Guru Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Guru using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Load Zuora Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zuora to a database.
-
Automated Continuous CockroachDB Replication to Databricks
Use CData Sync for automated, continuous, customizable CockroachDB replication to Databricks.
-
How to create Google Cloud Storage federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Cloud Storage in MySQL .
-
Replicate Multiple Dotmailer Accounts via the CData Sync CLI
Replicate multiple Dotmailer accounts to one or many databases.
-
Edit and Search Smartsheet External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Smartsheet to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Smartsheet objects that you can access from apps and the dashboard.
-
Analyze Live Azure DevOps Data in SAS Viya
Use CData Connect AI to connect to Azure DevOps from SAS Viya and deploy self-service analytics using live Azure DevOps.
-
Access Live Customer.io Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Customer.io in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Real-Time Access to Zoho CRM in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoho CRM in real time.
-
How to Seamlessly Import Aweber Data into IBM SPSS Modeler
Integrate Aweber data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Azure Analysis Services-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Azure Analysis Services to explore live Azure Analysis Services Data in Cursor to assist with building Azure Analysis Services-powered applications.
-
Query Sybase Data as a SQL Server Database in Node.js
Execute SQL Server queries against Sybase from Node.js.
-
Analyze Sage 300 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sage 300 in Microsoft R Open.
-
Import Real-Time MariaDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MariaDB in ColdFusion.
-
Automated Continuous Cloudant Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Cloudant replication to Google BigQuery.
-
Create Reports from Databricks Data in Looker Studio
Use CData Connect AI to gain access to live Databricks and create custom reports in Looker Studio.
-
Process & Analyze LionDesk Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live LionDesk Data.
-
Query eBay Data in ColdFusion
Write standard ColdFusion data access code to connect to eBay.
-
Access Live Greenplum Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Pivotal GreenPlum from your Excel spreadsheets.
-
Bridge Deel Connectivity with Apache NiFi
Access and process Deel in Apache NiFi using the CData JDBC Driver.
-
Connect to JotForm Data in Aqua Data Studio
Access JotForm from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access MailChimp Data from MySQL in Amazon QuickSight
Connect to MailChimp and build visualizations of MailChimp using a MySQL Connection in Amazon QuickSight.
-
Replicate Multiple Presto Accounts
Replicate multiple Presto accounts to one or many databases.
-
Build a Singer.io Tap for EmailOctopus With the CData Python Connector
Learn how to easily build a Singer.io Tap for live EmailOctopus data using
-
Build Charts with SAS Data Sets Data in Clear Analytics
Create dynamic charts and perform analytics based on SAS Data Sets in Clear Analytics.
-
Connect to NASA 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 NASA and work with NASA in your FileMaker application.
-
Moving Data from Everhour to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Everhour data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build an OLAP Cube in SSAS from MYOB AccountRight Data
Establish a connection to MYOB AccountRight data from SQL Server Analysis Services, and use the MYOB AccountRight Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build SAP SuccessFactors LMS Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP SuccessFactors LMS and build visualizations in Tableau Cloud.
-
Build a PostgreSQL Interface for Instagram Data using the CData JDBC Driver
Use the Remoting features of the Instagram JDBC Driver to create a PostgreSQL entry-point for data access.
-
Google Spanner Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Spanner facts in real time.
-
Visualize Live Basecamp Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Basecamp into custom reports in Power BI.
-
Connect and Query Live SAP Fieldglass Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP Fieldglass into Databricks
-
How to integrate SAP BusinessObjects BI with Apache Airflow
Access and process SAP BusinessObjects BI in Apache Airflow using the CData JDBC Driver.
-
Access Live MariaDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MariaDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use JayDeBeApi to access Sybase IQ Data in Python
Use standard Python scripting and the development environment of your choice to access live Sybase IQ.
-
Connect to Lakebase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Lakebase in the Denodo Virtual DataPort Administrator.
-
How to load Harvest data into Elasticsearch via Logstash
Introducing a simple method to load Harvest data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect Freshsales to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Freshsales using the CData Python MCP Server.
-
Connect to Salesforce Pardot Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce Pardot.
-
Replicate iContact Data to Multiple Databases via the CData Sync CLI
Replicate iContact to disparate databases with a single configuration.
-
Access Egnyte Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Egnyte from HeidiSQL.
-
Active Directory Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Active Directory facts in real time.
-
Connect to and Visualize Live Certinia Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Certinia.
-
Integrate LibreChat with Live Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle SCM from within the chat interface.
-
How to Create Power BI Visual Reports with Real-Time WordPress Data
Use CData Power BI Connectors to visualize WordPress in Power BI.
-
Connect to Twitter Ads Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Twitter Ads Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Power BI Reports on Real-Time Dropbox Data
Use the CData ODBC Driver for Dropbox to visualize Dropbox in Power BI Desktop.
-
Create Informatica Mappings From/To a JDBC Data Source for SingleStore
Create SingleStore data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Configure the CData JDBC Driver for Dynamics CRM in a Connection Pool in Tomcat
Connect to Microsoft Dynamics CRM from a connection pool in Tomcat.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed RSS Feeds to Power BI dashboards. Simply drag and drop RSS Feeds into data visuals on the Power BI canvas.
-
Use Dash to Build to Web Apps on Facebook Ads Data
Create Python applications that use pandas and Dash to build Facebook Ads-connected web apps.
-
Connect to Twilio Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Twilio.
-
Access Jira 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 Atlassian Jira.
-
Connect to Templated Data in DBeaver
Use the CData ODBC Driver to connect to Templated in DBeaver.
-
Access CapsuleCRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live CapsuleCRM from HeidiSQL.
-
Connect to ConstantContact Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ConstantContact and the SQL Gateway to access ConstantContact from Google Apps Script.
-
How to Connect to Live Microsoft OneDrive 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 Microsoft OneDrive for you.
-
Create Cassandra-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Cassandra Data from OutSystems and build custom enterprise apps using live Apache Cassandra.
-
How to Build an ETL App for Bitly Data in Python with CData
Create ETL applications and real-time data pipelines for Bitly in Python with petl.