CData Software - Knowledge Base
Recent Articles
-
Use the CData SSIS Components to Insert New or Update Existing Snapchat Ads Records from SQL Server
Easily push SQL Server data to Snapchat Ads using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Snapchat Ads or update existing records with data from a SQL Server database.
-
Use the CData Software ODBC Driver for eBay in SAS for Real-Time Reporting and Analytics
Connect to real-time eBay data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for eBay.
-
Use the CData SSIS Components to Insert New or Update Existing TaxJar Records from SQL Server
Easily push SQL Server data to TaxJar using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into TaxJar or update existing records with data from a SQL Server database.
-
Build Charts with MailerLite Data in Clear Analytics
Create dynamic charts and perform analytics based on MailerLite data in Clear Analytics.
-
Model, Search, and Visualize Live Cassandra Data in ThoughtSpot
Use CData Connect AI to connect to live Cassandra data for modeling, searching, and visualizing.
-
Build Email-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Email data.
-
Viewing Procore Data in RAD Studio Data Explorer
How to view Procore data in RAD Studio Data Explorer using the CData ODBC Driver for Procore.
-
Connect to Live Hive Data in MicroStrategy through CData Connect AI
Create a live connection to Hive Data in CData Connect AI and connect to your Hive data from MicroStrategy.
-
Add HubSpot Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HubSpot with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Hive from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Hive data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automate QuickBooks Integration Tasks from PowerShell
Are you in search of a quick and easy way to access QuickBooks data from PowerShell? This article demonstrates how to utilize the QuickBooks Cmdlets for tasks like connecting to QuickBooks data, automating operations, downloading data, and more.
-
Build Automated Workflows with Live PostgreSQL Data in Workato
Use CData Connect AI to connect to live PostgreSQL data and build automated workflows in Workato.
-
Create Reports from SAP HANA XS Advanced Data in Looker Studio
Use CData Connect AI to gain access to live SAP HANA XS Advanced data and create custom reports in Looker Studio.
-
Stream Salesforce Pardot Data into Apache Kafka Topics
Access and stream Salesforce Pardot data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create a Data Access Object for Elorus Data using JDBI
A brief overview of creating a SQL Object API for Elorus data in JDBI.
-
Automated Continuous ZohoPeople Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZohoPeople replication to AlloyDB.
-
DataBind Controls to LinkedIn Ads Data in C++Builder
DataBind to LinkedIn Ads data in C++Builder with standard components and controls.
-
Build a PostgreSQL Interface for Coda Data using the CData JDBC Driver
Use the Remoting features of the Coda JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Biml to Build SSIS Tasks to Replicate Perigon Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Perigon data to SQL Server.
-
Use Claude to Talk to Your Amazon Marketplace 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 Amazon Marketplace data for you.
-
Use the CData Software ODBC Driver for IBM Informix in MicroStrategy Desktop
Connect to IBM Informix data in MicroStrategy Desktop using the CData Software ODBC Driver for IBM Informix.
-
Build Dashboards with ChartMogul Data in Dundas BI
Create dynamic dashboards and perform analytics based on ChartMogul data in Dundas BI.
-
Getting Started with the CData Tableau Connector for Insightly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Reckon Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Reckon data.
-
Build a Singer.io Tap for Sentry With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sentry data using the CData Python Connector.
-
Connect to SAP HANA in SpagoBI
Create reports featuring live SAP HANA data in SpagoBI Studio. Host SAP HANA reports on SpagoBI Server.
-
How to Connect to Moosend Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Moosend data. Leverage the pyodbc module for ODBC in Python.
-
Connect to and Visualize Live Microsoft Dataverse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dataverse data.
-
Automated Continuous Apify Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Apify replication to Google BigQuery.
-
Analyze Dynamics CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dynamics CRM data in Microsoft R Open.
-
Build an OLAP Cube in SSAS from ZohoMarketingHub Data
Establish a connection to ZohoMarketingHub data data from SQL Server Analysis Services, and use the ZohoMarketingHub Data Provider to build OLAP cubes for use in analytics and reporting.
-
Analyze Exact Online Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Exact Online data and visualize live Exact Online data in Infragistics Reveal.
-
Integrate Open WebUI with Live ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ZohoPeople data from within the chat interface.
-
Build Semantic Layer Views for Ontraport Data in APOS Live Data Gateway
Use the CData Connector for Ontraport in APOS Live Data Gateway to build Semantic Layer Views for Ontraport data.
-
Use Dash to Build to Web Apps on Superchat Data
Create Python applications that use pandas and Dash to build Superchat-connected web apps.
-
Using the CData Software ODBC Driver for Apify in PyCharm
Connect to Apify as an ODBC data source in PyCharm using the CData Software ODBC Driver for Apify.
-
Build Cloudflare-Connected Apps in Choreo
Use CData Connect AI to connect to Cloudflare Data from Choreo and build custom apps using live Cloudflare data.
-
How to connect to Databricks Data in DBVisualizer
Integrate Databricks data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Biml to Build SSIS Tasks to Replicate OData Services to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate OData services to SQL Server.
-
Use Dash to Build Web Apps on Testmonitor Data via CData Connect AI
Build interactive Dash web apps on live Testmonitor data using pandas and the CData Connect AI Python SDK.
-
Integrate Freshdesk Data in Pentaho Data Integration
Build ETL pipelines based on Freshdesk data in the Pentaho Data Integration tool.
-
Automated Continuous Apollo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Apollo replication to Azure SQL Database.
-
Create Active Directory-Connected Applications in Appsmith
Connect to Active Directory Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Active Directory data.
-
Create Reports with Scrapfly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Scrapfly data.
-
Visualize Live Parallel Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Parallel data.
-
Analyze Oracle HCM Cloud Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Oracle HCM Cloud data and visualize Oracle HCM Cloud data in SAP Analytics Cloud.
-
Prepare, Blend, and Analyze ZohoDesk Data in Alteryx Designer (ODBC)
Build workflows to access live ZohoDesk data for self-service data analytics.
-
Automated Continuous EnterpriseDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Google BigQuery.
-
Integrate AdRoll Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live AdRoll data from Informatica Cloud.
-
Connect to Klipfolio Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Klipfolio to connect to Klipfolio data and execute queries in PowerBuilder.
-
LINQ to XML 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 XML Data Provider.
-
Automated Continuous Salesforce CRM Analytics Replication to MySQL
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to MySQL.
-
Automated Continuous Bitbucket Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Bitbucket replication to AlloyDB.
-
Consume Azure Data Lake Storage OData Feeds in PowerBuilder
This article demonstrates how to consume Azure Data Lake Storage data as OData feeds from PowerBuilder using the API Server.
-
View Reports on Real-Time Acumatica Data in Power BI Report Server
Use the CData ODBC Driver for Acumatica to visualize Acumatica data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating GitHub Copilot with ClickTime 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 an ODBC Data Source for Microsoft OneDrive
Create an ODBC connection to Microsoft OneDrive in Informatica and browse and transfer Microsoft OneDrive data.
-
Natively Connect to Sybase Data in PHP
The CData ODBC driver for Sybase enables you to create PHP applications with connectivity to Sybase data. Leverage the native support for ODBC in PHP.
-
Integrate Outreach.io Data in the Pentaho Report Designer
Publish reports based on Outreach.io data in the Pentaho BI tool.
-
Creating FTP-Connected Applications in Unqork
You can use CData Connect AI to feed FTP data to Unqork and build custom business apps.
-
Build Dashboards with Stripe Data in Dundas BI
Create dynamic dashboards and perform analytics based on Stripe data in Dundas BI.
-
Integrate Humanity Data in Pentaho Data Integration
Build ETL pipelines based on Humanity data in the Pentaho Data Integration tool.
-
Bind Live SAP Business One Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Business One data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
DataBind Controls to PayPal Data in Delphi
DataBind to PayPal data in Delphi with standard data access components and controls.
-
Integrate Brex with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Brex with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Brex data.
-
How to Build an ETL App for Google Forms Data in Python with CData
Create ETL applications and real-time data pipelines for Google Forms data in Python with petl.
-
Interact with Live SurveyMonkey Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SurveyMonkey data.
-
Import Real-Time Jumpseller Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Jumpseller data in ColdFusion.
-
Connect to Email Data from HeidiSQL
Use CData Connect AI to connect to and query live Email data from HeidiSQL.
-
Connect SpaceX to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SpaceX with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Keap Data in the Pentaho Report Designer
Publish reports based on Keap data in the Pentaho BI tool.
-
Query Amazon Athena Data in DataGrip
Create a Data Source for Amazon Athena in DataGrip and use SQL to query live Amazon Athena data.
-
Create Dynamic Airtable Grids Using the Infragistics XamDataGrid
Learn how you can connect Airtable to Infragistics XamDataGrid to build dynamic grids.
-
How to Query HubSpot Data in MySQL Workbench
Execute MySQL queries against live HubSpot data from MySQL Workbench.
-
Stream TigerGraph Data into Apache Kafka Topics
Access and stream TigerGraph data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Gumloop with Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sendwithus data within automated workflows.
-
Visualize Live Zoho Books Data in the Power BI Service
Use CData Connect AI to connect to live Zoho Books data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect Nuclia to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Nuclia data using the CData Python MCP Server.
-
Object-Relational Mapping (ORM) with Amazon S3 Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Amazon S3 data into a Java-based ORM framework, Hibernate.
-
Back Up MariaDB data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MariaDB. In this article, we will employ an SSIS workflow to populate a database with MariaDB data data.
-
Create Dynamic Vault CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Vault CRM to Infragistics XamDataGrid to build dynamic grids.
-
Build Pipelines with Live NetSuite SuiteAnalytics Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to NetSuite SuiteAnalytics from Google Cloud Data Fusion, enabling the integration of live NetSuite SuiteAnalytics data into the building and management of effective data pipelines.
-
Use the CData Software ODBC Driver for Klipfolio in MicroStrategy
Connect to Klipfolio data in MicroStrategy Developer using the CData Software ODBC Driver for Klipfolio.
-
Edit and Search External MYOB AccountRight Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MYOB AccountRight data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MYOB AccountRight Data objects that you can access from apps and the dashboard.
-
Working with Google Tasks Data in LINQPad
Execute LINQ queries to Google Tasks data in LINQPad.
-
Connect to Dynamics 365 Business Central Data in RazorSQL
Connect to Dynamics 365 Business Central from wizards and query Dynamics 365 Business Central data from the GUI in the RazorSQL database management tool.
-
Build Greenplum-Connected Apps in Choreo
Use CData Connect AI to connect to Greenplum Data from Choreo and build custom apps using live Greenplum data.
-
Connecting Agentforce with DB2 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 DB2 data for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Sage Cloud Accounting
Create Sage Cloud Accounting data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Apps from FTP Data in Qlik Sense Cloud
Use CData Connect AI to connect to FTP Data and build apps from live FTP data in Qlik Sense Cloud.
-
Integrate Live LDAP Objects into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live LDAP objects to Blue Prism using the CData ODBC Driver for LDAP to create automated workflows for repetitive business tasks.
-
Integrating GitHub Copilot with ShipStation 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 Workday Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Workday replication to Apache Cassandra.
-
Connect to Presto from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Presto data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData Software ODBC Driver for Gong in MicroStrategy
Connect to Gong data in MicroStrategy Developer using the CData Software ODBC Driver for Gong.
-
Publish Crystal Reports on Zoho Recruit Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Recruit data.
-
Integrate LibreChat with Live Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Workday data from within the chat interface.
-
Integrating LangChain with Optimizely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Optimizely data within automated workflows.
-
Search External ZohoInvoice Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ZohoInvoice data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ZohoInvoice Data objects that you can access from apps and the dashboard.
-
Connect to Dynamics NAV Data from a Connection Pool in JBoss
Integrate Dynamics NAV data into Java servlets: Use the Management Console in JBoss to install the Dynamics NAV JDBC Driver.