CData Software - Knowledge Base
Recent Articles
-
Connect to Excel Online Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Excel Online data.
-
Connect to Sybase Data in RapidMiner
Integrate Sybase data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Salesforce Data 360 Data in the Pentaho Report Designer
Publish reports based on Salesforce Data 360 data in the Pentaho BI tool.
-
Connect to EnterpriseDB Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for EnterpriseDB data in the Denodo Virtual DataPort Administrator.
-
Load PolarTeamPro Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PolarTeamPro data to a database.
-
Automated Continuous Mailjet Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Mailjet replication to IBM DB2.
-
Use the CData Software JDBC Driver for Insightly in MicroStrategy Web
Connect to Insightly data in MicroStrategy Web using the CData Software JDBC Driver for Insightly.
-
Visualize Facebook Data in TIBCO Spotfire through OData
Integrate Facebook data into dashboards in TIBCO Spotfire.
-
Provide OData Services of Reckon Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Reckon data by developing a WCF Service Application.
-
Migrating data from Insightly to Snowflake using CData SSIS Components.
Easily push Insightly data to Snowflake using the CData SSIS Tasks for Insightly and Snowflake.
-
How to import Access Data into Apache Solr
Use the CData Software JDBC Driver for Access in Data Import Handler and create an automated import of Access data to Apache Solr Enterprise Search platform.
-
How to Connect to & Open Pinterest Data in Microsoft Excel
This article uses the CData ODBC driver for Pinterest to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Live SAP BusinessObjects BI Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP BusinessObjects BI data to Blue Prism using the CData ODBC Driver for SAP BusinessObjects BI to create automated workflows for repetitive business tasks.
-
Build an OLAP Cube in SSAS from Clio Data
Establish a connection to Clio data data from SQL Server Analysis Services, and use the Clio Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect DBeaver to HelloSign via a JDBC Driver
Manage HelloSign data with visual tools in DBeaver like the query browser.
-
Connecting GenSpark with Adobe Experience Manager Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Adobe Experience Manager data without any replication or custom integration required.
-
Visualize Customer.io Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Customer.io data.
-
How to Connect to Live Google Forms 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 Google Forms data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for YouTube Analytics
Create an ODBC connection to YouTube Analytics in Informatica and browse and transfer YouTube Analytics data.
-
Automated Continuous Authorize.Net Replication to SQL Server
Use CData Sync for automated, continuous, customizable Authorize.Net replication to SQL Server.
-
Getting Started with the CData Python Connector for Invoiced
Learn to install and license the CData Python Connector and configure a connection to live Invoiced data.
-
Interact with Live Tally Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Tally data.
-
Use JayDeBeApi to access Greenhouse Data in Python
Use standard Python scripting and the development environment of your choice to access live Greenhouse data.
-
Connect to API Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for API Data and connect to API data in Akorbi Digital RunMyProcess.
-
Automated Microsoft Exchange Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft Exchange data replication to Teradata.
-
Build Teamwork-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Teamwork data.
-
Integrate Trae with Live Google Calendar Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Google Calendar data from within the AI-powered IDE.
-
How to connect to Google Contacts Data with Squirrel SQL client
Connect to Google Contacts data and execute queries in the Squirrel SQL Client.
-
Automate Reckon Data Replication to Azure Data Lake
Use CData Sync to customize and automate Reckon data replication to Azure Data Lake.
-
Build MySQL-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live MySQL data.
-
Integrate LibreChat with Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Splunk data from within the chat interface.
-
Consume Google Ads OData Feeds in PowerBuilder
This article demonstrates how to consume Google Ads data as OData feeds from PowerBuilder using the API Server.
-
Creating Snowflake-Connected Applications in Unqork
You can use CData Connect AI to feed Snowflake data to Unqork and build custom business apps.
-
Integrate Basecamp Data into Power Automate Desktop using CData Connect
CData Connect for Basecamp Data enables you to integrate Basecamp data into workflows built using Microsoft Power Automate Desktop.
-
Creating Wave Financial-Connected Applications in Unqork
You can use CData Connect AI to feed Wave Financial data to Unqork and build custom business apps.
-
A PostgreSQL Interface for Sage 200 Data using the CData ODBC Driver
Use the SQL Gateway and Sage 200 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import and Visualize Guru Data in Power View
Create data visualizations based on Guru data in Excel.
-
Integrate with Live AlloyDB Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to AlloyDB from the MuleSoft Anypoint Platform to integrate live AlloyDB data into custom reports and dashboards.
-
How to connect to Teamgate Data from Spring Boot
Connect to Teamgate in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Amplitude Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Amplitude data using standard SQL.
-
Connect and Visualize Live Wave Financial Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Wave Financial data into the Databricks platform and create visualization dashboards with real-time Wave Financial data.
-
Import Bannerbear Data Using Azure Data Factory
Use CData Connect AI to connect to Bannerbear Data from Azure Data Factory and import live Bannerbear data.
-
Create Salesforce-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Salesforce Data from OutSystems and build custom enterprise apps using live Salesforce data.
-
Query Teamwork Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Teamwork data from Node.js.
-
Access Live Google Drive Data in AWS Lambda
Connect to live Google Drive data in AWS Lambda using the CData JDBC Driver.
-
Build a Singer.io Tap for SAP HANA With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP HANA data using the CData Python Connector.
-
Integrate with Excel Data in JReport Designer
Create charts and reports based on Excel data in JReport Designer.
-
Write a Simple Go Application to work with Raisers Edge NXT Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Raisers Edge NXT data.
-
Automated Continuous Placid Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Placid replication to Azure SQL Database.
-
Automated Continuous ConvertAPI Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ConvertAPI replication to IBM DB2.
-
Automated Continuous Omnisend Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Omnisend replication to Apache Cassandra.
-
Connect to SAS xpt from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAS xpt to connect to SAS xpt data from Web applications running on WebLogic.
-
Connect to GitLab Data from HeidiSQL
Use CData Connect AI to connect to and query live GitLab data from HeidiSQL.
-
Build Nethunt-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Nethunt data and build web apps with connectivity to live Nethunt data.
-
Connect to PolarTeamPro Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live PolarTeamPro data.
-
Integrating Antigravity CLI with SharePoint data via CData CLI
Connect SharePoint data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Apps with Live SuiteCRM Data Using the Low-Code Development Platform of Mendix
Connect SuiteCRM data with Mendix to build apps using the CData JDBC Driver for SuiteCRM.
-
Process & Analyze Dotmailer Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Dotmailer Data.
-
Query Aha! Data in ColdFusion
Write standard ColdFusion data access code to connect to Aha! data.
-
How to connect to WooCommerce Data from IntelliJ
Integrate connectivity to WooCommerce data with wizards in IntelliJ.
-
Seamlessly Bring Perplexity Data into Retool Using CData Connect AI
Integrate Perplexity data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Prepare, Blend, and Analyze Hive Data in Alteryx Designer (Connect AI)
Build workflows to access live Hive data for self-service data analytics.
-
Automate Oracle Eloqua Data Replication to Azure Data Lake
Use CData Sync to customize and automate Oracle Eloqua data replication to Azure Data Lake.
-
Create SparkPost-Connected Nintex Workflows
Use CData Connect AI to connect to SparkPost Data from Nintex Workflow Cloud and build custom workflows using live SparkPost data.
-
DataBind SAP Fieldglass Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP Fieldglass with the DevExpress Windows Forms and Web controls to provide SAP Fieldglass data to a chart.
-
Connect to Redshift Data from PowerBuilder via JDBC
This article demonstrates how to access Redshift data from PowerBuilder using the Redshift JDBC Driver.
-
Getting Started with the CData SSIS Components for xBase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for xBase.
-
How to use SQLAlchemy ORM to access ConvertAPI Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ConvertAPI data.
-
Build Voice Agents in ElevenLabs with access to Live Freshservice Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Freshservice data.
-
Pinecone Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Pinecone facts in real time.
-
How to Connect to Live Azure DevOps Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Azure DevOps data for you.
-
Automated Continuous Oracle Eloqua Reporting Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to PostgreSQL.
-
How to connect to LDAP Objects from Spring Boot
Connect to LDAP in a Spring Boot Application using the CData JDBC Driver for LDAP
-
Connect to Salesforce Data 360 Data in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce Data 360 in FileMaker Pro to connect to Salesforce Data 360 and work with Salesforce Data 360 data in your FileMaker applications.
-
Automate SQL Server Data Replication to Azure Data Lake
Use CData Sync to customize and automate SQL Server data replication to Azure Data Lake.
-
Integrate Live ShipStation Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ShipStation data and integrate live ShipStation data into apps built in Microsoft Power Apps.
-
Integrate Google's Antigravity Agent with Live Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Act CRM data using the Model Context Protocol.
-
Visualize DocuSign Data in Sisense
Create an ElastiCube in Sisense app with access to DocuSign data.
-
Build ZohoInvoice-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ZohoInvoice data.
-
Replicate PolarTeamPro Data from PowerShell
Write a quick PowerShell script to query PolarTeamPro data. Use connectivity to the live data to replicate PolarTeamPro data to SQL Server.
-
Connect to Azure Data Lake Storage Data in RazorSQL
Connect to Azure Data Lake Storage from wizards and query Azure Data Lake Storage data from the GUI in the RazorSQL database management tool.
-
Integrate Google's Antigravity Agent with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Dataverse data using the Model Context Protocol.
-
Connect to and Visualize Live Teamgate Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Teamgate data.
-
Connect to PabblySubscriptions Data in DBArtisan
Use wizards in DBArtisan to configure PabblySubscriptions data as a data source.
-
How to connect to Vault CRM Data in DBVisualizer
Integrate Vault CRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData Excel Add-In for Datadog
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Datadog.
-
Working with QuickBooks Online Data in LINQPad
Execute LINQ queries to QuickBooks Online data in LINQPad.
-
Automated Continuous Pipeline CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to delimited files (CSV/TSV).
-
Build Pipelines with Live Discord Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Discord from Google Cloud Data Fusion, enabling the integration of live Discord data into the building and management of effective data pipelines.
-
Analyze Impala Data in Looker
Use CData Connect AI to connect to Impala Data from Looker and build custom apps using live Impala data.
-
Integrating Kiro with Salesforce CRM Analytics 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.
-
Connect to Box Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Box data.
-
Analyze Zendesk Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zendesk from Power Pivot. You will use the Table Import Wizard to load Zendesk data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous ScrapingBee Replication to Vertica
Use CData Sync for automated, continuous, customizable ScrapingBee replication to Vertica.
-
Integrating OpenCode with Snowflake 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.
-
Connect to SAP Hybris C4C in SpagoBI
Create reports featuring live SAP Hybris C4C data in SpagoBI Studio. Host SAP Hybris C4C reports on SpagoBI Server.
-
Bind Live Salesforce Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Build Data Flows from Salesforce Marketing to SQL Server using SSIS
Easily back up Salesforce Marketing data to SQL Server using the SSIS components for Salesforce Marketing.
-
Automated Continuous Eventbrite Replication to Snowflake
Use CData Sync for automated, continuous, customizable Eventbrite replication to Snowflake.
-
Use the CData Software ODBC Driver for ConvertAPI in MicroStrategy
Connect to ConvertAPI data in MicroStrategy Developer using the CData Software ODBC Driver for ConvertAPI.