CData Software - Knowledge Base
Recent Articles
-
How to connect to SAP Ariba Procurement Data with Squirrel SQL client
Connect to SAP Ariba Procurement data and execute queries in the Squirrel SQL Client.
-
Visualize Printify Data in Sisense
Create an ElastiCube in Sisense app with access to Printify data.
-
Model HubDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and HubDB, enabling the direct import of real-time HubDB data.
-
How to Connect to Live Cassandra Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Cassandra data through natural language.
-
Build Dashboards with Jumpseller Data in DBxtra
Create dynamic dashboards and perform analytics based on Jumpseller data in DBxtra.
-
Build Data Flows from Quickbase to SQL Server using SSIS
Easily back up Quickbase data to SQL Server using the SSIS components for Quickbase.
-
Connect to Box Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Box data.
-
Use Manus AI to Talk to Your Google Spanner 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 Google Spanner data.
-
Automated Continuous Discord Replication to Databricks
Use CData Sync for automated, continuous, customizable Discord replication to Databricks.
-
Create a Data Access Object for Chargebee Data using JDBI
A brief overview of creating a SQL Object API for Chargebee data in JDBI.
-
Integrating Kiro with Twitter Ads 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 ServiceDesk Plus Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to delimited files (CSV/TSV).
-
Build Semantic Layer Views for Mailgun Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Mailgun data.
-
How to connect to Google Analytics Data from Spring Boot
Connect to Google Analytics in a Spring Boot Application using the CData JDBC Driver for Google Analytics
-
Automated Oracle Financials Cloud Data Replication to Teradata
Use CData Sync to Customize and automate Oracle Financials Cloud data replication to Teradata.
-
Connect to Zuora Data from PowerBuilder via JDBC
This article demonstrates how to access Zuora data from PowerBuilder using the Zuora JDBC Driver.
-
Automated Continuous BigCommerce Replication to Amazon S3
Use CData Sync for automated, continuous, customizable BigCommerce replication to Amazon S3.
-
Stream ClickUp Data into Apache Kafka Topics
Access and stream ClickUp data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Salesforce Data from Spring Boot
Connect to Salesforce in a Spring Boot Application using the CData JDBC Driver for Salesforce
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Freshservice
Provide connectivity to Freshservice data through an SAP BusinessObjects universe.
-
How to Connect to & Open PostgreSQL Data in Microsoft Excel
This article uses the CData ODBC driver for PostgreSQL to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Monday.com Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Monday.com data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build a PostgreSQL Interface for HDFS Data using the CData JDBC Driver
Use the Remoting features of the HDFS JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bind Live Power BI XMLA Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Power BI XMLA data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Automate Calendly Data Replication to Azure Data Lake
Use CData Sync to customize and automate Calendly data replication to Azure Data Lake.
-
How to use SQLAlchemy ORM to access Instantly Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Instantly data.
-
LINQ to Facebook 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 Facebook Data Provider.
-
Access Live Gumroad Data in Coginiti Pro
Connect to and query live Gumroad data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Live FTP Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live FTP data into custom reports in Power BI.
-
Build AI Agents with Discord 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 Discord data through CData Connect AI.
-
Connect to Twitter Ads Data in NetBeans
Connect to Twitter Ads data in NetBeans with the data source configuration wizard.
-
Access Live Adobe Commerce Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Adobe Commerce data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Validate Bullhorn CRM Data with QuerySurge
Access and validate Bullhorn CRM data in QuerySurge using the CData JDBC Driver.
-
Connect to and Query Reckon Data in QlikView over ODBC
Create data visualizations with Reckon data in QlikView.
-
Getting Started with the CData Python Connector for TaxJar
Learn to install and license the CData Python Connector and configure a connection to live TaxJar data.
-
A PostgreSQL Interface for Redis Data (MySQL Remoting via JDBC)
Use the Remoting features of the Redis JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft OneDrive
Provide connectivity to Microsoft OneDrive data through an SAP BusinessObjects universe.
-
Build Square-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Square data without replication.
-
Analyze MailChimp Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MailChimp data and visualize live MailChimp data in Infragistics Reveal.
-
Integrating Antigravity CLI with Clari data via CData CLI
Connect Clari data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Seamlessly Import Rootly Data into IBM SPSS Modeler
Integrate Rootly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate LibreChat with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Impala data from within the chat interface.
-
Connect to LaunchDarkly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to LaunchDarkly.
-
Connect to Timely Data in Jaspersoft Studio
Execute SQL to remote Timely data in Jaspersoft Studio.
-
Migrating data from Mouseflow to Snowflake using CData SSIS Components.
Easily push Mouseflow data to Snowflake using the CData SSIS Tasks for Mouseflow and Snowflake.
-
Connect to PDFMonkey in SpagoBI
Create reports featuring live PDFMonkey data in SpagoBI Studio. Host PDFMonkey reports on SpagoBI Server.
-
Create ZohoSubscriptions Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZohoSubscriptions from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to ClickTime from a Connection Pool in WebLogic
Use the CData JDBC Driver for ClickTime to connect to ClickTime data from Web applications running on WebLogic.
-
Connect to eBay Data in ACL Analytics
Connect to eBay data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to eBay data.
-
Visualize GitHub Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to GitHub data.
-
Create Informatica Mappings From/To an ODBC Data Source for Salesloft
Create an ODBC connection to Salesloft in Informatica and browse and transfer Salesloft data.
-
Connect to Zuora from Asprova with CData Software ODBC Driver for Zuora
This article shows how to connect faster to Zuora data from Asprova.
-
Back Up Aircall 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 Aircall data data.
-
Import Real-Time Printify Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Printify data in ColdFusion.
-
Viewing Cosmos DB Data in RAD Studio Data Explorer
How to view Cosmos DB data in RAD Studio Data Explorer using the CData ODBC Driver for Cosmos DB.
-
Configure the CData JDBC Driver for PhantomBuster in a Connection Pool in Tomcat
Connect to PhantomBuster data from a connection pool in Tomcat.
-
How to Connect to Live FHIR Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live FHIR data securely in real time.
-
Connect to OData Services from HeidiSQL
Use CData Connect AI to connect to and query live OData services from HeidiSQL.
-
Create SingleStore-Connected Applications in Appsmith
Connect to SingleStore Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SingleStore data.
-
Automated Continuous iContact Replication to Oracle
Use CData Sync for automated, continuous, customizable iContact replication to Oracle.
-
Integrate Live PolarTeamPro Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PolarTeamPro data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to and Visualize Live SAP Ariba Source Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP Ariba Source data.
-
Bind Live Oracle Eloqua Reporting Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Eloqua Reporting data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Create Reports from CockroachDB Data in Looker Studio
Use CData Connect AI to gain access to live CockroachDB data and create custom reports in Looker Studio.
-
Connect to and Query Email Data in QlikView over ODBC
Create data visualizations with Email data in QlikView.
-
Viewing Nuclia Data in RAD Studio Data Explorer
How to view Nuclia data in RAD Studio Data Explorer using the CData ODBC Driver for Nuclia.
-
Access Live Paddle Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Paddle data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
View Reports on Real-Time Parquet Data in Power BI Report Server
Use the CData ODBC Driver for Parquet to visualize Parquet data in Power BI Desktop and then publish them to Power BI Report Server.
-
Choosing the Best Method to Connect ZohoInvoice to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoInvoice data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Azure AI Foundry to Talk to Your Bannerbear 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 Bannerbear data for you.
-
Integrate Wave Financial with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Wave Financial with External Services.
-
How to connect to Cosmos DB Data from IntelliJ
Integrate connectivity to Cosmos DB data with wizards in IntelliJ.
-
Build Coda-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Coda data and build web apps with connectivity to live Coda data.
-
Automated Continuous Sybase IQ Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Amazon Redshift.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Neo4J
Provide connectivity to Neo4J data through an SAP BusinessObjects universe.
-
How to Work with Wave Financial Data in AWS Glue Jobs Using JDBC
Connect to Wave Financial from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import Supabase Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Supabase Data and provide access to live Supabase data for custom reports in the Power BI Service.
-
How to Access Placid Data Using Entity Framework
This article shows how to access Placid data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData JDBC Driver for Attio
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Attio.
-
How to Visualize Cloudflare Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Cloudflare data in Python.
-
Integrating OpenCode with ElevenLabs 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 ZohoDesk Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Amazon Redshift.
-
Provide OData Services of Ontraport Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Ontraport data by developing a WCF Service Application.
-
Connect to Superchat from a Connection Pool in WebLogic
Use the CData JDBC Driver for Superchat to connect to Superchat data from Web applications running on WebLogic.
-
Object-Relational Mapping (ORM) with HBase 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 HBase data into a Java-based ORM framework, Hibernate.
-
Connecting Mastra with SAP Ariba Source Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAP Ariba Source data, no replication required.
-
Connect to eBay Data from a Connection Pool in Jetty
The eBay JDBC Driver supports connection pooling: This article shows how to connect faster to eBay data from Web apps in Jetty.
-
Using the CData Software ODBC Driver for Hubstaff in PyCharm
Connect to Hubstaff as an ODBC data source in PyCharm using the CData Software ODBC Driver for Hubstaff.
-
Build Samanage-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Samanage data and build web apps with connectivity to live Samanage data.
-
Build a Singer.io Tap for Landbot With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Landbot data using the CData Python Connector.
-
Build Zuora-Connected Apps in Choreo
Use CData Connect AI to connect to Zuora Data from Choreo and build custom apps using live Zuora data.
-
Back Up Blackbaud FE NXT data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Blackbaud FE NXT. In this article, we will employ an SSIS workflow to populate a database with Blackbaud FE NXT data data.
-
How to Access Live Keap Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Keap enables you to integrate Keap data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous FHIR Replication to SQLite
Use CData Sync for automated, continuous, customizable FHIR replication to SQLite.
-
Connect to SAP SuccessFactors LMS from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP SuccessFactors LMS to connect to SAP SuccessFactors LMS data from Web applications running on WebLogic.
-
How to connect SharePoint with QuickBooks Data through external lists
Provide QuickBooks data to SharePoint users as an external list.
-
Use the CData Software JDBC Driver for Slack in MicroStrategy Web
Connect to Slack data in MicroStrategy Web using the CData Software JDBC Driver for Slack.
-
Import Real-Time Phoenix Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Phoenix data in ColdFusion.
-
Natively Connect to GitLab Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to GitLab data. Leverage the native support for ODBC in PHP.
-
Automate Factorial Data Replication to Couchbase
Use CData Sync to Customize and automate Factorial data replication to Couchbase.