CData Software - Knowledge Base
Recent Articles
-
How to update Salesforce Marketing from Excel
This article explains how to transfer data from Excel to Salesforce Marketing using the Excel Add-In for Salesforce Marketing.
-
Create Quaderno Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Quaderno data access from reports, embedded analytics, and more.
-
Easily Integrate Tickspot Data in Lazarus Pascal IDE
Learn how to easily integrate live Tickspot data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Process & Analyze Microsoft Teams Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Microsoft Teams Data.
-
Automated Continuous Hive Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Hive replication to AlloyDB.
-
Analyze Pingdom Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Pingdom data in Microsoft R Open.
-
Build Apps with Live Printify data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Printify data into the Adalo platform and build custom mobile and web applications with real-time Printify data.
-
Analyze Timely Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Timely data with the CData JDBC Driver for Timely.
-
Choosing the Best Method to Connect LinkedIn Ads to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LinkedIn Ads data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Analyze OData Services in Looker
Use CData Connect AI to connect to OData Services from Looker and build custom apps using live OData services.
-
Build a Singer.io Tap for CSV With the CData Python Connector
Learn how to easily build a Singer.io Tap for live CSV data using the CData Python Connector.
-
How to Connect to Live Twilio 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 Twilio data without replication.
-
Using the CData Software ODBC Driver for Coinbase in PyCharm
Connect to Coinbase as an ODBC data source in PyCharm using the CData Software ODBC Driver for Coinbase.
-
Integrating Codex with Autopilot 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, Visualize, and Share live Shortcut Data in Redash
Use CData Connect AI to connect to live Shortcut data in Redash for querying, visualizing, and sharing.
-
Build Visualizations of Procore Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Procore data in Birst.
-
Replicate Supabase Data from PowerShell
Write a quick PowerShell script to query Supabase data. Use connectivity to the live data to replicate Supabase data to SQL Server.
-
How to Work with AfterShip Data in AWS Glue Jobs Using JDBC
Connect to AfterShip from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous OnePageCrm Replication to SingleStore
Use CData Sync for automated, continuous, customizable OnePageCrm replication to SingleStore.
-
Use the CData Software ODBC Driver for SageHR in MicroStrategy Desktop
Connect to SageHR data in MicroStrategy Desktop using the CData Software ODBC Driver for SageHR.
-
Integrate Todoist Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Todoist data from Informatica Cloud.
-
Import and Visualize Zoom Data in Power View
Create data visualizations based on Zoom data in Excel.
-
Use the CData Software JDBC Driver for Chargebee in MicroStrategy Desktop
Connect to Chargebee data in MicroStrategy Desktop using the CData Software JDBC Driver for Chargebee.
-
Automated Continuous Microsoft Exchange Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to SingleStore.
-
Operational Reporting on SparkPost Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SparkPost data.
-
Back Up Act CRM data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Act CRM. In this article, we will employ an SSIS workflow to populate a database with Act CRM data data.
-
Deploy the ADO.NET Provider for Placid on an SSRS Report Server
Connect to Placid data 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.
-
Automated Continuous Vercel Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Vercel replication to Azure SQL Database.
-
Build DB2-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live DB2 data without replication.
-
How to Connect to Live Acumatica Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Acumatica data through natural language.
-
Automate PDFMonkey Data Replication to Couchbase
Use CData Sync to Customize and automate PDFMonkey data replication to Couchbase.
-
Analyze Clockify Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Clockify from Power Pivot. You will use the Table Import Wizard to load Clockify data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Quaderno Data in NetBeans
Connect to Quaderno data in NetBeans with the data source configuration wizard.
-
Replicate Zoom Data from PowerShell
Write a quick PowerShell script to query Zoom data. Use connectivity to the live data to replicate Zoom data to SQL Server.
-
Build Apps with Live Browserless Data Using the Low-Code Development Platform of Mendix
Connect Browserless data with Mendix to build apps using the CData API Driver for JDBC.
-
Analyze ZohoInvoice Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ZohoInvoice from Power Pivot. You will use the Table Import Wizard to load ZohoInvoice data. You can visually build the import query or use any SQL supported by the driver.
-
Import Google Search Results into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Search Results and provide access to live Google Search results for custom reports in the Power BI Service.
-
Connect to Productboard Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Productboard data using standard SQL.
-
Analyze Live Jira Assets Data in SAS Viya
Use CData Connect AI to connect to Jira Assets data from SAS Viya and deploy self-service analytics using live Jira Assets data.
-
Build Blackbaud FE NXT-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Blackbaud FE NXT Data and create custom apps in Mendix.
-
Feed Google Calendar Data into FineReport
How to set Google Calendar data as a JDBC data source in FineReport.
-
Automated Continuous MessageBird Replication to Vertica
Use CData Sync for automated, continuous, customizable MessageBird replication to Vertica.
-
How to Connect to & Open PhantomBuster Data in Microsoft Excel
This article uses the CData ODBC driver for PhantomBuster to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Data Flows from RabbitMQ to SQL Server using SSIS
Easily back up RabbitMQ data to SQL Server using the SSIS components for RabbitMQ.
-
Connect ClickUp to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ClickUp data using the CData Python MCP Server.
-
Replicate Multiple Deel Accounts via the CData Sync CLI
Replicate multiple Deel accounts to one or many databases.
-
Import and Visualize Google Forms Data in Power View
Create data visualizations based on Google Forms data in Excel.
-
Replicate Twilio Data to Multiple Databases via the CData Sync CLI
Replicate Twilio data to disparate databases with a single configuration.
-
Use Microsoft Copilot Studio to talk to your QuickBooks Time 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 QuickBooks Time data for you.
-
Connect to Real-Time Airtable Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Airtable and Dataflow to import and use Airtable data in Power Apps.
-
How to Connect to Live Anaplan Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Anaplan data for you.
-
Connect to Apify Data from Crystal Reports
Use CData Connect AI to connect to and report on live Apify data from Crystal Reports.
-
How to load Bugsnag data into Elasticsearch via Logstash
Introducing a simple method to load Bugsnag data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect to FTP Data in DBVisualizer
Integrate FTP data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Query MarkLogic Data in MySQL Workbench
Execute MySQL queries against live MarkLogic data from MySQL Workbench.
-
Connect to xBase Data in Jaspersoft Studio
Execute SQL to remote xBase data in Jaspersoft Studio.
-
Automated Continuous Notion Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Notion replication to Azure SQL Database.
-
How to use SQLAlchemy ORM to access Mistral AI Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mistral AI data.
-
Query Oracle Eloqua Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle Eloqua data from Node.js.
-
Build Automated Kafka-Connected Workflows in Zapier
Use CData Connect AI to connect to live Kafka data and build automated workflows in Zapier.
-
Analyze Salesforce Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Import Shopify Data Using Azure Data Factory
Use CData Connect AI to connect to Shopify Data from Azure Data Factory and import live Shopify data.
-
ClickUp Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ClickUp facts in real time.
-
Automate Microsoft Exchange Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Exchange data replication to Azure Synapse.
-
Automated Continuous Discord Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Discord replication to Amazon Redshift.
-
Use Biml to Build SSIS Tasks to Replicate Excel Online Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Excel Online data to SQL Server.
-
Analyze Attio Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Attio from Power Pivot. You will use the Table Import Wizard to load Attio data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Live Cvent Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Cvent data to Blue Prism using the CData ODBC Driver for Cvent to create automated workflows for repetitive business tasks.
-
Use Biml to Build SSIS Tasks to Replicate Splunk Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Splunk data to SQL Server.
-
Create Datasets from SAP SuccessFactors LMS in Domo Workbench and Build Visualizations of SAP SuccessFactors LMS Data in Domo
Use the CData Software ODBC Driver for SAP SuccessFactors LMS to create datasets from SAP SuccessFactors LMS data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Facebook Ads Data from Spring Boot
Connect to Facebook Ads in a Spring Boot Application using the CData JDBC Driver for Facebook Ads
-
Query Live Google Drive 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 Google Drive data directly from the development environment.
-
Access Live Google Analytics Data in Coginiti Pro
Connect to and query live Google Analytics data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Choosing the Best Method to Connect Front to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Front data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Informatica Mappings From/To a JDBC Data Source for Suadeo
Create Suadeo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Import MongoDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MongoDB Data and provide access to live MongoDB data for custom reports in the Power BI Service.
-
How to connect to Testmonitor Data from Spring Boot
Connect to Testmonitor in a Spring Boot Application using the CData API Driver for JDBC
-
Choosing the Best Method to Connect Twitter Ads to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Twitter Ads data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous JobNimbus Replication to Vertica
Use CData Sync for automated, continuous, customizable JobNimbus replication to Vertica.
-
How to Connect to Live Square Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Square data for you.
-
Visualize Billsby Data in Sisense
Create an ElastiCube in Sisense app with access to Billsby data.
-
Connect to PingOne Data from PowerBuilder via JDBC
This article demonstrates how to access PingOne data from PowerBuilder using the PingOne JDBC Driver.
-
Connecting Mastra with Salesforce CRM Analytics 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 Salesforce CRM Analytics data, no replication required.
-
Connect to and Visualize Live Harvest Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Harvest data.
-
Visualize Live Contentful Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Contentful data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Model Perplexity Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Perplexity, enabling the direct import of real-time Perplexity data.
-
Building Dynamic Web Pages with CockroachDB Data Using AngularJS
Create single-page applications with live connectivity to CockroachDB using the CData API Server.
-
Integrate Real-Time Access to RSS in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to RSS feeds in real time.
-
Integrating Kiro with Zendesk 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 create an RPA flow for SAP HANA XS Advanced Data in UiPath Studio
Use the SAP HANA XS Advanced ODBC Driver to create workflows that access real-time SAP HANA XS Advanced data without any coding.
-
Integrate Live Samanage Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Samanage data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Visualizations of PingOne Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PingOne data in Birst.
-
Connect Simplesat to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Simplesat data using the CData Python MCP Server.
-
Integrating LlamaIndex with PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on PingOne data in real time.
-
Analyze Freshdesk Data in Looker
Use CData Connect AI to connect to Freshdesk Data from Looker and build custom apps using live Freshdesk data.
-
Integrate Elorus with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Elorus with External Services.
-
Integrating GitHub Copilot with Browserless 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 Pushbullet Replication to Databricks
Use CData Sync for automated, continuous, customizable Pushbullet replication to Databricks.
-
Explore Geographical Relationships in ZohoMarketingHub Data with Power Map
Create data visualizations with ZohoMarketingHub data in Power Map.
-
Process & Analyze Everhour Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Everhour Data.