CData Software - Knowledge Base
Recent Articles
-
Connect to Zuora Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zuora data.
-
Access Live Azure DevOps Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure DevOps data from your Excel spreadsheets.
-
Replicate Jumpseller Data to Multiple Databases via the CData Sync CLI
Replicate Jumpseller data to disparate databases with a single configuration.
-
Integrating LangGraph with Box Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Box data within automated workflows.
-
Automated Continuous Auth0 Replication to MySQL
Use CData Sync for automated, continuous, customizable Auth0 replication to MySQL.
-
Access Live Teradata Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Teradata data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Teamwork Data in JRuby
Create a simple JRuby app with access to live Teamwork data.
-
Moving Data from Codat to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Codat data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData ODBC Driver for Beeminder from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Beeminder to connect to Beeminder data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Beeminder data in Excel.
-
Access Live iContact Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to iContact data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Access ChartMogul Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ChartMogul data from HeidiSQL.
-
Use Biml to Build SSIS Tasks to Replicate AlloyDB Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate AlloyDB data to SQL Server.
-
Use Manus AI to Talk to Your Email 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 Email data.
-
Build Visualizations of PayPal Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PayPal data in Birst.
-
Getting Started with the CData Power BI Connector for Impala
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Impala.
-
Query Jodoo Data in ColdFusion
Write standard ColdFusion data access code to connect to Jodoo data.
-
How to publish and share Cosmos DB Data dashboards with Tableau Server
The CData ODBC driver for Cosmos DB enables you integrate Cosmos DB data into Tableau dashboards.
-
ETL ClickTime in Oracle Data Integrator
This article shows how to transfer ClickTime data into a data warehouse using Oracle Data Integrator.
-
How to Create Power BI Visual Reports with Real-Time Teradata Data
Use CData Power BI Connectors to visualize Teradata data in Power BI.
-
Build Dashboards with Shopify Data in DBxtra
Create dynamic dashboards and perform analytics based on Shopify data in DBxtra.
-
Integrate with Cloudflare Data in JReport Designer
Create charts and reports based on Cloudflare data in JReport Designer.
-
Connect and Query Live Zoom Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zoom data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Devin with Live Instagram Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Instagram data.
-
Create a Data Access Object for Quickbase Data using JDBI
A brief overview of creating a SQL Object API for Quickbase data in JDBI.
-
Migrating data from Front to Snowflake using CData SSIS Components.
Easily push Front data to Snowflake using the CData SSIS Tasks for Front and Snowflake.
-
Automated Continuous Unbounce Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Unbounce replication to Apache Kafka.
-
How to use SQLAlchemy ORM to access Azure Data Lake Storage Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Data Lake Storage data.
-
Establish a Live Connection with Power BI XMLA Data using Tableau Bridge
The CData ODBC Driver for Power BI XMLA enables you to integrate live Power BI XMLA data into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Spark-Connected Applications in Appsmith
Connect to Spark Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Spark data.
-
Design BIRT Reports on Timely Data
Provide current Timely data to your embedded analytics.
-
Build Apps with Live MarkLogic data in Adalo using CData Connect AI
Use CData Connect AI to integrate live MarkLogic data into the Adalo platform and build custom mobile and web applications with real-time MarkLogic data.
-
Integrating GitHub Copilot with PagerDuty 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.
-
Automate Everhour Data Replication to Azure Synapse
Use CData Sync to customize and automate Everhour data replication to Azure Synapse.
-
Paylocity Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Paylocity facts in real time.
-
Visualize AfterShip Data in TIBCO Spotfire through ADO.NET
Integrate AfterShip data into dashboards in TIBCO Spotfire.
-
Integrate Live HelloSign Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live HelloSign data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Live ElevenLabs Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ElevenLabs data into the statistical analysis tools available in SAS JMP. This article shows how to use ElevenLabs data in the Graph Builder and Query Builder.
-
Automated Continuous Printify Replication to SQL Server
Use CData Sync for automated, continuous, customizable Printify replication to SQL Server.
-
ZohoExpense Reporting in OBIEE with the ZohoExpense JDBC Driver
Deploy the ZohoExpense JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Seamlessly Import Mixpanel Data into IBM SPSS Modeler
Integrate Mixpanel data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect PolyBase to DocuSign
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live DocuSign data.
-
DataBind Controls to Azure Table Data in C++Builder
DataBind to Azure Table data in C++Builder with standard components and controls.
-
How to create an RPA flow for Float Data in UiPath Studio
Use the Float ODBC Driver to create workflows that access real-time Float data without any coding.
-
How to Query Aircall Data in MySQL Workbench
Execute MySQL queries against live Aircall data from MySQL Workbench.
-
Load Perplexity Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Perplexity data to a database.
-
Create a Data Access Object for Tavily Data using JDBI
A brief overview of creating a SQL Object API for Tavily data in JDBI.
-
Connect to Trello Data from HeidiSQL
Use CData Connect AI to connect to and query live Trello data from HeidiSQL.
-
Build a Singer.io Tap for Coinbase With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Coinbase data using the CData Python Connector.
-
Process & Analyze Amazon Marketplace Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Amazon Marketplace Data.
-
Automated Hive Data Replication to Teradata
Use CData Sync to Customize and automate Hive data replication to Teradata.
-
Query, Visualize, and Share live SQL Server Data in Redash
Use CData Connect AI to connect to live SQL Server data in Redash for querying, visualizing, and sharing.
-
Connect to Jira 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 Jira data.
-
Integrating LangGraph with Azure Table Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Azure Table data within automated workflows.
-
Build Automated Workflows with Live MYOB AccountRight Data in Workato
Use CData Connect AI to connect to live MYOB AccountRight data and build automated workflows in Workato.
-
How to Access QuickBooks Data Using Entity Framework
This article shows how to access QuickBooks data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Wrike Data in RapidMiner
Integrate Wrike data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to ShipStation Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ShipStation data using standard SQL.
-
Connect to Twilio Data from PowerBuilder via ADO.NET
This article demonstrates how to access Twilio data from Appeon PowerBuilder using the CData ADO.NET Provider for Twilio.
-
Import Real-Time Freshdesk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Freshdesk data in ColdFusion.
-
Automated Continuous Microsoft OneLake Replication to Vertica
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Vertica.
-
Building Dynamic Web Pages with Couchbase Data Using AngularJS
Create single-page applications with live connectivity to Couchbase using the CData API Server.
-
Use Manus AI to Talk to Your Microsoft Planner 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 Microsoft Planner data.
-
Automated Continuous Jumpseller Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Jumpseller replication to AlloyDB.
-
Visualize LinkedIn Ads Data in TIBCO Spotfire through OData
Integrate LinkedIn Ads data into dashboards in TIBCO Spotfire.
-
Create Reports from Email Data in Looker Studio
Use CData Connect AI to gain access to live Email data and create custom reports in Looker Studio.
-
Stream Jira Data into Apache Kafka Topics
Access and stream Jira data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect to IBM Informix Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to IBM Informix data. Leverage the pyodbc module for ODBC in Python.
-
Connect to SAS Data Sets from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAS Data Sets to connect to SAS Data Sets data from Web applications running on WebLogic.
-
DataBind Controls to Beeminder Data in C++Builder
DataBind to Beeminder data in C++Builder with standard components and controls.
-
How to connect PolyBase to Microsoft Teams
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Teams data.
-
Migrating data from EnterpriseDB to Snowflake using CData SSIS Components.
Easily push EnterpriseDB data to Snowflake using the CData SSIS Tasks for EnterpriseDB and Snowflake.
-
Connect to Confluence Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Confluence to connect to Confluence data and execute queries in PowerBuilder.
-
View Reports on Real-Time Clockify Data in Power BI Report Server
Use the CData ODBC Driver for Clockify to visualize Clockify data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate Sugar CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sugar CRM data from PowerShell? This article demonstrates how to utilize the Sugar CRM Cmdlets for tasks like connecting to Sugar CRM data, automating operations, downloading data, and more.
-
Access Live ZohoSubscriptions Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ZohoSubscriptions data from your Google Sheets.
-
Back Up Egnyte data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Egnyte data data.
-
Build an OLAP Cube in SSAS from SAP Netweaver Gateway Data
Establish a connection to SAP Netweaver Gateway data data from SQL Server Analysis Services, and use the SAP Netweaver Gateway Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate with Live Sybase IQ Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sybase IQ from the MuleSoft Anypoint Platform to integrate live Sybase IQ data into custom reports and dashboards.
-
Connecting Agentforce with Adobe Target 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 Adobe Target data for you.
-
Connect to Teamwork Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Teamwork data.
-
Integrate with Zoho Projects Data in JReport Designer
Create charts and reports based on Zoho Projects data in JReport Designer.
-
How to import SAP Ariba Source Data into Apache Solr
Use the CData Software JDBC Driver for SAP Ariba Source in Data Import Handler and create an automated import of SAP Ariba Source data to Apache Solr Enterprise Search platform.
-
Import Bitly Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Bitly Data and provide access to live Bitly data for custom reports in the Power BI Service.
-
Build Apps with Live iContact Data Using the Low-Code Development Platform of Mendix
Connect iContact data with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize MailChimp Data in TIBCO Spotfire through ADO.NET
Integrate MailChimp data into dashboards in TIBCO Spotfire.
-
Validate MYOB AccountRight Data with QuerySurge
Access and validate MYOB AccountRight data in QuerySurge using the CData JDBC Driver.
-
Seamlessly Bring Highrise Data into Retool Using CData Connect AI
Integrate Highrise data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Analyze Instagram Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Instagram from Power Pivot. You will use the Table Import Wizard to load Instagram data. You can visually build the import query or use any SQL supported by the driver.
-
How to use SQLAlchemy ORM to access Webex Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Webex data.
-
Create Reckon Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Reckon data access from reports, embedded analytics, and more.
-
Build an OLAP Cube in SSAS from Oracle Eloqua Reporting Data
Establish a connection to Oracle Eloqua Reporting data data from SQL Server Analysis Services, and use the Oracle Eloqua Reporting Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Salesforce Data 360 Data in CloverDX (formerly CloverETL)
Transfer Salesforce Data 360 data using the visual workflow in the CloverDX data integration tool.
-
How to Visualize Reply.io Data in Python with pandas
Use pandas and other modules to analyze and visualize live Reply.io data in Python.
-
Create Informatica Mappings From/To an ODBC Data Source for Pingdom
Create an ODBC connection to Pingdom in Informatica and browse and transfer Pingdom data.
-
Connect to MYOB AccountRight Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MYOB AccountRight as an External Source in Dremio.
-
How to Work with Phoenix Data in ETL Validator JDBC
Connect to Phoenix from ETL Validator jobs using the CData Software JDBC Driver.
-
Access Live SuiteCRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SuiteCRM data from your Excel spreadsheets.
-
Use Manus AI to Talk to Your Zoho CRM 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 CRM data.
-
Automate Instagram Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Instagram data from PowerShell? This article demonstrates how to utilize the Instagram Cmdlets for tasks like connecting to Instagram data, automating operations, downloading data, and more.
-
Build Jira Assets-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Jira Assets Data and create custom apps in Bubble.