CData Software - Knowledge Base
Recent Articles
-
Excel Spreadsheet Automation on Contentful Data with the QUERY Formula
Pull data from Contentful, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Connect AI Python SDK for ShipStation
Install the CData Connect AI Python SDK to read live ShipStation data with standard DB-API 2.0 Python code.
-
Connect to ZendeskSell Data in CloverDX (formerly CloverETL)
Transfer ZendeskSell data using the visual workflow in the CloverDX data integration tool.
-
How to Visualize Dotmailer Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dotmailer data in Python.
-
Access Factorial Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Factorial data from HeidiSQL.
-
Automated Continuous Drip Replication to Vertica
Use CData Sync for automated, continuous, customizable Drip replication to Vertica.
-
Integrate with live Quickbase Data in Jitterbit
Use CData Connect AI to connect to and integrate live Quickbase data in Jitterbit.
-
How to Visualize Recurly Data in Python with pandas
Use pandas and other modules to analyze and visualize live Recurly data in Python.
-
Connect to Oracle Eloqua Data from AWS Glue
Use CData Connect AI to gain access to live Oracle Eloqua data from your AWS Glue jobs.
-
Connect to Odoo Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Odoo Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to connect to Cohere Data from IntelliJ
Integrate connectivity to Cohere data with wizards in IntelliJ.
-
Visualize Live Salesforce CRM Analytics Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Salesforce CRM Analytics data into custom reports in Power BI.
-
Access Live Egnyte Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Egnyte data from your Google Sheets.
-
How to Query Neo4J Data in MySQL Workbench
Execute MySQL queries against live Neo4J data from MySQL Workbench.
-
Build Azure Analysis Services Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Azure Analysis Services data and build visualizations in Tableau.
-
Integrate Google's Antigravity Agent with Live Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Timely data using the Model Context Protocol.
-
Integrate Hacker News Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Hacker News data from Informatica Cloud.
-
Validate Cassandra Data with QuerySurge
Access and validate Cassandra data in QuerySurge using the CData JDBC Driver.
-
LINQ to Kintone 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 Kintone Data Provider.
-
Create Presto-Connected Nintex Workflows
Use CData Connect AI to connect to Presto Data from Nintex Workflow Cloud and build custom workflows using live Presto data.
-
Access Amplitude Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Amplitude data from your Oracle system.
-
Import Sendwithus Data Using Azure Data Factory
Use CData Connect AI to connect to Sendwithus Data from Azure Data Factory and import live Sendwithus data.
-
Build MVC Applications with Connectivity to AlloyDB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access AlloyDB from an ASP.NET MVC application.
-
Connecting GenSpark with LinkedIn Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to LinkedIn data without any replication or custom integration required.
-
Create HCL Domino Dataflows on PowerBI.com
Connect to the CData Power BI Connector for HCL Domino from PowerBI.com to create Power BI Dataflows with real-time data.
-
Migrating data from LinkedIn to Google BigQuery using CData SSIS Components.
Easily push LinkedIn data to Google BigQuery using the CData SSIS Tasks for LinkedIn and Google BigQuery.
-
Access Smartsheet 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 Smartsheet data.
-
How to connect to SuiteCRM Data with Squirrel SQL client
Connect to SuiteCRM data and execute queries in the Squirrel SQL Client.
-
Analyze Hugging Face Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Hugging Face from Power Pivot. You will use the Table Import Wizard to load Hugging Face data. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Kiro with Quaderno 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.
-
Build Semantic Layer Views for MariaDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MariaDB data.
-
Easily Integrate MailerSend Data in Lazarus Pascal IDE
Learn how to easily integrate live MailerSend data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build MailerLite Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MailerLite data and build visualizations in Tableau Cloud.
-
Replicate Multiple AdRoll Accounts via the CData Sync CLI
Replicate multiple AdRoll accounts to one or many databases.
-
Snowflake Drivers: How to Setup and Use Key-Pair Authentication
A guide on configuring key-pair authentication in Snowflake and using key-pair authentication with CData Snowflake solutions.
-
Create Data Visualizations Based On Dynamics 365 Business Central Data in Mode
Use CData Connect AI to connect to Dynamics 365 Business Central Data from Mode and build visualizations using live Dynamics 365 Business Central data.
-
Connect to Google Tasks Data from a Connection Pool in JBoss
Integrate Google Tasks data into Java servlets: Use the Management Console in JBoss to install the Google Tasks JDBC Driver.
-
Build Agents in Relevance AI with Access to Live SuiteCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SuiteCRM data within intelligent agent workflows.
-
Use Dash to Build to Web Apps on Onfleet Data
Create Python applications that use pandas and Dash to build Onfleet-connected web apps.
-
Consume Oracle Eloqua OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle Eloqua feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Clockify Replication to SQL Server
Use CData Sync for automated, continuous, customizable Clockify replication to SQL Server.
-
Analyze DB2 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for DB2 from Power Pivot. You will use the Table Import Wizard to load DB2 data. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software JDBC Driver for Datadog in MicroStrategy Desktop
Connect to Datadog data in MicroStrategy Desktop using the CData Software JDBC Driver for Datadog.
-
Creating ZohoDesk-Connected Applications in Unqork
You can use CData Connect AI to feed ZohoDesk data to Unqork and build custom business apps.
-
Access Live eBay Data in Coginiti Pro
Connect to and query live eBay data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Work with Live Twitter Ads Data in Power Query
Use CData Connect AI to connect to Twitter Ads data and work with live Twitter Ads data in Microsoft Power Query.
-
Automated Continuous Amazon Marketplace Replication to MongoDB
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to MongoDB.
-
Query SQL Analysis Services Data as a MySQL Database in Node.js
Execute MySQL queries against SQL Analysis Services data from Node.js.
-
Create Data Visualizations in Cognos BI with Aircall Data
Access Aircall data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData ODBC Driver for Marketo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Marketo to connect to Marketo data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Marketo data in Excel.
-
Automated Continuous eBay Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable eBay replication to delimited files (CSV/TSV).
-
Integrate with Beeminder Data in JReport Designer
Create charts and reports based on Beeminder data in JReport Designer.
-
How to Connect DBeaver to Xero via a JDBC Driver
Manage Xero data with visual tools in DBeaver like the query browser.
-
Connect to Pinecone Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Pinecone and work with Pinecone data in your FileMaker application.
-
Use Claude to Talk to Your Microsoft Planner 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 Planner data for you.
-
Automated SurveyMonkey Data Replication to Teradata
Use CData Sync to Customize and automate SurveyMonkey data replication to Teradata.
-
Build CockroachDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live CockroachDB data and build visualizations in Tableau Cloud.
-
Build Automated Workflows with Live Blackbaud FE NXT Data in Workato
Use CData Connect AI to connect to live Blackbaud FE NXT data and build automated workflows in Workato.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Unbounce
Provide connectivity to Unbounce data through an SAP BusinessObjects universe.
-
Automated Continuous Sage Intacct Replication to MySQL
Use CData Sync for automated, continuous, customizable Sage Intacct replication to MySQL.
-
How to Seamlessly Import Dynamics NAV Data into IBM SPSS Modeler
Integrate Dynamics NAV data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Live SAP HANA Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP HANA data.
-
Automated Continuous Perplexity Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Perplexity replication to delimited files (CSV/TSV).
-
Connect to FTP in SpagoBI
Create reports featuring live FTP data in SpagoBI Studio. Host FTP reports on SpagoBI Server.
-
Create Dynamic Planio Grids Using the Infragistics XamDataGrid
Learn how you can connect Planio to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Google's Vertex AI Agent with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Pipedrive data within intelligent workflows.
-
Connect to Salesforce Marketing Data in Jaspersoft Studio
Execute SQL to remote Salesforce Marketing data in Jaspersoft Studio.
-
Create Webex Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Webex data access from reports, embedded analytics, and more.
-
Connect and Visualize Live Salesforce Marketing Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Salesforce Marketing data into the Databricks platform and create visualization dashboards with real-time Salesforce Marketing data.
-
How to Connect to Live Snapchat Ads Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Snapchat Ads data without replication.
-
Moving Data from Eventbrite to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Eventbrite data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Manage Qualaroo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Qualaroo.
-
Query ChargeOver Data in DataGrip
Create a Data Source for ChargeOver in DataGrip and use SQL to query live ChargeOver data.
-
Connect to Mocean Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Mocean to connect to Mocean data and execute queries in PowerBuilder.
-
View Reports on Real-Time Grafana Data in Power BI Report Server
Use the CData ODBC Driver for Grafana to visualize Grafana data in Power BI Desktop and then publish them to Power BI Report Server.
-
Query Reply.io Data in ColdFusion
Write standard ColdFusion data access code to connect to Reply.io data.
-
Import MongoDB Data Using Azure Data Factory
Use CData Connect AI to connect to MongoDB Data from Azure Data Factory and import live MongoDB data.
-
How to Connect to Live IBM Informix 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 IBM Informix data for you.
-
Integrating Gumloop with Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Ad Manager data within automated workflows.
-
How to connect to Twilio Data from Spring Boot
Connect to Twilio in a Spring Boot Application using the CData JDBC Driver for Twilio
-
Query HBase Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume HBase entities in PHP by modeling them as objects.
-
Migrating data from SharePoint to Google BigQuery using CData SSIS Components.
Easily push SharePoint data to Google BigQuery using the CData SSIS Tasks for SharePoint and Google BigQuery.
-
Access Live MessageBird Data in Coginiti Pro
Connect to and query live MessageBird data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query Exact Online Data in DataGrip
Create a Data Source for Exact Online in DataGrip and use SQL to query live Exact Online data.
-
How to Visualize Microsoft Exchange Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Exchange data in Python.
-
Design BIRT Reports on Act-On Data
Provide current Act-On data to your embedded analytics.
-
Create a Data Access Object for Recurly Data using JDBI
A brief overview of creating a SQL Object API for Recurly data in JDBI.
-
How to Query PhantomBuster Data in MySQL Workbench
Execute MySQL queries against live PhantomBuster data from MySQL Workbench.
-
Connect to ZohoPeople Data in DBeaver
Use the CData ODBC Driver to connect to ZohoPeople data in DBeaver.
-
Perform Batch Operations with Klaviyo Data in Apache NiFi
Connect to Klaviyo data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Invoiced in MicroStrategy Web
Connect to Invoiced data in MicroStrategy Web using the CData Software JDBC Driver for Invoiced.
-
Access Live Amazon S3 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Amazon S3 data from your Excel spreadsheets.
-
Cohere Reporting in OBIEE with the Cohere JDBC Driver
Deploy the Cohere JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate Clockify Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Clockify data from PowerShell? This article demonstrates how to utilize the Clockify Cmdlets for tasks like connecting to Clockify data, automating operations, downloading data, and more.
-
Automate Vimeo Data Replication to SAP HANA
Use CData Sync to customize and automate Vimeo data replication to SAP HANA.
-
Visualize Live MariaDB Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MariaDB data.
-
Build Charts with Billsby Data in Clear Analytics
Create dynamic charts and perform analytics based on Billsby data in Clear Analytics.
-
Using the CData Software ODBC Driver for Salesforce Marketing in PyCharm
Connect to Salesforce Marketing as an ODBC data source in PyCharm using the CData Software ODBC Driver for Salesforce Marketing.
-
Access Live SAP Hybris C4C Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Hybris C4C data from your Excel spreadsheets.
-
Viewing Pinecone Data in RAD Studio Data Explorer
How to view Pinecone data in RAD Studio Data Explorer using the CData ODBC Driver for Pinecone.