CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to Optimizely Data in Delphi
DataBind to Optimizely data in Delphi with standard data access components and controls.
-
How to Easily Query Presto Data in OpenOffice Base
Connect to Presto data in OpenOffice Base using the CData ODBC Driver for Presto and generate reports with live data insights.
-
Bridge SAS xpt Connectivity with Apache NiFi
Access and process SAS xpt data in Apache NiFi using the CData JDBC Driver.
-
Integrating Gumloop with Google Forms Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Forms data within automated workflows.
-
Visualize Amazon DynamoDB Data in TIBCO Spotfire through ADO.NET
Integrate Amazon DynamoDB data into dashboards in TIBCO Spotfire.
-
Visualize Google Contacts Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Contacts data.
-
Replicate Google Forms Data to Multiple Databases
Replicate Google Forms data to disparate databases with a point-and-click configuration.
-
Configure the CData JDBC Driver for Adobe Target in a Connection Pool in Tomcat
Connect to Adobe Target data from a connection pool in Tomcat.
-
Automate Zoho Books Data Replication to Couchbase
Use CData Sync to Customize and automate Zoho Books data replication to Couchbase.
-
How to Build an ETL App for PayPal Data in Python with CData Connect AI
Extract and transform live PayPal data in Python with petl and the CData Connect AI Python SDK.
-
Easily Integrate Parquet Data in Lazarus Pascal IDE
Learn how to easily integrate live Parquet data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use Azure AI Foundry to Talk to Your Cvent 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 Cvent data for you.
-
Integrate with PingOne Data in JReport Designer
Create charts and reports based on PingOne data in JReport Designer.
-
Interact with Live Google Search Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Google Search results.
-
DataBind Microsoft Teams Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Microsoft Teams with the DevExpress Windows Forms and Web controls to provide Microsoft Teams data to a chart.
-
Automated Paddle Data Replication to Teradata
Use CData Sync to Customize and automate Paddle data replication to Teradata.
-
Getting Started with the CData JDBC Driver for Tavily
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Tavily.
-
Getting Started with the CData Python Connector for Exact Online
Learn to install and license the CData Python Connector and configure a connection to live Exact Online data.
-
Connect to CockroachDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live CockroachDB data from Filemaker Pro on Mac.
-
How to create CapsuleCRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for CapsuleCRM data in MySQL .
-
How to Connect to Pipeliner CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pipeliner CRM data. Leverage the pyodbc module for ODBC in Python.
-
Create Data Visualizations in Cognos BI with Snapchat Ads Data
Access Snapchat Ads data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Back Up Marketo data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Marketo. In this article, we will employ an SSIS workflow to populate a database with Marketo data data.
-
Build Greenhouse Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Greenhouse data and build visualizations in Tableau Cloud.
-
Create Informatica Mappings From/To an ODBC Data Source for Excel Online
Create an ODBC connection to Excel Online in Informatica and browse and transfer Excel Online data.
-
Integrate Real-Time Access to Oracle Service Cloud in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Service Cloud data in real time.
-
Perplexity Reporting in OBIEE with the Perplexity JDBC Driver
Deploy the Perplexity JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Visualizations of Short.io Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Short.io data in Birst.
-
LINQ to Wistia Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Wistia Data Provider.
-
Integrate Twilio Data in Pentaho Data Integration
Build ETL pipelines based on Twilio data in the Pentaho Data Integration tool.
-
Visualize Perplexity Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Perplexity data.
-
Connect to Samanage Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Samanage data from Filemaker Pro on Mac.
-
Build Apps with Live Google Contacts data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Contacts data into the Adalo platform and build custom mobile and web applications with real-time Google Contacts data.
-
How to work with MarkLogic Data in Apache Spark using SQL
Access and process MarkLogic Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Tableau Connector for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Analyze MYOB AccountRight Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MYOB AccountRight data and visualize live MYOB AccountRight data in Infragistics Reveal.
-
How to Connect to Live Gong Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Gong data for you.
-
Build Dashboards with Presto Data in DBxtra
Create dynamic dashboards and perform analytics based on Presto data in DBxtra.
-
Connecting GenSpark with Gmail Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Gmail data without any replication or custom integration required.
-
Extract, Transform, and Load Egnyte Data in Informatica PowerCenter
Create a simple Workflow for Egnyte data in Informatica PowerCenter.
-
Connect to iContact Data in Jaspersoft Studio
Execute SQL to remote iContact data in Jaspersoft Studio.
-
Build Data Flows from SQL Server to SAP SuccessFactors through SSIS
Easily push SQL Server data to SAP SuccessFactors using the CData SSIS Tasks for SAP SuccessFactors.
-
Analyze Live Google Campaign Manager 360 Data in SAS Viya
Use CData Connect AI to connect to Google Campaign Manager 360 data from SAS Viya and deploy self-service analytics using live Google Campaign Manager 360 data.
-
How to use SQLAlchemy ORM to access Front Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Front data.
-
Link Calendly with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Calendly data in Filemaker Pro for Mac or Windows.
-
Replicate ServiceNow Data in Heroku for Use in Salesforce Connect
Replicate ServiceNow data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to work with Brex Data in Apache Spark using SQL
Access and process Brex Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for JotForm in MicroStrategy Web
Connect to JotForm data in MicroStrategy Web using the CData Software ODBC Driver for JotForm.
-
Build a PostgreSQL Interface for Facebook Ads Data using the CData JDBC Driver
Use the Remoting features of the Facebook Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for GraphQL in MicroStrategy Web
Connect to GraphQL data in MicroStrategy Web using the CData Software ODBC Driver for GraphQL.
-
A PostgreSQL Interface for ConvertKit Data using the CData ODBC Driver
Use the SQL Gateway and ConvertKit ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Insightly Data in Aqua Data Studio
Access Insightly data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Create Power BI Visual Reports with Real-Time Autopilot Data
Use CData Power BI Connectors to visualize Autopilot data in Power BI.
-
Use JayDeBeApi to access Xero Data in Python
Use standard Python scripting and the development environment of your choice to access live Xero data.
-
How to Connect to Live SendGrid Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SendGrid data for you.
-
How to Access IBM Cloud Object Storage Data Using Entity Framework
This article shows how to access IBM Cloud Object Storage data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to work with Jira Data in Apache Spark using SQL
Access and process Jira Data in Apache Spark using the CData Software JDBC Driver.
-
DataBind Charts to Jodoo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Jodoo data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to update BigQuery from Excel
This article explains how to transfer data from Excel to BigQuery using the Excel Add-In for BigQuery.
-
Connect to Oracle Eloqua Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle Eloqua data from PowerBuilder using the Oracle Eloqua JDBC Driver.
-
Connect to Discord Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Discord as an External Source in Dremio.
-
How to connect to Facebook Data from Spring Boot
Connect to Facebook in a Spring Boot Application using the CData JDBC Driver for Facebook
-
How to Seamlessly Import Salesforce Marketing Data into IBM SPSS Modeler
Integrate Salesforce Marketing data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Salesloft Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Salesloft.
-
Build PingOne-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PingOne data and build web apps with connectivity to live PingOne data.
-
Create Bright Data Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Bright Data from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Live HDFS Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live HDFS data into custom reports in Power BI.
-
Bridge Azure Analysis Services Connectivity with Apache NiFi
Access and process Azure Analysis Services data in Apache NiFi using the CData JDBC Driver.
-
Write a Simple Go Application to work with Adobe Commerce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Commerce data.
-
Connect to and Visualize Live PabblySubscriptions Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PabblySubscriptions data.
-
Connect to Live WordPress Data in MicroStrategy through CData Connect AI
Create a live connection to WordPress Data in CData Connect AI and connect to your WordPress data from MicroStrategy.
-
Integrate Cline with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Klaviyo data from within your IDE.
-
Use the CData ODBC Driver for PhantomBuster from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PhantomBuster to connect to PhantomBuster data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PhantomBuster data in Excel.
-
Import Sage 200 Data Using Azure Data Factory
Use CData Connect AI to connect to Sage 200 Data from Azure Data Factory and import live Sage 200 data.
-
How to connect to Bitbucket Data from IntelliJ
Integrate connectivity to Bitbucket data with wizards in IntelliJ.
-
Automate RSS Feeds Replication to Couchbase
Use CData Sync to Customize and automate RSS feeds replication to Couchbase.
-
Integrate Trae with Live ServiceDesk Plus Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ServiceDesk Plus data from within the AI-powered IDE.
-
Access Live Avaza Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Avaza data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData Tableau Connector for Testmonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Facebook Ads Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Facebook Ads replication to delimited files (CSV/TSV).
-
Analyze Shopify Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Shopify data and visualize Shopify data in SAP Analytics Cloud.
-
Bridge Excel Connectivity with Apache NiFi
Access and process Excel data in Apache NiFi using the CData JDBC Driver.
-
Integrate Google's Antigravity Agent with Live Apify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Apify data using the Model Context Protocol.
-
Automated Continuous Oracle Financials Cloud Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to SQL Server.
-
Connect and Visualize Live Zoho Inventory Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zoho Inventory data into the Databricks platform and create visualization dashboards with real-time Zoho Inventory data.
-
Integrating Gumloop with SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Hybris C4C data within automated workflows.
-
Automated Continuous HubSpot Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable HubSpot replication to Google Cloud SQL.
-
Integrate Cline with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Facebook Ads data from within your IDE.
-
How to Work with ADP Data in ETL Validator JDBC
Connect to ADP from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Kafka Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Kafka.
-
Getting Started with the CData Power BI Connector for Landbot
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Retently Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Retently data in the Denodo Virtual DataPort Administrator.
-
Integrate Live SAP Business One Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SAP Business One data from within the IDE.
-
Integrating Dataiku with Coda Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Coda data.
-
Create SSAS Tabular Models from CockroachDB Data
How to build a SQL Server Analysis Service Tabular Model from CockroachDB data using CData drivers.
-
Integrating Dataiku with Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Planner data.
-
Connect to EmailOctopus Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for EmailOctopus to connect to EmailOctopus data and execute queries in PowerBuilder.
-
LINQ to Telegram Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Telegram Data Provider.
-
Create Apps from Avro Data in Qlik Sense Cloud
Use CData Connect AI to connect to Avro Data and build apps from live Avro data in Qlik Sense Cloud.
-
How to connect to Close Data with Squirrel SQL client
Connect to Close data and execute queries in the Squirrel SQL Client.