CData Software - Knowledge Base
Recent Articles
-
Connect to Pipedrive Data in RapidMiner
Integrate Pipedrive data with standard components and data source configuration wizards in RapidMiner Studio.
-
Work with Live DB2 Data in Power Query
Use CData Connect AI to connect to DB2 data and work with live DB2 data in Microsoft Power Query.
-
Query LinkedIn Ads Data through ODBC in Node.js
Use node-odbc to execute SQL queries against LinkedIn Ads data from Node.js.
-
Create Informatica Mappings From/To an ODBC Data Source for Twitter Ads
Create an ODBC connection to Twitter Ads in Informatica and browse and transfer Twitter Ads data.
-
Create Power BI Reports on Real-Time Pinterest Data
Use the CData ODBC Driver for Pinterest to visualize Pinterest data in Power BI Desktop.
-
Create eBay-Connected Business Apps in AppSheet
Connect to eBay Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to eBay data.
-
Visualize Odoo Data in TIBCO Spotfire through OData
Integrate Odoo data into dashboards in TIBCO Spotfire.
-
Integrate with Bitbucket Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Bitbucket data to a JSON file on disk.
-
Connect to Neo4J from a Connection Pool in WebLogic
Use the CData JDBC Driver for Neo4J to connect to Neo4J data from Web applications running on WebLogic.
-
Automated Continuous Pipeline CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to MongoDB.
-
Connect to BigQuery Data in RazorSQL
Connect to BigQuery from wizards and query BigQuery data from the GUI in the RazorSQL database management tool.
-
Automated Continuous ConstantContact Replication to Databricks
Use CData Sync for automated, continuous, customizable ConstantContact replication to Databricks.
-
Link Factorial with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Factorial data in Filemaker Pro for Mac or Windows.
-
Connect to Grafana Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Grafana Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Getting Started with the CData ODBC Driver for Bright Data
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Bright Data.
-
Build Charts with YouTube Analytics Data in Clear Analytics
Create dynamic charts and perform analytics based on YouTube Analytics data in Clear Analytics.
-
Connect to Toggl Data in DBArtisan
Use wizards in DBArtisan to configure Toggl data as a data source.
-
Create Reports with SAP Fieldglass Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Fieldglass data.
-
Connect to TaxJar in SpagoBI
Create reports featuring live TaxJar data in SpagoBI Studio. Host TaxJar reports on SpagoBI Server.
-
Use ChatGPT to Talk to Your Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Oracle Financials Cloud data for you.
-
Build CockroachDB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live CockroachDB data and build CockroachDB-connected web apps with Axios.
-
Integrate Live Amazon DynamoDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Amazon DynamoDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Amazon DynamoDB data.
-
Automated Continuous Avro Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Avro replication to Google BigQuery.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Recruit
Provide connectivity to Zoho Recruit data through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for Neo4J in MicroStrategy
Connect to Neo4J data in MicroStrategy Developer using the CData Software JDBC Driver for Neo4J.
-
Use ChatGPT to Talk to Your MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your MariaDB data for you.
-
Connect to MailerSend Data in Jaspersoft Studio
Execute SQL to remote MailerSend data in Jaspersoft Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for RabbitMQ
Provide connectivity to RabbitMQ data through an SAP BusinessObjects universe.
-
Replicate Multiple Bright Data Accounts
Replicate multiple Bright Data accounts to one or many databases.
-
Connect to QuickBooks Online in SpagoBI
Create reports featuring live QuickBooks Online data in SpagoBI Studio. Host QuickBooks Online reports on SpagoBI Server.
-
Connect to Printify Data from PowerBuilder via ADO.NET
This article demonstrates how to access Printify data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Dashboards with ShipEngine Data in DBxtra
Create dynamic dashboards and perform analytics based on ShipEngine data in DBxtra.
-
Interact with Live Oracle Service Cloud Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Oracle Service Cloud data.
-
Connect to OData Services in JRuby
Create a simple JRuby app with access to live OData services.
-
Connecting Pipedream with Zoho Creator 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 Zoho Creator data in real time.
-
Analyze Coda Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Coda data in Microsoft R Open.
-
A PostgreSQL Interface for LinkedIn Data (MySQL Remoting via JDBC)
Use the Remoting features of the LinkedIn JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live CouchDB Data in Coginiti Pro
Connect to and query live CouchDB data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Design BIRT Reports on Zoho Creator Data
Provide current Zoho Creator data to your embedded analytics.
-
Bidirectional Access to Klaviyo Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Klaviyo data in Filemaker Pro for Mac or Windows.
-
Integrating Codex with Figshare 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.
-
Working with Sage Intacct Data in LINQPad
Execute LINQ queries to Sage Intacct data in LINQPad.
-
Analyze Avro Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Avro data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating Boomi Agentstudio with Testmonitor Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Testmonitor data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Tavily Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Tavily and work with Tavily data in your FileMaker applications.
-
Import Google Analytics Data Using Azure Data Factory
Use CData Connect AI to connect to Google Analytics Data from Azure Data Factory and import live Google Analytics data.
-
View Reports on Real-Time Oracle Financials Cloud Data in Power BI Report Server
Use the CData ODBC Driver for Oracle Financials Cloud to visualize Oracle Financials Cloud data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to create Zoho Inventory federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho Inventory data in MySQL .
-
Back Up Sentry data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Sentry data data.
-
Access Live FTP Data in Coginiti Pro
Connect to and query live FTP data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Instagram Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Instagram data and build visualizations in Tableau.
-
DataBind SendPulse Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide SendPulse data to a chart.
-
Automated Continuous MongoDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MongoDB replication to PostgreSQL.
-
Build Google Ads-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Google Ads data without replication.
-
How to Work with Exa Data in ETL Validator JDBC
Connect to Exa from ETL Validator jobs using the CData Software JDBC Driver.
-
Consume Freshdesk OData Feeds in PowerBuilder
This article demonstrates how to consume Freshdesk data as OData feeds from PowerBuilder using the API Server.
-
Establish a Live Connection with SurveyMonkey Data using Tableau Bridge
The CData ODBC Driver for SurveyMonkey enables you to integrate live SurveyMonkey data into Tableau Cloud dashboards using the Tableau Bridge.
-
Viewing Odoo Data in RAD Studio Data Explorer
How to view Odoo data in RAD Studio Data Explorer using the CData ODBC Driver for Odoo.
-
Connect to Sage Cloud Accounting Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sage Cloud Accounting data using standard SQL.
-
How to Seamlessly Import xBase Data into IBM SPSS Modeler
Integrate xBase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software ODBC Driver for Redshift in SAS for Real-Time Reporting and Analytics
Connect to real-time Redshift data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Redshift.
-
Use Dash to Build Web Apps on Egnyte Data via CData Connect AI
Build interactive Dash web apps on live Egnyte data using pandas and the CData Connect AI Python SDK.
-
Build HCL Domino-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live HCL Domino data without replication.
-
Query Azure Data Catalog Data as a SQL Server Database in Node.js
Execute SQL Server queries against Azure Data Catalog data from Node.js.
-
Connect to Brex Data in JRuby
Create a simple JRuby app with access to live Brex data.
-
Build Automated Perplexity-Connected Workflows in Zapier
Use CData Connect AI to connect to live Perplexity data and build automated workflows in Zapier.
-
DataBind Controls to RabbitMQ Data in Delphi
DataBind to RabbitMQ data in Delphi with standard data access components and controls.
-
How to publish and share REST Data dashboards with Tableau Server
The CData ODBC driver for REST enables you integrate REST data into Tableau dashboards.
-
Query NASA Data in DataGrip
Create a Data Source for NASA in DataGrip and use SQL to query live NASA data.
-
How to connect SharePoint with SAP Data through external lists
Provide SAP data to SharePoint users as an external list.
-
Moving Data from Phoenix to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Phoenix data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query PagerDuty Data as a MySQL Database in Node.js
Execute MySQL queries against PagerDuty data from Node.js.
-
How to connect to Odoo Data with Squirrel SQL client
Connect to Odoo data and execute queries in the Squirrel SQL Client.
-
Use the CData ODBC Driver for SAP Ariba Source from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Ariba Source to connect to SAP Ariba Source data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Ariba Source data in Excel.
-
Build Power BI XMLA-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Power BI XMLA data and build web apps with connectivity to live Power BI XMLA data.
-
Migrating data from Google Cloud Storage to Google BigQuery using CData SSIS Components.
Easily push Google Cloud Storage data to Google BigQuery using the CData SSIS Tasks for Google Cloud Storage and Google BigQuery.
-
Connect iContact Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your iContact data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Aircall Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Aircall replication to Google BigQuery.
-
Use Azure AI Foundry to Talk to Your Paylocity 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 Paylocity data for you.
-
Analyze QuickBooks Data in Cognos Analytics
Use CData Connect AI to connect to QuickBooks Data from Cognos Analytics and analyze live QuickBooks data.
-
Connecting Mastra with HDFS 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 HDFS data, no replication required.
-
Build AI/ML Models with Live Google Directory Data using Dataiku
Connect Google Directory Data with Dataiku using the CData JDBC Driver for Google Directory.
-
Automated Continuous IBM Informix Replication to MySQL
Use CData Sync for automated, continuous, customizable IBM Informix replication to MySQL.
-
Using the CData Software ODBC Driver for Cohere in PyCharm
Connect to Cohere as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cohere.
-
Connect to Yelp from a Connection Pool in WebLogic
Use the CData JDBC Driver for Yelp to connect to Yelp data from Web applications running on WebLogic.
-
How to Build an ETL App for Cvent Data in Python with CData Connect AI
Build ETL pipelines that read and write live Cvent data in Python with petl and the CData Connect AI Python SDK.
-
Create Informatica Mappings From/To a JDBC Data Source for Email
Create Email data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect Azure DevOps to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure DevOps with IBM WebSphere for seamless data integration and connectivity.
-
Use Manus AI to Talk to Your FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on FTP data.
-
Write a Simple Go Application to work with Amplitude Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Amplitude data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for REST
Provide connectivity to REST data through an SAP BusinessObjects universe.
-
Build Node.js Apps on Your Business Data with the New CData CLI
Learn how the CData CLI and cdata-cli-odbc skill ground AI coding agents in your real schema so they can build production-ready Node.js apps connected to Salesforce and hundreds of other sources through the CData ODBC Driver.
-
Feed Vimeo Data into FineReport
How to set Vimeo data as a JDBC data source in FineReport.
-
Automated Continuous Nuclia Replication to MongoDB
Use CData Sync for automated, continuous, customizable Nuclia replication to MongoDB.
-
Visualize BambooHR 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 BambooHR data into TIBCO Spotfire.
-
Access Live Calendly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Calendly data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Harvest Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Harvest replication to Google Cloud SQL.
-
Use the CData ODBC Driver for Shopify from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Shopify to connect to Shopify data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Shopify data in Excel.
-
Integrate Office 365 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Office 365 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Office 365 data.
-
Integrating Kiro with Cvent 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.