CData Software - Knowledge Base
Recent Articles
-
Migrating data from Airtable to Databricks using CData SSIS Components.
Easily push Airtable to Databricks using the CData SSIS Tasks for Airtable and Databricks.
-
Access Google Cloud Storage Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Cloud Storage.
-
Integrate Real-Time Access to Certinia in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Certinia in real time.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PolarTeamPro
Provide connectivity to PolarTeamPro through an SAP BusinessObjects universe.
-
Build Scrapfly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Scrapfly and build web apps with connectivity to live Scrapfly.
-
Configure the CData JDBC Driver for Accelo in a Connection Pool in Tomcat
Connect to Accelo from a connection pool in Tomcat.
-
Import Active Directory Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Active Directory. In this article, you will use the OData format to import Active Directory into Microsoft Power Query.
-
Integrate Azure Data Lake Storage Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure Data Lake Storage from Informatica Cloud.
-
How to Visualize Greenhouse Data in Python with pandas
Use pandas and other modules to analyze and visualize live Greenhouse in Python.
-
Integrate Pinterest with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Pinterest with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pinterest.
-
Integrate Open WebUI with Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Amazon S3 from within the chat interface.
-
Automated HelloSign Data Replication to Teradata
Use CData Sync to Customize and automate HelloSign replication to Teradata.
-
Connect to and Visualize Live Databricks Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Databricks.
-
Use the CData Software ODBC Driver for Facebook in SAS for Real-Time Reporting and Analytics
Connect to real-time Facebook in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Facebook.
-
Connect to Ontraport Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Ontraport in the Denodo Virtual DataPort Administrator.
-
Connect to SageHR 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 SageHR and work with SageHR in your FileMaker application.
-
LINQ to JSON Services
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 JSON Data Provider.
-
Access Live SageHR Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SageHR into the statistical analysis tools available in SAS JMP. This article shows how to use SageHR in the Graph Builder and Query Builder.
-
Query Office 365 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Office 365 from Node.js.
-
How to Connect Flowise AI Agents to Live ServiceNow Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live ServiceNow without replication.
-
Automated Continuous Clari Replication to Oracle
Use CData Sync for automated, continuous, customizable Clari replication to Oracle.
-
How to connect to Act-On Data with Squirrel SQL client
Connect to Act-On and execute queries in the Squirrel SQL Client.
-
How to Create Power BI Visual Reports with Real-Time Front Data
Use CData Power BI Connectors to visualize Front in Power BI.
-
Visualize Live OData Services in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live OData.
-
Integrate Live BigQuery Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to BigQuery from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google BigQuery.
-
Connect to Xero Data in Aqua Data Studio
Access Xero Accounting from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Cursor CLI with Workable 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.
-
Connect Microsoft Ads to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Microsoft Ads with IBM WebSphere for seamless data integration and connectivity.
-
Connect to CapsuleCRM from Asprova with CData Software ODBC Driver for CapsuleCRM
This article shows how to connect faster to CapsuleCRM data from Asprova.
-
Design BIRT Reports on BenchmarkEmail Data
Provide current BenchmarkEmail to your embedded analytics.
-
Build TaxJar-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for TaxJar to explore live TaxJar Data in Claude Code to assist with building TaxJar-powered applications.
-
Connect to SAP Ariba Procurement Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Ariba Procurement.
-
Build Dashboards with Jira Data in DBxtra
Create dynamic dashboards and perform analytics based on Atlassian Jira in DBxtra.
-
Connect to Asana Data from AWS Glue
Use CData Connect AI to gain access to live Asana from your AWS Glue jobs.
-
Connect to AfterShip Data in JRuby
Create a simple JRuby app with access to live AfterShip.
-
Connect to Bullhorn CRM Data in ACL Analytics
Connect to Bullhorn CRM via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Bullhorn CRM.
-
Use Grok to Talk to Your LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your LinkedIn Ads for you.
-
Connect to and Visualize Live IBM Cloud Object Storage Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live IBM Cloud Object Storage.
-
How to Connect to Zoho Recruit Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho Recruit. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData JDBC Driver for Splunk
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Splunk.
-
Integrating Codex CLI with PDFMonkey 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.
-
Visualize HelloSign Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to HelloSign.
-
Edit and Search XML External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of XML Files to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create XML objects that you can access from apps and the dashboard.
-
Access Live Google Forms Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Forms in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Google Forms Data in RapidMiner
Integrate Google Forms with standard components and data source configuration wizards in RapidMiner Studio.
-
Query BenchmarkEmail Data as a MySQL Database in Node.js
Execute MySQL queries against BenchmarkEmail from Node.js.
-
DataBind Controls to Mouseflow Data in C++Builder
DataBind to Mouseflow in C++Builder with standard components and controls.
-
Query CockroachDB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CockroachDB from Node.js.
-
Use Dash to Build to Web Apps on Adobe Experience Manager Data
Create Python applications that use pandas and Dash to build Adobe Experience Manager-connected web apps.
-
Connect to Unbounce Data in DBArtisan
Use wizards in DBArtisan to configure Unbounce as a data source.
-
Build AI Agents with Microsoft Ads 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 Microsoft Ads through CData Connect AI.
-
Build Instagram-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Instagram Data from Zoho Analytics and import live Instagram.
-
Feed Pipeline CRM Data into FineReport
How to set Pipeline CRM as a JDBC data source in FineReport.
-
Build Semantic Layer Views for Amazon DynamoDB Data in APOS Live Data Gateway
Use the CData Connector for Amazon DynamoDB in APOS Live Data Gateway to build Semantic Layer Views for Amazon DynamoDB.
-
Viewing GraphQL Data in RAD Studio Data Explorer
How to view GraphQL in RAD Studio Data Explorer using the CData ODBC Driver for GraphQL.
-
View Reports on Real-Time Gong Data in Power BI Report Server
Use the CData ODBC Driver for Gong to visualize Gong in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData ODBC Driver for Mailjet from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mailjet to connect to Mailjet from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mailjet in Excel.
-
A PostgreSQL Interface for Azure Table Data (MySQL Remoting via JDBC)
Use the Remoting features of the Azure Table JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate SAP Fieldglass Data to Multiple Databases
Replicate SAP Fieldglass to disparate databases with a point-and-click configuration.
-
Use the CData Software ODBC Driver for ServiceDesk Plus in SAS for Real-Time Reporting and Analytics
Connect to real-time ServiceDesk Plus in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ServiceDesk Plus.
-
Connect to ADP Data from a Connection Pool in Jetty
The ADP JDBC Driver supports connection pooling: This article shows how to connect faster to ADP from Web apps in Jetty.
-
Use Biml to Build SSIS Tasks to Replicate MYOB AccountRight Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate MYOB AccountRight to SQL Server.
-
Connect to SAP Ariba Procurement Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Ariba Procurement to connect to SAP Ariba Procurement and execute queries in PowerBuilder.
-
Use Claude to Talk to Your Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Azure Cosmos DB for you.
-
How to connect to Kintone Data in DBVisualizer
Integrate Kintone with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Databricks Agent Bricks to Talk to Your SAP Netweaver Gateway Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Netweaver Gateway for you.
-
Build Pipelines with Live Box Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Box from Google Cloud Data Fusion, enabling the integration of live Box into the building and management of effective data pipelines.
-
Analyze Live HCL Domino Data in SAS Viya
Use CData Connect AI to connect to HCL Domino from SAS Viya and deploy self-service analytics using live HCL Domino.
-
GitLab Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to GitLab through CData Connect AI using different applications and tools.
-
Access Live Jira Assets Data in Excel 365 Online (Excel for the web)
Connect to Jira Assets from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live SAP Concur Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Concur into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Concur in the Graph Builder and Query Builder.
-
Analyze Google Drive Data in Cognos Analytics
Use CData Connect AI to connect to Google Drive Data from Cognos Analytics and analyze live Google Drive.
-
Create a Data Access Object for QuickBooks Online Data using JDBI
A brief overview of creating a SQL Object API for QuickBooks Online in JDBI.
-
How to Work with Amazon S3 Data in AWS Glue Jobs Using JDBC
Connect to Amazon S3 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to & Open AfterShip Data in Microsoft Excel
This article uses the CData ODBC driver for AfterShip to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect to SendInBlue Data from IntelliJ
Integrate connectivity to SendInBlue with wizards in IntelliJ.
-
Create Xero Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Xero from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData API Server to Access Adobe Target Data in Microsoft PowerPivot
Use the CData API Server to connect to live Adobe Target in the Power Pivot business intelligence tool.
-
How to load Eventbrite data into Elasticsearch via Logstash
Introducing a simple method to load Eventbrite data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
DataBind Charts to Simplesat Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Simplesat from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to connect to SAS xpt Data from Spring Boot
Connect to SAS xpt in a Spring Boot Application using the CData JDBC Driver for SAS xpt
-
Getting Started with the CData JDBC Driver for JobNimbus
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for JobNimbus.
-
Connect to Front Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Front in the Denodo Virtual DataPort Administrator.
-
Query Sage 200 Data in ColdFusion
Write standard ColdFusion data access code to connect to Sage 200.
-
Automated Continuous Avaza Replication to SQL Server
Use CData Sync for automated, continuous, customizable Avaza replication to SQL Server.
-
Connect to Pipedrive Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to integrate MessageBird with Apache Airflow
Access and process MessageBird in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Grafana Replication to Oracle
Use CData Sync for automated, continuous, customizable Grafana replication to Oracle.
-
Create Data Visualizations in Cognos BI with ShipEngine Data
Access ShipEngine as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Datasets from Certinia in Domo Workbench and Build Visualizations of Certinia Data in Domo
Use the CData Software ODBC Driver for Certinia to create datasets from Certinia in Domo Workbench and then build visualizations in the Domo service.
-
Connect to MongoDB Data in JRuby
Create a simple JRuby app with access to live MongoDB.
-
Connect to Azure Data Catalog Data in DBArtisan
Use wizards in DBArtisan to configure Azure Data Catalog as a data source.
-
Visualize ZohoPeople Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoPeople.
-
Getting Started: Custom MCP Tools in CData Connect AI
Learn how to create Custom MCP Tools in CData Connect AI to give AI agents precise, reusable operations over your live data.
-
Integrating Claude Code with Sage Cloud Accounting Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Sage Business Cloud Accounting within assisted coding and automated development workflows.
-
A PostgreSQL Interface for ActiveCampaign Data (MySQL Remoting via JDBC)
Use the Remoting features of the ActiveCampaign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Dashboards and Visualize Live Dynamics 365 Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Dynamics 365 and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Deploy the ADO.NET Provider for Basecamp on an SSRS Report Server
Connect to Basecamp 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.
-
DataBind Controls to Bannerbear Data in Delphi
DataBind to Bannerbear in Delphi with standard data access components and controls.
-
Connect to ActiveCampaign Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ActiveCampaign from Filemaker Pro on Mac.