CData Software - Knowledge Base
Recent Articles
-
How to Connect to SAP Ariba Procurement Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Ariba Procurement. Leverage the pyodbc module for ODBC in Python.
-
Connect to Jira Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Paddle 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 Paddle.
-
Migrating data from Snowflake to Databricks using CData SSIS Components.
Easily push Snowflake to Databricks using the CData SSIS Tasks for Snowflake and Databricks.
-
Connect to IBM Cloud Object Storage Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for IBM Cloud Object Storage and the Script function in FileMaker Pro to connect to IBM Cloud Object Storage and work with IBM Cloud Object Storage in your FileMaker application.
-
Automated Continuous Active Directory Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Active Directory replication to delimited files (CSV/TSV).
-
Automated Continuous Kafka Replication to SingleStore
Use CData Sync for automated, continuous, customizable Kafka replication to SingleStore.
-
Create Vertica-Connected Applications in Appsmith
Connect to Vertica Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Vertica.
-
MYOB AccountRight Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MYOB AccountRight facts in real time.
-
Analyze Salesforce Marketing Data in Cognos Analytics
Use CData Connect AI to connect to Salesforce Marketing Data from Cognos Analytics and analyze live Salesforce Marketing Cloud.
-
Consume Bullhorn CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Bullhorn CRM feeds that reflect any changes in SAP Lumira.
-
Connect Trello Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Trello using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import and Visualize Harvest Data in Power View
Create data visualizations based on Harvest in Excel.
-
Build Zoho CRM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Zoho CRM to explore live Zoho CRM Data in GitHub Copilot to assist with building Zoho CRM-powered applications.
-
Add Tally Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Tally with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish Vercel-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Vercel.
-
Connect to ConvertAPI Data in Aqua Data Studio
Access ConvertAPI from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Publish eBay Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live eBay Analytics.
-
Build OnePageCrm-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live OnePageCrm Data in Claude Code to assist with building OnePageCrm-powered applications.
-
How to Work with RSS Feeds in ETL Validator JDBC
Connect to RSS from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Power BI Connector for Google Translate
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Work with Live Zendesk Data in Power Query
Use CData Connect AI to connect to Zendesk and work with live Zendesk in Microsoft Power Query.
-
Extract, Transform, and Load Calendly Data in Informatica PowerCenter
Create a simple Workflow for Calendly in Informatica PowerCenter.
-
Query Google Sheets Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Sheets and perform CRUD operations on Google Sheets from Node.js.
-
Connect to Freshservice Data from a Connection Pool in JBoss
Integrate Freshservice into Java servlets: Use the Management Console in JBoss to install the Freshservice JDBC Driver.
-
How to Work with Apollo Data in ETL Validator JDBC
Connect to Apollo from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze Amazon DynamoDB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Amazon DynamoDB and visualize live Amazon DynamoDB in Infragistics Reveal.
-
Bridge Freshteam Connectivity with Apache NiFi
Access and process Freshteam in Apache NiFi using the CData JDBC Driver.
-
Connect to Google Ads Data in DBeaver
Use the CData ODBC Driver to connect to Google Ads in DBeaver.
-
Automate Smartsheet Data Replication to Couchbase
Use CData Sync to Customize and automate Smartsheet replication to Couchbase.
-
Connect to Browserless Data in NetBeans
Connect to Browserless in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Power BI Connector for Reckon
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Reckon.
-
How to connect SharePoint with Pipeliner CRM Data through external lists
Provide Pipeliner CRM to SharePoint users as an external list.
-
Unbounce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Unbounce facts in real time.
-
Deploy the ADO.NET Provider for FormSite on an SSRS Report Server
Connect to FormSite 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.
-
Analyze ChargeOver Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of ChargeOver and visualize live ChargeOver in Infragistics Reveal.
-
Connect to Amazon DynamoDB Data in HULFT Integrate
Connect to Amazon DynamoDB as a JDBC data source in HULFT Integrate
-
Access Live Yelp Data in Coginiti Pro
Connect to and query live Yelp from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Dash to Build to Web Apps on SAP Ariba Source Data
Create Python applications that use pandas and Dash to build SAP Ariba Source-connected web apps.
-
Automated Continuous FormSite Replication to SQL Server
Use CData Sync for automated, continuous, customizable FormSite replication to SQL Server.
-
Create Instantly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Instantly data access from reports, embedded analytics, and more.
-
Analyze Google Tasks Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Tasks and visualize live Google Tasks in Infragistics Reveal.
-
Feed Auth0 Data into FineReport
How to set Auth0 as a JDBC data source in FineReport.
-
Connect to Salesforce Data in Ruby
Connect to Salesforce & Force.com in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Automated Zoho Creator-Connected Workflows in Zapier
Use CData Connect AI to connect to live Zoho Creator and build automated workflows in Zapier.
-
Query Zoho Recruit Data in ColdFusion
Write standard ColdFusion data access code to connect to Zoho Recruit.
-
Access Live Beeminder Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Beeminder into the statistical analysis tools available in SAS JMP. This article shows how to use Beeminder in the Graph Builder and Query Builder.
-
Integrating Sybase IQ Data in Talend Cloud Data Management Platform
Connect Sybase IQ Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sybase IQ.
-
Getting Started with the CData Tableau Connector for Sybase IQ
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Sybase IQ.
-
Create Tally Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Tally data access from reports, embedded analytics, and more.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Campaign Manager 360 within intelligent workflows.
-
Connect and Visualize Live Azure Synapse Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Synapse into the Databricks platform and create visualization dashboards with real-time Azure Synapse.
-
Connect to Invoiced Data in DBeaver
Use the CData ODBC Driver to connect to Invoiced in DBeaver.
-
Greenplum Reporting in OBIEE with the Greenplum JDBC Driver
Deploy the Greenplum JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Work with NetSuite Data in AWS Glue Jobs Using JDBC
Connect to NetSuite from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Work with QuickBooks Online Data in ETL Validator JDBC
Connect to QuickBooks Online from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Wrike Replication to Snowflake
Use CData Sync for automated, continuous, customizable Wrike replication to Snowflake.
-
Visualize Exa Data in Tableau
The CData ODBC driver for Exa enables you integrate Exa into Tableau dashboards.
-
Automated Continuous Google Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Analytics replication to PostgreSQL.
-
Getting Started with the CData Tableau Connector for Greenplum
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Greenplum.
-
Integrating Cursor CLI with Everhour 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 Data Flows from Slack to SQL Server using SSIS
Easily back up Slack to SQL Server using the SSIS components for Slack.
-
Getting Started with the CData JDBC Driver for ZohoMarketingHub
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZohoMarketingHub.
-
Integrating Antigravity CLI with LinkedIn Ads via CData CLI
Connect LinkedIn Ads to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build MVC Applications with Connectivity to Shortcut Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Shortcut from an ASP.NET MVC application.
-
Query Sage 300 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sage 300 entities in PHP by modeling them as objects.
-
How to connect SharePoint with Pipedrive Data through external lists
Provide Pipedrive to SharePoint users as an external list.
-
Create Informatica Mappings From/To an ODBC Data Source for FHIR
Create an ODBC connection to FHIR in Informatica and browse and transfer FHIR.
-
Getting Started with the CData Python Connector for Wistia
Learn to install and license the CData Python Connector
-
Connecting Mastra with Couchbase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Couchbase, no replication required.
-
Build Agents in Relevance AI with Access to Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Analytics within intelligent agent workflows.
-
Access Sage Intacct 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 Sage Intacct.
-
Connect to Stripe Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Stripe in the Denodo Virtual DataPort Administrator.
-
Access Live Airtable Data in Excel 365 Online (Excel for the web)
Connect to Airtable from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Prepare, Blend, and Analyze Lakebase Data in Alteryx Designer (ODBC)
Build workflows to access live Lakebase for self-service data analytics.
-
Use the CData ODBC Driver for Perplexity from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Perplexity to connect to Perplexity from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Perplexity in Excel.
-
Build a PostgreSQL Interface for Freshdesk Data using the CData JDBC Driver
Use the Remoting features of the Freshdesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Dynamics 365 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Amazon S3.
-
Configure the CData JDBC Driver for Amazon Athena in a Connection Pool in Tomcat
Connect to Amazon Athena from a connection pool in Tomcat.
-
DataBind Controls to Teamwork Data in Delphi
DataBind to Teamwork in Delphi with standard data access components and controls.
-
Visualize Live BambooHR Data in the Power BI Service
Use CData Connect AI to connect to live BambooHR and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Rapidly Develop Paddle-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 Paddle.
-
Integrate Basecamp Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Basecamp and integrate live Basecamp into your Power Automate tasks.
-
How to publish and share BenchmarkEmail Data dashboards with Tableau Server
The CData ODBC driver for BenchmarkEmail enables you integrate BenchmarkEmail into Tableau dashboards.
-
How to integrate Recurly with Apache Airflow
Access and process Recurly in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for Pinterest
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Pinterest.
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle Sales
Create an ODBC connection to Oracle Sales in Informatica and browse and transfer Oracle Sales.
-
Operational Reporting on Opsgenie Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Opsgenie.
-
Create Ontraport Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Ontraport from PowerBI.com to create Power BI Dataflows with real-time data.
-
Migrating data from Float to Snowflake using CData SSIS Components.
Easily push Float to Snowflake using the CData SSIS Tasks for Float and Snowflake.
-
Consume Databricks OData Feeds in PowerBuilder
This article demonstrates how to consume Databricks as OData feeds from PowerBuilder using the API Server.
-
Integrate Cline with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Shopify from within your IDE.
-
Connect to Pinecone Data from PowerBuilder via JDBC
This article demonstrates how to access Pinecone from PowerBuilder using the Pinecone JDBC Driver.
-
How to Connect to & Open JobNimbus Data in Microsoft Excel
This article uses the CData ODBC driver for JobNimbus to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Bidirectional Access to Typeform Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Typeform in Filemaker Pro for Mac or Windows.
-
Automate Amazon Marketplace Data Replication to SAP HANA
Use CData Sync to customize and automate Amazon Marketplace replication to SAP HANA.
-
Automated Continuous Azure Synapse Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Azure Synapse replication to delimited files (CSV/TSV).
-
Using the CData Software ODBC Driver for Jodoo in PyCharm
Connect to Jodoo as an ODBC data source in PyCharm using the CData Software ODBC Driver for Jodoo.
-
Connect to Zoho Recruit Data in JRuby
Create a simple JRuby app with access to live Zoho Recruit.
-
Query Pinterest Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pinterest from Node.js.