CData Software - Knowledge Base
Recent Articles
-
How to Connect to ShipStation Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ShipStation data. Leverage the pyodbc module for ODBC in Python.
-
Building Dynamic Web Pages with EnterpriseDB Data Using AngularJS
Create single-page applications with live connectivity to EnterpriseDB using the CData API Server.
-
Link Oracle SCM with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle SCM data in Filemaker Pro for Mac or Windows.
-
How to Access SAP Hybris C4C Data Using Entity Framework
This article shows how to access SAP Hybris C4C data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Migrating data from Adobe Target to Databricks using CData SSIS Components.
Easily push Adobe Target data to Databricks using the CData SSIS Tasks for Adobe Target and Databricks.
-
Integrate Lakebase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Lakebase data from Informatica Cloud.
-
LINQ to PostgreSQL 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 PostgreSQL Data Provider.
-
Connect to Facebook Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Facebook Ads data.
-
Build a Simple VCL Application for Stripe Data
How to build a simple VCL Application to view Stripe data in RAD Studio using the CData ODBC Driver for Stripe.
-
Replicate Printify Data from PowerShell
Write a quick PowerShell script to query Printify data. Use connectivity to the live data to replicate Printify data to SQL Server.
-
Build EnterpriseDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live EnterpriseDB data and build visualizations in Tableau Cloud.
-
Access Live Blackbaud FE NXT Data in Excel 365 Online (Excel for the web)
Connect to Blackbaud FE NXT data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connecting GenSpark with Excel Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Excel Online data without any replication or custom integration required.
-
DataBind Controls to NetSuite Data in C++Builder
DataBind to NetSuite data in C++Builder with standard components and controls.
-
Connect to eBay Data in Aqua Data Studio
Access eBay data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Access Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Access replication to IBM DB2.
-
How to connect to CircleCI Data from Spring Boot
Connect to CircleCI in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate LibreChat with Live Pinterest Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Pinterest data from within the chat interface.
-
Build AI/ML Models with Live Google Contacts Data using Dataiku
Connect Google Contacts Data with Dataiku using the CData JDBC Driver for Google Contacts.
-
Build GitLab-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for GitLab Data and create custom apps in Bubble.
-
How to Work with Freshdesk Data in ETL Validator JDBC
Connect to Freshdesk from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating LangGraph with Spark Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Spark data within automated workflows.
-
Connect to Short.io Data in DBeaver
Use the CData ODBC Driver to connect to Short.io data in DBeaver.
-
Visualize Live Rootly Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Rootly data.
-
Build Zoho Projects-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zoho Projects Data and create custom apps in Mendix.
-
Connect to Apify Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Apify data in Airbyte.
-
Use Dash to Build to Web Apps on HubSpot Data
Create Python applications that use pandas and Dash to build HubSpot-connected web apps.
-
Connect to Oracle Sales Data in RazorSQL
Connect to Oracle Sales from wizards and query Oracle Sales data from the GUI in the RazorSQL database management tool.
-
View Reports on Real-Time Pinterest Data in Power BI Report Server
Use the CData ODBC Driver for Pinterest to visualize Pinterest data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Build an ETL App for GitHub Data in Python with CData
Create ETL applications and real-time data pipelines for GitHub data in Python with petl.
-
Build Visualizations of Epicor Kinetic Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Epicor Kinetic data in Birst.
-
Choosing the Best Method to Connect Smartsheet to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Smartsheet data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to SQL Server Data in JRuby
Create a simple JRuby app with access to live SQL Server data.
-
Integrating OpenCode with YouTube Analytics 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.
-
Prepare, Blend, and Analyze Rebilly Data in Alteryx Designer (ODBC)
Build workflows to access live Rebilly data for self-service data analytics.
-
Integrating Claude Code with Cloudant Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Cloudant data within assisted coding and automated development workflows.
-
Create Adobe Experience Manager-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Adobe Experience Manager Data from OutSystems and build custom enterprise apps using live Adobe Experience Manager data.
-
Connect to Suadeo Data in DBeaver
Use the CData ODBC Driver to connect to Suadeo data in DBeaver.
-
Connect to ActiveCampaign Data from a Connection Pool in Jetty
The ActiveCampaign JDBC Driver supports connection pooling: This article shows how to connect faster to ActiveCampaign data from Web apps in Jetty.
-
Integrate Theia IDE with Live BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live BigCommerce data from within the development environment.
-
Automate Keap Data Replication to SAP HANA
Use CData Sync to customize and automate Keap data replication to SAP HANA.
-
Use the CData Software JDBC Driver for Sage 300 in MicroStrategy
Connect to Sage 300 data in MicroStrategy Developer using the CData Software JDBC Driver for Sage 300.
-
How to Easily Query Redshift Data in OpenOffice Base
Connect to Redshift data in OpenOffice Base using the CData ODBC Driver for Redshift and generate reports with live data insights.
-
How to update Kintone from Excel
This article explains how to transfer data from Excel to Kintone using the Excel Add-In for Kintone.
-
Write a Simple Go Application to work with Contentful Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Contentful data.
-
Connecting GenSpark with iContact Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to iContact data without any replication or custom integration required.
-
Automate Workday Data Replication to Couchbase
Use CData Sync to Customize and automate Workday data replication to Couchbase.
-
Connect to Nuclia in SpagoBI
Create reports featuring live Nuclia data in SpagoBI Studio. Host Nuclia reports on SpagoBI Server.
-
Use the CData Software ODBC Driver for Google Cloud Storage in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Cloud Storage data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Cloud Storage.
-
Create Reports from Confluence Data in Looker Studio
Use CData Connect AI to gain access to live Confluence data and create custom reports in Looker Studio.
-
Using the CData Software ODBC Driver for ZarMoney in PyCharm
Connect to ZarMoney as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZarMoney.
-
Natively Connect to Auth0 Data in PHP
The CData ODBC driver for Auth0 enables you to create PHP applications with connectivity to Auth0 data. Leverage the native support for ODBC in PHP.
-
Use Dash to Build Web Apps on eBay Data via CData Connect AI
Build interactive Dash web apps on live eBay data using pandas and the CData Connect AI Python SDK.
-
Stream Templated Data into Apache Kafka Topics
Access and stream Templated data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Helpscout Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Helpscout replication to Apache Cassandra.
-
Automated Continuous Amazon S3 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Google BigQuery.
-
ETL ZarMoney in Oracle Data Integrator
This article shows how to transfer ZarMoney data into a data warehouse using Oracle Data Integrator.
-
Integrating Codex with Everhour 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 DB2 Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable DB2 replication to Amazon Redshift.
-
Visualize Live Active Directory Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Active Directory data into custom reports in Power BI.
-
Automated Continuous SparkPost Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SparkPost replication to Azure SQL Database.
-
How to import Google Contacts Data into Apache Solr
Use the CData Software JDBC Driver for Google Contacts in Data Import Handler and create an automated import of Google Contacts data to Apache Solr Enterprise Search platform.
-
Replicate Oracle Eloqua Reporting Data in Heroku for Use in Salesforce Connect
Replicate Oracle Eloqua Reporting data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous MailerLite Replication to Vertica
Use CData Sync for automated, continuous, customizable MailerLite replication to Vertica.
-
Integrating Antigravity CLI with Typeform data via CData CLI
Connect Typeform data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to work with Trello Data in Apache Spark using SQL
Access and process Trello Data in Apache Spark using the CData Software JDBC Driver.
-
Connect Vimeo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Vimeo data using the CData Python MCP Server.
-
How to create SQL Server federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SQL Server data in MySQL .
-
Access Live Testmonitor Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Testmonitor data through MCP integration.
-
Getting Started with the CData JDBC Driver for eBay Analytics
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for eBay Analytics.
-
Create Optimizely-Connected Nintex Workflows
Use CData Connect AI to connect to Optimizely Data from Nintex Workflow Cloud and build custom workflows using live Optimizely data.
-
Automated Continuous Deel Replication to Vertica
Use CData Sync for automated, continuous, customizable Deel replication to Vertica.
-
Feed ConvertKit Data into FineReport
How to set ConvertKit data as a JDBC data source in FineReport.
-
Integrate Devin with Live Quickbase Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Quickbase data.
-
Automate Facebook Ads Data Replication to Azure Synapse
Use CData Sync to customize and automate Facebook Ads data replication to Azure Synapse.
-
Process & Analyze Demio Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Demio Data.
-
Integrating Antigravity CLI with Google Cloud Storage data via CData CLI
Connect Google Cloud Storage data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
CData Sync Enhances Snowflake Integration with Optimized High Volume Data Handling
Learn how to optimize Snowflake data replication in CData Sync 24.3 using the new optimized option, boosting performance for high-volume data transfers.
-
Work with Acumatica Data in FoxPro
Load Acumatica data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to integrate SendInBlue with Apache Airflow
Access and process SendInBlue data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous ShipEngine Replication to Vertica
Use CData Sync for automated, continuous, customizable ShipEngine replication to Vertica.
-
Use the CData Software JDBC Driver for IBM Informix in MicroStrategy
Connect to IBM Informix data in MicroStrategy Developer using the CData Software JDBC Driver for IBM Informix.
-
Connect to Bright Data Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Bright Data as an External Source in Dremio.
-
Connect to Helpscout Data in NetBeans
Connect to Helpscout data in NetBeans with the data source configuration wizard.
-
Connect to WordPress Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for WordPress to connect to WordPress data and execute queries in PowerBuilder.
-
Integrating Claude Code with MySQL Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on MySQL data within assisted coding and automated development workflows.
-
How to connect to BambooHR Data with Squirrel SQL client
Connect to BambooHR data and execute queries in the Squirrel SQL Client.
-
Connect to Bannerbear Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Bannerbear as an External Source in Dremio.
-
Getting Started with the CData Excel Add-In for Square
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Square.
-
Integrate with Everhour Data in JReport Designer
Create charts and reports based on Everhour data in JReport Designer.
-
Prepare, Blend, and Analyze QuickBooks Online Data in Alteryx Designer (ODBC)
Build workflows to access live QuickBooks Online data for self-service data analytics.
-
Integrate Live SAP HANA Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP HANA data and integrate live SAP HANA data into apps built in Microsoft Power Apps.
-
How to connect Amazon QuickSight to Freshdesk Data
Create a connection to Freshdesk data in CData Connect AI and insert Freshdesk data into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous SAP Fieldglass Replication to SQL Server
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to SQL Server.
-
Publish Xero-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Xero data.
-
Connect to Basecamp Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Basecamp as an External Source in Dremio.
-
How to Build an ETL App for AdRoll Data in Python with CData
Create ETL applications and real-time data pipelines for AdRoll data in Python with petl.
-
Connect to Dropbox Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Dropbox data.
-
Analyze QuickBooks Time Data in Cognos Analytics
Use CData Connect AI to connect to QuickBooks Time Data from Cognos Analytics and analyze live QuickBooks Time data.
-
Add SAP HANA Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP HANA with the Informatica Enterprise Data Catalog to classify and organize data.