CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with Paymo Data in DBxtra
Create dynamic dashboards and perform analytics based on Paymo in DBxtra.
-
Create Informatica Mappings From/To an ODBC Data Source for IBM Cloud Object Storage
Create an ODBC connection to IBM Cloud Object Storage in Informatica and browse and transfer IBM Cloud Object Storage.
-
Build Charts with Google Campaign Manager 360 Data in Clear Analytics
Create dynamic charts and perform analytics based on Google Campaign Manager 360 in Clear Analytics.
-
Migrating data from Google Directory to Snowflake using CData SSIS Components.
Easily push Google Directory to Snowflake using the CData SSIS Tasks for Google Directory and Snowflake.
-
How to Connect to Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics for you.
-
Access Live Freshservice Data in AWS Lambda
Connect to live Freshservice in AWS Lambda using the CData JDBC Driver.
-
How to Work with Zoho Projects Data in AWS Glue Jobs Using JDBC
Connect to Zoho Projects from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Provide OData Services of WordPress Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for WordPress by developing a WCF Service Application.
-
Connect to Snowflake Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Snowflake and the SQL Gateway to access Snowflake from Google Apps Script.
-
How to Visualize MySQL 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 MySQL in Python.
-
How to Connect Flowise AI Agents to Live Shopify 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 Shopify without replication.
-
Create OData Dataflows on PowerBI.com
Connect to the CData Power BI Connector for OData from PowerBI.com to create Power BI Dataflows with real-time data.
-
Process & Analyze Cloudflare Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Cloudflare Data.
-
Bridge Adobe Analytics Connectivity with Apache NiFi
Access and process Adobe Analytics in Apache NiFi using the CData JDBC Driver.
-
Use the CData API Server to Access SAP Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP ERP/NetWeaver in the Power Pivot business intelligence tool.
-
Analyze Microsoft Teams Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft Teams from Power Pivot. You will use the Table Import Wizard to load Microsoft Teams. You can visually build the import query or use any SQL supported by the driver.
-
Connect to and Visualize Live Sybase IQ Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sybase IQ.
-
Build Data Flows from SQL Server to SAP Ariba Source through SSIS
Easily push SQL Server data to SAP Ariba Source using the CData SSIS Tasks for SAP Ariba Source.
-
Create Data Visualizations Based On EnterpriseDB Data in Mode
Use CData Connect AI to connect to EnterpriseDB Data from Mode and build visualizations using live
-
Automated Continuous Instagram Replication to MySQL
Use CData Sync for automated, continuous, customizable Instagram replication to MySQL.
-
Integrate Theia IDE with Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build Pipelines with Live Dynamics CRM Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Dynamics CRM from Google Cloud Data Fusion, enabling the integration of live Microsoft Dynamics CRM into the building and management of effective data pipelines.
-
Connecting GenSpark with Marketo Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Marketo without any replication or custom integration required.
-
How to connect and process Humanity from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Humanity.
-
How to Connect DBeaver to OneNote via a JDBC Driver
Manage Microsoft OneNote with visual tools in DBeaver like the query browser.
-
Use JayDeBeApi to access Facebook Ads Data in Python
Use standard Python scripting and the development environment of your choice to access live Facebook Ads.
-
Query Salesforce Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Salesforce & Force.com and perform CRUD operations on Salesforce from Node.js.
-
Integrate Live Dynamics 365 Business Central Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Dynamics 365 Business Central and integrate live Dynamics 365 Business Central into apps built in Microsoft Power Apps.
-
How to Connect to Live Salesforce CRM Analytics Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Salesforce CRM Analytics through natural language.
-
Easily Integrate Amplitude Data in Lazarus Pascal IDE
Learn how to easily integrate live Amplitude in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Import Real-Time Dynamics 365 Business Central Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Dynamics 365 Business Central in ColdFusion.
-
DataBind Controls to Coinbase Data in Delphi
DataBind to Coinbase in Delphi with standard data access components and controls.
-
Connect to Jira Data from AWS Glue
Use CData Connect AI to gain access to live Atlassian Jira from your AWS Glue jobs.
-
Import Real-Time ZendeskSell Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZendeskSell in ColdFusion.
-
Build Semantic Layer Views for Sentry Data in APOS Live Data Gateway
Use the CData Connector for Sentry in APOS Live Data Gateway to build Semantic Layer Views for Sentry.
-
Visualize Dynamics CRM Data in Sisense
Create an ElastiCube in Sisense app with access to Microsoft Dynamics CRM.
-
Add Basecamp Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Basecamp with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate Coinbase Data Replication to Couchbase
Use CData Sync to Customize and automate Coinbase replication to Couchbase.
-
Consume MarkLogic OData Feeds in SAP Lumira
Use the API Server to create data visualizations on MarkLogic feeds that reflect any changes in SAP Lumira.
-
Bannerbear Reporting in OBIEE with the Bannerbear JDBC Driver
Deploy the Bannerbear JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Import Jira Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Atlassian Jira. In this article, you will use the OData format to import Atlassian Jira into Microsoft Power Query.
-
Integrate LibreChat with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Atlassian Confluence from within the chat interface.
-
Connect to SAS xpt Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAS XPORT using standard SQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MongoDB
Provide connectivity to MongoDB through an SAP BusinessObjects universe.
-
Migrating data from LinkedIn Ads to Google BigQuery using CData SSIS Components.
Easily push LinkedIn Ads to Google BigQuery using the CData SSIS Tasks for LinkedIn Ads and Google BigQuery.
-
Integrate with Zoho Recruit Data in JReport Designer
Create charts and reports based on Zoho Recruit in JReport Designer.
-
How to Build an ETL App for Gong Data in Python with CData Connect AI
Build ETL pipelines that read and write live Gong in Python with petl and the CData Connect AI Python SDK.
-
How to connect PolyBase to OpenWeatherMap
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live OpenWeatherMap.
-
Access Aweber Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Aweber from HeidiSQL.
-
How to Connect DBeaver to Amazon S3 via a JDBC Driver
Manage Amazon S3 with visual tools in DBeaver like the query browser.
-
How to Query Live GitHub Data in Claude Desktop
Connect to and query live GitHub Data in Claude Desktop using CData MCP Server.
-
Connect to Pipedrive Data in NetBeans
Connect to Pipedrive in NetBeans with the data source configuration wizard.
-
Create Data Visualizations in Cognos BI with Reckon Data
Access Reckon as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Amazon Athena Replication to Databricks
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Databricks.
-
Integrate Real-Time Access to Epicor Kinetic in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Epicor Kinetic in real time.
-
Integrate Google Spanner Data into Power Automate Desktop using CData Connect
CData Connect for Google Spanner Data enables you to integrate Google Spanner into workflows built using Microsoft Power Automate Desktop.
-
Create Informatica Mappings From/To a JDBC Data Source for Asana
Create Asana data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to ZohoSubscriptions Data from a Connection Pool in JBoss
Integrate ZohoSubscriptions into Java servlets: Use the Management Console in JBoss to install the ZohoSubscriptions JDBC Driver.
-
Visualize SAP Hybris C4C 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 SAP Hybris C4C into TIBCO Spotfire.
-
How to connect PolyBase to Sendwithus
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sendwithus.
-
Analyze Okta Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Okta from Power Pivot. You will use the Table Import Wizard to load Okta. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Avro Replication to MySQL
Use CData Sync for automated, continuous, customizable Avro replication to MySQL.
-
How to integrate Google Search with Apache Airflow
Access and process Google Search in Apache Airflow using the CData JDBC Driver.
-
Automate Testmonitor Data Replication to Couchbase
Use CData Sync to Customize and automate Testmonitor replication to Couchbase.
-
Access Live Procore Data in Excel 365 Online (Excel for the web)
Connect to Procore from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Intercom Data in Aqua Data Studio
Access Intercom from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate with Live Dynamics 365 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Dynamics 365 from the MuleSoft Anypoint Platform to integrate live Microsoft Dynamics 365 into custom reports and dashboards.
-
Integrating Boomi Agentstudio with Splunk Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Splunk, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Seamlessly Import MariaDB Data into IBM SPSS Modeler
Integrate MariaDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData JDBC Driver for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for IBM Cloud Object Storage.
-
Operational Reporting on Cohere Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Cohere.
-
Integrate Certinia with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Certinia with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Certinia.
-
Connecting Agentforce with CouchDB 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 Apache CouchDB for you.
-
Connect Twitter Ads to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Twitter Ads with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Google Directory 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 Directory into TIBCO Spotfire.
-
Build SQL Analysis Services-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SQL Analysis Services and build web apps with connectivity to live SQL Analysis Services.
-
Build Agents in Relevance AI with Access to Live Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Outreach.io within intelligent agent workflows.
-
Integrating Antigravity CLI with Reckon via CData CLI
Connect Reckon to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Work with Oracle SCM Data in AWS Glue Jobs Using JDBC
Connect to Oracle SCM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Claude Code CLI with Samanage 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.
-
Build Slack-Connected Apps in Choreo
Use CData Connect AI to connect to Slack Data from Choreo and build custom apps using live Slack.
-
Integrating DocuSign Data in Talend Cloud Data Management Platform
Connect DocuSign Data with Talend Cloud Data Management Platform using the CData JDBC Driver for DocuSign.
-
Connect to Airtable Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Analyze CloudConvert Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze CloudConvert with the CData JDBC Driver for CloudConvert.
-
Create HBase Dataflows on PowerBI.com
Connect to the CData Power BI Connector for HBase from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Zendesk Data from PowerBuilder via JDBC
This article demonstrates how to access Zendesk from PowerBuilder using the Zendesk JDBC Driver.
-
Establish a Live Connection with Highrise Data using Tableau Bridge
The CData ODBC Driver for Highrise enables you to integrate live Highrise CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
How to integrate Metabase with Authorize.Net Data
Use CData Connect AI to connect to live Authorize.Net and create an interactive dashboard in Metabase from Authorize.Net.
-
Query Presto Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Presto entities in PHP by modeling them as objects.
-
Automate Zuora Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zuora from PowerShell? This article demonstrates how to utilize the Zuora Cmdlets for tasks like connecting to Zuora, automating operations, downloading data, and more.
-
How to connect Amazon QuickSight to CouchDB Data
Create a connection to Apache CouchDB in CData Connect AI and insert Apache CouchDB into Amazon QuickSight SPICE to build interactive dashboards.
-
Analyze Live Power BI XMLA Data in SAS Viya
Use CData Connect AI to connect to Power BI XMLA from SAS Viya and deploy self-service analytics using live Power BI XMLA.
-
Automated Continuous BambooHR Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable BambooHR replication to Apache Cassandra.
-
Build Visualizations of Google Forms Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Forms in Birst.
-
Connect to Teamgate Data from PowerBuilder via JDBC
This article demonstrates how to access Teamgate from PowerBuilder using the Teamgate JDBC Driver.
-
Analyze SAP Netweaver Gateway Data in Cognos Analytics
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Cognos Analytics and analyze live SAP Netweaver Gateway.
-
Rapidly Develop PostgreSQL-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 PostgreSQL.
-
Visualize ZohoInvoice Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoInvoice.
-
Connect to Azure Synapse Data from a Connection Pool in Jetty
The Azure Synapse JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Synapse from Web apps in Jetty.
-
Getting Started with the CData ODBC Driver for ShipStation
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ShipStation.