CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Tableau Connector for Pipeline CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect and Query Live API Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live API data into Databricks and enable direct, live querying and analysis without replication.
-
Create Data Visualizations in Cognos BI with CircleCI Data
Access CircleCI data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to OnePageCrm Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time OnePageCrm data using standard SQL.
-
Working with SendPulse Data in LINQPad
Execute LINQ queries to SendPulse data in LINQPad.
-
Visualize Google Translate Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Google Translate data into TIBCO Spotfire.
-
Model, Search, and Visualize Live Acumatica Data in ThoughtSpot
Use CData Connect AI to connect to live Acumatica data for modeling, searching, and visualizing.
-
Connect to Google Directory Data in DBArtisan
Use wizards in DBArtisan to configure Google Directory data as a data source.
-
Analyze Accelo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Accelo from Power Pivot. You will use the Table Import Wizard to load Accelo data. You can visually build the import query or use any SQL supported by the driver.
-
ETL Paymo in Oracle Data Integrator
This article shows how to transfer Paymo data into a data warehouse using Oracle Data Integrator.
-
Replicate Sage 200 Data from PowerShell
Write a quick PowerShell script to query Sage 200 data. Use connectivity to the live data to replicate Sage 200 data to SQL Server.
-
How to work with Amazon S3 Data in Apache Spark using SQL
Access and process Amazon S3 Data in Apache Spark using the CData Software JDBC Driver.
-
Build a PostgreSQL Interface for Amazon S3 Data using the CData JDBC Driver
Use the Remoting features of the Amazon S3 JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to MongoDB Data in DBVisualizer
Integrate MongoDB data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect and Visualize Live Salesforce Data 360 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Salesforce Data 360 data into the Databricks platform and create visualization dashboards with real-time Salesforce Data 360 data.
-
Use Dash to Build to Web Apps on ZarMoney Data
Create Python applications that use pandas and Dash to build ZarMoney-connected web apps.
-
Automate Short.io Data Replication to SAP HANA
Use CData Sync to customize and automate Short.io data replication to SAP HANA.
-
Access Live QuickBooks Online Data in Excel 365 Online (Excel for the web)
Connect to QuickBooks Online data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use ChatGPT to Talk to Your Optimizely 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 Optimizely data for you.
-
Create Power BI Reports on Real-Time SAP Business Warehouse Data
Use the CData ODBC Driver for SAP Business Warehouse to visualize SAP Business Warehouse data in Power BI Desktop.
-
Integrate Float Data in Pentaho Data Integration
Build ETL pipelines based on Float data in the Pentaho Data Integration tool.
-
Rapidly Develop Oracle-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 Oracle.
-
Connect to HelloSign in SpagoBI
Create reports featuring live HelloSign data in SpagoBI Studio. Host HelloSign reports on SpagoBI Server.
-
Connect to NASA Data in Jaspersoft Studio
Execute SQL to remote NASA data in Jaspersoft Studio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ZohoExpense
Provide connectivity to ZohoExpense data through an SAP BusinessObjects universe.
-
Getting Started with the CData SSIS Components for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LaunchDarkly.
-
Integrate Amazon Marketplace with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Amazon Marketplace with External Services.
-
Back Up Superchat 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 Superchat data data.
-
Integrate Instantly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Instantly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Instantly data.
-
How to Build an ETL App for PDFMonkey Data in Python with CData
Create ETL applications and real-time data pipelines for PDFMonkey data in Python with petl.
-
Connect to Deel Data in Jaspersoft Studio
Execute SQL to remote Deel data in Jaspersoft Studio.
-
Working with ClickUp Data in LINQPad
Execute LINQ queries to ClickUp data in LINQPad.
-
Publish Reports with ShipEngine Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ShipEngine data.
-
Create Blackbaud FE NXT-Connected Applications in Appsmith
Connect to Blackbaud FE NXT Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Blackbaud FE NXT data.
-
Use the CData Software ODBC Driver for Unbounce in MicroStrategy Web
Connect to Unbounce data in MicroStrategy Web using the CData Software ODBC Driver for Unbounce.
-
Create YouTube Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time YouTube Analytics data access from reports, embedded analytics, and more.
-
Automate Cloudflare Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Cloudflare data from PowerShell? This article demonstrates how to utilize the Cloudflare Cmdlets for tasks like connecting to Cloudflare data, automating operations, downloading data, and more.
-
Build AI/ML Models with Live SAP Business One Data using Dataiku
Connect SAP Business One Data with Dataiku using the CData JDBC Driver for SAP Business One.
-
Build Semantic Layer Views for Snowflake Data in APOS Live Data Gateway
Use the CData Connector for Snowflake in APOS Live Data Gateway to build Semantic Layer Views for Snowflake data.
-
Natively Connect to Cohere Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cohere data. Leverage the native support for ODBC in PHP.
-
Use the CData SSIS Components to Insert New or Update Existing Salesforce Marketing Records from SQL Server
Easily push SQL Server data to Salesforce Marketing using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesforce Marketing or update existing records with data from a SQL Server database.
-
Build Charts with SAP Netweaver Gateway Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Netweaver Gateway data in Clear Analytics.
-
How to connect and process Billsby data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Billsby data.
-
Create Google Directory-Connected Dashboards in Grafana
Connect to Google Directory Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Directory data.
-
Build a PostgreSQL Interface for Snapchat Ads Data using the CData JDBC Driver
Use the Remoting features of the Snapchat Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Moving Data from Google Tasks to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Tasks data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connecting Agentforce with Sage 300 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 Sage 300 data for you.
-
Integrate Real-Time Access to Asana in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Asana data in real time.
-
Automate IBM Cloud Object Storage Data Replication to Azure Synapse
Use CData Sync to customize and automate IBM Cloud Object Storage data replication to Azure Synapse.
-
Automated Continuous Mixpanel Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Mixpanel replication to Apache Cassandra.
-
Connect to Live Bitbucket Data in MicroStrategy through CData Connect AI
Create a live connection to Bitbucket Data in CData Connect AI and connect to your Bitbucket data from MicroStrategy.
-
Visualize Live ZarMoney Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ZarMoney data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to MariaDB from a Connection Pool in WebLogic
Use the CData JDBC Driver for MariaDB to connect to MariaDB data from Web applications running on WebLogic.
-
Connect to Real-Time Campaigner Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Campaigner data in Power Apps.
-
Viewing Clockify Data in RAD Studio Data Explorer
How to view Clockify data in RAD Studio Data Explorer using the CData ODBC Driver for Clockify.
-
Build Dashboards with Short.io Data in DBxtra
Create dynamic dashboards and perform analytics based on Short.io data in DBxtra.
-
Create Google Ads-Connected Nintex Workflows
Use CData Connect AI to connect to Google Ads Data from Nintex Workflow Cloud and build custom workflows using live Google Ads data.
-
Getting Started with the CData JDBC Driver for Strava
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Strava.
-
Import Real-Time REST Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use REST data in ColdFusion.
-
Access Live eBay Analytics Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live eBay Analytics data from your Excel spreadsheets.
-
A PostgreSQL Interface for Printful Data (MySQL Remoting via JDBC)
Use the Remoting features of the Printful JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Oracle SCM from Asprova with CData Software ODBC Driver for Oracle SCM
This article shows how to connect faster to Oracle SCM data from Asprova.
-
Connect to Azure Analysis Services Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure Analysis Services data in Airbyte.
-
Add Freshdesk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Freshdesk with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Omnisend Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Omnisend data through MCP integration.
-
Import SendPulse Data Using Azure Data Factory
Use CData Connect AI to connect to SendPulse Data from Azure Data Factory and import live SendPulse data.
-
Use Dash to Build Web Apps on ZohoExpense Data via CData Connect AI
Build interactive Dash web apps on live ZohoExpense data using pandas and the CData Connect AI Python SDK.
-
Access SAS Data Sets Data from MySQL in Amazon QuickSight
Connect to SAS Data Sets and build visualizations of SAS Data Sets data using a MySQL Connection in Amazon QuickSight.
-
Build an OLAP Cube in SSAS from SharePoint Excel Services Data
Establish a connection to SharePoint Excel Services data data from SQL Server Analysis Services, and use the SharePoint Excel Services Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Work with Telegram Data in ETL Validator JDBC
Connect to Telegram from ETL Validator jobs using the CData Software JDBC Driver.
-
Publish Google Tasks-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Tasks data.
-
Connect Reply.io Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Reply.io data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software ODBC Driver for Notion in MicroStrategy Web
Connect to Notion data in MicroStrategy Web using the CData Software ODBC Driver for Notion.
-
How to integrate Timely with Apache Airflow
Access and process Timely data in Apache Airflow using the CData JDBC Driver.
-
Working with Klaviyo Data in LINQPad
Execute LINQ queries to Klaviyo data in LINQPad.
-
LINQ to Chargebee 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 Chargebee Data Provider.
-
Create Dynamic Cohere Grids Using the Infragistics XamDataGrid
Learn how you can connect Cohere to Infragistics XamDataGrid to build dynamic grids.
-
Connect to AlloyDB Data from AWS Glue
Use CData Connect AI to gain access to live AlloyDB data from your AWS Glue jobs.
-
Query Slack Data as a MySQL Database in Node.js
Execute MySQL queries against Slack data from Node.js.
-
Integrating Dataiku with AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live AlloyDB data.
-
How to Connect DBeaver to Pushbullet via a JDBC Driver
Manage Pushbullet data with visual tools in DBeaver like the query browser.
-
Connect to Zuora Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zuora and the Script function in FileMaker Pro to connect to Zuora and work with Zuora data in your FileMaker application.
-
Integrate VWO Data in Pentaho Data Integration
Build ETL pipelines based on VWO data in the Pentaho Data Integration tool.
-
Work with Pipeliner CRM Data in FoxPro
Load Pipeliner CRM data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Live SAP Ariba Procurement 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 SAP Ariba Procurement data through a conversational interface.
-
Bridge Zoho Books Connectivity with Apache NiFi
Access and process Zoho Books data in Apache NiFi using the CData JDBC Driver.
-
Integrate Theia IDE with Live Trello 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 Trello data from within the development environment.
-
Feed LaunchDarkly Data into FineReport
How to set LaunchDarkly data as a JDBC data source in FineReport.
-
Integrate Live HBase Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to HBase data and integrate live HBase data into apps built in Microsoft Power Apps.
-
Create Data Visualizations in Cognos BI with Zoho Creator Data
Access Zoho Creator data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Slack Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Slack data through MCP integration.
-
How to Connect to Live Gmail Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Gmail data for you.
-
Integrate Toggl with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Toggl with External Services.
-
How to Connect to Dotmailer Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Dotmailer data. Leverage the pyodbc module for ODBC in Python.
-
Manage Power BI XMLA Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Power BI XMLA.
-
How to Build an ETL App for GitLab Data in Python with CData
Create ETL applications and real-time data pipelines for GitLab data in Python with petl.
-
Integrate Devin with Live SAP Netweaver Gateway 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 SAP Netweaver Gateway data.
-
Visualize Workable Data in Tableau
The CData ODBC driver for Workable enables you integrate Workable data into Tableau dashboards.
-
Analyze SAS Data Sets Data in Cognos Analytics
Use CData Connect AI to connect to SAS Data Sets Data from Cognos Analytics and analyze live SAS Data Sets data.
-
Connect to SAP HANA XS Advanced Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP HANA XS Advanced data in Google Apps Script.