CData Software - Knowledge Base
Recent Articles
-
Extract, Transform, and Load Clio Data in Informatica PowerCenter
Create a simple Workflow for Clio data in Informatica PowerCenter.
-
Automate Intercom Data Replication to Azure Data Lake
Use CData Sync to customize and automate Intercom data replication to Azure Data Lake.
-
Access SAP Ariba Source Data from MySQL in Amazon QuickSight
Connect to SAP Ariba Source and build visualizations of SAP Ariba Source data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Clari Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Clari replication to Google Cloud SQL.
-
Connect to Excel Data in RazorSQL
Connect to Excel from wizards and query Excel data from the GUI in the RazorSQL database management tool.
-
Access Live RSS Feeds in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live RSS feeds from your Google Sheets.
-
Build Charts with Impala Data in Clear Analytics
Create dynamic charts and perform analytics based on Impala data in Clear Analytics.
-
Connect to Onfleet Data in Ruby
Connect to Onfleet data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Zoho Books from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoho Books to connect to Zoho Books data from Web applications running on WebLogic.
-
Build a Simple VCL Application for SpaceX Data
How to build a simple VCL Application to view SpaceX data in RAD Studio using the CData ODBC Driver for SpaceX.
-
Build Vertica Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Vertica data and build visualizations in Tableau.
-
Build MVC Applications with Connectivity to SpaceX Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SpaceX from an ASP.NET MVC application.
-
Use Agno to Talk to Your Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Oracle Eloqua data for you.
-
Redis Reporting in OBIEE with the Redis JDBC Driver
Deploy the Redis JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to import Humanity Data into Apache Solr
Use the CData Software JDBC Driver for Humanity in Data Import Handler and create an automated import of Humanity data to Apache Solr Enterprise Search platform.
-
Connect to CloudConvert 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 CloudConvert and work with CloudConvert data in your FileMaker application.
-
Front Reporting in OBIEE with the Front JDBC Driver
Deploy the Front JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Boomi Agentstudio with Raisers Edge NXT Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Raisers Edge NXT data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect Paddle to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Paddle data using the CData Python MCP Server.
-
Connect to and Visualize Live SAP Hybris C4C Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP Hybris C4C data.
-
Connect and Query Live Typeform Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Typeform data into Databricks and enable direct, live querying and analysis without replication.
-
Access Mistral AI Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mistral AI data from your Oracle system.
-
Automated Continuous ScrapingBee Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ScrapingBee replication to Google BigQuery.
-
Getting Started with the CData Power BI Connector for SendPulse
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to SAP HANA XS Advanced Data in NetBeans
Connect to SAP HANA XS Advanced data in NetBeans with the data source configuration wizard.
-
Choosing the Best Method to Connect Google Spanner to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Spanner data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Query Copper Data as a MySQL Database in Node.js
Execute MySQL queries against Copper data from Node.js.
-
Build Visualizations of Sybase IQ Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sybase IQ data in Birst.
-
Integrate OData Services in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live OData services from Informatica Cloud.
-
Replicate Cvent Data from PowerShell
Write a quick PowerShell script to query Cvent data. Use connectivity to the live data to replicate Cvent data to SQL Server.
-
How to connect and process LinkedIn data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live LinkedIn data.
-
Access Live Toggl Data in AWS Lambda
Connect to live Toggl data in AWS Lambda using the CData JDBC Driver.
-
Use the CData ODBC Driver for Pushbullet in Microsoft Power Query
You can use the CData Pushbullet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pushbullet data into Microsoft Power Query.
-
Visualize Live Cloudflare Data in the Power BI Service
Use CData Connect AI to connect to live Cloudflare data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Azure Data Lake Storage Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Azure Data Lake Storage data and visualize Azure Data Lake Storage data in SAP Analytics Cloud.
-
Easily Integrate CockroachDB Data in Lazarus Pascal IDE
Learn how to easily integrate live CockroachDB data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Simplesat Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Simplesat and work with Simplesat data in your FileMaker applications.
-
Automated Continuous Google Ads Replication to MySQL
Use CData Sync for automated, continuous, customizable Google Ads replication to MySQL.
-
Build BigCommerce-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live BigCommerce data.
-
Integrating Codex with Parallel 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.
-
Connect to Real-Time Foursquare Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Foursquare data in Power Apps.
-
Analyze Sage Intacct Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Sage Intacct data and visualize Sage Intacct data in SAP Analytics Cloud.
-
Analyze SAP HANA XS Advanced Data in Looker
Use CData Connect AI to connect to SAP HANA XS Advanced Data from Looker and build custom apps using live SAP HANA XS Advanced data.
-
Build Dashboards with Act-On Data in Dundas BI
Create dynamic dashboards and perform analytics based on Act-On data in Dundas BI.
-
Connect to Azure Synapse Data from PowerBuilder via ADO.NET
This article demonstrates how to access Azure Synapse data from Appeon PowerBuilder using the CData ADO.NET Provider for Azure Synapse.
-
Automated Continuous PolarTeamPro Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Apache Kafka.
-
Manage Dropbox Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Dropbox.
-
Visualize Oracle Sales 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 Oracle Sales data into TIBCO Spotfire.
-
Connect to Bitbucket Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Bitbucket as an External Source in Dremio.
-
Getting Started with the CData SSIS Components for Mocean
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mocean.
-
How to connect to MailerSend Data in DBVisualizer
Integrate MailerSend data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Seamlessly Import Mocean Data into IBM SPSS Modeler
Integrate Mocean data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Model SAP Business One Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Business One, enabling the direct import of real-time SAP Business One data.
-
Automated Todoist Data Replication to Teradata
Use CData Sync to Customize and automate Todoist data replication to Teradata.
-
Use the CData Software ODBC Driver for REST in MicroStrategy
Connect to REST data in MicroStrategy Developer using the CData Software ODBC Driver for REST.
-
Create Data Visualizations in Cognos BI with Accelo Data
Access Accelo data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate LibreChat with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle Financials Cloud data from within the chat interface.
-
Feed Google Sheets Data into FineReport
How to set Google Sheets data as a JDBC data source in FineReport.
-
Connect to Yelp Data in JRuby
Create a simple JRuby app with access to live Yelp data.
-
DataBind Controls to Superchat Data in Delphi
DataBind to Superchat data in Delphi with standard data access components and controls.
-
Connect and Visualize Live Outreach.io Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Outreach.io data into the Databricks platform and create visualization dashboards with real-time Outreach.io data.
-
Connect to WooCommerce Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live WooCommerce data from Filemaker Pro on Mac.
-
Access Float Data from MySQL in Amazon QuickSight
Connect to Float and build visualizations of Float data using a MySQL Connection in Amazon QuickSight.
-
Access Live Flowlu Data in AWS Lambda
Connect to live Flowlu data in AWS Lambda using the CData JDBC Driver.
-
Access Live JDBC-ODBC Bridge Data in AWS Lambda
Connect to live JDBC-ODBC Bridge data in AWS Lambda using the CData JDBC Driver.
-
Automate Cohere Data Replication to Couchbase
Use CData Sync to Customize and automate Cohere data replication to Couchbase.
-
Access Live LinkedIn Ads Data in TIBCO Data Virtualization
Use the LinkedIn Ads Tibco DV Adapter to create a LinkedIn Ads data data source in TIBCO Data Virtualization Studio and gain access to live LinkedIn Ads data from your TDV Server.
-
Natively Connect to Redshift Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Redshift data. Leverage the native support for ODBC in PHP.
-
Connect to SageHR Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SageHR data in Airbyte.
-
Connect to Greenplum Data in RazorSQL
Connect to Greenplum from wizards and query Greenplum data from the GUI in the RazorSQL database management tool.
-
Automated Continuous ZeroBounce Replication to Oracle
Use CData Sync for automated, continuous, customizable ZeroBounce replication to Oracle.
-
How to Visualize Slack 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 Slack data in Python.
-
Connect ConvertAPI to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ConvertAPI data using the CData Python MCP Server.
-
Create Reports from Microsoft Planner Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Planner data and create custom reports in Looker Studio.
-
Integrating OpenCode with Discord 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 Apps with Live Teradata data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Teradata data into the Adalo platform and build custom mobile and web applications with real-time Teradata data.
-
DataBind Charts to Databricks Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Databricks 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.
-
DataBind Controls to Missive Data in C++Builder
DataBind to Missive data in C++Builder with standard components and controls.
-
Validate Act-On Data with QuerySurge
Access and validate Act-On data in QuerySurge using the CData JDBC Driver.
-
Create Apps from Adobe Experience Manager Data in Qlik Sense Cloud
Use CData Connect AI to connect to Adobe Experience Manager Data and build apps from live Adobe Experience Manager data in Qlik Sense Cloud.
-
Automated Continuous Avalara AvaTax Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Apache Kafka.
-
Analyze SAP HANA Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP HANA data and visualize SAP HANA data in SAP Analytics Cloud.
-
Establish a Live Connection with ChargeOver Data using Tableau Bridge
The CData ODBC Driver for ChargeOver enables you to integrate live ChargeOver data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use JayDeBeApi to access Cvent Data in Python
Use standard Python scripting and the development environment of your choice to access live Cvent data.
-
Create Google Directory Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Directory from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData ODBC Driver for Printful in Microsoft Power Query
You can use the CData Printful ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Printful data into Microsoft Power Query.
-
Link Vimeo with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Vimeo data in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for Yelp in MicroStrategy Desktop
Connect to Yelp data in MicroStrategy Desktop using the CData Software ODBC Driver for Yelp.
-
LINQ to Google Calendar 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 Google Calendar Data Provider.
-
Load ElevenLabs Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ElevenLabs data to a database.
-
Automated Continuous Invoiced Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Invoiced replication to AlloyDB.
-
Integrate Dify with Live Salesforce Data 360 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Salesforce Data 360 data.
-
Back Up ZohoPeople 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 ZohoPeople data data.
-
Automated Continuous Mixpanel Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Mixpanel replication to PostgreSQL.
-
Create Dynamic CircleCI Grids Using the Infragistics XamDataGrid
Learn how you can connect CircleCI to Infragistics XamDataGrid to build dynamic grids.
-
Link Pinecone with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pinecone data in Filemaker Pro for Mac or Windows.
-
Connect to Salesloft Data in CloverDX (formerly CloverETL)
Transfer Salesloft data using the visual workflow in the CloverDX data integration tool.
-
Write a Simple Go Application to work with MarkLogic Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MarkLogic data.
-
Automated Continuous Azure Blob Storage Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Apache Kafka.
-
Create Dropbox-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Dropbox Data from Klipfolio and build custom visualizations using live Dropbox data.