CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Square Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Square replication to PostgreSQL.
-
Visualize Postmark Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Postmark.
-
Automate Harvest Data Replication to Azure Synapse
Use CData Sync to customize and automate Harvest replication to Azure Synapse.
-
How to Create Power BI Visual Reports with Real-Time Float Data
Use CData Power BI Connectors to visualize Float in Power BI.
-
View Reports on Real-Time ConvertAPI Data in Power BI Report Server
Use the CData ODBC Driver for ConvertAPI to visualize ConvertAPI in Power BI Desktop and then publish them to Power BI Report Server.
-
Publish Discord-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Discord.
-
Visualize Gmail Data in TIBCO Spotfire through OData
Integrate Gmail into dashboards in TIBCO Spotfire.
-
How to connect and process ActiveCampaign from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ActiveCampaign.
-
Build Dashboards with Pinterest Data in DBxtra
Create dynamic dashboards and perform analytics based on Pinterest in DBxtra.
-
View Reports on Real-Time Accelo Data in Power BI Report Server
Use the CData ODBC Driver for Accelo to visualize Accelo in Power BI Desktop and then publish them to Power BI Report Server.
-
Work with Nuclia Data in FoxPro
Load Nuclia into a FoxPro database. This article includes full code and a walk-through of the process.
-
Configure the CData JDBC Driver for SAS xpt in a Connection Pool in Tomcat
Connect to SAS XPORT from a connection pool in Tomcat.
-
Create a Data Access Object for SendInBlue Data using JDBI
A brief overview of creating a SQL Object API for SendInBlue in JDBI.
-
Build a PostgreSQL Interface for Yelp Data using the CData JDBC Driver
Use the Remoting features of the Yelp JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with TaxJar Data in JReport Designer
Create charts and reports based on TaxJar in JReport Designer.
-
Access Live SAP SuccessFactors Data in AWS Lambda
Connect to live SAP SuccessFactors in AWS Lambda using the CData JDBC Driver.
-
Connect to eBay Analytics Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for eBay Analytics.
-
Connect to TaxJar Data in RapidMiner
Integrate TaxJar with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData Software ODBC Driver for Oracle Eloqua Reporting in MicroStrategy
Connect to Oracle Eloqua Reporting in MicroStrategy Developer using the CData Software ODBC Driver for Oracle Eloqua Reporting.
-
Automate Highrise Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Highrise CRM and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automate AfterShip Integration Tasks from PowerShell
Are you in search of a quick and easy way to access AfterShip from PowerShell? This article demonstrates how to utilize the AfterShip Cmdlets for tasks like connecting to AfterShip, automating operations, downloading data, and more.
-
Create Power BI Reports on Real-Time Shopify Data
Use the CData ODBC Driver for Shopify to visualize Shopify in Power BI Desktop.
-
How to connect and process Google Drive from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Drive.
-
Establish a Live Connection with Pipeline CRM Data using Tableau Bridge
The CData ODBC Driver for Pipeline CRM enables you to integrate live Pipeline CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
Consume eBay OData Feeds in SAP Lumira
Use the API Server to create data visualizations on eBay feeds that reflect any changes in SAP Lumira.
-
Extract, Transform, and Load Gong Data in Informatica PowerCenter
Create a simple Workflow for Gong in Informatica PowerCenter.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Twitter Ads using the Model Context Protocol.
-
Excel Spreadsheet Automation on Humanity Data with the QUERY Formula
Pull data from Humanity, automate spreadsheets, and more with the QUERY formula.
-
Integrate Cursor with Live Highrise Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Highrise CRM from within the editor.
-
How to Design WooCommerce Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to WooCommerce from mobile and tablet Power Apps.
-
Query Perigon Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Perigon from Node.js.
-
Access Live Pipedrive Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Pipedrive through MCP integration.
-
Access Teradata Data from MySQL in PHP
Connect to Teradata through the standard MySQL libraries in PHP.
-
How to import Campaigner Data into Apache Solr
Use the CData Software JDBC Driver for Campaigner in Data Import Handler and create an automated import of Campaigner to Apache Solr Enterprise Search platform.
-
Connecting Pipedream with GitLab Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on GitLab data in real time.
-
How to integrate Jumpseller with Apache Airflow
Access and process Jumpseller in Apache Airflow using the CData JDBC Driver.
-
Build AI/ML Models with Live Nuclia Data using Dataiku
Connect Nuclia Data with Dataiku using the CData API Driver for JDBC.
-
How to Access SAP Business One Data Using Entity Framework
This article shows how to access SAP Business One using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect to Live Klaviyo Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Klaviyo for you.
-
Connect to Bitly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Bitly using standard SQL.
-
Connect to Live Zoho Books Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zoho Books in CData Connect AI and connect to your Zoho Books from PostgreSQL.
-
Use Dash to Build to Web Apps on Freshdesk Data
Create Python applications that use pandas and Dash to build Freshdesk-connected web apps.
-
Manage Customer.io Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Customer.io.
-
How to connect PolyBase to Zoho Books
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Books.
-
Create a Data Access Object for AfterShip Data using JDBI
A brief overview of creating a SQL Object API for AfterShip in JDBI.
-
Using the CData Software ODBC Driver for HCL Domino in PyCharm
Connect to HCL Domino as an ODBC data source in PyCharm using the CData Software ODBC Driver for HCL Domino.
-
Connect to Strava 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 Strava and work with Strava in your FileMaker application.
-
Analyze Excel Online Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Excel Online and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Cloudflare Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Cloudflare replication to Amazon Redshift.
-
Access Delighted Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Delighted from your Oracle system.
-
How to import Accelo Data into Apache Solr
Use the CData Software JDBC Driver for Accelo in Data Import Handler and create an automated import of Accelo to Apache Solr Enterprise Search platform.
-
Visualize Basecamp Data in TIBCO Spotfire through ADO.NET
Integrate Basecamp into dashboards in TIBCO Spotfire.
-
Extract, Transform, and Load Pipedrive Data in Informatica PowerCenter
Create a simple Workflow for Pipedrive in Informatica PowerCenter.
-
Visualize Procore Data in TIBCO Spotfire through ADO.NET
Integrate Procore into dashboards in TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy Desktop
Connect to Salesforce Pardot in MicroStrategy Desktop using the CData Software JDBC Driver for Salesforce Pardot.
-
Build Microsoft Dataverse-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Microsoft Dataverse to explore live Microsoft Dataverse Data in Claude Code to assist with building Microsoft Dataverse-powered applications.
-
Connect and Visualize Live Airtable Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Airtable into the Databricks platform and create visualization dashboards with real-time Airtable.
-
How to load Aweber data into Elasticsearch via Logstash
Introducing a simple method to load Aweber data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Teams using the Model Context Protocol.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Cvent using the Model Context Protocol.
-
How to connect to Pipeliner CRM Data from IntelliJ
Integrate connectivity to Pipeliner CRM with wizards in IntelliJ.
-
Use the CData Software JDBC Driver for Printify in MicroStrategy Web
Connect to Printify in MicroStrategy Web using the CData Software JDBC Driver for Printify.
-
Access Adobe Experience Manager Data from MySQL in PHP
Connect to Adobe Experience Manager through the standard MySQL libraries in PHP.
-
Integrate Live NetSuite SuiteAnalytics Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to NetSuite SuiteAnalytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live NetSuite SuiteAnalytics.
-
Integrate Goose with Live Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Stripe from within the local AI agent.
-
Connect to AgileCRM Data in CloverDX (formerly CloverETL)
Transfer AgileCRM using the visual workflow in the CloverDX data integration tool.
-
Build Pipelines with Live Apollo Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Apollo from Google Cloud Data Fusion, enabling the integration of live Apollo into the building and management of effective data pipelines.
-
Create a Data Access Object for Marketo Data using JDBI
A brief overview of creating a SQL Object API for Marketo in JDBI.
-
Connect to Procore Data in ACL Analytics
Connect to Procore via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Procore.
-
Connect to HelloSign 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 HelloSign and work with HelloSign in your FileMaker application.
-
Query Ontraport Data in DataGrip
Create a Data Source for Ontraport in DataGrip and use SQL to query live Ontraport.
-
Integrating Boomi Agentstudio with Slack Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Slack, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Natively Connect to Flowlu Data in PHP
The CData ODBC driver for Flowlu enables you to create PHP applications with connectivity to Flowlu. Leverage the native support for ODBC in PHP.
-
How to publish and share Pinecone Data dashboards with Tableau Server
The CData ODBC driver for Pinecone enables you integrate Pinecone into Tableau dashboards.
-
Connect to SAP Hybris C4C Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP Hybris C4C Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect and Visualize Live Google Ads Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Ads into the Databricks platform and create visualization dashboards with real-time Google Ads.
-
Create Data Visualizations in Cognos BI with Exa Data
Access Exa as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Exact Online Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Exact Online replication to delimited files (CSV/TSV).
-
Publish Amazon Athena-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amazon Athena.
-
How to Seamlessly Import FormSite Data into IBM SPSS Modeler
Integrate FormSite data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Airtable Data Replication to Couchbase
Use CData Sync to Customize and automate Airtable replication to Couchbase.
-
Create Shippo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Shippo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to NASA Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for NASA and the SQL Gateway to access NASA from Google Apps Script.
-
Create GraphQL Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time GraphQL data access from reports, embedded analytics, and more.
-
Connect to CircleCI Data in HULFT Integrate
Connect to CircleCI as a JDBC data source in HULFT Integrate
-
Automated Continuous Autopilot Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Autopilot replication to Google Cloud SQL.
-
A PostgreSQL Interface for Brex Data (MySQL Remoting via JDBC)
Use the Remoting features of the Brex JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to create Visio diagrams from Facebook Ads Data
Automatically update Facebook Ads with the changes you make to Visio master shapes.
-
Seamlessly Bring Freshservice Data into Retool Using CData Connect AI
Integrate Freshservice data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Query, Visualize, and Share live API Data in Redash
Use CData Connect AI to connect to live API in Redash for querying, visualizing, and sharing.
-
Integrate Stack Exchange Data in Pentaho Data Integration
Build ETL pipelines based on Stack Exchange in the Pentaho Data Integration tool.
-
Use Dash to Build Web Apps on Stripe Data via CData Connect AI
Build interactive Dash web apps on live Stripe using pandas and the CData Connect AI Python SDK.
-
Create Box-Connected Dashboards in Grafana
Connect to Box Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Box.
-
Connect to Invoiced Data in NetBeans
Connect to Invoiced in NetBeans with the data source configuration wizard.
-
Connect to Couchbase from Asprova with CData Software ODBC Driver for Couchbase
This article shows how to connect faster to Couchbase data from Asprova.
-
Access Live GitLab Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GitLab from your Google Sheets.
-
Import Real-Time Freshteam Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Freshteam in ColdFusion.
-
How to Work with SAS Data Sets Data in ETL Validator JDBC
Connect to SAS Data Sets from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to CouchDB Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apache CouchDB in the Denodo Virtual DataPort Administrator.
-
Use Azure AI Foundry to Talk to Your Oracle Sales 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 Oracle Sales for you.