CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Phoenix Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Phoenix replication to Azure SQL Database.
-
How to Easily Query Azure DevOps Data in OpenOffice Base
Connect to Azure DevOps data in OpenOffice Base using the CData ODBC Driver for Azure DevOps and generate reports with live data insights.
-
Automated Continuous Act CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Act CRM replication to delimited files (CSV/TSV).
-
Connect to and Query Okta Data in QlikView over ODBC
Create data visualizations with Okta data in QlikView.
-
Prepare, Blend, and Analyze Bullhorn CRM Data in Alteryx Designer (ODBC)
Build workflows to access live Bullhorn CRM data for self-service data analytics.
-
Visualize Live Suadeo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Suadeo data into custom reports in Power BI.
-
How to Connect to Live Trello 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 Trello data for you.
-
Automated Continuous Smartsheet Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Smartsheet replication to IBM DB2.
-
Migrating data from Azure Analysis Services to Snowflake using CData SSIS Components.
Easily push Azure Analysis Services data to Snowflake using the CData SSIS Tasks for Azure Analysis Services and Snowflake.
-
Automate ChargeOver Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ChargeOver data from PowerShell? This article demonstrates how to utilize the ChargeOver Cmdlets for tasks like connecting to ChargeOver data, automating operations, downloading data, and more.
-
Use Dash to Build Web Apps on ShipEngine Data via CData Connect AI
Build interactive Dash web apps on live ShipEngine data using pandas and the CData Connect AI Python SDK.
-
Search External PingOne Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of PingOne data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create PingOne Data objects that you can access from apps and the dashboard.
-
Visualize Wave Financial Data in TIBCO Spotfire through ADO.NET
Integrate Wave Financial data into dashboards in TIBCO Spotfire.
-
Integrating LangGraph with JSON Services via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on JSON services within automated workflows.
-
Work with RabbitMQ Data in FoxPro
Load RabbitMQ data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Live SAP Ariba Procurement Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Ariba Procurement data.
-
Operational Reporting on Mouseflow Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Mouseflow data.
-
How to Connect to Live Box Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Box data for you.
-
Use Manus AI to Talk to Your Zoho Creator 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 Creator data.
-
Connect to Acumatica Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Acumatica to connect to Acumatica data and execute queries in PowerBuilder.
-
How to Build an ETL App for DocuSign Data in Python with CData
Create ETL applications and real-time data pipelines for DocuSign data in Python with petl.
-
How to connect to ShipStation Data with Squirrel SQL client
Connect to ShipStation data and execute queries in the Squirrel SQL Client.
-
Visualize Flowlu Data in Tableau
The CData ODBC driver for Flowlu enables you integrate Flowlu data into Tableau dashboards.
-
Create Workday-Connected Business Apps in AppSheet
Connect to Workday Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Workday data.
-
Build Microsoft Planner-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft Planner Data and create custom apps in Mendix.
-
Publish Crystal Reports on Freshsales Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Freshsales data.
-
Connect to Asana Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Asana Data and connect to Asana data in Akorbi Digital RunMyProcess.
-
Connect to Freshdesk Data in Claris FileMaker Pro
Use the CData ODBC Driver for Freshdesk in FileMaker Pro to connect to Freshdesk and work with Freshdesk data in your FileMaker applications.
-
How to connect to Google Drive Data from Spring Boot
Connect to Google Drive in a Spring Boot Application using the CData JDBC Driver for Google Drive
-
Visualize Live IBM Informix Data in the Power BI Service
Use CData Connect AI to connect to live IBM Informix data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Manus AI to Talk to Your Facebook 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 Facebook data.
-
Integrate Live Monday.com Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Monday.com data to Blue Prism using the CData ODBC Driver for Monday.com to create automated workflows for repetitive business tasks.
-
Publish Timely-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Timely data.
-
Connect to Pinterest Data in RapidMiner
Integrate Pinterest data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect to Accelo Data in DBVisualizer
Integrate Accelo data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Oracle Eloqua Reporting Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle Eloqua Reporting to connect to Oracle Eloqua Reporting data and execute queries in PowerBuilder.
-
Connect to Live Adobe Target Data in MicroStrategy through CData Connect AI
Create a live connection to Adobe Target Data in CData Connect AI and connect to your Adobe Target data from MicroStrategy.
-
Connect to Auth0 Data in RazorSQL
Connect to Auth0 from wizards and query Auth0 data from the GUI in the RazorSQL database management tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Ads
Provide connectivity to Google Ads data through an SAP BusinessObjects universe.
-
Integrate with Salesloft Data in JReport Designer
Create charts and reports based on Salesloft data in JReport Designer.
-
Back Up SAP Netweaver Gateway data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Netweaver Gateway. In this article, we will employ an SSIS workflow to populate a database with SAP Netweaver Gateway data data.
-
Integrate Close Data in the Pentaho Report Designer
Publish reports based on Close data in the Pentaho BI tool.
-
Visualize Live ZohoPeople Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ZohoPeople data into custom reports in Power BI.
-
Integrate Jodoo Data in the Pentaho Report Designer
Publish reports based on Jodoo data in the Pentaho BI tool.
-
How to Visualize Anaplan 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 Anaplan data in Python.
-
Replicate Teradata Data in Heroku for Use in Salesforce Connect
Replicate Teradata data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Live Stripe Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Stripe data for you.
-
Build TaxJar Visualizations in Tableau Desktop
Use CData Connect AI to connect to live TaxJar data and build visualizations in Tableau.
-
A PostgreSQL Interface for Mocean Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mocean JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live Asana Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Asana enables you to integrate Asana data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Dataiku with Grafana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Grafana data.
-
Natively Connect to Google Analytics Data in PHP
The CData ODBC driver for Google Analytics enables you to create PHP applications with connectivity to Google Analytics data. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze Workday Data in Alteryx Designer (Connect AI)
Build workflows to access live Workday data for self-service data analytics.
-
Connect to Tickspot Data in Jaspersoft Studio
Execute SQL to remote Tickspot data in Jaspersoft Studio.
-
LinkedIn Ads Reporting in OBIEE with the LinkedIn Ads JDBC Driver
Deploy the LinkedIn Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to publish and share Apollo Data dashboards with Tableau Server
The CData ODBC driver for Apollo enables you integrate Apollo data into Tableau dashboards.
-
Import Real-Time Teamwork Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Teamwork data in ColdFusion.
-
Use the CData Software ODBC Driver for Lakebase in MicroStrategy
Connect to Lakebase data in MicroStrategy Developer using the CData Software ODBC Driver for Lakebase.
-
Integrate Brex Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Brex data from Informatica Cloud.
-
Getting Started with the CData Connect AI Python SDK for SAP Concur
Install the CData Connect AI Python SDK to read and write live SAP Concur data with standard DB-API 2.0 Python code.
-
Analyze iContact Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze iContact data in Microsoft R Open.
-
Connect to Live Active Directory Data in MicroStrategy through CData Connect AI
Create a live connection to Active Directory Data in CData Connect AI and connect to your Active Directory data from MicroStrategy.
-
Integrate with Greenhouse Data in JReport Designer
Create charts and reports based on Greenhouse data in JReport Designer.
-
Getting Started with the CData Connect AI Python SDK for XML
Install the CData Connect AI Python SDK to read and write live XML data with standard DB-API 2.0 Python code.
-
Automate Rebilly Data Replication to SAP HANA
Use CData Sync to customize and automate Rebilly data replication to SAP HANA.
-
Access Live Oracle Data in AWS Lambda
Connect to live Oracle data in AWS Lambda using the CData JDBC Driver.
-
Back Up Microsoft Teams data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Teams. In this article, we will employ an SSIS workflow to populate a database with Microsoft Teams data data.
-
Use the CData Software ODBC Driver for Mistral AI in MicroStrategy
Connect to Mistral AI data in MicroStrategy Developer using the CData Software ODBC Driver for Mistral AI.
-
Connect to Slack Data in DBArtisan
Use wizards in DBArtisan to configure Slack data as a data source.
-
Build Vertica Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Vertica data and build visualizations in Tableau Cloud.
-
Build a Simple VCL Application for Postmark Data
How to build a simple VCL Application to view Postmark data in RAD Studio using the CData ODBC Driver for Postmark.
-
Analyze Clio Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Clio data with the CData JDBC Driver for Clio.
-
Use the CData Software ODBC Driver for Cassandra in SAS for Real-Time Reporting and Analytics
Connect to real-time Cassandra data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cassandra.
-
Analyze PabblySubscriptions Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for PabblySubscriptions from Power Pivot. You will use the Table Import Wizard to load PabblySubscriptions data. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData JDBC Driver for Anaplan
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Anaplan.
-
Build Dashboards with ChartMogul Data in DBxtra
Create dynamic dashboards and perform analytics based on ChartMogul data in DBxtra.
-
Connect to Pipeline CRM Data in RazorSQL
Connect to Pipeline CRM from wizards and query Pipeline CRM data from the GUI in the RazorSQL database management tool.
-
Integrate SQL Analysis Services Data in the Pentaho Report Designer
Publish reports based on SQL Analysis Services data in the Pentaho BI tool.
-
Build Semantic Layer Views for SAP Concur Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Concur data.
-
Connect to Exa Data in DBArtisan
Use wizards in DBArtisan to configure Exa data as a data source.
-
How to Connect to Live AfterShip Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live AfterShip data securely in real time.
-
How to Visualize Airtable 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 Airtable data in Python.
-
Build Semantic Layer Views for Act-On Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Act-On data.
-
Build AI Agents with Reckon Accounts Hosted Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Reckon Accounts Hosted data through CData Connect AI.
-
Use the CData SSIS Components to Insert New or Update Existing Bitbucket Records from SQL Server
Easily push SQL Server data to Bitbucket using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Bitbucket or update existing records with data from a SQL Server database.
-
Access Live DocuSign Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live DocuSign data from your Excel spreadsheets.
-
Replicate DocuSign Data to Multiple Databases
Replicate DocuSign data to disparate databases with a point-and-click configuration.
-
Connect to Facebook Ads in SpagoBI
Create reports featuring live Facebook Ads data in SpagoBI Studio. Host Facebook Ads reports on SpagoBI Server.
-
Connect to Shopify Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Shopify data in the Denodo Virtual DataPort Administrator.
-
Connect to Figshare Data in Aqua Data Studio
Access Figshare data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live HDFS Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live HDFS data from your Excel spreadsheets.
-
Build Data Flows from Epicor Kinetic to SQL Server using SSIS
Easily back up Epicor Kinetic data to SQL Server using the SSIS components for Epicor Kinetic.
-
Migrating data from Aircall to Databricks using CData SSIS Components.
Easily push Aircall data to Databricks using the CData SSIS Tasks for Aircall and Databricks.
-
Natively Connect to WooCommerce Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to WooCommerce data. Leverage the native support for ODBC in PHP.
-
Connect Oracle Eloqua Reporting to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle Eloqua Reporting with IBM WebSphere for seamless data integration and connectivity.
-
Automated Freshservice Data Replication to Teradata
Use CData Sync to Customize and automate Freshservice data replication to Teradata.
-
Create Shopify-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Shopify Data from OutSystems and build custom enterprise apps using live Shopify data.
-
Query SAP BusinessObjects BI Data in DataGrip
Create a Data Source for SAP BusinessObjects BI in DataGrip and use SQL to query live SAP BusinessObjects BI data.
-
Getting Started with the CData ODBC Driver for SFTP
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SFTP.
-
Visualize MessageBird Data in Sisense
Create an ElastiCube in Sisense app with access to MessageBird data.