CData Software - Knowledge Base
Recent Articles
-
Back Up Tally data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Tally. In this article, we will employ an SSIS workflow to populate a database with Tally data data.
-
Integrate Trae with Live MariaDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live MariaDB data from within the AI-powered IDE.
-
Automated Continuous Superchat Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Superchat replication to Apache Cassandra.
-
Use the CData Software JDBC Driver for SAP Business Warehouse in MicroStrategy Web
Connect to SAP Business Warehouse data in MicroStrategy Web using the CData Software JDBC Driver for SAP Business Warehouse.
-
How to import Elasticsearch Data into Apache Solr
Use the CData Software JDBC Driver for Elasticsearch in Data Import Handler and create an automated import of Elasticsearch data to Apache Solr Enterprise Search platform.
-
Automated Continuous ServiceDesk Plus Replication to Oracle
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to Oracle.
-
Automated Continuous Beeminder Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Beeminder replication to Google Cloud SQL.
-
Edit and Search External Klaviyo Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Klaviyo data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Klaviyo Data objects that you can access from apps and the dashboard.
-
Use the CData Software JDBC Driver for SAP HANA in MicroStrategy Desktop
Connect to SAP HANA data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP HANA.
-
Create IBM Informix Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time IBM Informix data access from reports, embedded analytics, and more.
-
Integrate Devin with Live Samanage Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Samanage data.
-
Replicate Multiple Paddle Accounts via the CData Sync CLI
Replicate multiple Paddle accounts to one or many databases.
-
Query Asana Data in ColdFusion
Write standard ColdFusion data access code to connect to Asana data.
-
How to Work with AlloyDB Data in ETL Validator JDBC
Connect to AlloyDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Clockify Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Clockify and the SQL Gateway to access Clockify data from Google Apps Script.
-
How to Access Live Tavily Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Tavily enables you to integrate Tavily data into workflows built using Microsoft Power Automate Desktop.
-
Access Epicor Kinetic 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 Epicor Kinetic data.
-
How to Connect to Live Splunk Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Splunk data for you.
-
How to Connect DBeaver to Printful via a JDBC Driver
Manage Printful data with visual tools in DBeaver like the query browser.
-
Getting Started with the CData Tableau Connector for Miro
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate Open WebUI with Live MailerLite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live MailerLite data from within the chat interface.
-
How to connect to Jumpseller Data from Spring Boot
Connect to Jumpseller in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Reckon Accounts Hosted Data in NetBeans
Connect to Reckon Accounts Hosted data in NetBeans with the data source configuration wizard.
-
Import Vault CRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Vault CRM Data and provide access to live Vault CRM data for custom reports in the Power BI Service.
-
Analyze Cosmos DB Data in Looker
Use CData Connect AI to connect to Cosmos DB Data from Looker and build custom apps using live Cosmos DB data.
-
Deploy the ADO.NET Provider for Twitter Ads on an SSRS Report Server
Connect to Twitter Ads 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.
-
Create Reports with Qualaroo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Qualaroo data.
-
Analyze Sybase IQ Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sybase IQ data with the CData JDBC Driver for Sybase IQ.
-
Access Live Shippo Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Shippo data from your Excel spreadsheets.
-
Publish Reports with Oracle Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle data.
-
Back Up Dotmailer data 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 Dotmailer data data.
-
View Reports on Real-Time Egnyte Data in Power BI Report Server
Use the CData ODBC Driver for Egnyte to visualize Egnyte data in Power BI Desktop and then publish them to Power BI Report Server.
-
A PostgreSQL Interface for Dynamics NAV Data (MySQL Remoting via JDBC)
Use the Remoting features of the Dynamics NAV JDBC Driver to create a PostgreSQL entry-point for data access.
-
Back Up Azure Data Catalog data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure Data Catalog. In this article, we will employ an SSIS workflow to populate a database with Azure Data Catalog data data.
-
Build OData-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live OData services.
-
Publish Datadog-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Datadog data.
-
Create AfterShip-Connected Applications in Appsmith
Connect to AfterShip Data via CData Connect AI in Appsmith and create custom business applications with real-time access to AfterShip data.
-
Use the CData Software JDBC Driver for Odoo in MicroStrategy
Connect to Odoo data in MicroStrategy Developer using the CData Software JDBC Driver for Odoo.
-
How to connect to Avro Data in DBVisualizer
Integrate Avro data with visual data analysis tools and data connection wizards in DBVisualizer
-
Deploy the ADO.NET Provider for Pipeline CRM on an SSRS Report Server
Connect to Pipeline CRM 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.
-
Create Active Directory Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Active Directory data access from reports, embedded analytics, and more.
-
How to Work with Tanda Data in AWS Glue Jobs Using JDBC
Connect to Tanda from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Theia IDE with Live SendPulse 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 SendPulse data from within the development environment.
-
Integrate Devin with Live Kintone Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Kintone data.
-
Build Dashboards with PhantomBuster Data in Dundas BI
Create dynamic dashboards and perform analytics based on PhantomBuster data in Dundas BI.
-
Edit and Search External Workday Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Workday data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Workday Data objects that you can access from apps and the dashboard.
-
Use the CData ODBC Driver for Shippo in Microsoft Power Query
You can use the CData Shippo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Shippo data into Microsoft Power Query.
-
Automated Continuous Pingdom Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Pingdom replication to Azure SQL Database.
-
Use Grok to Talk to Your Freshdesk 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 Freshdesk data for you.
-
Create Reports with ZarMoney Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZarMoney data.
-
Query Epicor Kinetic Data as a MySQL Database in Node.js
Execute MySQL queries against Epicor Kinetic data from Node.js.
-
Use the CData Software ODBC Driver for Snowflake in SAS for Real-Time Reporting and Analytics
Connect to real-time Snowflake data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Snowflake.
-
Build Acumatica-Connected Apps in Choreo
Use CData Connect AI to connect to Acumatica Data from Choreo and build custom apps using live Acumatica data.
-
Access Live Timely Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Timely data from your Excel spreadsheets.
-
How to Visualize MySQL Data in Python with pandas
Use pandas and other modules to analyze and visualize live MySQL data in Python.
-
How to Connect to ShipEngine Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ShipEngine data. Leverage the pyodbc module for ODBC in Python.
-
Access Demio Data from MySQL in Amazon QuickSight
Connect to Demio and build visualizations of Demio data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Workday Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Workday replication to Apache Kafka.
-
Build MVC Applications with Connectivity to Xero Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Xero from an ASP.NET MVC application.
-
Connect to ClickTime Data in DBArtisan
Use wizards in DBArtisan to configure ClickTime data as a data source.
-
Connect to SendPulse Data in DBeaver
Use the CData ODBC Driver to connect to SendPulse data in DBeaver.
-
Connect to Shopify Data in Jaspersoft Studio
Execute SQL to remote Shopify data in Jaspersoft Studio.
-
Getting Started with the CData Python Connector for Tickspot
Learn to install and license the CData Python Connector and configure a connection to live Tickspot data.
-
Enable the Samanage JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Samanage data.
-
How to Connect the Power BI Service to QuickBooks Time: Complete Guide
Connect to the CData Software Power BI Connector for QuickBooks Time from PowerBI.com to provide real-time QuickBooks Time data across the organization.
-
Use Azure AI Foundry to Talk to Your Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Facebook data for you.
-
Use the CData Software JDBC Driver for SendInBlue in MicroStrategy
Connect to SendInBlue data in MicroStrategy Developer using the CData Software JDBC Driver for SendInBlue.
-
Use Dash to Build to Web Apps on Monday.com Data
Create Python applications that use pandas and Dash to build Monday.com-connected web apps.
-
Build Redshift-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Redshift data.
-
Automated Continuous WooCommerce Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable WooCommerce replication to Apache Cassandra.
-
Prepare, Blend, and Analyze AgileCRM Data in Alteryx Designer (Connect AI)
Build workflows to access live AgileCRM data for self-service data analytics.
-
Build Automated Microsoft Entra ID-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Entra ID data and build automated workflows in Zapier.
-
Publish Gorgias-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Gorgias data.
-
Import and Visualize SAP Business Warehouse Data in Power View
Create data visualizations based on SAP Business Warehouse data in Excel.
-
How to Access Live Jira Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Jira enables you to integrate Jira data into workflows built using Microsoft Power Automate Desktop.
-
How to create Freshteam federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Freshteam data in MySQL .
-
Connect to Cosmos DB Data in DBArtisan
Use wizards in DBArtisan to configure Cosmos DB data as a data source.
-
Model, Search, and Visualize Live Snapchat Ads Data in ThoughtSpot
Use CData Connect AI to connect to live Snapchat Ads data for modeling, searching, and visualizing.
-
Integrating LangGraph with Apify Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Apify data within automated workflows.
-
Automated Continuous HubSpot Replication to SQLite
Use CData Sync for automated, continuous, customizable HubSpot replication to SQLite.
-
Create SSAS Tabular Models from Facebook Ads Data
How to build a SQL Server Analysis Service Tabular Model from Facebook Ads data using CData drivers.
-
Integrate Goose with Live Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Oracle data from within the local AI agent.
-
Automated Continuous Eventbrite Replication to SQLite
Use CData Sync for automated, continuous, customizable Eventbrite replication to SQLite.
-
Use Azure AI Foundry to Talk to Your ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your ConstantContact data for you.
-
Create BenchmarkEmail-Connected Nintex Workflows
Use CData Connect AI to connect to BenchmarkEmail Data from Nintex Workflow Cloud and build custom workflows using live BenchmarkEmail data.
-
Integrating Boomi Agentstudio with QuickBooks Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to QuickBooks data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to SuiteCRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live SuiteCRM data from Crystal Reports.
-
How to Use a Microsoft Access Database to Update Square Data in Real Time
Update Square data by creating a linked table in Microsoft Access with the CData Square ODBC Driver.
-
Create Suadeo-Connected Dashboards in Grafana
Connect to Suadeo Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Suadeo data.
-
Model DB2 Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and DB2, enabling the direct import of real-time DB2 data.
-
Access Live ShipEngine Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ShipEngine data from your Google Sheets.
-
Automated Continuous Greenplum Replication to SingleStore
Use CData Sync for automated, continuous, customizable Greenplum replication to SingleStore.
-
Choosing the Best Method to Connect Salesforce Data 360 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Salesforce Data 360 data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Copper Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Copper and the SQL Gateway to access Copper data from Google Apps Script.
-
Replicate Float Data to Multiple Databases via the CData Sync CLI
Replicate Float data to disparate databases with a single configuration.
-
Automated Continuous Oracle Service Cloud Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to SQL Server.
-
Connect to ShipEngine Data in RapidMiner
Integrate ShipEngine data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to create an RPA flow for Facebook Data in UiPath Studio
Use the Facebook ODBC Driver to create workflows that access real-time Facebook data without any coding.
-
Connecting Moonlit Workflow with SuiteCRM 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 SuiteCRM data in real time.
-
Connect to Live SQL Analysis Services Data in MicroStrategy through CData Connect AI
Create a live connection to SQL Analysis Services Data in CData Connect AI and connect to your SQL Analysis Services data from MicroStrategy.