CData Software - Knowledge Base
Recent Articles
-
Automate Dynamics 365 Business Central Data Replication to Couchbase
Use CData Sync to Customize and automate Dynamics 365 Business Central replication to Couchbase.
-
Connect to FTP Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for FTP to connect to FTP Servers and execute queries in PowerBuilder.
-
Automated Continuous SAP Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP replication to AlloyDB.
-
How to Work with Jira Data in ETL Validator JDBC
Connect to Jira from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Chargebee in MicroStrategy Web
Connect to Chargebee in MicroStrategy Web using the CData Software JDBC Driver for Chargebee.
-
Build Eventbrite-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Eventbrite and build web apps with connectivity to live Eventbrite.
-
How to create an RPA flow for Freshdesk Data in UiPath Studio
Use the Freshdesk ODBC Driver to create workflows that access real-time Freshdesk without any coding.
-
Visualize Kafka Data in TIBCO Spotfire through OData
Integrate Apache Kafka into dashboards in TIBCO Spotfire.
-
A PostgreSQL Interface for Slack Data (MySQL Remoting via JDBC)
Use the Remoting features of the Slack JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect Mouseflow Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Mouseflow using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze FHIR Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of FHIR and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating Neo4J Data in Talend Cloud Data Management Platform
Connect Neo4J Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Neo4J.
-
Build SurveyMonkey-Connected Apps in Choreo
Use CData Connect AI to connect to SurveyMonkey Data from Choreo and build custom apps using live SurveyMonkey.
-
Publish Reports with CloudConvert Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CloudConvert.
-
How to Seamlessly Import Active Directory Data into IBM SPSS Modeler
Integrate Active Directory data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Replicate OpenWeatherMap Data from PowerShell
Write a quick PowerShell script to query OpenWeatherMap. Use connectivity to the live data to replicate OpenWeatherMap to SQL Server.
-
Automate Zoom Data Replication to SAP HANA
Use CData Sync to customize and automate Zoom replication to SAP HANA.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MailerLite
Provide connectivity to MailerLite through an SAP BusinessObjects universe.
-
How to Connect the Power BI Service to SageHR: Complete Guide
Connect to the CData Software Power BI Connector for SageHR from PowerBI.com to provide real-time SageHR across the organization.
-
Use the CData API Server to Access Pipedrive Data in Microsoft PowerPivot
Use the CData API Server to connect to live Pipedrive in the Power Pivot business intelligence tool.
-
Query Hubstaff Data in DataGrip
Create a Data Source for Hubstaff in DataGrip and use SQL to query live Hubstaff.
-
How to Seamlessly Import Copper Data into IBM SPSS Modeler
Integrate Copper data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Extract, Transform, and Load Mailgun Data in Informatica PowerCenter
Create a simple Workflow for Mailgun in Informatica PowerCenter.
-
Build Vertica-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Vertica and build Vertica-connected web apps with Axios.
-
How to Query Live Confluence Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Atlassian Confluence data in natural language using Python.
-
Getting Started with the CData Connect AI Python SDK for HBase
Install the CData Connect AI Python SDK to read and write live Apache HBase with standard DB-API 2.0 Python code.
-
Deploy the ADO.NET Provider for Humanity on an SSRS Report Server
Connect to Humanity 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.
-
Visualize CircleCI Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load CircleCI into TIBCO Spotfire.
-
Trigger SAP HANA IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for SAP HANA with standard wizards in Logic Apps.
-
Create Datasets from Datadog in Domo Workbench and Build Visualizations of Datadog Data in Domo
Use the CData Software ODBC Driver for Datadog to create datasets from Datadog in Domo Workbench and then build visualizations in the Domo service.
-
Integrate with MailChimp Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MailChimp in SnapLogic.
-
Use the CData ODBC Driver for Bitly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bitly to connect to Bitly from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bitly in Excel.
-
Replicate Mailjet Data to Multiple Databases
Replicate Mailjet to disparate databases with a point-and-click configuration.
-
Integrating Act-On Data in Talend Cloud Data Management Platform
Connect Act-On Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Act-On.
-
Visualize Live Vault CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Veeva Vault & Vault CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Object-Relational Mapping (ORM) with Acumatica Data 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 Acumatica ERP into a Java-based ORM framework, Hibernate.
-
Automate Redis Data Replication to Azure Synapse
Use CData Sync to customize and automate Redis replication to Azure Synapse.
-
Visualize Oracle Service Cloud Data in Sisense
Create an ElastiCube in Sisense app with access to Oracle Service Cloud.
-
Automated Continuous FormSite Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable FormSite replication to Apache Kafka.
-
Connect Zoho Books to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zoho Books with IBM WebSphere for seamless data integration and connectivity.
-
Use Biml to Build SSIS Tasks to Replicate Trello Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Trello to SQL Server.
-
Connect to Jumpseller Data in HULFT Integrate
Connect to Jumpseller as a JDBC data source in HULFT Integrate
-
Connect and Visualize Live Raisers Edge NXT Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Raisers Edge NXT into the Databricks platform and create visualization dashboards with real-time Raisers Edge NXT.
-
Create Informatica Mappings From/To a JDBC Data Source for Customer.io
Create Customer.io data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Creating Sugar CRM-Connected Applications in Unqork
You can use CData Connect AI to feed Sugar CRM to Unqork and build custom business apps.
-
Getting Started with the CData Power BI Connector for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Fieldglass.
-
Create Pipeliner CRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pipeliner CRM data access from reports, embedded analytics, and more.
-
Access BigCommerce Data from MySQL in Amazon QuickSight
Connect to BigCommerce and build visualizations of BigCommerce using a MySQL Connection in Amazon QuickSight.
-
Integrating Codex CLI with Tavily 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.
-
Operational Reporting on Campaigner Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Campaigner.
-
Integrate Live Basecamp Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Easily Query Bitbucket Data in OpenOffice Base
Connect to Bitbucket data in OpenOffice Base using the CData ODBC Driver for Bitbucket and generate reports with live data insights.
-
Load HBase Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache HBase to a database.
-
Getting Started with the CData Power BI Connector for HCL Domino
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for HCL Domino.
-
How to work with Adobe Commerce Data in Apache Spark using SQL
Access and process Adobe Commerce Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Telegram Data from a Connection Pool in JBoss
Integrate Telegram into Java servlets: Use the Management Console in JBoss to install the Telegram JDBC Driver.
-
How to load Teradata data into Elasticsearch via Logstash
Introducing a simple method to load Teradata data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData Excel Add-In for SAS Data Sets
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAS Data Sets.
-
How to connect to ClickTime Data in DBVisualizer
Integrate ClickTime with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Neo4J-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Neo4J.
-
Automate Apify Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apify replication to Azure Data Lake.
-
Query Live Presto Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Presto directly from the development environment.
-
Access Gorgias 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 Gorgias.
-
Use the CData ODBC Driver for FHIR from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for FHIR to connect to FHIR from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring FHIR in Excel.
-
How to Easily Query Supabase Data in OpenOffice Base
Connect to Supabase data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access AdRoll Data from MySQL in Amazon QuickSight
Connect to AdRoll and build visualizations of AdRoll using a MySQL Connection in Amazon QuickSight.
-
Natively Connect to SAP Hybris C4C Data in PHP
The CData ODBC driver for SAP Hybris C4C enables you to create PHP applications with connectivity to SAP Hybris C4C. Leverage the native support for ODBC in PHP.
-
Visualize xBase Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load xBase into TIBCO Spotfire.
-
Connect to Live BigCommerce Data in MicroStrategy through CData Connect AI
Create a live connection to BigCommerce Data in CData Connect AI and connect to your BigCommerce from MicroStrategy.
-
Use the CData Software JDBC Driver for Microsoft Ads in MicroStrategy Web
Connect to Microsoft Ads in MicroStrategy Web using the CData Software JDBC Driver for Microsoft Ads.
-
Use ChatGPT to Talk to Your Freshdesk 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 Freshdesk for you.
-
Integrate Live Amazon DynamoDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Automate Kintone Data Replication to Azure Synapse
Use CData Sync to customize and automate Kintone replication to Azure Synapse.
-
Design BIRT Reports on Keap Data
Provide current Keap to your embedded analytics.
-
Automate Microsoft Planner Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Planner from PowerShell? This article demonstrates how to utilize the Microsoft Planner Cmdlets for tasks like connecting to Microsoft Planner, automating operations, downloading data, and more.
-
How to Connect to & Open Strava Data in Microsoft Excel
This article uses the CData ODBC driver for Strava to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Real-Time Demio Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Demio in Power Apps.
-
Access SQL Analysis Services Data from MySQL in PHP
Connect to SQL Analysis Services through the standard MySQL libraries in PHP.
-
Design BIRT Reports on Impala Data
Provide current Apache Impala to your embedded analytics.
-
Work with Live WooCommerce Data in Power Query
Use CData Connect AI to connect to WooCommerce and work with live WooCommerce in Microsoft Power Query.
-
Getting Started with the CData SSIS Components for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Elasticsearch.
-
Access Freshsales Data from MySQL in Amazon QuickSight
Connect to Freshsales and build visualizations of Freshsales using a MySQL Connection in Amazon QuickSight.
-
Publish Brex-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Brex.
-
How to integrate Short.io with Apache Airflow
Access and process Short.io in Apache Airflow using the CData JDBC Driver.
-
Access Live Azure DevOps 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 Azure DevOps through MCP integration.
-
Automate Sage Intacct Data Replication to SAP HANA
Use CData Sync to customize and automate Sage Intacct replication to SAP HANA.
-
Visualize ChargeOver Data in Sisense
Create an ElastiCube in Sisense app with access to ChargeOver.
-
Integrate Azure Data Catalog Data in Pentaho Data Integration
Build ETL pipelines based on Azure Data Catalog in the Pentaho Data Integration tool.
-
Build AI/ML Models with Live Humanity Data using Dataiku
Connect Humanity Data with Dataiku using the CData API Driver for JDBC.
-
Build MVC Applications with Connectivity to EmailOctopus Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access EmailOctopus from an ASP.NET MVC application.
-
How to Connect to ZendeskSell Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZendeskSell. Leverage the pyodbc module for ODBC in Python.
-
Use the CData ODBC Driver for Adobe Commerce in Microsoft Power Query
You can use the CData Adobe Commerce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Commerce into Microsoft Power Query.
-
A PostgreSQL Interface for Zoho CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Sybase Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sybase. In this article, you will use the OData format to import Sybase into Microsoft Power Query.
-
Build a PostgreSQL Interface for Sybase IQ Data using the CData JDBC Driver
Use the Remoting features of the Sybase IQ JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Close Data in Coginiti Pro
Connect to and query live Close from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect Flowise AI Agents to Live MariaDB Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live MariaDB without replication.
-
Integrate with Microsoft Dataverse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Dataverse (CDS) to a JSON file on disk.
-
Build Charts with Azure Synapse Data in Clear Analytics
Create dynamic charts and perform analytics based on Azure Synapse in Clear Analytics.
-
Automate Zuora Data Replication to SAP HANA
Use CData Sync to customize and automate Zuora replication to SAP HANA.