CData Software - Knowledge Base
Recent Articles
-
How to Build an ETL App for SAP ByDesign Data in Python with CData Connect AI
Build ETL pipelines that read and write live SAP Business ByDesign in Python with petl and the CData Connect AI Python SDK.
-
How to connect to Amplitude Data with Squirrel SQL client
Connect to Amplitude and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Freshdesk 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 Freshdesk for you.
-
Query Tally Data as a SQL Server Database in Node.js
Execute SQL Server queries against Tally ERP from Node.js.
-
Connect to Live Amazon Marketplace Data in MicroStrategy through CData Connect AI
Create a live connection to Amazon Marketplace Data in CData Connect AI and connect to your Amazon Marketplace from MicroStrategy.
-
Automated Continuous Tickspot Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Tickspot replication to delimited files (CSV/TSV).
-
Connect to Outlook Data from PowerBuilder via JDBC
This article demonstrates how to access Outlook from PowerBuilder using the Outlook JDBC Driver.
-
Integrate Live HCL Domino Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to HCL Domino and integrate live HCL Domino into apps built in Microsoft Power Apps.
-
Use the CData Software JDBC Driver for Authorize.Net in MicroStrategy Desktop
Connect to Authorize.Net in MicroStrategy Desktop using the CData Software JDBC Driver for Authorize.Net.
-
Create SSAS Tabular Models from SAP Ariba Procurement Data
How to build a SQL Server Analysis Service Tabular Model from SAP Ariba Procurement using CData drivers.
-
Use Grok to Talk to Your Snowflake 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 Snowflake for you.
-
Replicate Multiple Coinbase Accounts via the CData Sync CLI
Replicate multiple Coinbase accounts to one or many databases.
-
Manage Delighted Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Delighted.
-
Build ServiceNow-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ServiceNow Data and create custom apps in Bubble.
-
Connect to Unbounce Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Unbounce using standard SQL.
-
Connect to SAP SuccessFactors LMS Data in JRuby
Create a simple JRuby app with access to live SAP SuccessFactors LMS.
-
How to create an RPA flow for ShipEngine Data in UiPath Studio
Use the ShipEngine ODBC Driver to create workflows that access real-time ShipEngine without any coding.
-
Automated Continuous Reckon Accounts Hosted Replication to MySQL
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to MySQL.
-
Import SAP Hybris C4C Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP Hybris C4C. In this article, you will use the OData format to import SAP Hybris C4C into Microsoft Power Query.
-
Query Avro Data as a MySQL Database in Node.js
Execute MySQL queries against Apache Avro from Node.js.
-
How to Connect Azure Data Lake Storage Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Azure Data Lake Storage data in real time using natural language.
-
Easily Integrate Mailjet Data in Lazarus Pascal IDE
Learn how to easily integrate live Mailjet in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Analyze Xero Data in Cognos Analytics
Use CData Connect AI to connect to Xero Data from Cognos Analytics and analyze live Xero Accounting.
-
How to create Visio diagrams from Dynamics CRM Data
Automatically update Microsoft Dynamics CRM with the changes you make to Visio master shapes.
-
How to Connect Flowise AI Agents to Live Google Ads 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 Google Ads without replication.
-
Connect to RabbitMQ from a Connection Pool in WebLogic
Use the CData JDBC Driver for RabbitMQ to connect to RabbitMQ from Web applications running on WebLogic.
-
How to publish and share Cloudant Data dashboards with Tableau Server
The CData ODBC driver for Cloudant enables you integrate IBM Cloudant into Tableau dashboards.
-
Connect to Short.io Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software ODBC Driver for Basecamp in MicroStrategy Web
Connect to Basecamp in MicroStrategy Web using the CData Software ODBC Driver for Basecamp.
-
Connect to Shippo Data in Jaspersoft Studio
Execute SQL to remote Shippo in Jaspersoft Studio.
-
Connect to Google Campaign Manager 360 Data in HULFT Integrate
Connect to Google Campaign Manager 360 as a JDBC data source in HULFT Integrate
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for BambooHR
Provide connectivity to BambooHR through an SAP BusinessObjects universe.
-
Integrate Cursor with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live CockroachDB from within the editor.
-
Connect to Copper Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Copper and work with Copper in your FileMaker applications.
-
Use JayDeBeApi to access Epicor Kinetic Data in Python
Use standard Python scripting and the development environment of your choice to access live Epicor Kinetic.
-
Publish Crystal Reports on SAP Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP ERP/NetWeaver.
-
Visualize Pinterest 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 Pinterest into TIBCO Spotfire.
-
Connect to Amplitude Data in Aqua Data Studio
Access Amplitude from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to & Open Salesloft Data in Microsoft Excel
This article uses the CData ODBC driver for Salesloft to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Samanage Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Samanage replication to Azure SQL Database.
-
Integrating Kiro CLI with Bitly 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.
-
How to connect and process SAP Concur from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Concur.
-
How to Connect Workday Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Workday data in real time using natural language.
-
Build a Singer.io Tap for Short.io With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Short.io data using
-
Zoho CRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zoho CRM through CData Connect AI using different applications and tools.
-
Create Informatica Mappings From/To an ODBC Data Source for JSON
Create an ODBC connection to JSON in Informatica and browse and transfer JSON.
-
Integrate Open WebUI with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Ariba Source from within the chat interface.
-
How to Connect to Aha! Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Aha!. Leverage the pyodbc module for ODBC in Python.
-
Integrate with Dynamics 365 Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Dynamics 365 in SnapLogic.
-
Integrating Claude Code with Quickbase Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Quickbase within assisted coding and automated development workflows.
-
Analyze MYOB AccountRight Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MYOB AccountRight from Power Pivot. You will use the Table Import Wizard to load MYOB AccountRight. You can visually build the import query or use any SQL supported by the driver.
-
DataBind IBM Informix Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for IBM Informix with the DevExpress Windows Forms and Web controls to provide IBM Informix to a chart.
-
Query Adobe Target Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Adobe Target entities in PHP by modeling them as objects.
-
Connect to Google Directory Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Directory in the Denodo Virtual DataPort Administrator.
-
How to Easily Query LightSpeedRetail Data in OpenOffice Base
Connect to LightSpeedRetail data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to PabblySubscriptions 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 PabblySubscriptions and work with PabblySubscriptions in your FileMaker application.
-
Use the CData Software JDBC Driver for Mouseflow in MicroStrategy Desktop
Connect to Mouseflow in MicroStrategy Desktop using the CData Software JDBC Driver for Mouseflow.
-
Use the CData API Server to Access Instagram Data in Microsoft PowerPivot
Use the CData API Server to connect to live Instagram in the Power Pivot business intelligence tool.
-
Create SSAS Tabular Models from SAP SuccessFactors Data
How to build a SQL Server Analysis Service Tabular Model from SAP SuccessFactors using CData drivers.
-
Connect to Timely Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Timely.
-
Natively Connect to SendGrid Data in PHP
The CData ODBC driver for SendGrid enables you to create PHP applications with connectivity to SendGrid. Leverage the native support for ODBC in PHP.
-
Automated Continuous Redis Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Redis replication to Apache Kafka.
-
How to Work with Access Data in ETL Validator JDBC
Connect to Access from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect DBeaver to Certinia via a JDBC Driver
Manage Certinia with visual tools in DBeaver like the query browser.
-
Connect Sage Intacct to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Sage Intacct with IBM WebSphere for seamless data integration and connectivity.
-
How to Access Microsoft Dataverse Data Using Entity Framework
This article shows how to access Microsoft Dataverse (CDS) using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Avalara AvaTax Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to AlloyDB.
-
Use JayDeBeApi to access SingleStore Data in Python
Use standard Python scripting and the development environment of your choice to access live SingleStore.
-
Validate Acumatica Data with QuerySurge
Access and validate Acumatica ERP in QuerySurge using the CData JDBC Driver.
-
Access Live Adobe Experience Manager Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Adobe Experience Manager in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software ODBC Driver for DB2 in MicroStrategy Web
Connect to IBM DB2 in MicroStrategy Web using the CData Software ODBC Driver for DB2.
-
How to connect to CapsuleCRM Data in DBVisualizer
Integrate CapsuleCRM with visual data analysis tools and data connection wizards in DBVisualizer
-
Back Up Mistral AI 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 Mistral AI data.
-
Automated Continuous Sendwithus Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sendwithus replication to Apache Kafka.
-
Automated Continuous SAP Ariba Source Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Google BigQuery.
-
ETL Eventbrite in Oracle Data Integrator
This article shows how to transfer Eventbrite into a data warehouse using Oracle Data Integrator.
-
Configure the CData JDBC Driver for Clio in a Connection Pool in Tomcat
Connect to Clio from a connection pool in Tomcat.
-
Working with Microsoft Entra ID Data in LINQPad
Execute LINQ queries to Microsoft Entra ID in LINQPad.
-
Connect to MYOB AccountRight Data in JRuby
Create a simple JRuby app with access to live MYOB AccountRight.
-
Connect to Spotify from a Connection Pool in WebLogic
Use the CData JDBC Driver for Spotify to connect to Spotify from Web applications running on WebLogic.
-
Deploy the ADO.NET Provider for LionDesk on an SSRS Report Server
Connect to LionDesk 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.
-
How to Build an ETL App for EmailOctopus Data in Python with CData
Create ETL applications and real-time data pipelines for EmailOctopus in Python with petl.
-
Establish a Live Connection with Harvest Data using Tableau Bridge
The CData ODBC Driver for Harvest enables you to integrate live Harvest into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize QuickBooks Time Data in Tableau
The CData ODBC driver for QuickBooks Time enables you integrate QuickBooks Time into Tableau dashboards.
-
Automated Continuous Twitter Ads Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Amazon Redshift.
-
Automated Continuous Wrike Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Wrike replication to Apache Cassandra.
-
Build ChartMogul-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ChartMogul and build web apps with connectivity to live ChartMogul.
-
CData Connect AI Quickstart
Everything you need to get started with data connectivity as a service.
-
Access Live Exact Online Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Exact Online from your Google Sheets.
-
Use ChatGPT to Talk to Your BigCommerce 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 BigCommerce for you.
-
How to connect PolyBase to Nethunt
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Nethunt.
-
Replicate Multiple Bannerbear Accounts via the CData Sync CLI
Replicate multiple Bannerbear accounts to one or many databases.
-
Creating Google Ads-Connected Applications in Unqork
You can use CData Connect AI to feed Google Ads to Unqork and build custom business apps.
-
Write a Simple Go Application to work with ActiveCampaign Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ActiveCampaign.
-
Load Excel Online Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Excel Online to a database.
-
Import Real-Time Twitter Ads Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Twitter Ads in ColdFusion.
-
Build Semantic Layer Views for CSV Data in APOS Live Data Gateway
Use the CData Connector for CSV in APOS Live Data Gateway to build Semantic Layer Views for CSV/TSV Files.
-
Create Reports with Google Cloud Storage Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Cloud Storage.
-
Create a Data Access Object for Cvent Data using JDBI
A brief overview of creating a SQL Object API for Cvent in JDBI.
-
Import Basecamp Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Basecamp. In this article, you will use the OData format to import Basecamp into Microsoft Power Query.