CData Software - Knowledge Base
Recent Articles
-
Load Discord Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Discord data to a database.
-
How to Query Azure Synapse Data in MySQL Workbench
Execute MySQL queries against live Azure Synapse data from MySQL Workbench.
-
Connect to Google Translate Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Translate data.
-
Analyze Live Sugar CRM Data in SAS Viya
Use CData Connect AI to connect to Sugar CRM data from SAS Viya and deploy self-service analytics using live Sugar CRM data.
-
Connect to BigCommerce Data in CloverDX (formerly CloverETL)
Transfer BigCommerce data using the visual workflow in the CloverDX data integration tool.
-
Build Shippo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Shippo data and build web apps with connectivity to live Shippo data.
-
Connect to and Query Google Forms Data in QlikView over ODBC
Create data visualizations with Google Forms data in QlikView.
-
Create SSAS Tabular Models from ClickTime Data
How to build a SQL Server Analysis Service Tabular Model from ClickTime data using CData drivers.
-
Connect to SAS Data Sets Data in DBeaver
Use the CData ODBC Driver to connect to SAS Data Sets data in DBeaver.
-
Use the CData Software ODBC Driver for SAP Business One in MicroStrategy
Connect to SAP Business One data in MicroStrategy Developer using the CData Software ODBC Driver for SAP Business One.
-
TaxJar Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on TaxJar facts in real time.
-
How to connect to JobNimbus Data from IntelliJ
Integrate connectivity to JobNimbus data with wizards in IntelliJ.
-
Connect and Visualize Live SparkPost Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SparkPost data into the Databricks platform and create visualization dashboards with real-time SparkPost data.
-
Automated Continuous Office 365 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Office 365 replication to Google BigQuery.
-
Rapidly Develop Salesforce Data 360-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Salesforce Data 360.
-
Integrating Boomi Agentstudio with Jumpseller Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Jumpseller data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate Calendly Data to Multiple Databases
Replicate Calendly data to disparate databases with a point-and-click configuration.
-
Link ZohoInvoice with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZohoInvoice data in Filemaker Pro for Mac or Windows.
-
Work with Live Couchbase Data in Power Query
Use CData Connect AI to connect to Couchbase data and work with live Couchbase data in Microsoft Power Query.
-
How to Connect to Float Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Float data. Leverage the pyodbc module for ODBC in Python.
-
Create Shortcut-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Shortcut Data from OutSystems and build custom enterprise apps using live Shortcut data.
-
Use CData Connect AI to Access Gmail Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Gmail data in the Power Pivot business intelligence tool.
-
Build Shortcut-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Shortcut data and build Shortcut-connected web apps with Axios.
-
Build SAP BusinessObjects BI-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP BusinessObjects BI Data and create custom apps in Mendix.
-
Establish a Live Connection with Gong Data using Tableau Bridge
The CData ODBC Driver for Gong enables you to integrate live Gong data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Coda Data in DBArtisan
Use wizards in DBArtisan to configure Coda data as a data source.
-
How to use SQLAlchemy ORM to access Google Sheets Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Sheets data.
-
How to connect to Azure Data Catalog Data in DBVisualizer
Integrate Azure Data Catalog data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to publish and share Google Campaign Manager 360 Data dashboards with Tableau Server
The CData ODBC driver for Google Campaign Manager 360 enables you integrate Google Campaign Manager 360 data into Tableau dashboards.
-
Create Dynamic Amazon S3 Grids Using the Infragistics XamDataGrid
Learn how you can connect Amazon S3 to Infragistics XamDataGrid to build dynamic grids.
-
How to Visualize Vertica 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 Vertica data in Python.
-
Connect to Exact Online Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Exact Online and the Script function in FileMaker Pro to connect to Exact Online and work with Exact Online data in your FileMaker application.
-
Getting Started with the CData Tableau Connector for Bugsnag
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Perplexity 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 Perplexity data.
-
How to Seamlessly Import MYOB AccountRight Data into IBM SPSS Modeler
Integrate MYOB AccountRight data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate ServiceDesk Plus Data into Power Automate Desktop using CData Connect
CData Connect for ServiceDesk Plus Data enables you to integrate ServiceDesk Plus data into workflows built using Microsoft Power Automate Desktop.
-
Build AI Agents with Spark 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 Spark data through CData Connect AI.
-
Build Charts with EmailOctopus Data in Clear Analytics
Create dynamic charts and perform analytics based on EmailOctopus data in Clear Analytics.
-
Connect to ClickUp Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ClickUp.
-
Getting Started: Build a Customer Health AI Agent with Microsoft Copilot Studio and CData Connect AI
Learn how to build a customer health AI agent in Microsoft Copilot Studio using CData Connect AI to analyze sample customer data from Google Sheets.
-
How to Easily Query SharePoint Data in OpenOffice Base
Connect to SharePoint data in OpenOffice Base using the CData ODBC Driver for SharePoint and generate reports with live data insights.
-
Creating Google Ad Manager-Connected Applications in Unqork
You can use CData Connect AI to feed Google Ad Manager data to Unqork and build custom business apps.
-
Migrating data from Codat to Snowflake using CData SSIS Components.
Easily push Codat data to Snowflake using the CData SSIS Tasks for Codat and Snowflake.
-
Model Snapchat Ads Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Snapchat Ads, enabling the direct import of real-time Snapchat Ads data.
-
Access CSV Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access CSV data from your Oracle system.
-
Build Tickspot-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Tickspot data.
-
Use the CData Software JDBC Driver for Qualaroo in MicroStrategy Web
Connect to Qualaroo data in MicroStrategy Web using the CData Software JDBC Driver for Qualaroo.
-
Connecting to Apache Doris with a CData MySQL Connector
A guide to using the CData MySQL JDBC Driver to talk to Apache Doris
-
Automated Microsoft Planner Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft Planner data replication to Teradata.
-
Automate Salesforce Data Replication to Azure Synapse
Use CData Sync to customize and automate Salesforce data replication to Azure Synapse.
-
Analyze SAP HANA Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP HANA data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Download files from a SharePoint site using the CData SSIS Components
The CData SSIS data flow components allow you to easily import and export data from various data sources. However in some cases the type of operation you need does not fit the SSIS Data Source or the SSIS Data Destination model. In this article, we will demonstrate how to use a CData stored procedure in your SSIS data flow.
-
Integrating Boomi Agentstudio with Omnisend Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Omnisend data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
GitHub Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to GitHub data through CData Connect AI using different applications and tools.
-
How to Access Paddle Data Using Entity Framework
This article shows how to access Paddle data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Kafka Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Kafka replication to Google BigQuery.
-
Integrating Antigravity CLI with Aweber data via CData CLI
Connect Aweber data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Provide OData Services of PDFMonkey Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PDFMonkey data by developing a WCF Service Application.
-
Integrate Google's Antigravity Agent with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live eBay data using the Model Context Protocol.
-
Automate AgileCRM Data Replication to Couchbase
Use CData Sync to Customize and automate AgileCRM data replication to Couchbase.
-
How to Work with Grafana Data in ETL Validator JDBC
Connect to Grafana from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Charts with ZohoSubscriptions Data in Clear Analytics
Create dynamic charts and perform analytics based on ZohoSubscriptions data in Clear Analytics.
-
Replicate Kafka Data in Heroku for Use in Salesforce Connect
Replicate Kafka data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Live Snapchat Ads Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Snapchat Ads data for you.
-
Automated Continuous AdRoll Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable AdRoll replication to Amazon Redshift.
-
Build Klaviyo-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Klaviyo Data and create custom apps in Bubble.
-
Import Real-Time Zoho Inventory Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Inventory data in ColdFusion.
-
Create Informatica Mappings From/To an ODBC Data Source for Presto
Create an ODBC connection to Presto in Informatica and browse and transfer Presto data.
-
Connect and Query Live SAP Business Warehouse Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP Business Warehouse data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Microsoft Teams Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Teams Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Work with PabblySubscriptions Data in ETL Validator JDBC
Connect to PabblySubscriptions from ETL Validator jobs using the CData Software JDBC Driver.
-
Connecting Mastra with Monday.com 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 Monday.com data, no replication required.
-
Query RSS Feeds in DataGrip
Create a Data Source for RSS in DataGrip and use SQL to query live RSS feeds.
-
Build Data Flows from CSV to SQL Server using SSIS
Easily back up CSV data to SQL Server using the SSIS components for CSV.
-
Integrating Claude Code with MarkLogic Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on MarkLogic data within assisted coding and automated development workflows.
-
Create Microsoft OneDrive-Connected Applications in Appsmith
Connect to Microsoft OneDrive Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Microsoft OneDrive data.
-
Access Pingdom Data from MySQL in PHP
Connect to Pingdom through the standard MySQL libraries in PHP.
-
Build Charts with Humanity Data in Clear Analytics
Create dynamic charts and perform analytics based on Humanity data in Clear Analytics.
-
Migrating data from Oracle Eloqua to Databricks using CData SSIS Components.
Easily push Oracle Eloqua data to Databricks using the CData SSIS Tasks for Oracle Eloqua and Databricks.
-
Use CData Connect AI to Access SAP Ariba Source Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Ariba Source data in the Power Pivot business intelligence tool.
-
Automated Continuous Unbounce Replication to Vertica
Use CData Sync for automated, continuous, customizable Unbounce replication to Vertica.
-
Integrating OpenCode with Greenplum 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.
-
Configure the CData JDBC Driver for Instantly in a Connection Pool in Tomcat
Connect to Instantly data from a connection pool in Tomcat.
-
How to connect to ZarMoney Data with Squirrel SQL client
Connect to ZarMoney data and execute queries in the Squirrel SQL Client.
-
Consume Vault CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Vault CRM feeds that reflect any changes in SAP Lumira.
-
How to integrate Metabase with Hive Data
Use CData Connect AI to connect to live Hive data and create an interactive dashboard in Metabase from Hive data.
-
Integrate Teamgate with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Teamgate with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Teamgate data.
-
Integrate Pipeline CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Pipeline CRM with External Services.
-
Connect to Highrise Data from Crystal Reports
Use CData Connect AI to connect to and report on live Highrise data from Crystal Reports.
-
Import Real-Time Dynamics CRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Dynamics CRM data in ColdFusion.
-
Connect to Anaplan Data from HeidiSQL
Use CData Connect AI to connect to and query live Anaplan data from HeidiSQL.
-
Use the CData Software JDBC Driver for Google Drive in MicroStrategy
Connect to Google Drive data in MicroStrategy Developer using the CData Software JDBC Driver for Google Drive.
-
Natively Connect to Yelp Data in PHP
The CData ODBC driver for Yelp enables you to create PHP applications with connectivity to Yelp data. Leverage the native support for ODBC in PHP.
-
Connect to Beeminder Data in DBArtisan
Use wizards in DBArtisan to configure Beeminder data as a data source.
-
Query, Visualize, and Share live Aweber Data in Redash
Use CData Connect AI to connect to live Aweber data in Redash for querying, visualizing, and sharing.
-
How to work with Simplesat Data in Apache Spark using SQL
Access and process Simplesat Data in Apache Spark using the CData Software JDBC Driver.
-
Build MVC Applications with Connectivity to Amazon S3 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Amazon S3 from an ASP.NET MVC application.
-
Automated Continuous ServiceNow Replication to MongoDB
Use CData Sync for automated, continuous, customizable ServiceNow replication to MongoDB.
-
Build ShipStation Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ShipStation data and build visualizations in Tableau.
-
Connect to Pipeliner CRM Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Pipeliner CRM and work with Pipeliner CRM data in your FileMaker applications.