CData Software - Knowledge Base
Recent Articles
-
Build Automated MongoDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live MongoDB and build automated workflows in Zapier.
-
How to integrate SendPulse with Apache Airflow
Access and process SendPulse in Apache Airflow using the CData JDBC Driver.
-
How to create Dynamics CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Dynamics CRM in MySQL .
-
Import Dynamics CRM Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Dynamics CRM. In this article, you will use the OData format to import Microsoft Dynamics CRM into Microsoft Power Query.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Calendly
Provide connectivity to Calendly through an SAP BusinessObjects universe.
-
How to create Hacker News federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Hacker News in MySQL .
-
How to Connect SAP Hybris C4C Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SAP Hybris C4C data in real time using natural language.
-
How to connect to Twitter Ads Data from Spring Boot
Connect to Twitter Ads in a Spring Boot Application using the CData JDBC Driver for Twitter Ads
-
Building Dynamic Web Pages with Google Calendar Data Using AngularJS
Create single-page applications with live connectivity to Google Calendar using the CData API Server.
-
Use Biml to Build SSIS Tasks to Replicate Google Drive Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Drive to SQL Server.
-
Automate Jodoo Data Replication to SAP HANA
Use CData Sync to customize and automate Jodoo replication to SAP HANA.
-
Publish Reports with ZeroBounce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZeroBounce.
-
Visualize Pinterest Data in Tableau
The CData ODBC driver for Pinterest enables you integrate Pinterest into Tableau dashboards.
-
Model SingleStore Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SingleStore, enabling the direct import of real-time SingleStore.
-
Import Klaviyo Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Klaviyo. In this article, you will use the OData format to import Klaviyo into Microsoft Power Query.
-
Connect to Reply.io Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to PostgreSQL Data in Jaspersoft Studio
Execute SQL to remote PostgreSQL in Jaspersoft Studio.
-
Choosing the Best Method to Connect Shortcut to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Shortcut from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Live Excel Online Data in MicroStrategy through CData Connect AI
Create a live connection to Excel Online Data in CData Connect AI and connect to your Microsoft Excel Online from MicroStrategy.
-
How to Build an ETL App for SAP SuccessFactors LMS Data in Python with CData
Create ETL applications and real-time data pipelines for SAP SuccessFactors LMS in Python with petl.
-
Integrate with Browserless Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Browserless to a JSON file on disk.
-
Back Up FTP Servers to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for FTP. In this article, we will employ an SSIS workflow to populate a database with FTP Servers data.
-
Connecting Mastra with Vault CRM 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 Veeva Vault & Vault CRM, no replication required.
-
Automated Continuous Azure Blob Storage Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Google Cloud SQL.
-
Connect to Instagram Data in Jaspersoft Studio
Execute SQL to remote Instagram in Jaspersoft Studio.
-
Query Live Hive Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Apache Hive directly from the development environment.
-
Use ChatGPT to Talk to Your CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Apache CouchDB for you.
-
Integrating Kiro CLI with Dynamics CRM 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Rootly
Create Rootly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating Kiro CLI with Aweber 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 publish and share eBay Analytics Data dashboards with Tableau Server
The CData ODBC driver for eBay Analytics enables you integrate eBay Analytics into Tableau dashboards.
-
Build Apps with Live SAP SuccessFactors LMS in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors LMS into the Adalo platform and build custom mobile and web applications with real-time SAP SuccessFactors LMS.
-
How to Connect DBeaver to EmailOctopus via a JDBC Driver
Manage EmailOctopus with visual tools in DBeaver like the query browser.
-
Create Samanage Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Samanage from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData ADO.NET Provider for BenchmarkEmail
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Migrating data from Perigon to Databricks using CData SSIS Components.
Easily push Perigon to Databricks using the CData SSIS Tasks for Perigon and Databricks.
-
Connect to Sybase IQ from a Connection Pool in WebLogic
Use the CData JDBC Driver for Sybase IQ to connect to Sybase IQ from Web applications running on WebLogic.
-
Use Biml to Build SSIS Tasks to Replicate SAS Data Sets Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAS Data Sets to SQL Server.
-
Use Agno to Talk to Your FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your FTP Servers for you.
-
Query Salesloft Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Salesloft from Node.js.
-
Automated Continuous Kintone Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Kintone replication to Google BigQuery.
-
Automate SendInBlue Data Replication to Azure Synapse
Use CData Sync to customize and automate SendInBlue replication to Azure Synapse.
-
Integrate Goose with Live Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Oracle Eloqua from within the local AI agent.
-
How to Design YouTube Analytics Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to YouTube Analytics from mobile and tablet Power Apps.
-
How to Easily Query Oracle Sales Data in OpenOffice Base
Connect to Oracle Sales data in OpenOffice Base using the CData ODBC Driver for Oracle Sales and generate reports with live data insights.
-
Connect to BigCommerce Data in Aqua Data Studio
Access BigCommerce from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize ConvertKit Data in TIBCO Spotfire through ADO.NET
Integrate ConvertKit into dashboards in TIBCO Spotfire.
-
How to Connect to Live Sybase IQ Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Sybase IQ securely in real time.
-
Design BIRT Reports on ServiceDesk Plus Data
Provide current ServiceDesk Plus to your embedded analytics.
-
Access Live Oracle Financials Cloud Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle Financials Cloud in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to SingleStore Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SingleStore.
-
Rapidly Develop JobNimbus-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 JobNimbus.
-
Perform Batch Operations with Reckon Accounts Hosted Data in Apache NiFi
Connect to Reckon Accounts Hosted and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Visualize SAP Ariba Source Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Ariba Source.
-
Query Redshift Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Redshift entities in PHP by modeling them as objects.
-
Create Dynamics 365 Business Central-Connected Applications in Appsmith
Connect to Dynamics 365 Business Central Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Dynamics 365 Business Central.
-
Use Claude to Talk to Your Certinia 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 Certinia for you.
-
Connect to Simplesat Data in JRuby
Create a simple JRuby app with access to live Simplesat.
-
Connect to Oracle Financials Cloud Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle Financials Cloud as an External Source in Dremio.
-
Validate IBM Cloud Object Storage Data with QuerySurge
Access and validate IBM Cloud Object Storage in QuerySurge using the CData JDBC Driver.
-
Build Data Flows from SQL Server to Google Campaign Manager 360 through SSIS
Easily push SQL Server data to Google Campaign Manager 360 using the CData SSIS Tasks for Google Campaign Manager 360.
-
How to connect to Greenhouse Data from Spring Boot
Connect to Greenhouse in a Spring Boot Application using the CData JDBC Driver for Greenhouse
-
DataBind Controls to HubSpot Data in Delphi
DataBind to HubSpot in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Paylocity in MicroStrategy
Connect to Paylocity in MicroStrategy Developer using the CData Software ODBC Driver for Paylocity.
-
Connect to SAS xpt Data from HeidiSQL
Use CData Connect AI to connect to and query live SAS XPORT from HeidiSQL.
-
Natively Connect to Greenhouse Data in PHP
The CData ODBC driver for Greenhouse enables you to create PHP applications with connectivity to Greenhouse. Leverage the native support for ODBC in PHP.
-
How to Visualize Customer.io Data in Python with pandas
Use pandas and other modules to analyze and visualize live Customer.io in Python.
-
Extend Google Sheets with Spark Data
Make calls to Spark from Google Apps Script via the API Server.
-
Replicate Teradata Data from PowerShell
Write a quick PowerShell script to query Teradata. Use connectivity to the live data to replicate Teradata to SQL Server.
-
Manage Humanity Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Humanity.
-
How to Connect to & Open Facebook Data in Microsoft Excel
This article uses the CData ODBC driver for Facebook to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Data Visualizations in Cognos BI with Templated Data
Access Templated as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for Scrapfly in MicroStrategy Desktop
Connect to Scrapfly in MicroStrategy Desktop using the CData Software JDBC Driver for Scrapfly.
-
Use the CData ODBC Driver for HelloSign from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HelloSign to connect to HelloSign from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HelloSign in Excel.
-
Access Live Optimizely Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Optimizely in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Google Contacts Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Contacts from Node.js.
-
Import Sybase IQ Data Using Azure Data Factory
Use CData Connect AI to connect to Sybase IQ Data from Azure Data Factory and import live Sybase IQ.
-
Connecting Agentforce with BigQuery Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Google BigQuery for you.
-
Build Dashboards with NASA Data in Dundas BI
Create dynamic dashboards and perform analytics based on NASA in Dundas BI.
-
Connect to Microsoft Exchange Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Exchange.
-
Getting Started with the CData ODBC Driver for SharePoint Excel Services
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SharePoint Excel Services.
-
DataBind AdRoll Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide AdRoll to a chart.
-
Build Apps with Live Azure Table Storage in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure Table Storage into the Adalo platform and build custom mobile and web applications with real-time Azure Table Storage.
-
DataBind Controls to Office 365 Data in C++Builder
DataBind to Microsoft Office 365 in C++Builder with standard components and controls.
-
Connect to ElevenLabs Data in DBArtisan
Use wizards in DBArtisan to configure ElevenLabs as a data source.
-
Model Smartsheet Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Smartsheet, enabling the direct import of real-time Smartsheet.
-
Automated Continuous MariaDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable MariaDB replication to SingleStore.
-
Access Paylocity Data from MySQL in PHP
Connect to Paylocity through the standard MySQL libraries in PHP.
-
Automated Continuous Clio Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Clio replication to Azure SQL Database.
-
Access Planio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Planio from HeidiSQL.
-
Visualize Live TigerGraph Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live TigerGraph using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Using the CData Software ODBC Driver for Zoho Books in PyCharm
Connect to Zoho Books as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zoho Books.
-
Create Datasets from Clockify in Domo Workbench and Build Visualizations of Clockify Data in Domo
Use the CData Software ODBC Driver for Clockify to create datasets from Clockify in Domo Workbench and then build visualizations in the Domo service.
-
Process & Analyze Placid Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Placid Data.
-
Connect to Google Ads Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Ads.
-
How to Create Power BI Visual Reports with Real-Time SparkPost Data
Use CData Power BI Connectors to visualize SparkPost in Power BI.
-
Automated Continuous GitHub Replication to MySQL
Use CData Sync for automated, continuous, customizable GitHub replication to MySQL.
-
How to Connect Microsoft Exchange Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Microsoft Exchange data in real time using natural language.
-
Connect to SAP Hybris C4C from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Hybris C4C to connect to SAP Hybris C4C from Web applications running on WebLogic.
-
Feed Dynamics CRM Data into FineReport
How to set Microsoft Dynamics CRM as a JDBC data source in FineReport.