CData Software - Knowledge Base
Recent Articles
-
Analyze HubDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of HubDB data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Reports from Outreach.io Data in Looker Studio
Use CData Connect AI to gain access to live Outreach.io data and create custom reports in Looker Studio.
-
How to use SQLAlchemy ORM to access SAP BusinessObjects BI Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP BusinessObjects BI data.
-
Connect to Live SAP Hybris C4C Data in MicroStrategy through CData Connect AI
Create a live connection to SAP Hybris C4C Data in CData Connect AI and connect to your SAP Hybris C4C data from MicroStrategy.
-
Query Toggl Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Toggl data from Node.js.
-
Connect to Teamwork Data in HULFT Integrate
Connect to Teamwork as a JDBC data source in HULFT Integrate
-
Automated Continuous Amazon Marketplace Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Apache Cassandra.
-
Build ShipEngine-Connected Apps in Choreo
Use CData Connect AI to connect to ShipEngine Data from Choreo and build custom apps using live ShipEngine data.
-
Getting Started with the CData Power BI Connector for Retently
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Klaviyo Data in Ruby
Connect to Klaviyo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to create Visio diagrams from Dynamics 365 Data
Automatically update Dynamics 365 data with the changes you make to Visio master shapes.
-
Automated Continuous REST Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable REST replication to Apache Kafka.
-
How to Connect to Live ZohoSubscriptions 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 ZohoSubscriptions data for you.
-
Build Yelp-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Yelp data.
-
How to Create Power BI Visual Reports with Real-Time Anaplan Data
Use CData Power BI Connectors to visualize Anaplan data in Power BI.
-
A PostgreSQL Interface for XML Data using the CData ODBC Driver
Use the SQL Gateway and XML ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with live Google Cloud Storage Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Cloud Storage data in Jitterbit.
-
Automated Continuous Jira Assets Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Jira Assets data replication to OneLake in Microsoft Fabric.
-
Build ServiceNow-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 ServiceNow data without replication.
-
How to Access Live LinkedIn Data in Power Automate Desktop via ODBC
The CData ODBC Driver for LinkedIn enables you to integrate LinkedIn data into workflows built using Microsoft Power Automate Desktop.
-
How to connect SharePoint with HubSpot Data through external lists
Provide HubSpot data to SharePoint users as an external list.
-
Validate Beeminder Data with QuerySurge
Access and validate Beeminder data in QuerySurge using the CData JDBC Driver.
-
Moving Data from JSON to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live JSON data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query Live Notion Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Notion data through a conversational interface.
-
ETL Billsby in Oracle Data Integrator
This article shows how to transfer Billsby data into a data warehouse using Oracle Data Integrator.
-
Replicate FreeAgent Data to Multiple Databases via the CData Sync CLI
Replicate FreeAgent data to disparate databases with a single configuration.
-
Perform Batch Operations with Active Directory Data in Apache NiFi
Connect to Active Directory data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Moving Data from PabblySubscriptions to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PabblySubscriptions data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Data Visualizations in Cognos BI with PayPal Data
Access PayPal data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Visualize Omnisend Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Omnisend data in Python.
-
Automated Continuous Salesforce Pardot Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Vertica.
-
Analyze LinkedIn Ads Data in Looker
Use CData Connect AI to connect to LinkedIn Ads Data from Looker and build custom apps using live LinkedIn Ads data.
-
Connecting Moonlit Workflow with Trello Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Trello data in real time.
-
Integrating Antigravity CLI with Google Directory data via CData CLI
Connect Google Directory data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use Agno to Talk to Your SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your SAP Business One data for you.
-
Perform Batch Operations with SAP Netweaver Gateway Data in Apache NiFi
Connect to SAP Netweaver Gateway data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Google Search Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Search replication to Azure SQL Database.
-
Integrate Dynamics CRM Data in the Pentaho Report Designer
Publish reports based on Dynamics CRM data in the Pentaho BI tool.
-
Getting Started with the CData Excel Add-In for LeadDesk
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for LeadDesk.
-
Access Shortcut Data from MySQL in PHP
Connect to Shortcut through the standard MySQL libraries in PHP.
-
How to Seamlessly Import Superchat Data into IBM SPSS Modeler
Integrate Superchat data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Model Facebook Ads Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Facebook Ads, enabling the direct import of real-time Facebook Ads data.
-
Import Real-Time Neo4J Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Neo4J data in ColdFusion.
-
Visualize Live Paymo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Paymo data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Controls to Procore Data in C++Builder
DataBind to Procore data in C++Builder with standard components and controls.
-
Connect to Azure Data Catalog Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Data Catalog data using standard SQL.
-
LINQ to Amazon S3 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 Amazon S3 Data Provider.
-
ETL Amazon S3 in Oracle Data Integrator
This article shows how to transfer Amazon S3 data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Teamgate Replication to Snowflake
Use CData Sync for automated, continuous, customizable Teamgate replication to Snowflake.
-
How to Connect DBeaver to Google Ad Manager via a JDBC Driver
Manage Google Ad Manager data with visual tools in DBeaver like the query browser.
-
Connect to SAP Business One Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Business One to connect to SAP Business One data and execute queries in PowerBuilder.
-
Connect to Microsoft Ads Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Ads data in DBeaver.
-
Connect to LinkedIn Ads Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for LinkedIn Ads data in Airbyte.
-
Query, Visualize, and Share live ZohoInvoice Data in Redash
Use CData Connect AI to connect to live ZohoInvoice data in Redash for querying, visualizing, and sharing.
-
How to Connect to Live Active Directory 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 Active Directory data for you.
-
Use Claude to Talk to Your MySQL 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 MySQL data for you.
-
Import and Visualize PhantomBuster Data in Power View
Create data visualizations based on PhantomBuster data in Excel.
-
Migrating data from ZeroBounce to Databricks using CData SSIS Components.
Easily push ZeroBounce data to Databricks using the CData SSIS Tasks for ZeroBounce and Databricks.
-
Process & Analyze Hugging Face Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Hugging Face Data.
-
Use Databricks Agent Bricks to Talk to Your Salesforce Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Salesforce data for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sendwithus
Provide connectivity to Sendwithus data through an SAP BusinessObjects universe.
-
Create SSAS Tabular Models from Smartsheet Data
How to build a SQL Server Analysis Service Tabular Model from Smartsheet data using CData drivers.
-
Connect to Zuora Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zuora data in the Denodo Virtual DataPort Administrator.
-
Design BIRT Reports on Google Translate Data
Provide current Google Translate data to your embedded analytics.
-
Automated Continuous Blackbaud FE NXT Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to AlloyDB.
-
Excel Spreadsheet Automation on GitLab Data with the QUERY Formula
Pull data from GitLab, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Python Connector for SparkPost
Learn to install and license the CData Python Connector and configure a connection to live SparkPost data.
-
Access Live SharePoint Excel Services Data in AWS Lambda
Connect to live SharePoint Excel Services data in AWS Lambda using the CData JDBC Driver.
-
How to connect and process Teradata data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Teradata data.
-
How to Work with ActiveCampaign Data in ETL Validator JDBC
Connect to ActiveCampaign from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live SQL Analysis Services Data in TIBCO Data Virtualization
Use the SQL Analysis Services Tibco DV Adapter to create a SQL Analysis Services data data source in TIBCO Data Virtualization Studio and gain access to live SQL Analysis Services data from your TDV Server.
-
Analyze Teamwork Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Teamwork from Power Pivot. You will use the Table Import Wizard to load Teamwork data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Live Asana Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Asana data and integrate live Asana data into apps built in Microsoft Power Apps.
-
Connect to Bitly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Bitly to connect to Bitly data and execute queries in PowerBuilder.
-
How to Build an ETL App for Datadog Data in Python with CData
Create ETL applications and real-time data pipelines for Datadog data in Python with petl.
-
Connect to TigerGraph Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for TigerGraph and the Script function in FileMaker Pro to connect to TigerGraph and work with TigerGraph data in your FileMaker application.
-
Integrating Dataiku with SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Concur data.
-
Replicate Multiple Avro Accounts
Replicate multiple Avro accounts to one or many databases.
-
Seamlessly Bring Supabase Data into Retool Using CData Connect AI
Integrate Supabase data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Configure the CData JDBC Driver for ZohoMarketingHub in a Connection Pool in Tomcat
Connect to ZohoMarketingHub data from a connection pool in Tomcat.
-
Connect to Tavily Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Tavily to connect to Tavily data and execute queries in PowerBuilder.
-
How to Connect Flowise AI Agents to Live Azure Synapse Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Azure Synapse data without replication.
-
Analyze SAP ByDesign Data in Looker
Use CData Connect AI to connect to SAP ByDesign Data from Looker and build custom apps using live SAP ByDesign data.
-
Integrating Boomi Agentstudio with Sybase IQ Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sybase IQ data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Access Live Cloudflare Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Cloudflare enables you to integrate Cloudflare data into workflows built using Microsoft Power Automate Desktop.
-
Build Visualizations of Excel Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Excel data in Birst.
-
Access Live Dynamics 365 Business Central Data in Excel 365 Online (Excel for the web)
Connect to Dynamics 365 Business Central data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect Opsgenie Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Opsgenie data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connecting GenSpark with SAP Concur Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Concur data without any replication or custom integration required.
-
Build Pipelines with Live PingOne Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to PingOne from Google Cloud Data Fusion, enabling the integration of live PingOne data into the building and management of effective data pipelines.
-
Integrating Dataiku with Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Raisers Edge NXT data.
-
Use the CData Software JDBC Driver for Insightly in MicroStrategy Desktop
Connect to Insightly data in MicroStrategy Desktop using the CData Software JDBC Driver for Insightly.
-
Access Zoho Books Data from MySQL in Amazon QuickSight
Connect to Zoho Books and build visualizations of Zoho Books data using a MySQL Connection in Amazon QuickSight.
-
Replicate Google Ad Manager Data to Multiple Databases via the CData Sync CLI
Replicate Google Ad Manager data to disparate databases with a single configuration.
-
How to Easily Query Oracle Service Cloud Data in OpenOffice Base
Connect to Oracle Service Cloud data in OpenOffice Base using the CData ODBC Driver for Oracle Service Cloud and generate reports with live data insights.
-
Choosing the Best Method to Connect VWO to SQL Server: 5 Options Explained
Discover multiple ways to connect and use VWO data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Intercom Data Replication to Teradata
Use CData Sync to Customize and automate Intercom data replication to Teradata.
-
Create Reports with Zendesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zendesk data.
-
Build Google Contacts-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Contacts data and build Google Contacts-connected web apps with Axios.
-
Connect to Live Adobe Analytics Data in MicroStrategy through CData Connect AI
Create a live connection to Adobe Analytics Data in CData Connect AI and connect to your Adobe Analytics data from MicroStrategy.