CData Software - Knowledge Base
Recent Articles
-
Visualize Live OneNote Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft OneNote into custom reports in Power BI.
-
Create Power BI Reports on Real-Time Greenplum Data
Use the CData ODBC Driver for Greenplum to visualize Pivotal GreenPlum in Power BI Desktop.
-
Integrating Kiro CLI with SAP Concur 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 Blackbaud FE NXT Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Google BigQuery.
-
Replicate Multiple Salesforce Accounts
Replicate multiple Salesforce accounts to one or many databases.
-
Build AI/ML Models with Live Onfleet Data using Dataiku
Connect Onfleet Data with Dataiku using the CData API Driver for JDBC.
-
How to Connect to Salesloft Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Salesloft. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData Tableau Connector for Autopilot
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate Multiple ClickTime Accounts via the CData Sync CLI
Replicate multiple ClickTime accounts to one or many databases.
-
Build Power BI XMLA-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Power BI XMLA Data and create custom apps in Bubble.
-
Use the CData Software JDBC Driver for Zuora in MicroStrategy
Connect to Zuora in MicroStrategy Developer using the CData Software JDBC Driver for Zuora.
-
Automated Continuous Amazon DynamoDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Snowflake.
-
Integrating Antigravity CLI with Hacker News via CData CLI
Connect Hacker News to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build MVC Applications with Connectivity to CockroachDB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CockroachDB from an ASP.NET MVC application.
-
Use the CData Software JDBC Driver for Gong in MicroStrategy Desktop
Connect to Gong in MicroStrategy Desktop using the CData Software JDBC Driver for Gong.
-
How to Build an ETL App for Marketo Data in Python with CData Connect AI
Build ETL pipelines that read and write live Marketo in Python with petl and the CData Connect AI Python SDK.
-
Viewing ZohoInvoice Data in RAD Studio Data Explorer
How to view ZohoInvoice in RAD Studio Data Explorer using the CData ODBC Driver for ZohoInvoice.
-
Create Dashboards and Visualize Live Cosmos DB Data in Geckoboard
Use CData Connect AI to connect to live Azure Cosmos DB and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to connect SharePoint with Salesloft Data through external lists
Provide Salesloft to SharePoint users as an external list.
-
How to Import Data from Teradata into Google Sheets
Import Teradata into a Google spreadsheet that is automatically refreshed.
-
Bind Live GitHub Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live GitHub data
-
Connect to ChargeOver Data from PowerBuilder via JDBC
This article demonstrates how to access ChargeOver from PowerBuilder using the ChargeOver JDBC Driver.
-
Integrate Live Copper Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Copper to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize Live EnterpriseDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live EnterpriseDB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create FHIR-Connected Dashboards in Grafana
Connect to FHIR Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to FHIR.
-
Natively Connect to Perigon Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Perigon. Leverage the native support for ODBC in PHP.
-
Build Microsoft Ads-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Ads and build web apps with connectivity to live Microsoft Ads.
-
Build Google Spanner-Connected Apps in Choreo
Use CData Connect AI to connect to Google Spanner Data from Choreo and build custom apps using live Google Spanner.
-
Automated Continuous Google Contacts Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Contacts replication to Oracle.
-
Visualize Sage Intacct Data in Tableau
The CData ODBC driver for Sage Intacct enables you integrate Sage Intacct into Tableau dashboards.
-
Visualize Live Nethunt Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Nethunt using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Google Forms Data in the Pentaho Report Designer
Publish reports based on Google Forms in the Pentaho BI tool.
-
Validate FormSite Data with QuerySurge
Access and validate FormSite in QuerySurge using the CData JDBC Driver.
-
Automate eBay Analytics Data Replication to Azure Synapse
Use CData Sync to customize and automate eBay Analytics replication to Azure Synapse.
-
Connect to PolarTeamPro Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Back Up ActiveCampaign to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for ActiveCampaign. In this article, we will employ an SSIS workflow to populate a database with ActiveCampaign data.
-
Automated Aweber Data Replication to Teradata
Use CData Sync to Customize and automate Aweber replication to Teradata.
-
Extract, Transform, and Load ShipStation Data in Informatica PowerCenter
Create a simple Workflow for ShipStation in Informatica PowerCenter.
-
Visualize Cloudant Data in Tableau
The CData ODBC driver for Cloudant enables you integrate IBM Cloudant into Tableau dashboards.
-
Getting Started with the CData Python Connector for Vercel
Learn to install and license the CData Python Connector
-
Connect to Timely Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build MVC Applications with Connectivity to Spotify Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Spotify from an ASP.NET MVC application.
-
Use Microsoft Copilot Studio to talk to your Pipedrive 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 Pipedrive for you.
-
Access Live Email Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Email through MCP integration.
-
Perform Batch Operations with OneNote Data in Apache NiFi
Connect to Microsoft OneNote and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Operational Reporting on Vault CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Veeva Vault & Vault CRM.
-
Choosing the Best Method to Connect MailerLite to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MailerLite from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Kiro CLI with NASA 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 Pingdom Data in UiPath Studio
Use the Pingdom ODBC Driver to create workflows that access real-time Pingdom without any coding.
-
Build a Simple VCL Application for BigQuery Data
How to build a simple VCL Application to view Google BigQuery in RAD Studio using the CData ODBC Driver for BigQuery.
-
Connect to Salesforce CRM Analytics Data in RapidMiner
Integrate Salesforce CRM Analytics with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live SAP BusinessObjects BI Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP BusinessObjects BI in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Easily Query PolarTeamPro Data in OpenOffice Base
Connect to PolarTeamPro data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous LinkedIn Replication to AlloyDB
Use CData Sync for automated, continuous, customizable LinkedIn replication to AlloyDB.
-
Feed ChargeOver Data into FineReport
How to set ChargeOver as a JDBC data source in FineReport.
-
Integrate LibreChat with Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live BambooHR from within the chat interface.
-
Extract, Transform, and Load FTP Data in Informatica PowerCenter
Create a simple Workflow for FTP Servers in Informatica PowerCenter.
-
Analyze Impala Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Apache Impala and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Couchbase Replication to Databricks
Use CData Sync for automated, continuous, customizable Couchbase replication to Databricks.
-
Analyze PagerDuty Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PagerDuty in Microsoft R Open.
-
Query Adobe Analytics Data in DataGrip
Create a Data Source for Adobe Analytics in DataGrip and use SQL to query live Adobe Analytics.
-
Visualize Teamgate Data in TIBCO Spotfire through ADO.NET
Integrate Teamgate into dashboards in TIBCO Spotfire.
-
Use Biml to Build SSIS Tasks to Replicate Vercel Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Vercel to SQL Server.
-
Connect to Samanage from a Connection Pool in WebLogic
Use the CData JDBC Driver for Samanage to connect to Samanage from Web applications running on WebLogic.
-
Replicate Azure Table Data from PowerShell
Write a quick PowerShell script to query Azure Table Storage. Use connectivity to the live data to replicate Azure Table Storage to SQL Server.
-
Connect to Google Forms Data in Ruby
Connect to Google Forms in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SQL Analysis Services
Provide connectivity to SQL Analysis Services through an SAP BusinessObjects universe.
-
REST Reporting in OBIEE with the REST JDBC Driver
Deploy the REST JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Aircall Data as a MySQL Database in Node.js
Execute MySQL queries against Aircall from Node.js.
-
Integrate Live Twitter Ads Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create Data Visualizations Based On SAS xpt Data in Mode
Use CData Connect AI to connect to SAS xpt Data from Mode and build visualizations using live
-
Import eBay Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to eBay Data and provide access to live eBay for custom reports in the Power BI Service.
-
Analyze Twitter Ads Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Twitter Ads and visualize live Twitter Ads in Infragistics Reveal.
-
Integrate Cursor with Live API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live API from within the editor.
-
Connect to Salesloft Data from PowerBuilder via ADO.NET
This article demonstrates how to access Salesloft from Appeon PowerBuilder using the CData ADO.NET Provider for Salesloft.
-
Automated SAP Ariba Source Data Replication to Teradata
Use CData Sync to Customize and automate SAP Ariba Source replication to Teradata.
-
Create Data Visualizations in Cognos BI with Chargebee Data
Access Chargebee as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Epicor Kinetic Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Epicor Kinetic from your Google Sheets.
-
Migrating data from LinkedIn Ads to Databricks using CData SSIS Components.
Easily push LinkedIn Ads to Databricks using the CData SSIS Tasks for LinkedIn Ads and Databricks.
-
Integrate with Mailjet Data in JReport Designer
Create charts and reports based on Mailjet in JReport Designer.
-
Use the CData ODBC Driver for Pipeliner CRM in Microsoft Power Query
You can use the CData Pipeliner CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pipeliner CRM into Microsoft Power Query.
-
Connect to Act CRM Data in Ruby
Connect to Act CRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
A Comparison of the CData and Sun JDBC-ODBC Bridges
Performance tests show that the CData JDBC-ODBC Bridge is up to 327% faster than the Sun JDBC-ODBC Bridge.
-
Build Dashboards with Tavily Data in Dundas BI
Create dynamic dashboards and perform analytics based on Tavily in Dundas BI.
-
Access Live Hive Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache Hive into the statistical analysis tools available in SAS JMP. This article shows how to use Apache Hive in the Graph Builder and Query Builder.
-
Connect and Visualize Live Email Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Email into the Databricks platform and create visualization dashboards with real-time Email.
-
Analyze Live CouchDB Data in SAS Viya
Use CData Connect AI to connect to Apache CouchDB from SAS Viya and deploy self-service analytics using live Apache CouchDB.
-
Migrating data from Amazon Athena to Google BigQuery using CData SSIS Components.
Easily push Amazon Athena to Google BigQuery using the CData SSIS Tasks for Amazon Athena and Google BigQuery.
-
Connect to Monday.com from a Connection Pool in WebLogic
Use the CData JDBC Driver for Monday.com to connect to Monday.com from Web applications running on WebLogic.
-
Build Automated Workflows with Live Dynamics CRM Data in Workato
Use CData Connect AI to connect to live Microsoft Dynamics CRM and build automated workflows in Workato.
-
A PostgreSQL Interface for SuiteCRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the SuiteCRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData API Server to Access Suadeo Data in Microsoft PowerPivot
Use the CData API Server to connect to live Suadeo in the Power Pivot business intelligence tool.
-
Use the CData Software ODBC Driver for Drift in SAS for Real-Time Reporting and Analytics
Connect to real-time Drift in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Drift.
-
Analyze Google Tasks Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Tasks in Microsoft R Open.
-
Feed Parallel Data into FineReport
How to set Parallel as a JDBC data source in FineReport.
-
Provide OData Services of JobNimbus Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for JobNimbus by developing a WCF Service Application.
-
Use Manus AI to Talk to Your Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Zoho Inventory.
-
How to work with Cloudflare Data in Apache Spark using SQL
Access and process Cloudflare Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate with ChargeOver Data in JReport Designer
Create charts and reports based on ChargeOver in JReport Designer.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Facebook within intelligent workflows.