CData Software - Knowledge Base
Recent Articles
-
How to Use a Microsoft Access Database to Update Klaviyo Data in Real Time
Update Klaviyo data by creating a linked table in Microsoft Access with the CData Klaviyo ODBC Driver.
-
Build Charts with Calendly Data in Clear Analytics
Create dynamic charts and perform analytics based on Calendly data in Clear Analytics.
-
Access Live Airtable 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 Airtable data through MCP integration.
-
How to connect SharePoint with Pinterest Data through external lists
Provide Pinterest data to SharePoint users as an external list.
-
Process & Analyze Timely Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Timely Data.
-
Automate Supabase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Supabase data replication to Azure Data Lake.
-
Integrate LibreChat with Live Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle Sales data from within the chat interface.
-
Natively Connect to Harvest Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Harvest data. Leverage the native support for ODBC in PHP.
-
Integrate Google Sheets Data in the Pentaho Report Designer
Publish reports based on Google Sheets data in the Pentaho BI tool.
-
Build a PostgreSQL Interface for EmailOctopus Data using the CData JDBC Driver
Use the Remoting features of the EmailOctopus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Basecamp-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Basecamp data.
-
Integrate Theia IDE with Live Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Snapchat Ads data from within the development environment.
-
Connect to Live BigQuery Data in MicroStrategy through CData Connect AI
Create a live connection to BigQuery Data in CData Connect AI and connect to your BigQuery data from MicroStrategy.
-
Import Real-Time Tickspot Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Tickspot data in ColdFusion.
-
Stream Hubstaff Data into Apache Kafka Topics
Access and stream Hubstaff data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Build an ETL App for MYOB AccountRight Data in Python with CData
Create ETL applications and real-time data pipelines for MYOB AccountRight data in Python with petl.
-
Enable the Accelo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Accelo data.
-
How to work with iContact Data in Apache Spark using SQL
Access and process iContact Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous HDFS Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HDFS replication to AlloyDB.
-
Build MVC Applications with Connectivity to Okta Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Okta from an ASP.NET MVC application.
-
How to Connect to Live Act-On Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Act-On data securely in real time.
-
Automate Paymo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Paymo data from PowerShell? This article demonstrates how to utilize the Paymo Cmdlets for tasks like connecting to Paymo data, automating operations, downloading data, and more.
-
Build Teradata Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Teradata data and build visualizations in Tableau.
-
Automated MySQL Data Replication to Teradata
Use CData Sync to Customize and automate MySQL data replication to Teradata.
-
How to create Visio diagrams from AlloyDB Data
Automatically update AlloyDB data with the changes you make to Visio master shapes.
-
Import GetResponse Data Using Azure Data Factory
Use CData Connect AI to connect to GetResponse Data from Azure Data Factory and import live GetResponse data.
-
Connect to Intercom Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Intercom data.
-
Build Data Flows from Keap to SQL Server using SSIS
Easily back up Keap data to SQL Server using the SSIS components for Keap.
-
Consume Zendesk OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Zendesk feeds that reflect any changes in SAP Lumira.
-
Use the CData Software JDBC Driver for Outlook in MicroStrategy Desktop
Connect to Outlook data in MicroStrategy Desktop using the CData Software JDBC Driver for Outlook.
-
How to Query Live SageHR Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SageHR data data in natural language using Python.
-
How to Visualize Jumpseller 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 Jumpseller data in Python.
-
Rapidly Develop IBM Cloud Object Storage-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by IBM Cloud Object Storage.
-
Integrate with live MarkLogic Data in Jitterbit
Use CData Connect AI to connect to and integrate live MarkLogic data in Jitterbit.
-
Automated Continuous Kintone Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Kintone data replication to OneLake in Microsoft Fabric.
-
Access Cloudflare Data from MySQL in Amazon QuickSight
Connect to Cloudflare and build visualizations of Cloudflare data using a MySQL Connection in Amazon QuickSight.
-
Moving Data from Miro to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Miro data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate LibreChat with Live Attio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Attio data from within the chat interface.
-
How to create Cloudflare federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Cloudflare data in MySQL .
-
Automate NetSuite Integration Tasks from PowerShell
Are you in search of a quick and easy way to access NetSuite data from PowerShell? This article demonstrates how to utilize the NetSuite Cmdlets for tasks like connecting to NetSuite data, automating operations, downloading data, and more.
-
Integrate with live SAP ByDesign Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP ByDesign data in Jitterbit.
-
Analyze Shopify Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Shopify from Power Pivot. You will use the Table Import Wizard to load Shopify data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Facebook Ads Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Facebook Ads data.
-
Visualize Live Paddle Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Paddle data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate Mocean Data Replication to SAP HANA
Use CData Sync to customize and automate Mocean data replication to SAP HANA.
-
Use Grok to Talk to Your Typeform Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Typeform data for you.
-
Build Dashboards with Amplitude Data in Dundas BI
Create dynamic dashboards and perform analytics based on Amplitude data in Dundas BI.
-
Integrating Cursor with Yelp 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.
-
Migrating data from YouTube Analytics to Databricks using CData SSIS Components.
Easily push YouTube Analytics data to Databricks using the CData SSIS Tasks for YouTube Analytics and Databricks.
-
Access Live SendPulse Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SendPulse data from your Google Sheets.
-
Edit and Search External Freshdesk Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Freshdesk data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Freshdesk Data objects that you can access from apps and the dashboard.
-
View Reports on Real-Time Mocean Data in Power BI Report Server
Use the CData ODBC Driver for Mocean to visualize Mocean data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Visualize Apify 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 Apify data in Python.
-
Integrate Cline with Live HDFS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live HDFS data from within your IDE.
-
Import and Visualize PayPal Data in Power View
Create data visualizations based on PayPal data in Excel.
-
Connect Harvest to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Harvest with IBM WebSphere for seamless data integration and connectivity.
-
Build Dashboards with Nethunt Data in Dundas BI
Create dynamic dashboards and perform analytics based on Nethunt data in Dundas BI.
-
A PostgreSQL Interface for Nethunt Data (MySQL Remoting via JDBC)
Use the Remoting features of the Nethunt JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData SSIS Components for Bitbucket
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bitbucket.
-
Access Live Supabase Data in Excel 365 Online (Excel for the web)
Connect to Supabase data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData SSIS Components for Instantly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Instantly.
-
Build AI/ML Models with Live Quickbase Data using Dataiku
Connect Quickbase Data with Dataiku using the CData JDBC Driver for Quickbase.
-
Import LinkedIn Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to LinkedIn Data and provide access to live LinkedIn data for custom reports in the Power BI Service.
-
Automated Continuous LightSpeedRetail Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Google Cloud SQL.
-
Visualize Live Amazon Athena Data in the Power BI Service
Use CData Connect AI to connect to live Amazon Athena data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to create Visio diagrams from Act CRM Data
Automatically update Act CRM data with the changes you make to Visio master shapes.
-
Connect to Power BI XMLA Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Power BI XMLA and the SQL Gateway to access Power BI XMLA data from Google Apps Script.
-
Connect to Egnyte Data in DBArtisan
Use wizards in DBArtisan to configure Egnyte data as a data source.
-
Visualize Live LinkedIn Ads Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live LinkedIn Ads data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Controls to Mocean Data in Delphi
DataBind to Mocean data in Delphi with standard data access components and controls.
-
Import Gmail Data Using Azure Data Factory
Use CData Connect AI to connect to Gmail Data from Azure Data Factory and import live Gmail data.
-
Build Semantic Layer Views for Zendesk Data in APOS Live Data Gateway
Use the CData Connector for Zendesk in APOS Live Data Gateway to build Semantic Layer Views for Zendesk data.
-
Automated Continuous Adobe Target Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Adobe Target replication to Apache Cassandra.
-
Moving Data from Clari to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Clari data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Snapchat Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Snapchat Ads data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to SharePoint Excel Services Data in HULFT Integrate
Connect to SharePoint Excel Services as a JDBC data source in HULFT Integrate
-
Analyze Oracle Service Cloud Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Oracle Service Cloud data and visualize live Oracle Service Cloud data in Infragistics Reveal.
-
Getting Started with the CData SSIS Components for Clockify
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Clockify.
-
Import and Visualize ServiceDesk Plus Data in Power View
Create data visualizations based on ServiceDesk Plus data in Excel.
-
Create LightSpeedRetail Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LightSpeedRetail data access from reports, embedded analytics, and more.
-
Analyze Adobe Analytics Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Adobe Analytics data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Microsoft OneLake Replication to Oracle
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Oracle.
-
Deploy the ADO.NET Provider for ConvertAPI on an SSRS Report Server
Connect to ConvertAPI data 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.
-
Automated Continuous SageHR Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SageHR replication to Apache Cassandra.
-
Connect to Freshservice Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Freshservice data.
-
How to Work with SQL Server Data in ETL Validator JDBC
Connect to SQL Server from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to Microsoft Exchange Data from IntelliJ
Integrate connectivity to Microsoft Exchange data with wizards in IntelliJ.
-
Bind Live Azure Data Catalog Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Data Catalog data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Analyze Jira Assets Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Jira Assets data with the CData JDBC Driver for Jira Assets.
-
Automate iContact Data Replication to Couchbase
Use CData Sync to Customize and automate iContact data replication to Couchbase.
-
Connect to eBay Data in DBeaver
Use the CData ODBC Driver to connect to eBay data in DBeaver.
-
Create Reports with Google Sheets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Sheets data.
-
Use the CData Software JDBC Driver for Stack Exchange in MicroStrategy
Connect to Stack Exchange data in MicroStrategy Developer using the CData Software JDBC Driver for Stack Exchange.
-
Use JayDeBeApi to access Helpscout Data in Python
Use standard Python scripting and the development environment of your choice to access live Helpscout data.
-
Establish a Live Connection with Webex Data using Tableau Bridge
The CData ODBC Driver for Webex enables you to integrate live Webex data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use ChatGPT to Talk to Your Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Azure Synapse data for you.
-
Use the CData Software ODBC Driver for SendGrid in MicroStrategy
Connect to SendGrid data in MicroStrategy Developer using the CData Software ODBC Driver for SendGrid.
-
How to Seamlessly Import Spark Data into IBM SPSS Modeler
Integrate Spark data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect GetResponse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your GetResponse data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Dash to Build to Web Apps on Act CRM Data
Create Python applications that use pandas and Dash to build Act CRM-connected web apps.