CData Software - Knowledge Base
Recent Articles
-
Connect to ConvertAPI Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create Informatica Mappings From/To a JDBC Data Source for Outlook
Create Outlook data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
ETL Xero in Oracle Data Integrator
This article shows how to transfer Xero Accounting into a data warehouse using Oracle Data Integrator.
-
Visualize Power BI XMLA 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 Power BI XMLA into TIBCO Spotfire.
-
Create Data Visualizations in Cognos BI with Float Data
Access Float as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze Oracle Eloqua Data in Cognos Analytics
Use CData Connect AI to connect to Oracle Eloqua Data from Cognos Analytics and analyze live Oracle Eloqua.
-
Automated Continuous AdRoll Replication to SQLite
Use CData Sync for automated, continuous, customizable AdRoll replication to SQLite.
-
How to Query Live GetResponse Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live GetResponse data in natural language using Python.
-
Viewing CircleCI Data in RAD Studio Data Explorer
How to view CircleCI in RAD Studio Data Explorer using the CData ODBC Driver for CircleCI.
-
Connect to Bannerbear Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Bannerbear and work with Bannerbear in your FileMaker applications.
-
Connect to and Visualize Live Anaplan Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Anaplan.
-
Getting Started with the CData Connect AI Python SDK for ADP
Install the CData Connect AI Python SDK to read and write live ADP with standard DB-API 2.0 Python code.
-
Build Xero-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Xero to explore live Xero Data in GitHub Copilot to assist with building Xero-powered applications.
-
Create a Data Access Object for Microsoft Entra ID Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Entra ID in JDBI.
-
Integrate JSON Services in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live JSON from Informatica Cloud.
-
Visualize Vercel Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Vercel.
-
Edit and Search BigQuery External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google BigQuery to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create BigQuery objects that you can access from apps and the dashboard.
-
Connect to Microsoft Exchange Data in RazorSQL
Connect to Microsoft Exchange from wizards and query Microsoft Exchange from the GUI in the RazorSQL database management tool.
-
How to Connect Flowise AI Agents to Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics without replication.
-
Integrate with Quickbase Data in JReport Designer
Create charts and reports based on Quickbase in JReport Designer.
-
How to Connect the Power BI Service to Avaza: Complete Guide
Connect to the CData Software Power BI Connector for Avaza from PowerBI.com to provide real-time Avaza across the organization.
-
Provide OData Services of SFTP Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SFTP by developing a WCF Service Application.
-
Build NetSuite-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for NetSuite to explore live NetSuite Data in GitHub Copilot to assist with building NetSuite-powered applications.
-
Access Pinecone Data from MySQL in PHP
Connect to Pinecone through the standard MySQL libraries in PHP.
-
Integrate xBase Data in the Pentaho Report Designer
Publish reports based on xBase in the Pentaho BI tool.
-
Build Semantic Layer Views for Keap Data in APOS Live Data Gateway
Use the CData Connector for Keap in APOS Live Data Gateway to build Semantic Layer Views for Keap.
-
Integrate Cline with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Exact Online from within your IDE.
-
Connect to Real-Time CircleCI Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use CircleCI in Power Apps.
-
Connect to LinkedIn Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for LinkedIn in the Denodo Virtual DataPort Administrator.
-
Access Live Wistia Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Wistia into the statistical analysis tools available in SAS JMP. This article shows how to use Wistia in the Graph Builder and Query Builder.
-
Connect to Azure Table Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Azure Table Data and connect to Azure Table Storage in Akorbi Digital RunMyProcess.
-
How to Connect to & Open Google Ads Data in Microsoft Excel
This article uses the CData ODBC driver for Google Ads to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Object-Relational Mapping (ORM) with Paymo Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Paymo into a Java-based ORM framework, Hibernate.
-
Create Informatica Mappings From/To a JDBC Data Source for Simplesat
Create Simplesat data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create OData-Connected Business Apps in AppSheet
Connect to OData Services via CData Connect AI in Google AppSheet and create custom business applications with real-time access to OData.
-
Create Data Visualizations in Cognos BI with Parallel Data
Access Parallel as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Easily Query Mailjet Data in OpenOffice Base
Connect to Mailjet data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Mouseflow from Asprova with CData Software ODBC Driver for Mouseflow
This article shows how to connect faster to Mouseflow data from Asprova.
-
Create SurveyMonkey-Connected Dashboards in Grafana
Connect to SurveyMonkey Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SurveyMonkey.
-
How to Connect to Live Tally 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 Tally ERP for you.
-
Visualize SageHR Data in TIBCO Spotfire through ADO.NET
Integrate SageHR into dashboards in TIBCO Spotfire.
-
Connect to Accelo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Accelo as an External Source in Dremio.
-
Visualize Live Cloudflare Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Cloudflare using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Zoho CRM Data in DataGrip
Create a Data Source for Zoho CRM in DataGrip and use SQL to query live Zoho CRM.
-
Integrate with SharePoint Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft SharePoint in SnapLogic.
-
Create Datasets from Asana in Domo Workbench and Build Visualizations of Asana Data in Domo
Use the CData Software ODBC Driver for Asana to create datasets from Asana in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Zoho Creator Replication to SQLite
Use CData Sync for automated, continuous, customizable Zoho Creator replication to SQLite.
-
ETL Couchbase in Oracle Data Integrator
This article shows how to transfer Couchbase into a data warehouse using Oracle Data Integrator.
-
Integrate with Basecamp Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Basecamp to a JSON file on disk.
-
Create Reports with xBase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date xBase.
-
Query Google Contacts Data as a MySQL Database in Node.js
Execute MySQL queries against Google Contacts from Node.js.
-
Query Deel Data in ColdFusion
Write standard ColdFusion data access code to connect to Deel.
-
How to Query FreeAgent Data in MySQL Workbench
Execute MySQL queries against live FreeAgent from MySQL Workbench.
-
How to Connect to Excel Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Excel. Leverage the pyodbc module for ODBC in Python.
-
Create MarkLogic-Connected Nintex Workflows
Use CData Connect AI to connect to MarkLogic Data from Nintex Workflow Cloud and build custom workflows using live MarkLogic.
-
Integrate Email Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Email and integrate live Email into your Power Automate tasks.
-
Integrate Live Office 365 Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Office 365 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Office 365.
-
Integrate LinkedIn Ads with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate LinkedIn Ads with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to LinkedIn Ads.
-
How to Access Live MariaDB Data in Visual Studio Code via Cline
Run CData MCP Server for MariaDB on Windows Subsytem for Linux (WSL) and connect to live MariaDB from the Cline extension in Visual Studio Code.
-
Access Todoist Data from MySQL in PHP
Connect to Todoist through the standard MySQL libraries in PHP.
-
Use the CData Software ODBC Driver for Mailjet in MicroStrategy Web
Connect to Mailjet in MicroStrategy Web using the CData Software ODBC Driver for Mailjet.
-
Query Google Contacts Data in DataGrip
Create a Data Source for Google Contacts in DataGrip and use SQL to query live Google Contacts.
-
Use Dash to Build to Web Apps on PagerDuty Data
Create Python applications that use pandas and Dash to build PagerDuty-connected web apps.
-
Build Voice Agents in ElevenLabs with access to Live NetSuite Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live NetSuite CRM & ERP.
-
Build Apps with Live Jira Assets in Adalo using CData Connect AI
Use CData Connect AI to integrate live Jira Assets into the Adalo platform and build custom mobile and web applications with real-time Jira Assets.
-
Natively Connect to CampaignMonitor Data in PHP
The CData ODBC driver for CampaignMonitor enables you to create PHP applications with connectivity to CampaignMonitor. Leverage the native support for ODBC in PHP.
-
Connect to Couchbase 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 Couchbase.
-
Access Live IBM Informix Data in Coginiti Pro
Connect to and query live IBM Informix from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze SAP Netweaver Gateway Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP Netweaver Gateway and visualize SAP Netweaver Gateway in SAP Analytics Cloud.
-
Use Azure AI Foundry to Talk to Your Blackbaud FE NXT 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 Blackbaud FE NXT for you.
-
Access Live Sugar CRM Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Sugar CRM from your Excel spreadsheets.
-
Use Grok to Talk to Your Adobe Analytics 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 Adobe Analytics for you.
-
Build AI/ML Models with Live ClickTime Data using Dataiku
Connect ClickTime Data with Dataiku using the CData API Driver for JDBC.
-
Write a Simple Go Application to work with Cohere Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Cohere.
-
Use Databricks Agent Bricks to Talk to Your Oracle Financials Cloud Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Oracle Financials Cloud for you.
-
Connect to Real-Time Zoho Inventory Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zoho Inventory and Dataflow to import and use Zoho Inventory in Power Apps.
-
Use CData Connect AI to Access SAP HANA Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP HANA in the Power Pivot business intelligence tool.
-
Connect to and Query Act-On Data in QlikView over ODBC
Create data visualizations with Act-On in QlikView.
-
Integrate with Azure DevOps Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure DevOps to a JSON file on disk.
-
Bridge Monday.com Connectivity with Apache NiFi
Access and process Monday.com in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Zendesk Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zendesk replication to MongoDB.
-
Visualize Parallel Data in Sisense
Create an ElastiCube in Sisense app with access to Parallel.
-
How to connect to ConvertAPI Data from IntelliJ
Integrate connectivity to ConvertAPI with wizards in IntelliJ.
-
Getting Started with the CData JDBC Driver for Google Tasks
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Tasks.
-
Operational Reporting on Tally Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Tally ERP.
-
Connect to Kafka Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Kafka from Appeon PowerBuilder using the CData ADO.NET Provider for Kafka.
-
Connect to Templated Data in DBArtisan
Use wizards in DBArtisan to configure Templated as a data source.
-
Build AI/ML Models with Live Freshdesk Data using Dataiku
Connect Freshdesk Data with Dataiku using the CData JDBC Driver for Freshdesk.
-
Visualize Browserless 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 Browserless into TIBCO Spotfire.
-
How to integrate Metabase with Workday Data
Use CData Connect AI to connect to live Workday and create an interactive dashboard in Metabase from Workday.
-
How to connect SharePoint with Email Data through external lists
Provide Email to SharePoint users as an external list.
-
Automate Adobe Analytics Data Replication to Azure Data Lake
Use CData Sync to customize and automate Adobe Analytics replication to Azure Data Lake.
-
Add Google Tasks Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Tasks with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Todoist Replication to Databricks
Use CData Sync for automated, continuous, customizable Todoist replication to Databricks.
-
Back Up MySQL to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MySQL. In this article, we will employ an SSIS workflow to populate a database with MySQL data.
-
Choosing the Best Method to Connect Amazon Athena to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amazon Athena from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Validate Wrike Data with QuerySurge
Access and validate Wrike in QuerySurge using the CData JDBC Driver.
-
Integrating LangGraph with Zoho Projects Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zoho Projects within automated workflows.
-
Build Apps with Live Gorgias Data Using the Low-Code Development Platform of Mendix
Connect Gorgias with Mendix to build apps using the CData API Driver for JDBC.
-
How to load Pipedrive data into Elasticsearch via Logstash
Introducing a simple method to load Pipedrive data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.