CData Software - Knowledge Base
Recent Articles
-
Create a Data Access Object for PDFMonkey Data using JDBI
A brief overview of creating a SQL Object API for PDFMonkey in JDBI.
-
Automated Continuous LaunchDarkly Replication to MongoDB
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to MongoDB.
-
Use the CData Software ODBC Driver for ZohoSubscriptions in MicroStrategy
Connect to ZohoSubscriptions in MicroStrategy Developer using the CData Software ODBC Driver for ZohoSubscriptions.
-
Seamlessly Bring Zoom Data into Retool Using CData Connect AI
Integrate Zoom data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to connect SharePoint with HDFS Data through external lists
Provide Apache HDFS to SharePoint users as an external list.
-
Work with Toggl Data in FoxPro
Load Toggl into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Datasets from ZohoExpense in Domo Workbench and Build Visualizations of ZohoExpense Data in Domo
Use the CData Software ODBC Driver for ZohoExpense to create datasets from ZohoExpense in Domo Workbench and then build visualizations in the Domo service.
-
View Reports on Real-Time Oracle SCM Data in Power BI Report Server
Use the CData ODBC Driver for Oracle SCM to visualize Oracle SCM in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate SuiteCRM Data in the Pentaho Report Designer
Publish reports based on SuiteCRM in the Pentaho BI tool.
-
Connect to Amazon Marketplace Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Amazon Marketplace in Airbyte.
-
QuickBooks Online Reporting in OBIEE with the QuickBooks Online JDBC Driver
Deploy the QuickBooks Online JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Lakebase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Lakebase.
-
How to create an RPA flow for Acumatica Data in UiPath Studio
Use the Acumatica ODBC Driver to create workflows that access real-time Acumatica ERP without any coding.
-
Build Greenplum-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Pivotal GreenPlum.
-
How to connect PolyBase to Deel
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Deel.
-
Connect to Okta Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connecting Agentforce with Trello 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 Trello for you.
-
Integrating Gumloop with SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SendGrid within automated workflows.
-
Connect Testmonitor to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Testmonitor using the CData Python MCP Server.
-
A PostgreSQL Interface for Strava Data (MySQL Remoting via JDBC)
Use the Remoting features of the Strava JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Crystal Reports on Microsoft Planner Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Planner.
-
Connect to and Query Datadog Data in QlikView over ODBC
Create data visualizations with Datadog in QlikView.
-
How to Work with Tickspot Data in AWS Glue Jobs Using JDBC
Connect to Tickspot from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Stack Exchange Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Stack Exchange replication to OneLake in Microsoft Fabric.
-
Automated Continuous SAP SuccessFactors Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Google Cloud SQL.
-
Automate Cloudflare Data Replication to Azure Synapse
Use CData Sync to customize and automate Cloudflare replication to Azure Synapse.
-
Integrate Open WebUI with Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Square from within the chat interface.
-
Use Dash to Build Web Apps on Dynamics 365 Business Central Data via CData Connect AI
Build interactive Dash web apps on live Dynamics 365 Business Central using pandas and the CData Connect AI Python SDK.
-
DataBind Controls to Bannerbear Data in C++Builder
DataBind to Bannerbear in C++Builder with standard components and controls.
-
Integrating OpenCode Terminal with Hubstaff 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 Reckon Replication to SQL Server
Use CData Sync for automated, continuous, customizable Reckon replication to SQL Server.
-
Import Acumatica Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Acumatica ERP. In this article, you will use the OData format to import Acumatica ERP into Microsoft Power Query.
-
How to Work with ZohoInvoice Data in AWS Glue Jobs Using JDBC
Connect to ZohoInvoice from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous eBay Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable eBay replication to OneLake in Microsoft Fabric.
-
Query Slack Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Slack entities in PHP by modeling them as objects.
-
Build Dashboards with Insightly Data in DBxtra
Create dynamic dashboards and perform analytics based on Insightly in DBxtra.
-
How to Connect DBeaver to BigCommerce via a JDBC Driver
Manage BigCommerce with visual tools in DBeaver like the query browser.
-
Analyze ServiceNow Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of ServiceNow and visualize live ServiceNow in Infragistics Reveal.
-
Validate Grafana Data with QuerySurge
Access and validate Grafana in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Shopify Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Shopify replication to Amazon Redshift.
-
Build a PostgreSQL Interface for Rootly Data using the CData JDBC Driver
Use the Remoting features of the Rootly JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to SAP Netweaver Gateway Data from IntelliJ
Integrate connectivity to SAP Netweaver Gateway with wizards in IntelliJ.
-
Connect to Instantly Data in NetBeans
Connect to Instantly in NetBeans with the data source configuration wizard.
-
Build Dashboards with Foursquare Data in DBxtra
Create dynamic dashboards and perform analytics based on Foursquare in DBxtra.
-
Connect to Reply.io Data in RapidMiner
Integrate Reply.io with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Biml to Build SSIS Tasks to Replicate Nuclia Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Nuclia to SQL Server.
-
Connect to Telegram Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Telegram in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Smartsheet Replication to SQL Server
Use CData Sync for automated, continuous, customizable Smartsheet replication to SQL Server.
-
Visualize Parquet 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 Apache Parquet into TIBCO Spotfire.
-
Getting Started with the CData Connect AI Python SDK for Reckon Accounts Hosted
Install the CData Connect AI Python SDK to read and write live Reckon Accounts Hosted with standard DB-API 2.0 Python code.
-
Connect to Zoho Books Data from a Connection Pool in JBoss
Integrate Zoho Books into Java servlets: Use the Management Console in JBoss to install the Zoho Books JDBC Driver.
-
Visualize Sentry Data in Sisense
Create an ElastiCube in Sisense app with access to Sentry.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Avro
Provide connectivity to Apache Avro through an SAP BusinessObjects universe.
-
How to integrate Hubstaff with Apache Airflow
Access and process Hubstaff in Apache Airflow using the CData JDBC Driver.
-
Connect Deel to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Deel using the CData Python MCP Server.
-
Create Reports from Power BI XMLA Data in Looker Studio
Use CData Connect AI to gain access to live Power BI XMLA and create custom reports in Looker Studio.
-
Migrating data from SAP Business One to Snowflake using CData SSIS Components.
Easily push SAP Business One to Snowflake using the CData SSIS Tasks for SAP Business One and Snowflake.
-
Visualize Todoist Data in Tableau
The CData ODBC driver for Todoist enables you integrate Todoist into Tableau dashboards.
-
Use the CData SSIS Components to Insert New or Update Existing MySQL Records from SQL Server
Easily push SQL Server data to MySQL using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into MySQL or update existing records with data from a SQL Server database.
-
Load MailerSend Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load MailerSend to a database.
-
Choosing the Best Method to Connect Google Cloud Storage to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Cloud Storage from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Zoho Recruit Reporting in OBIEE with the Zoho Recruit JDBC Driver
Deploy the Zoho Recruit JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous QuickBooks Replication to Vertica
Use CData Sync for automated, continuous, customizable QuickBooks replication to Vertica.
-
How to Connect to & Open Front Data in Microsoft Excel
This article uses the CData ODBC driver for Front to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Codex CLI with ScrapingBee 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.
-
Query OpenWeatherMap Data in ColdFusion
Write standard ColdFusion data access code to connect to OpenWeatherMap.
-
Automate Cassandra Data Replication to Couchbase
Use CData Sync to Customize and automate Apache Cassandra replication to Couchbase.
-
How to Connect to Live HBase Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apache HBase without replication.
-
Access Live Egnyte Data in Coginiti Pro
Connect to and query live Egnyte from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use ChatGPT to Talk to Your eBay 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 eBay for you.
-
Automated Continuous Adobe Commerce Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Azure SQL Database.
-
Connect to Blackbaud FE NXT Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Blackbaud FE NXT in Airbyte.
-
Use Azure AI Foundry to Talk to Your Pipedrive 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 Pipedrive for you.
-
Back Up SuiteCRM to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SuiteCRM. In this article, we will employ an SSIS workflow to populate a database with SuiteCRM data.
-
Create Informatica Mappings From/To an ODBC Data Source for Freshsales
Create an ODBC connection to Freshsales in Informatica and browse and transfer Freshsales.
-
Use Dash to Build to Web Apps on Amazon S3 Data
Create Python applications that use pandas and Dash to build Amazon S3-connected web apps.
-
Migrating data from Smartsheet to Google BigQuery using CData SSIS Components.
Easily push Smartsheet to Google BigQuery using the CData SSIS Tasks for Smartsheet and Google BigQuery.
-
Integrate with Live OneNote Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to OneNote from the MuleSoft Anypoint Platform to integrate live Microsoft OneNote into custom reports and dashboards.
-
Access Live Excel Data in Coginiti Pro
Connect to and query live Microsoft Excel from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use ChatGPT to Talk to Your Vault CRM 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 Veeva Vault & Vault CRM for you.
-
Integrate LibreChat with Live SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP Netweaver Gateway from within the chat interface.
-
Automated Continuous Zoho Inventory Replication to Oracle
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Oracle.
-
Connect to Twilio Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Twilio Data and connect to Twilio in Akorbi Digital RunMyProcess.
-
Replicate Multiple Neo4J Accounts via the CData Sync CLI
Replicate multiple Neo4J accounts to one or many databases.
-
Provide OData Services of MariaDB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MariaDB by developing a WCF Service Application.
-
Connect to Adobe Commerce Data in HULFT Integrate
Connect to Adobe Commerce as a JDBC data source in HULFT Integrate
-
Configure the CData JDBC Driver for Google Ad Manager in a Connection Pool in Tomcat
Connect to Google Ad Manager from a connection pool in Tomcat.
-
Build AI/ML Models with Live SAP Ariba Procurement Data using Dataiku
Connect SAP Ariba Procurement Data with Dataiku using the CData JDBC Driver for SAP Ariba Procurement.
-
Use the CData ODBC Driver for ZohoExpense in Microsoft Power Query
You can use the CData ZohoExpense ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ZohoExpense into Microsoft Power Query.
-
Connect to Microsoft Dataverse Data in Aqua Data Studio
Access Microsoft Dataverse (CDS) from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Operational Reporting on IBM Cloud Object Storage Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote IBM Cloud Object Storage.
-
Automate Oracle Sales Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle Sales replication to Azure Data Lake.
-
Create Instantly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Instantly from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Reports with SAP HANA Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP HANA.
-
Automated Continuous Moosend Replication to SQL Server
Use CData Sync for automated, continuous, customizable Moosend replication to SQL Server.
-
DataBind Controls to Placid Data in Delphi
DataBind to Placid in Delphi with standard data access components and controls.
-
Create Informatica Mappings From/To a JDBC Data Source for Snowflake
Create Snowflake data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect to Live Cvent Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Cvent securely in real time.
-
Integrating Dataiku with Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Email.
-
Build FHIR-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for FHIR to explore live FHIR Data in Gemini Code Assist to assist with building FHIR-powered applications.