CData Software - Knowledge Base
Recent Articles
-
How to Build an ETL App for AfterShip Data in Python with CData
Create ETL applications and real-time data pipelines for AfterShip in Python with petl.
-
Use Azure AI Foundry to Talk to Your SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SAS XPORT for you.
-
Connect and Query Live Avalara AvaTax Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Avalara AvaTax into Databricks
-
Create Splunk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Splunk data access from reports, embedded analytics, and more.
-
Integrate Live Bright Data Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Bright Data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Analyze Live Certinia Data in SAS Viya
Use CData Connect AI to connect to Certinia from SAS Viya and deploy self-service analytics using live Certinia.
-
Deploy the ADO.NET Provider for Perigon on an SSRS Report Server
Connect to Perigon 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.
-
How to Connect to Couchbase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Couchbase. Leverage the pyodbc module for ODBC in Python.
-
Connect to BambooHR Data from a Connection Pool in Jetty
The BambooHR JDBC Driver supports connection pooling: This article shows how to connect faster to BambooHR from Web apps in Jetty.
-
Integrate with Paylocity Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Paylocity to a JSON file on disk.
-
Integrate CircleCI Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CircleCI from Informatica Cloud.
-
ETL Redis in Oracle Data Integrator
This article shows how to transfer Redis into a data warehouse using Oracle Data Integrator.
-
DataBind Oracle Financials Cloud Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Oracle Financials Cloud with the DevExpress Windows Forms and Web controls to provide Oracle Financials Cloud to a chart.
-
Connect GitHub to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect GitHub with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Clockify with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Clockify with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Clockify.
-
Automate MarkLogic Data Replication to SAP HANA
Use CData Sync to customize and automate MarkLogic replication to SAP HANA.
-
How to Query Live Act CRM Data in Claude Desktop
Connect to and query live Act CRM Data in Claude Desktop using CData MCP Server.
-
Connect to CircleCI Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to CircleCI and work with CircleCI in your FileMaker application.
-
How to Build an ETL App for JobNimbus Data in Python with CData
Create ETL applications and real-time data pipelines for JobNimbus in Python with petl.
-
Integrating Gumloop with SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Ariba Source within automated workflows.
-
Query Cvent Data in DataGrip
Create a Data Source for Cvent in DataGrip and use SQL to query live Cvent.
-
Use Biml to Build SSIS Tasks to Replicate Exa Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Exa to SQL Server.
-
Integrate Live Box Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Box and integrate live Box into apps built in Microsoft Power Apps.
-
Query Airtable Data in ColdFusion
Write standard ColdFusion data access code to connect to Airtable.
-
Build Semantic Layer Views for PolarTeamPro Data in APOS Live Data Gateway
Use the CData Connector for PolarTeamPro in APOS Live Data Gateway to build Semantic Layer Views for PolarTeamPro.
-
Query Printify Data in DataGrip
Create a Data Source for Printify in DataGrip and use SQL to query live Printify.
-
Getting Started with the CData Excel Add-In for Intercom
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Intercom.
-
Query Codat Data in DataGrip
Create a Data Source for Codat in DataGrip and use SQL to query live Codat.
-
How to Seamlessly Import MailerLite Data into IBM SPSS Modeler
Integrate MailerLite data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Amazon S3-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Amazon S3 to explore live Amazon S3 Data in Claude Code to assist with building Amazon S3-powered applications.
-
Connect to Clockify Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate Opsgenie Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Opsgenie from PowerShell? This article demonstrates how to utilize the Opsgenie Cmdlets for tasks like connecting to Opsgenie, automating operations, downloading data, and more.
-
Configure the CData JDBC Driver for Timely in a Connection Pool in Tomcat
Connect to Timely from a connection pool in Tomcat.
-
Automated Continuous Zoho Projects Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Apache Kafka.
-
Automate Sage Intacct Data Replication to Couchbase
Use CData Sync to Customize and automate Sage Intacct replication to Couchbase.
-
Getting Started with the CData Excel Add-In for Trello
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Trello.
-
Integrating Cursor CLI with Freshservice 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.
-
Integrate with Live Zuora Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Zuora from the MuleSoft Anypoint Platform to integrate live Zuora into custom reports and dashboards.
-
Create Dynamic Azure DevOps Grids Using the Infragistics XamDataGrid
Learn how you can connect Azure DevOps to Infragistics XamDataGrid to build dynamic grids.
-
Integrating LangGraph with Authorize.Net Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Authorize.Net within automated workflows.
-
Automated Continuous Attio Replication to SQLite
Use CData Sync for automated, continuous, customizable Attio replication to SQLite.
-
Integrate Rebilly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Rebilly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Rebilly.
-
Migrating data from Printify to Google BigQuery using CData SSIS Components.
Easily push Printify to Google BigQuery using the CData SSIS Tasks for Printify and Google BigQuery.
-
Configure the CData JDBC Driver for Insightly in a Connection Pool in Tomcat
Connect to Insightly from a connection pool in Tomcat.
-
Create a Data Access Object for MongoDB Data using JDBI
A brief overview of creating a SQL Object API for MongoDB in JDBI.
-
How to connect to SAP HANA Data from Spring Boot
Connect to SAP HANA in a Spring Boot Application using the CData JDBC Driver for SAP HANA
-
Connect Google Tasks Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Tasks using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Automated Facebook-Connected Workflows in Zapier
Use CData Connect AI to connect to live Facebook and build automated workflows in Zapier.
-
Replicate Multiple Tanda Accounts
Replicate multiple Tanda accounts to one or many databases.
-
How to connect to SAP SuccessFactors Data from Spring Boot
Connect to SAP SuccessFactors in a Spring Boot Application using the CData JDBC Driver for SAP SuccessFactors
-
Analyze Zoho Books Data in Looker
Use CData Connect AI to connect to Zoho Books Data from Looker and build custom apps using live Zoho Books.
-
How to Work with Mouseflow Data in AWS Glue Jobs Using JDBC
Connect to Mouseflow from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Seamlessly Import Microsoft Teams Data into IBM SPSS Modeler
Integrate Microsoft Teams data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Perigon Reporting in OBIEE with the Perigon JDBC Driver
Deploy the Perigon JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate Toggl Data Replication to Couchbase
Use CData Sync to Customize and automate Toggl replication to Couchbase.
-
How to Connect the Power BI Service to Azure Analysis Services: Complete Guide
Connect to the CData Software Power BI Connector for Azure Analysis Services from PowerBI.com to provide real-time Azure Analysis Services across the organization.
-
How to Visualize SAP Ariba Procurement Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Ariba Procurement in Python.
-
Replicate Cassandra Data to Multiple Databases
Replicate Apache Cassandra to disparate databases with a point-and-click configuration.
-
Use the CData ODBC Driver for Jira Assets from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Jira Assets to connect to Jira Assets from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Jira Assets in Excel.
-
View Reports on Real-Time Datadog Data in Power BI Report Server
Use the CData ODBC Driver for Datadog to visualize Datadog in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect and Visualize Live SAP Concur Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Concur into the Databricks platform and create visualization dashboards with real-time SAP Concur.
-
Analyze WooCommerce Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze WooCommerce in Microsoft R Open.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Amazon Marketplace to Power BI dashboards. Simply drag and drop Amazon Marketplace into data visuals on the Power BI canvas.
-
Integrating Dataiku with Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zendesk.
-
Build Automated Workflows with Live Google Search Results in Workato
Use CData Connect AI to connect to live Google Search and build automated workflows in Workato.
-
Connecting Moonlit Workflow with Azure DevOps 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 Azure DevOps in real time.
-
Analyze Exact Online Data in Cognos Analytics
Use CData Connect AI to connect to Exact Online Data from Cognos Analytics and analyze live Exact Online.
-
Connect to SpaceX Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SpaceX as an External Source in Dremio.
-
Query Browserless Data in ColdFusion
Write standard ColdFusion data access code to connect to Browserless.
-
Build AI/ML Models with Live ADP Data using Dataiku
Connect ADP Data with Dataiku using the CData JDBC Driver for ADP.
-
Connect to BigCommerce Data in CloverDX (formerly CloverETL)
Transfer BigCommerce using the visual workflow in the CloverDX data integration tool.
-
How to Query Live Facebook Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Facebook data in natural language using Python.
-
How to work with xBase Data in Apache Spark using SQL
Access and process xBase Data in Apache Spark using the CData Software JDBC Driver.
-
Extract, Transform, and Load Raisers Edge NXT Data in Informatica PowerCenter
Create a simple Workflow for Raisers Edge NXT in Informatica PowerCenter.
-
A PostgreSQL Interface for Outlook Data using the CData ODBC Driver
Use the SQL Gateway and Outlook ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live Freshteam Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Freshteam enables you to integrate Freshteam into workflows built using Microsoft Power Automate Desktop.
-
Visualize SAP SuccessFactors Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP SuccessFactors.
-
Connect to and Visualize Live Instantly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Instantly.
-
How to Build an ETL App for Apify Data in Python with CData
Create ETL applications and real-time data pipelines for Apify in Python with petl.
-
Connect to SAP SuccessFactors LMS Data in HULFT Integrate
Connect to SAP SuccessFactors LMS as a JDBC data source in HULFT Integrate
-
Excel Spreadsheet Automation on Mouseflow Data with the QUERY Formula
Pull data from Mouseflow, automate spreadsheets, and more with the QUERY formula.
-
How to Query NetSuite Data in MySQL Workbench
Execute MySQL queries against live NetSuite CRM & ERP from MySQL Workbench.
-
Deploy the ADO.NET Provider for Simplesat on an SSRS Report Server
Connect to Simplesat 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 FHIR Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable FHIR replication to delimited files (CSV/TSV).
-
Bridge Dynamics NAV Connectivity with Apache NiFi
Access and process Microsoft Dynamics NAV in Apache NiFi using the CData JDBC Driver.
-
How to Visualize Vertica 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 Vertica in Python.
-
Manage Testmonitor Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Testmonitor.
-
Connect to SAP Ariba Source Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP Ariba Source Data and connect to SAP Ariba Source in Akorbi Digital RunMyProcess.
-
Integrating LangGraph with Azure Data Lake Storage Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Azure Data Lake Storage within automated workflows.
-
Connect to Zoho CRM Data from AWS Glue
Use CData Connect AI to gain access to live Zoho CRM from your AWS Glue jobs.
-
How to Seamlessly Import MYOB AccountRight Data into IBM SPSS Modeler
Integrate MYOB AccountRight data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Provide OData Services of Suadeo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Suadeo by developing a WCF Service Application.
-
Query Cassandra Data in DataGrip
Create a Data Source for Cassandra in DataGrip and use SQL to query live Apache Cassandra.
-
Configure the CData JDBC Driver for Yelp in a Connection Pool in Tomcat
Connect to Yelp from a connection pool in Tomcat.
-
Connect to ClickUp Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software JDBC Driver for VWO in MicroStrategy
Connect to VWO in MicroStrategy Developer using the CData Software JDBC Driver for VWO.
-
DataBind Controls to GraphQL Data in C++Builder
DataBind to GraphQL in C++Builder with standard components and controls.
-
How to Access Perigon Data Using Entity Framework
This article shows how to access Perigon using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to import Shortcut Data into Apache Solr
Use the CData Software JDBC Driver for Shortcut in Data Import Handler and create an automated import of Shortcut to Apache Solr Enterprise Search platform.
-
Create Reports with Jira Assets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Jira Assets.