CData Software - Knowledge Base
Recent Articles
-
Connect to Bugsnag from Asprova with CData Software ODBC Driver for Bugsnag
This article shows how to connect faster to Bugsnag data from Asprova.
-
ETL Clari in Oracle Data Integrator
This article shows how to transfer Clari into a data warehouse using Oracle Data Integrator.
-
Create Informatica Mappings From/To a JDBC Data Source for Acumatica
Create Acumatica data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software ODBC Driver for Front in MicroStrategy Desktop
Connect to Front in MicroStrategy Desktop using the CData Software ODBC Driver for Front.
-
Excel Spreadsheet Automation on LinkedIn Data with the QUERY Formula
Pull data from LinkedIn, automate spreadsheets, and more with the QUERY formula.
-
Using the CData Software ODBC Driver for Landbot in PyCharm
Connect to Landbot as an ODBC data source in PyCharm using the CData Software ODBC Driver for Landbot.
-
Build Apps with Live Tavily Data Using the Low-Code Development Platform of Mendix
Connect Tavily with Mendix to build apps using the CData API Driver for JDBC.
-
How to connect to Avalara AvaTax Data from IntelliJ
Integrate connectivity to Avalara AvaTax with wizards in IntelliJ.
-
Connect Shippo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Shippo with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Real-Time Jira Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Jira and Dataflow to import and use Atlassian Jira in Power Apps.
-
How to Connect Flowise AI Agents to Live Twilio 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 Twilio without replication.
-
How to Connect to Productboard Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Productboard. Leverage the pyodbc module for ODBC in Python.
-
Process & Analyze Salesforce Pardot Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Salesforce Pardot Data.
-
Getting Started with the CData Tableau Connector for Asana
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Asana.
-
Load SAP Hybris C4C Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP Hybris C4C to a database.
-
Automate Slack Data Replication to Azure Synapse
Use CData Sync to customize and automate Slack replication to Azure Synapse.
-
Getting Started with the CData Excel Add-In for Pushbullet
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pushbullet.
-
Visualize Freshdesk 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 Freshdesk into TIBCO Spotfire.
-
Create Authorize.Net-Connected Nintex Workflows
Use CData Connect AI to connect to Authorize.Net Data from Nintex Workflow Cloud and build custom workflows using live Authorize.Net.
-
Build NetSuite-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for NetSuite to explore live NetSuite Data in Claude Code to assist with building NetSuite-powered applications.
-
Connect to Zoho Recruit Data in Aqua Data Studio
Access Zoho Recruit from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Easily Integrate CouchDB Data in Lazarus Pascal IDE
Learn how to easily integrate live Apache CouchDB in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Mocean Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Mocean using standard SQL.
-
Use the CData Software ODBC Driver for NetSuite in MicroStrategy
Connect to NetSuite CRM & ERP in MicroStrategy Developer using the CData Software ODBC Driver for NetSuite.
-
Getting Started with the CData JDBC Driver for Couchbase
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Couchbase.
-
Access Wave Financial Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Wave Financial from HeidiSQL.
-
Create Datasets from Guru in Domo Workbench and Build Visualizations of Guru Data in Domo
Use the CData Software ODBC Driver for Guru to create datasets from Guru in Domo Workbench and then build visualizations in the Domo service.
-
Create Splunk-Connected Dashboards in Grafana
Connect to Splunk Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Splunk.
-
Connect Beeminder to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Beeminder with IBM WebSphere for seamless data integration and connectivity.
-
Query Moosend Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Moosend from Node.js.
-
How to update LinkedIn from Excel
This article explains how to transfer data from Excel to LinkedIn using the Excel Add-In for LinkedIn.
-
How to Work with Square Data in AWS Glue Jobs Using JDBC
Connect to Square from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Automated Gmail-Connected Workflows in Zapier
Use CData Connect AI to connect to live Gmail and build automated workflows in Zapier.
-
Connect to FTP Data in Ruby
Connect to FTP Servers in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Design Microsoft Exchange Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Microsoft Exchange from mobile and tablet Power Apps.
-
LINQ to SpaceX Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the SpaceX Data Provider.
-
Design BIRT Reports on Klaviyo Data
Provide current Klaviyo to your embedded analytics.
-
Use the CData Software JDBC Driver for Timely in MicroStrategy
Connect to Timely in MicroStrategy Developer using the CData Software JDBC Driver for Timely.
-
Create Zoho Books Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zoho Books from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Reports with Exa Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Exa.
-
Build a PostgreSQL Interface for Parquet Data using the CData JDBC Driver
Use the Remoting features of the Parquet JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Live SAP SuccessFactors LMS Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP SuccessFactors LMS data in natural language using Python.
-
Create Datasets from Aircall in Domo Workbench and Build Visualizations of Aircall Data in Domo
Use the CData Software ODBC Driver for Aircall to create datasets from Aircall in Domo Workbench and then build visualizations in the Domo service.
-
How to Work with Webex Data in ETL Validator JDBC
Connect to Webex from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind Charts to Amplitude Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amplitude 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Customer.io
Provide connectivity to Customer.io through an SAP BusinessObjects universe.
-
Use Manus AI to Talk to Your Jira 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 Atlassian Jira.
-
A PostgreSQL Interface for Auth0 Data using the CData ODBC Driver
Use the SQL Gateway and Auth0 ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect PolyBase to Freshsales
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Freshsales.
-
Build Google Analytics-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Analytics Data from Zoho Analytics and import live Google Analytics.
-
How to Build an ETL App for Cvent Data in Python with CData
Create ETL applications and real-time data pipelines for Cvent in Python with petl.
-
Visualize Oracle Service Cloud Data in TIBCO Spotfire through OData
Integrate Oracle Service Cloud into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Shippo in MicroStrategy Desktop
Connect to Shippo in MicroStrategy Desktop using the CData Software ODBC Driver for Shippo.
-
How to Connect to Live Jira 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 Atlassian Jira for you.
-
Build AI Agents with DB2 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 IBM DB2 through CData Connect AI.
-
Deploy the ADO.NET Provider for Amazon S3 on an SSRS Report Server
Connect to Amazon S3 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.
-
Build Dashboards with Power BI XMLA Data in DBxtra
Create dynamic dashboards and perform analytics based on Power BI XMLA in DBxtra.
-
Use JayDeBeApi to access Chargebee Data in Python
Use standard Python scripting and the development environment of your choice to access live Chargebee.
-
Prepare, Blend, and Analyze FTP Data in Alteryx Designer (ODBC)
Build workflows to access live FTP Servers for self-service data analytics.
-
Excel Spreadsheet Automation on CampaignMonitor Data with the QUERY Formula
Pull data from CampaignMonitor, automate spreadsheets, and more with the QUERY formula.
-
Build SAP BusinessObjects BI Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP BusinessObjects BI and build visualizations in Tableau.
-
Replicate Multiple Paylocity Accounts via the CData Sync CLI
Replicate multiple Paylocity accounts to one or many databases.
-
How to Connect the Power BI Service to Act CRM: Complete Guide
Connect to the CData Software Power BI Connector for Act CRM from PowerBI.com to provide real-time Act CRM across the organization.
-
Integrating Codex CLI with Gong 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.
-
Connect to Oracle Data from Crystal Reports
Use CData Connect AI to connect to and report on live Oracle Database from Crystal Reports.
-
Connect to Avaza Data from a Connection Pool in JBoss
Integrate Avaza into Java servlets: Use the Management Console in JBoss to install the Avaza JDBC Driver.
-
Connecting GenSpark with Pipedrive Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Pipedrive without any replication or custom integration required.
-
Access Apify 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 Apify.
-
Connect to Clari from Asprova with CData Software ODBC Driver for Clari
This article shows how to connect faster to Clari data from Asprova.
-
Bidirectional Access to PabblySubscriptions Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PabblySubscriptions in Filemaker Pro for Mac or Windows.
-
View Reports on Real-Time Auth0 Data in Power BI Report Server
Use the CData ODBC Driver for Auth0 to visualize Auth0 in Power BI Desktop and then publish them to Power BI Report Server.
-
Using the CData Software ODBC Driver for Google Analytics in PyCharm
Connect to Google Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Analytics.
-
Create a Data Access Object for xBase Data using JDBI
A brief overview of creating a SQL Object API for xBase in JDBI.
-
Replicate Multiple FormSite Accounts
Replicate multiple FormSite accounts to one or many databases.
-
Write a Simple Go Application to work with Tanda Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Tanda.
-
Build MVC Applications with Connectivity to LinkedIn Ads Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LinkedIn Ads from an ASP.NET MVC application.
-
Integrating Antigravity CLI with Sybase IQ via CData CLI
Connect Sybase IQ to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to import Pipedrive Data into Apache Solr
Use the CData Software JDBC Driver for Pipedrive in Data Import Handler and create an automated import of Pipedrive to Apache Solr Enterprise Search platform.
-
Supabase Reporting in OBIEE with the Supabase JDBC Driver
Deploy the Supabase JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Discord Data from MySQL in Amazon QuickSight
Connect to Discord and build visualizations of Discord using a MySQL Connection in Amazon QuickSight.
-
Automate MailerLite Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MailerLite from PowerShell? This article demonstrates how to utilize the MailerLite Cmdlets for tasks like connecting to MailerLite, automating operations, downloading data, and more.
-
Integrating Claude Code with Zoho Projects Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zoho Projects within assisted coding and automated development workflows.
-
Visualize IBM Informix Data in Sisense
Create an ElastiCube in Sisense app with access to IBM Informix.
-
How to Connect to Live DocuSign 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 DocuSign for you.
-
Using the CData Software ODBC Driver for Paddle in PyCharm
Connect to Paddle as an ODBC data source in PyCharm using the CData Software ODBC Driver for Paddle.
-
Connect to and Query Salesforce Pardot Data in QlikView over ODBC
Create data visualizations with Salesforce Pardot in QlikView.
-
DataBind Controls to SAP Netweaver Gateway Data in C++Builder
DataBind to SAP Netweaver Gateway in C++Builder with standard components and controls.
-
Integrate Goose with Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Facebook from within the local AI agent.
-
Use Claude to Talk to Your Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft Dataverse (CDS) for you.
-
Build Cohere-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Cohere and build web apps with connectivity to live Cohere.
-
Object-Relational Mapping (ORM) with Shortcut 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 Shortcut into a Java-based ORM framework, Hibernate.
-
Create Reports with Azure Synapse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Synapse.
-
Excel Spreadsheet Automation on Planio Data with the QUERY Formula
Pull data from Planio, automate spreadsheets, and more with the QUERY formula.
-
Use the CData ODBC Driver for Cosmos DB in Microsoft Power Query
You can use the CData Cosmos DB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Cosmos DB into Microsoft Power Query.
-
How to Work with SAP Business One Data in ETL Validator JDBC
Connect to SAP Business One from ETL Validator jobs using the CData Software JDBC Driver.
-
How to import Zoom Data into Apache Solr
Use the CData Software JDBC Driver for Zoom in Data Import Handler and create an automated import of Zoom to Apache Solr Enterprise Search platform.
-
Back Up Snapchat Ads to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Snapchat Ads. In this article, we will employ an SSIS workflow to populate a database with Snapchat Ads data.
-
Design BIRT Reports on Strava Data
Provide current Strava to your embedded analytics.
-
Access Live MariaDB Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MariaDB from your Excel spreadsheets.
-
Automated Continuous EmailOctopus Replication to Oracle
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Oracle.