CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To an ODBC Data Source for ScrapingBee
Create an ODBC connection to ScrapingBee in Informatica and browse and transfer ScrapingBee.
-
Excel Spreadsheet Automation on Pingdom Data with the QUERY Formula
Pull data from Pingdom, automate spreadsheets, and more with the QUERY formula.
-
ETL Twilio in Oracle Data Integrator
This article shows how to transfer Twilio into a data warehouse using Oracle Data Integrator.
-
Use the CData ODBC Driver for LDAP from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LDAP to connect to LDAP from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LDAP in Excel.
-
Access Live Marketo Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Marketo from your Excel spreadsheets.
-
Create a Data Access Object for Vault CRM Data using JDBI
A brief overview of creating a SQL Object API for Veeva Vault & Vault CRM in JDBI.
-
Connect to Presto Data in Claris FileMaker Pro
Use the CData ODBC Driver for Presto in FileMaker Pro to connect to Presto and work with Presto in your FileMaker applications.
-
Access Salesloft Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Salesloft from your Oracle system.
-
Connect to Figshare Data in HULFT Integrate
Connect to Figshare as a JDBC data source in HULFT Integrate
-
Connect to Azure Analysis Services Data in Ruby
Connect to Azure Analysis Services in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Adobe Commerce-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Adobe Commerce Data and create custom apps in Mendix.
-
Access ZendeskSell Data from MySQL in Amazon QuickSight
Connect to ZendeskSell and build visualizations of ZendeskSell using a MySQL Connection in Amazon QuickSight.
-
Create Exact Online Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Exact Online data access from reports, embedded analytics, and more.
-
Connect to CockroachDB Data in Aqua Data Studio
Access CockroachDB from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to connect SharePoint with Hive Data through external lists
Provide Apache Hive to SharePoint users as an external list.
-
Extend Google Sheets with PingOne Data
Make calls to PingOne from Google Apps Script via the API Server.
-
How to create an RPA flow for Humanity Data in UiPath Studio
Use the Humanity ODBC Driver to create workflows that access real-time Humanity without any coding.
-
Build Google Sheets Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Sheets and build visualizations in Tableau.
-
Connecting Mastra with Cvent 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 Cvent, no replication required.
-
Automated Continuous Google Directory Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Directory replication to SQLite.
-
Automated Continuous Dynamics 365 Replication to SingleStore
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to SingleStore.
-
How to Seamlessly Import ZohoDesk Data into IBM SPSS Modeler
Integrate ZohoDesk data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Amazon S3 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Amazon S3 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Query Mailgun Data in MySQL Workbench
Execute MySQL queries against live Mailgun from MySQL Workbench.
-
Bridge Microsoft Entra ID Connectivity with Apache NiFi
Access and process Microsoft Entra ID in Apache NiFi using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for Exact Online on an SSRS Report Server
Connect to Exact Online from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrate GitLab Data in Pentaho Data Integration
Build ETL pipelines based on GitLab in the Pentaho Data Integration tool.
-
How to Query Live HubDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live HubDB data in natural language using Python.
-
Connect to Harvest from a Connection Pool in WebLogic
Use the CData JDBC Driver for Harvest to connect to Harvest from Web applications running on WebLogic.
-
ETL Hugging Face in Oracle Data Integrator
This article shows how to transfer Hugging Face into a data warehouse using Oracle Data Integrator.
-
Analyze Avro Data in Cognos Analytics
Use CData Connect AI to connect to Avro Data from Cognos Analytics and analyze live Apache Avro.
-
Model HCL Domino Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and HCL Domino, enabling the direct import of real-time HCL Domino.
-
How to integrate Metabase with Google Cloud Storage Data
Use CData Connect AI to connect to live Google Cloud Storage and create an interactive dashboard in Metabase from Google Cloud Storage.
-
Automate Access Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Access from PowerShell? This article demonstrates how to utilize the Access Cmdlets for tasks like connecting to Microsoft Access, automating operations, downloading data, and more.
-
Create Informatica Mappings From/To an ODBC Data Source for MailerLite
Create an ODBC connection to MailerLite in Informatica and browse and transfer MailerLite.
-
Integrate Teradata Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Teradata from Informatica Cloud.
-
Use JayDeBeApi to access Sage 200 Data in Python
Use standard Python scripting and the development environment of your choice to access live Sage 200.
-
Google Calendar Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Calendar through CData Connect AI using different applications and tools.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Slack within intelligent workflows.
-
Back Up Twitter Ads to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Twitter Ads. In this article, we will employ an SSIS workflow to populate a database with Twitter Ads data.
-
Integrate Azure Table Data in the Pentaho Report Designer
Publish reports based on Azure Table Storage in the Pentaho BI tool.
-
Integrating OpenCode Terminal with LinkedIn 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.
-
Query Todoist Data in ColdFusion
Write standard ColdFusion data access code to connect to Todoist.
-
DataBind Charts to Shortcut Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Shortcut from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to Quickbase Data in ACL Analytics
Connect to Quickbase via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Quickbase.
-
Visualize Short.io Data in Sisense
Create an ElastiCube in Sisense app with access to Short.io.
-
Build Sage Cloud Accounting Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Sage Business Cloud Accounting and build visualizations in Tableau Cloud.
-
Establish a Live Connection with NASA Data using Tableau Bridge
The CData ODBC Driver for NASA enables you to integrate live NASA into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Todoist Data to Multiple Databases
Replicate Todoist to disparate databases with a point-and-click configuration.
-
Access Live JDBC-ODBC Bridge Data in AWS Lambda (with IntelliJ IDEA)
Connect to live JDBC-ODBC Bridge in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Dash to Build to Web Apps on Bitbucket Data
Create Python applications that use pandas and Dash to build Bitbucket-connected web apps.
-
Build HCL Domino-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live HCL Domino and build HCL Domino-connected web apps with Axios.
-
How to Work with Sentry Data in ETL Validator JDBC
Connect to Sentry from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect ServiceNow Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ServiceNow using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to create Visio diagrams from Dynamics 365 Business Central Data
Automatically update Dynamics 365 Business Central with the changes you make to Visio master shapes.
-
Build MVC Applications with Connectivity to SurveyMonkey Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SurveyMonkey from an ASP.NET MVC application.
-
How to connect to Office 365 Data with Squirrel SQL client
Connect to Microsoft Office 365 and execute queries in the Squirrel SQL Client.
-
DataBind Controls to Hugging Face Data in Delphi
DataBind to Hugging Face in Delphi with standard data access components and controls.
-
Getting Started with the CData ODBC Driver for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Amazon Athena.
-
Automated Continuous Klipfolio Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Klipfolio replication to Google BigQuery.
-
Visualize Live CapsuleCRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CapsuleCRM.
-
Build PayPal-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for PayPal to explore live PayPal Data in Cursor to assist with building PayPal-powered applications.
-
Create Data Visualizations Based On Dynamics CRM Data in Mode
Use CData Connect AI to connect to Dynamics CRM Data from Mode and build visualizations using live
-
Query Azure Synapse Data in DataGrip
Create a Data Source for Azure Synapse in DataGrip and use SQL to query live Azure Synapse.
-
Connect to Nuclia Data in RapidMiner
Integrate Nuclia with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate SharePoint Excel Services Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SharePoint Excel Services from Informatica Cloud.
-
How to create Short.io federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Short.io in MySQL .
-
How to connect Amazon QuickSight to Facebook Ads Data
Create a connection to Facebook Ads in CData Connect AI and insert Facebook Ads into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Anaplan Data in DBArtisan
Use wizards in DBArtisan to configure Anaplan as a data source.
-
Integrating Claude Code CLI with ConvertAPI 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 Zoom Replication to SQLite
Use CData Sync for automated, continuous, customizable Zoom replication to SQLite.
-
Automated Continuous Google Contacts Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Contacts replication to SQLite.
-
Create Apps from Azure DevOps Data in Qlik Sense Cloud
Use CData Connect AI to connect to Azure DevOps Data and build apps from live Azure DevOps in Qlik Sense Cloud.
-
Operational Reporting on Oracle Eloqua Reporting Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Eloqua Reporting.
-
Integrate with Nuclia Data in JReport Designer
Create charts and reports based on Nuclia in JReport Designer.
-
Connect to SAP BusinessObjects BI Data in HULFT Integrate
Connect to SAP BusinessObjects BI as a JDBC data source in HULFT Integrate
-
Getting Started with the CData ODBC Driver for Bannerbear
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Bannerbear.
-
Query SAP Ariba Procurement Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Ariba Procurement from Node.js.
-
How to create an RPA flow for Zoho Projects Data in UiPath Studio
Use the Zoho Projects ODBC Driver to create workflows that access real-time Zoho Projects without any coding.
-
Build MVC Applications with Connectivity to Keap Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Keap from an ASP.NET MVC application.
-
Import and Visualize Webex Data in Power View
Create data visualizations based on Webex in Excel.
-
How to integrate Metabase with PostgreSQL Data
Use CData Connect AI to connect to live PostgreSQL and create an interactive dashboard in Metabase from PostgreSQL.
-
Connect to Spark Data from AWS Glue
Use CData Connect AI to gain access to live Apache Spark SQL from your AWS Glue jobs.
-
Use the CData Software ODBC Driver for Oracle Sales in MicroStrategy
Connect to Oracle Sales in MicroStrategy Developer using the CData Software ODBC Driver for Oracle Sales.
-
Create BambooHR Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time BambooHR data access from reports, embedded analytics, and more.
-
Automated Continuous Box Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Box replication to IBM DB2.
-
Connect to Front Data from a Connection Pool in Jetty
The Front JDBC Driver supports connection pooling: This article shows how to connect faster to Front from Web apps in Jetty.
-
Trigger Google Calendar IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Calendar with standard wizards in Logic Apps.
-
Replicate Rebilly Data from PowerShell
Write a quick PowerShell script to query Rebilly. Use connectivity to the live data to replicate Rebilly to SQL Server.
-
Connect to Twilio Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Twilio as an External Source in Dremio.
-
Getting Started with the CData JDBC Driver for Google Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Ads.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Amazon Marketplace using the Model Context Protocol.
-
Automated Continuous Sendwithus Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sendwithus replication to Amazon Redshift.
-
Integrate Real-Time Access to DB2 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to IBM DB2 in real time.
-
Choosing the Best Method to Connect Clockify to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Clockify from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Apps from Tally Data in Qlik Sense Cloud
Use CData Connect AI to connect to Tally Data and build apps from live Tally ERP in Qlik Sense Cloud.
-
Automated Continuous Redis Replication to Databricks
Use CData Sync for automated, continuous, customizable Redis replication to Databricks.
-
Connect to CampaignMonitor Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to CampaignMonitor and work with CampaignMonitor in your FileMaker applications.
-
How to Work with Snapchat Ads Data in AWS Glue Jobs Using JDBC
Connect to Snapchat Ads from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to update Slack from Excel
This article explains how to transfer data from Excel to Slack using the Excel Add-In for Slack.