CData Software - Knowledge Base
Recent Articles
-
How to Easily Query Perigon Data in OpenOffice Base
Connect to Perigon data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrating LangGraph with PolarTeamPro Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on PolarTeamPro data within automated workflows.
-
Integrating Cursor with Deel 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.
-
Automated Continuous YouTube Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to SingleStore.
-
Connect to Recurly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Recurly data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to PostgreSQL Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for PostgreSQL and the Script function in FileMaker Pro to connect to PostgreSQL and work with PostgreSQL data in your FileMaker application.
-
Analyze SAP Business Warehouse Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Business Warehouse data and visualize live SAP Business Warehouse data in Infragistics Reveal.
-
Automated Continuous Twilio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Twilio replication to Apache Kafka.
-
How to Seamlessly Import SAP Ariba Procurement Data into IBM SPSS Modeler
Integrate SAP Ariba Procurement data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Apps with Live eBay Data Using the Low-Code Development Platform of Mendix
Connect eBay data with Mendix to build apps using the CData JDBC Driver for eBay.
-
Create Dashboards and Visualize Live Tavily Data in Geckoboard
Use CData Connect AI to connect to live Tavily data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Deploy the ADO.NET Provider for Mistral AI on an SSRS Report Server
Connect to Mistral AI data 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.
-
Integrate Epicor Kinetic Data in the Pentaho Report Designer
Publish reports based on Epicor Kinetic data in the Pentaho BI tool.
-
Build Agents in Relevance AI with Access to Live Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Oracle data within intelligent agent workflows.
-
How to connect SharePoint with LinkedIn Ads Data through external lists
Provide LinkedIn Ads data to SharePoint users as an external list.
-
Deploy the ADO.NET Provider for Bullhorn CRM on an SSRS Report Server
Connect to Bullhorn CRM data 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.
-
Automated Continuous Zoho Books Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoho Books replication to Snowflake.
-
Integrate Cursor with Live SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP BusinessObjects BI data from within the editor.
-
Replicate Bullhorn CRM Data in Heroku for Use in Salesforce Connect
Replicate Bullhorn CRM data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Provide OData Services of ZeroBounce Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZeroBounce data by developing a WCF Service Application.
-
Extract, Transform, and Load Google Drive Data in Informatica PowerCenter
Create a simple Workflow for Google Drive data in Informatica PowerCenter.
-
Visualize ZohoPeople Data in TIBCO Spotfire through ADO.NET
Integrate ZohoPeople data into dashboards in TIBCO Spotfire.
-
Automated Continuous Apify Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Apify replication to PostgreSQL.
-
Integrate Cline with Live RSS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live RSS feeds from within your IDE.
-
Connect to Salesforce Pardot Data from a Connection Pool in JBoss
Integrate Salesforce Pardot data into Java servlets: Use the Management Console in JBoss to install the Salesforce Pardot JDBC Driver.
-
Stream Spotify Data into Apache Kafka Topics
Access and stream Spotify data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Zoho Projects Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Projects and the SQL Gateway to access Zoho Projects data from Google Apps Script.
-
Automated Continuous Auth0 Replication to SQLite
Use CData Sync for automated, continuous, customizable Auth0 replication to SQLite.
-
Establish a Live Connection with Flowlu Data using Tableau Bridge
The CData ODBC Driver for Flowlu enables you to integrate live Flowlu data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Act CRM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Act CRM in FileMaker Pro to connect to Act CRM and work with Act CRM data in your FileMaker applications.
-
Getting Started with the CData JDBC Driver for Optimizely
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Optimizely.
-
Automated Continuous Rootly Replication to Oracle
Use CData Sync for automated, continuous, customizable Rootly replication to Oracle.
-
Migrating data from Vimeo to Databricks using CData SSIS Components.
Easily push Vimeo data to Databricks using the CData SSIS Tasks for Vimeo and Databricks.
-
Integrate Devin with Live API Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live API data.
-
Create a Data Access Object for Aha! Data using JDBI
A brief overview of creating a SQL Object API for Aha! data in JDBI.
-
Connect to Sage 200 Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sage 200 data in the Denodo Virtual DataPort Administrator.
-
ETL Cloudflare in Oracle Data Integrator
This article shows how to transfer Cloudflare data into a data warehouse using Oracle Data Integrator.
-
Configure the CData JDBC Driver for Intercom in a Connection Pool in Tomcat
Connect to Intercom data from a connection pool in Tomcat.
-
DataBind Charts to Hive Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Hive 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 Connect to & Open BigQuery Data in Microsoft Excel
This article uses the CData ODBC driver for BigQuery to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to and Query ZohoMarketingHub Data in QlikView over ODBC
Create data visualizations with ZohoMarketingHub data in QlikView.
-
Connect RabbitMQ Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your RabbitMQ data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Rapidly Develop CouchDB-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 CouchDB.
-
Publish Facebook-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Facebook data.
-
Automated Continuous Mailjet Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Mailjet replication to PostgreSQL.
-
How to connect to YouTube Analytics Data in DBVisualizer
Integrate YouTube Analytics data with visual data analysis tools and data connection wizards in DBVisualizer
-
Working with Rootly Data in LINQPad
Execute LINQ queries to Rootly data in LINQPad.
-
Automated Continuous Pinterest Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Pinterest replication to AlloyDB.
-
Explore Geographical Relationships in Dynamics CRM Data with Power Map
Create data visualizations with Dynamics CRM data in Power Map.
-
Create Data Visualizations in Cognos BI with QuickBooks Online Data
Access QuickBooks Online data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Data Visualizations in Cognos BI with Webflow Data
Access Webflow data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Dashboards and Visualize Live Snapchat Ads Data in Geckoboard
Use CData Connect AI to connect to live Snapchat Ads data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use JayDeBeApi to access YouTube Analytics Data in Python
Use standard Python scripting and the development environment of your choice to access live YouTube Analytics data.
-
Automate Splunk Data Replication to Couchbase
Use CData Sync to Customize and automate Splunk data replication to Couchbase.
-
Access Live NetSuite SuiteAnalytics Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to NetSuite SuiteAnalytics data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Migrating data from Wistia to Snowflake using CData SSIS Components.
Easily push Wistia data to Snowflake using the CData SSIS Tasks for Wistia and Snowflake.
-
Automated Continuous Freshdesk Replication to Snowflake
Use CData Sync for automated, continuous, customizable Freshdesk replication to Snowflake.
-
Connect to SAS xpt Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAS xpt data from Appeon PowerBuilder using the CData ADO.NET Provider for SAS xpt.
-
Automated Continuous Amazon Athena Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Google BigQuery.
-
Import and Visualize Google Calendar Data in Power View
Create data visualizations based on Google Calendar data in Excel.
-
Build Data Flows from Reply.io to SQL Server using SSIS
Easily back up Reply.io data to SQL Server using the SSIS components for Reply.io.
-
Connect to Zoho Creator Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Creator in FileMaker Pro to connect to Zoho Creator and work with Zoho Creator data in your FileMaker applications.
-
Create Reports from Dynamics CRM Data in Looker Studio
Use CData Connect AI to gain access to live Dynamics CRM data and create custom reports in Looker Studio.
-
Access Live Avalara AvaTax Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Avalara AvaTax data through MCP integration.
-
Connect to Mouseflow Data in Aqua Data Studio
Access Mouseflow data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Basecamp Data in the Pentaho Report Designer
Publish reports based on Basecamp data in the Pentaho BI tool.
-
Create Tally-Connected Applications in Appsmith
Connect to Tally Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Tally data.
-
Getting Started with the CData SSIS Components for Reckon
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Reckon.
-
Automated Continuous Paylocity Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Paylocity replication to AlloyDB.
-
Build Charts with Jira Data in Clear Analytics
Create dynamic charts and perform analytics based on Jira data in Clear Analytics.
-
Use the CData Software JDBC Driver for JSON in MicroStrategy Desktop
Connect to JSON services in MicroStrategy Desktop using the CData Software JDBC Driver for JSON.
-
Create Raisers Edge NXT-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Raisers Edge NXT Data from OutSystems and build custom enterprise apps using live Raisers Edge NXT data.
-
Use the CData ODBC Driver for SAP HANA from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP HANA to connect to SAP HANA data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP HANA data in Excel.
-
Build an OLAP Cube in SSAS from Dotmailer Data
Establish a connection to Dotmailer data data from SQL Server Analysis Services, and use the Dotmailer Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Google Analytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Analytics data and build visualizations in Tableau Cloud.
-
Automate NASA Integration Tasks from PowerShell
Are you in search of a quick and easy way to access NASA data from PowerShell? This article demonstrates how to utilize the NASA Cmdlets for tasks like connecting to NASA data, automating operations, downloading data, and more.
-
Build Voice Agents in ElevenLabs with access to Live API Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live API data.
-
Access Live Amazon DynamoDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Amazon DynamoDB data into the statistical analysis tools available in SAS JMP. This article shows how to use Amazon DynamoDB data in the Graph Builder and Query Builder.
-
Create Informatica Mappings From/To a JDBC Data Source for Reckon Accounts Hosted
Create Reckon Accounts Hosted data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
View Reports on Real-Time SendGrid Data in Power BI Report Server
Use the CData ODBC Driver for SendGrid to visualize SendGrid data in Power BI Desktop and then publish them to Power BI Report Server.
-
Working with Microsoft Ads Data in LINQPad
Execute LINQ queries to Microsoft Ads data in LINQPad.
-
Import Real-Time Nethunt Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Nethunt data in ColdFusion.
-
Connect to Freshservice Data in RazorSQL
Connect to Freshservice from wizards and query Freshservice data from the GUI in the RazorSQL database management tool.
-
Integrate Dynamics 365 Business Central with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Dynamics 365 Business Central with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Dynamics 365 Business Central data.
-
Back Up Landbot 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 Landbot data data.
-
How to Easily Query Mailgun Data in OpenOffice Base
Connect to Mailgun data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Consume SAP Fieldglass OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Fieldglass feeds that reflect any changes in SAP Lumira.
-
Integrating Claude Code CLI with Greenhouse 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 a Simple VCL Application for Suadeo Data
How to build a simple VCL Application to view Suadeo data in RAD Studio using the CData ODBC Driver for Suadeo.
-
How to Visualize Microsoft Dataverse 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 Microsoft Dataverse data in Python.
-
How to connect to Act CRM Data with Squirrel SQL client
Connect to Act CRM data and execute queries in the Squirrel SQL Client.
-
Integrate ConvertAPI Data in Pentaho Data Integration
Build ETL pipelines based on ConvertAPI data in the Pentaho Data Integration tool.
-
Automated Continuous NASA Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable NASA replication to Apache Cassandra.
-
Process & Analyze CircleCI Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live CircleCI Data.
-
Query LinkedIn Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume LinkedIn entities in PHP by modeling them as objects.
-
Automated Continuous WooCommerce Replication to MongoDB
Use CData Sync for automated, continuous, customizable WooCommerce replication to MongoDB.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Productboard
Provide connectivity to Productboard data through an SAP BusinessObjects universe.
-
Query Power BI XMLA Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Power BI XMLA entities in PHP by modeling them as objects.
-
Publish Exact Online-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Exact Online data.
-
Integrate with QuickBooks Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy QuickBooks data to a JSON file on disk.