CData Software - Knowledge Base
Recent Articles
-
Query ShipEngine Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ShipEngine data from Node.js.
-
Build a Simple VCL Application for Amazon Athena Data
How to build a simple VCL Application to view Amazon Athena data in RAD Studio using the CData ODBC Driver for Amazon Athena.
-
Integrate Postmark Data in Pentaho Data Integration
Build ETL pipelines based on Postmark data in the Pentaho Data Integration tool.
-
Build Semantic Layer Views for Vault CRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Vault CRM data.
-
Visualize Instagram Data in TIBCO Spotfire through OData
Integrate Instagram data into dashboards in TIBCO Spotfire.
-
A PostgreSQL Interface for Pinterest Data (MySQL Remoting via JDBC)
Use the Remoting features of the Pinterest JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Workable Data from IntelliJ
Integrate connectivity to Workable data with wizards in IntelliJ.
-
Connect to Redis Data from a Connection Pool in Jetty
The Redis JDBC Driver supports connection pooling: This article shows how to connect faster to Redis data from Web apps in Jetty.
-
Automated Continuous Smartsheet Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Smartsheet replication to Google Cloud SQL.
-
Connect and Query Live Authorize.Net Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Authorize.Net data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect to Sugar CRM Data with Squirrel SQL client
Connect to Sugar CRM data and execute queries in the Squirrel SQL Client.
-
Build a Simple VCL Application for Pingdom Data
How to build a simple VCL Application to view Pingdom data in RAD Studio using the CData ODBC Driver for Pingdom.
-
Access Live Exa Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Exa data from your Excel spreadsheets.
-
Automate Reckon Accounts Hosted Data Replication to Couchbase
Use CData Sync to Customize and automate Reckon Accounts Hosted data replication to Couchbase.
-
How to connect to IBM Informix Data in DBVisualizer
Integrate IBM Informix data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to and Query Klipfolio Data in QlikView over ODBC
Create data visualizations with Klipfolio data in QlikView.
-
Query SAP Fieldglass Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Fieldglass data from Node.js.
-
Work with Live Amazon Athena Data in Power Query
Use CData Connect AI to connect to Amazon Athena data and work with live Amazon Athena data in Microsoft Power Query.
-
Automate Phoenix Data Replication to Azure Synapse
Use CData Sync to customize and automate Phoenix data replication to Azure Synapse.
-
Automated Continuous Jira Replication to SQLite
Use CData Sync for automated, continuous, customizable Jira replication to SQLite.
-
Visualize Bitbucket 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 Bitbucket data into TIBCO Spotfire.
-
Connect and Query Live Cloudant Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Cloudant data into Databricks and enable direct, live querying and analysis without replication.
-
Access Flowlu Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Flowlu data from your Oracle system.
-
Use Dash to Build Web Apps on Samanage Data via CData Connect AI
Build interactive Dash web apps on live Samanage data using pandas and the CData Connect AI Python SDK.
-
Replicate Multiple Outreach.io Accounts
Replicate multiple Outreach.io accounts to one or many databases.
-
Getting Started with the CData Excel Add-In for Webex
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Webex.
-
ETL Azure Synapse in Oracle Data Integrator
This article shows how to transfer Azure Synapse data into a data warehouse using Oracle Data Integrator.
-
Build MVC Applications with Connectivity to Greenplum Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Greenplum from an ASP.NET MVC application.
-
Build Automated BigQuery-Connected Workflows in Zapier
Use CData Connect AI to connect to live BigQuery data and build automated workflows in Zapier.
-
Access Live Lakebase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Lakebase data from your Google Sheets.
-
Automated Continuous SageHR Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SageHR data replication to OneLake in Microsoft Fabric.
-
Connecting Mastra with ZohoExpense 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 ZohoExpense data, no replication required.
-
Use Microsoft Copilot Studio to talk to your Mailjet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Mailjet data for you.
-
Create SSAS Tabular Models from Quaderno Data
How to build a SQL Server Analysis Service Tabular Model from Quaderno data using CData drivers.
-
Write a Simple Go Application to work with Outlook Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Outlook data.
-
How to Connect DBeaver to xBase via a JDBC Driver
Manage xBase data with visual tools in DBeaver like the query browser.
-
Build Apps with Live Vault CRM data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Vault CRM data into the Adalo platform and build custom mobile and web applications with real-time Vault CRM data.
-
Import Real-Time Nethunt Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Nethunt data in ColdFusion.
-
Automated Continuous SAP HANA Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP HANA replication to Google BigQuery.
-
How to Query Live Helpscout Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Helpscout data data in natural language using Python.
-
Integrate MongoDB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MongoDB data from Informatica Cloud.
-
Link Wistia with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Wistia data in Filemaker Pro for Mac or Windows.
-
Integrating TaxJar Data in Talend Cloud Data Management Platform
Connect TaxJar Data with Talend Cloud Data Management Platform using the CData JDBC Driver for TaxJar.
-
Getting Started with the CData ODBC Driver for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for IBM Cloud Object Storage.
-
Back Up Cohere 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 Cohere data data.
-
Build Oracle Service Cloud-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Oracle Service Cloud Data and create custom apps in Mendix.
-
Manage DocuSign Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for DocuSign.
-
Integrate with Avro Data in JReport Designer
Create charts and reports based on Avro data in JReport Designer.
-
Integrating LangGraph with Anaplan Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Anaplan data within automated workflows.
-
Write a Simple Go Application to work with Mode Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Mode data.
-
Connect to CloudConvert Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for CloudConvert data.
-
Automated Continuous Perigon Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Perigon data replication to OneLake in Microsoft Fabric.
-
Create Datasets from Twitter Ads in Domo Workbench and Build Visualizations of Twitter Ads Data in Domo
Use the CData Software ODBC Driver for Twitter Ads to create datasets from Twitter Ads data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous LightSpeedRetail Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Apache Cassandra.
-
Integrating Claude Code CLI with Supabase 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 Access Okta Data Using Entity Framework
This article shows how to access Okta data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Create SQL Pass-Through Queries in MS Access Using CData
Learn how to create SQL pass-through queries in MS Access using CData to optimize database performance and execute SQL directly on external data sources.
-
Access Live FTP Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to FTP data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous TaxJar Replication to Vertica
Use CData Sync for automated, continuous, customizable TaxJar replication to Vertica.
-
Connect to Microsoft Ads Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Ads data.
-
Migrating data from QuickBooks Time to Snowflake using CData SSIS Components.
Easily push QuickBooks Time data to Snowflake using the CData SSIS Tasks for QuickBooks Time and Snowflake.
-
Connect to SendPulse Data in Jaspersoft Studio
Execute SQL to remote SendPulse data in Jaspersoft Studio.
-
Connecting GenSpark with SQL Server Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SQL Server data without any replication or custom integration required.
-
Import Real-Time Opsgenie Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Opsgenie data in ColdFusion.
-
Connect to Google Calendar Data in ACL Analytics
Connect to Google Calendar data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Calendar data.
-
Publish Reports with Drip Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Drip data.
-
Migrating data from Contentful to Snowflake using CData SSIS Components.
Easily push Contentful data to Snowflake using the CData SSIS Tasks for Contentful and Snowflake.
-
Use CData Connect AI to Access Guru Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Guru data in the Power Pivot business intelligence tool.
-
Analyze OpenWeatherMap Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze OpenWeatherMap data in Microsoft R Open.
-
Object-Relational Mapping (ORM) with Toggl 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 Toggl data into a Java-based ORM framework, Hibernate.
-
How to connect Amazon QuickSight to IBM Informix Data
Create a connection to IBM Informix data in CData Connect AI and insert IBM Informix data into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Calendly Data from PowerShell
Write a quick PowerShell script to query Calendly data. Use connectivity to the live data to replicate Calendly data to SQL Server.
-
How to create an RPA flow for Bright Data Data in UiPath Studio
Use the Bright Data ODBC Driver to create workflows that access real-time Bright Data data without any coding.
-
Automated Continuous HubSpot Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HubSpot replication to AlloyDB.
-
How to create an RPA flow for Cassandra Data in UiPath Studio
Use the Cassandra ODBC Driver to create workflows that access real-time Cassandra data without any coding.
-
Integrate Acumatica Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Acumatica data from Informatica Cloud.
-
Connect and Query Live Sendwithus Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Sendwithus data into Databricks and enable direct, live querying and analysis without replication.
-
Build Visualizations of RSS Feeds in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of RSS feeds in Birst.
-
Import Real-Time BigQuery Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use BigQuery data in ColdFusion.
-
Connect to Zoho Books Data in DBeaver
Use the CData ODBC Driver to connect to Zoho Books data in DBeaver.
-
Connect to PostgreSQL Data in DBeaver
Use the CData ODBC Driver to connect to PostgreSQL data in DBeaver.
-
Stream Vault CRM Data into Apache Kafka Topics
Access and stream Vault CRM data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to XML Data from HeidiSQL
Use CData Connect AI to connect to and query live XML data from HeidiSQL.
-
How to integrate Pushbullet with Apache Airflow
Access and process Pushbullet data in Apache Airflow using the CData JDBC Driver.
-
Visualize Salesloft 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 Salesloft data into TIBCO Spotfire.
-
Publish Freshteam-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Freshteam data.
-
Integrate Cline with Live Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Azure Table data from within your IDE.
-
Automated Continuous Factorial Replication to Databricks
Use CData Sync for automated, continuous, customizable Factorial replication to Databricks.
-
How to connect to DB2 Data with Squirrel SQL client
Connect to DB2 data and execute queries in the Squirrel SQL Client.
-
Build Visualizations of SAP Fieldglass Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Fieldglass data in Birst.
-
Choosing the Best Method to Connect Act CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Act CRM data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Kiro with Wistia 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.
-
Use the CData Software ODBC Driver for Sage 200 in MicroStrategy Desktop
Connect to Sage 200 data in MicroStrategy Desktop using the CData Software ODBC Driver for Sage 200.
-
Create SSAS Tabular Models from Brex Data
How to build a SQL Server Analysis Service Tabular Model from Brex data using CData drivers.
-
Access Live Azure Analysis Services Data in TIBCO Data Virtualization
Use the Azure Analysis Services Tibco DV Adapter to create a Azure Analysis Services data data source in TIBCO Data Virtualization Studio and gain access to live Azure Analysis Services data from your TDV Server.
-
Integrate PingOne with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PingOne with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PingOne data.
-
ZohoSubscriptions Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ZohoSubscriptions facts in real time.
-
Integrate Zendesk Data in Pentaho Data Integration
Build ETL pipelines based on Zendesk data in the Pentaho Data Integration tool.
-
Access Live SuiteCRM Data in TIBCO Data Virtualization
Use the SuiteCRM Tibco DV Adapter to create a SuiteCRM data data source in TIBCO Data Virtualization Studio and gain access to live SuiteCRM data from your TDV Server.
-
How to Query Live Procore Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Procore data data in natural language using Python.