CData Software - Knowledge Base
Recent Articles
-
Integrate Live ClickUp Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ClickUp to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Salesforce Pardot Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Salesforce Pardot and integrate live Salesforce Pardot into your Power Automate tasks.
-
Visualize Mailgun Data in Sisense
Create an ElastiCube in Sisense app with access to Mailgun.
-
Automated Continuous Billsby Replication to SQL Server
Use CData Sync for automated, continuous, customizable Billsby replication to SQL Server.
-
Replicate ZarMoney Data to Multiple Databases via the CData Sync CLI
Replicate ZarMoney to disparate databases with a single configuration.
-
Manage Intercom Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Intercom.
-
How to Connect to Live Monday.com 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 Monday.com for you.
-
Automated Continuous Intercom Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Intercom replication to delimited files (CSV/TSV).
-
Integrate Printful with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Printful with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Printful.
-
Getting Started with the CData JDBC Driver for Amazon DynamoDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Amazon DynamoDB.
-
Use the CData API Server to Access Reckon Data in Microsoft PowerPivot
Use the CData API Server to connect to live Reckon in the Power Pivot business intelligence tool.
-
Connect to SQL Server from Asprova with CData Software ODBC Driver for SQL Server
This article shows how to connect faster to SQL Server data from Asprova.
-
How to work with Google Analytics Data in Apache Spark using SQL
Access and process Google Analytics Data in Apache Spark using the CData Software JDBC Driver.
-
How to Access Live PivotalTracker Data in Power Automate Desktop via ODBC
The CData ODBC Driver for PivotalTracker enables you to integrate PivotalTracker into workflows built using Microsoft Power Automate Desktop.
-
LINQ to Moosend 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 Moosend Data Provider.
-
Use Databricks Agent Bricks to Talk to Your SAP HANA Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP HANA for you.
-
Deploy the ADO.NET Provider for Salesforce CRM Analytics on an SSRS Report Server
Connect to Salesforce CRM Analytics 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.
-
Connect to Act-On in SpagoBI
Create reports featuring live Act-On in SpagoBI Studio. Host Act-On reports on SpagoBI Server.
-
How to load LinkedIn Ads data into Elasticsearch via Logstash
Introducing a simple method to load LinkedIn Ads data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query Drip Data in ColdFusion
Write standard ColdFusion data access code to connect to Drip.
-
Work with Live Databricks Data in Power Query
Use CData Connect AI to connect to Databricks and work with live Databricks in Microsoft Power Query.
-
How to Access Salesforce Data Using Entity Framework
This article shows how to access Salesforce & Force.com using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate Multiple PostgreSQL Accounts via the CData Sync CLI
Replicate multiple PostgreSQL accounts to one or many databases.
-
Feed SAP Business One Data into FineReport
How to set SAP Business One as a JDBC data source in FineReport.
-
How to Seamlessly Import Autopilot Data into IBM SPSS Modeler
Integrate Autopilot data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import Real-Time MYOB AccountRight Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MYOB AccountRight in ColdFusion.
-
Build Semantic Layer Views for Databricks Data in APOS Live Data Gateway
Use the CData Connector for Databricks in APOS Live Data Gateway to build Semantic Layer Views for Databricks.
-
Build MVC Applications with Connectivity to Sage Cloud Accounting Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sage Cloud Accounting from an ASP.NET MVC application.
-
Integrating LangGraph with Splunk Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Splunk within automated workflows.
-
Create a Data Access Object for Datadog Data using JDBI
A brief overview of creating a SQL Object API for Datadog in JDBI.
-
Migrating data from Oracle SCM to Snowflake using CData SSIS Components.
Easily push Oracle SCM to Snowflake using the CData SSIS Tasks for Oracle SCM and Snowflake.
-
ETL Highrise in Oracle Data Integrator
This article shows how to transfer Highrise CRM into a data warehouse using Oracle Data Integrator.
-
Replicate SAP Concur Data in Heroku for Use in Salesforce Connect
Replicate SAP Concur to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Using the CData Software ODBC Driver for Tickspot in PyCharm
Connect to Tickspot as an ODBC data source in PyCharm using the CData Software ODBC Driver for Tickspot.
-
How to Create Power BI Visual Reports with Real-Time Contentful Data
Use CData Power BI Connectors to visualize Contentful in Power BI.
-
Getting Started with the CData Excel Add-In for SAP SuccessFactors
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP SuccessFactors.
-
Use Biml to Build SSIS Tasks to Replicate Highrise Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Highrise CRM to SQL Server.
-
Add Bullhorn CRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Bullhorn CRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Codex CLI with Gumroad 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.
-
Feed Typeform Data into FineReport
How to set Typeform as a JDBC data source in FineReport.
-
Automated Continuous Codat Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Codat replication to Google BigQuery.
-
How to Work with Slack Data in ETL Validator JDBC
Connect to Slack from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Reckon Accounts Hosted from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Reckon Accounts Hosted, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to connect to Mouseflow Data in DBVisualizer
Integrate Mouseflow with visual data analysis tools and data connection wizards in DBVisualizer
-
Manage SAP ByDesign Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP ByDesign.
-
Integrating OpenCode Terminal with Salesforce Data 360 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.
-
Use the CData ODBC Driver for Delighted in Microsoft Power Query
You can use the CData Delighted ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Delighted into Microsoft Power Query.
-
Query Coda Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Coda from Node.js.
-
Build Semantic Layer Views for Spotify Data in APOS Live Data Gateway
Use the CData Connector for Spotify in APOS Live Data Gateway to build Semantic Layer Views for Spotify.
-
Automate SAP HANA Data Replication to SAP HANA
Use CData Sync to customize and automate SAP HANA replication to SAP HANA.
-
Connect to MailerSend Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for MailerSend and the SQL Gateway to access MailerSend from Google Apps Script.
-
Build Data Flows from ZarMoney to SQL Server using SSIS
Easily back up ZarMoney to SQL Server using the SSIS components for ZarMoney.
-
Connect to Typeform Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Replicate SageHR Data in Heroku for Use in Salesforce Connect
Replicate SageHR to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Visualizations of SQL Server Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft SQL Server in Birst.
-
Build Data Flows from Discourse to SQL Server using SSIS
Easily back up Discourse to SQL Server using the SSIS components for Discourse.
-
Explore Geographical Relationships in Azure Data Catalog Data with Power Map
Create data visualizations with Azure Data Catalog in Power Map.
-
Create SSAS Tabular Models from Aweber Data
How to build a SQL Server Analysis Service Tabular Model from Aweber using CData drivers.
-
Build Google Ad Manager-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Ad Manager Data and create custom apps in Mendix.
-
Connect to Microsoft Planner Data in CloverDX (formerly CloverETL)
Transfer Microsoft Planner using the visual workflow in the CloverDX data integration tool.
-
Validate BigCommerce Data with QuerySurge
Access and validate BigCommerce in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Dotmailer Replication to SQL Server
Use CData Sync for automated, continuous, customizable Dotmailer replication to SQL Server.
-
Automate Hubstaff Data Replication to Azure Synapse
Use CData Sync to customize and automate Hubstaff replication to Azure Synapse.
-
Query Invoiced Data in DataGrip
Create a Data Source for Invoiced in DataGrip and use SQL to query live Invoiced.
-
Deploy the ADO.NET Provider for SAP BusinessObjects BI on an SSRS Report Server
Connect to SAP BusinessObjects BI 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.
-
Connect to Google Campaign Manager 360 Data in Aqua Data Studio
Access Google Campaign Manager 360 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live WordPress 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 WordPress for you.
-
Connect to NASA Data from a Connection Pool in JBoss
Integrate NASA into Java servlets: Use the Management Console in JBoss to install the NASA JDBC Driver.
-
Model Zuora Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zuora, enabling the direct import of real-time Zuora.
-
Configure the CData JDBC Driver for SAP Ariba Procurement in a Connection Pool in Tomcat
Connect to SAP Ariba Procurement from a connection pool in Tomcat.
-
Connect ConvertAPI to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ConvertAPI with IBM WebSphere for seamless data integration and connectivity.
-
Connect to ConvertKit Data in DBArtisan
Use wizards in DBArtisan to configure ConvertKit as a data source.
-
How to create Access federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Access in MySQL .
-
How to load Salesforce Data 360 data into Elasticsearch via Logstash
Introducing a simple method to load Salesforce Data 360 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build MVC Applications with Connectivity to GetResponse Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access GetResponse from an ASP.NET MVC application.
-
Automated Continuous Clockify Replication to MongoDB
Use CData Sync for automated, continuous, customizable Clockify replication to MongoDB.
-
DataBind Charts to DB2 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to IBM DB2 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.
-
Access ElevenLabs Data from MySQL in PHP
Connect to ElevenLabs through the standard MySQL libraries in PHP.
-
How to Visualize Microsoft Ads Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Ads in Python.
-
Create Dashboards and Visualize Live Redshift Data in Geckoboard
Use CData Connect AI to connect to live Amazon Redshift and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous ActiveCampaign Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to delimited files (CSV/TSV).
-
Build Retently-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Retently.
-
Feed Cassandra Data into FineReport
How to set Apache Cassandra as a JDBC data source in FineReport.
-
Integrating Codex CLI with Testmonitor 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.
-
Use Claude to Talk to Your Sugar CRM 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 Sugar CRM for you.
-
Integrating Boomi Agentstudio with OData Services via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to OData, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Import HubSpot Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to HubSpot Data and provide access to live HubSpot for custom reports in the Power BI Service.
-
Analyze Twitter Ads Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Twitter Ads and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Grafana-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Grafana and build web apps with connectivity to live Grafana.
-
Access Spark Data from MySQL in PHP
Connect to Spark through the standard MySQL libraries in PHP.
-
Analyze Gorgias Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Gorgias from Power Pivot. You will use the Table Import Wizard to load Gorgias. You can visually build the import query or use any SQL supported by the driver.
-
How to connect and process Sugar CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sugar CRM.
-
How to connect and process Amazon Athena from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Amazon Athena.
-
Build SAP HANA-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP HANA.
-
Integrating Codex CLI with Microsoft SQL Server 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.
-
Integrating Antigravity CLI with IBM Informix via CData CLI
Connect IBM Informix to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Apps with Live XML Data Using the Low-Code Development Platform of Mendix
Connect XML Files with Mendix to build apps using the CData JDBC Driver for XML.
-
Model Sage Intacct Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Sage Intacct, enabling the direct import of real-time Sage Intacct.
-
Add Facebook Ads Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Facebook Ads with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle Eloqua Reporting
Provide connectivity to Oracle Eloqua Reporting through an SAP BusinessObjects universe.