CData Software - Knowledge Base
Recent Articles
-
Access ChartMogul Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ChartMogul 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 Google AlloyDB 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.
-
Build Visualizations of PayPal Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PayPal 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.
-
How to Access Live Confluence Data in Visual Studio Code via Cline
Run CData MCP Server for Confluence on Windows Subsytem for Linux (WSL) and connect to live Atlassian Confluence from the Cline extension in Visual Studio Code.
-
Query Jodoo Data in ColdFusion
Write standard ColdFusion data access code to connect to Jodoo.
-
Analyze Monday.com Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Monday.com and visualize live Monday.com in Infragistics Reveal.
-
How to publish and share Cosmos DB Data dashboards with Tableau Server
The CData ODBC driver for Cosmos DB enables you integrate Azure Cosmos DB into Tableau dashboards.
-
ETL ClickTime in Oracle Data Integrator
This article shows how to transfer ClickTime 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 in Power BI.
-
Build Cassandra-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Cassandra to explore live Cassandra Data in Gemini Code Assist to assist with building Cassandra-powered applications.
-
Build Dashboards with Shopify Data in DBxtra
Create dynamic dashboards and perform analytics based on Shopify in DBxtra.
-
Integrate with Cloudflare Data in JReport Designer
Create charts and reports based on Cloudflare in JReport Designer.
-
Connect and Query Live Zoom Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zoom into Databricks
-
Create a Data Access Object for Quickbase Data using JDBI
A brief overview of creating a SQL Object API for Quickbase in JDBI.
-
Migrating data from Front to Snowflake using CData SSIS Components.
Easily push Front 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.
-
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 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 Apache Spark SQL.
-
Design BIRT Reports on Timely Data
Provide current Timely to your embedded analytics.
-
Build Apps with Live MarkLogic in Adalo using CData Connect AI
Use CData Connect AI to integrate live MarkLogic into the Adalo platform and build custom mobile and web applications with real-time MarkLogic.
-
Integrating GitHub Copilot CLI with PagerDuty 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 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 into dashboards in TIBCO Spotfire.
-
Integrate Live HelloSign Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live HelloSign 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 into the statistical analysis tools available in SAS JMP. This article shows how to use ElevenLabs 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.
-
DataBind Controls to Azure Table Data in C++Builder
DataBind to Azure Table Storage 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 without any coding.
-
How to Query Aircall Data in MySQL Workbench
Execute MySQL queries against live Aircall 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 to a database.
-
Create a Data Access Object for Tavily Data using JDBI
A brief overview of creating a SQL Object API for Tavily in JDBI.
-
Connect to Trello Data from HeidiSQL
Use CData Connect AI to connect to and query live Trello 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
-
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 Apache Hive replication to Teradata.
-
Query, Visualize, and Share live SQL Server Data in Redash
Use CData Connect AI to connect to live Microsoft SQL Server 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 Atlassian Jira.
-
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 Storage within automated workflows.
-
Build Automated Workflows with Live MYOB AccountRight Data in Workato
Use CData Connect AI to connect to live MYOB AccountRight and build automated workflows in Workato.
-
How to Access QuickBooks Data Using Entity Framework
This article shows how to access QuickBooks Desktop 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 with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect the Power BI Service to Drift: Complete Guide
Connect to the CData Software Power BI Connector for Drift from PowerBI.com to provide real-time Drift across the organization.
-
Connect to ShipStation Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ShipStation using standard SQL.
-
Connect to Twilio Data from PowerBuilder via ADO.NET
This article demonstrates how to access Twilio 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 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.
-
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 into dashboards in TIBCO Spotfire.
-
Create Reports from Email Data in Looker Studio
Use CData Connect AI to gain access to live Email and create custom reports in Looker Studio.
-
Stream Jira Data into Apache Kafka Topics
Access and stream Atlassian Jira 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. 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 from Web applications running on WebLogic.
-
DataBind Controls to Beeminder Data in C++Builder
DataBind to Beeminder 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.
-
Migrating data from EnterpriseDB to Snowflake using CData SSIS Components.
Easily push EnterpriseDB 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 Atlassian Confluence 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 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 from PowerShell? This article demonstrates how to utilize the Sugar CRM Cmdlets for tasks like connecting to Sugar CRM, automating operations, downloading data, and more.
-
Back Up Egnyte 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.
-
Build an OLAP Cube in SSAS from SAP Netweaver Gateway Data
Establish a connection to SAP Netweaver Gateway 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 into custom reports and dashboards.
-
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.
-
Integrate with Zoho Projects Data in JReport Designer
Create charts and reports based on Zoho Projects 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 to Apache Solr Enterprise Search platform.
-
Build Apps with Live iContact Data Using the Low-Code Development Platform of Mendix
Connect iContact with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize MailChimp Data in TIBCO Spotfire through ADO.NET
Integrate MailChimp into dashboards in TIBCO Spotfire.
-
Validate MYOB AccountRight Data with QuerySurge
Access and validate MYOB AccountRight 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. 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.
-
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 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 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 in Python.
-
Import Real-Time Drift Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Drift in ColdFusion.
-
Create Informatica Mappings From/To an ODBC Data Source for Pingdom
Create an ODBC connection to Pingdom in Informatica and browse and transfer Pingdom.
-
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.
-
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.
-
Automate Instagram Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Instagram from PowerShell? This article demonstrates how to utilize the Instagram Cmdlets for tasks like connecting to Instagram, 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.
-
Using the CData Software ODBC Driver for Invoiced in PyCharm
Connect to Invoiced as an ODBC data source in PyCharm using the CData Software ODBC Driver for Invoiced.
-
Epicor Kinetic Reporting in OBIEE with the Epicor Kinetic JDBC Driver
Deploy the Epicor Kinetic JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to HBase Data from a Connection Pool in Jetty
The HBase JDBC Driver supports connection pooling: This article shows how to connect faster to Apache HBase from Web apps in Jetty.
-
Automated Continuous Calendly Replication to SQLite
Use CData Sync for automated, continuous, customizable Calendly replication to SQLite.
-
Integrate IBM Informix Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to IBM Informix and integrate live IBM Informix into your Power Automate tasks.
-
Build Pipelines with Live Google Calendar Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Calendar from Google Cloud Data Fusion, enabling the integration of live Google Calendar into the building and management of effective data pipelines.
-
Connect and Query Live Facebook Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Facebook into Databricks
-
Replicate Reckon Accounts Hosted Data in Heroku for Use in Salesforce Connect
Replicate Reckon Accounts Hosted to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze GitLab Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze GitLab in Microsoft R Open.
-
Connecting Moonlit Workflow with Google Ads 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 Google Ads in real time.