CData Software - Knowledge Base
Recent Articles
-
How to use SQLAlchemy ORM to access Asana Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Asana data.
-
Connect to PingOne Data from PowerBuilder via ADO.NET
This article demonstrates how to access PingOne data from Appeon PowerBuilder using the CData ADO.NET Provider for PingOne.
-
Build Semantic Layer Views for Monday.com Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Monday.com data.
-
Easily Integrate Xero Data in Lazarus Pascal IDE
Learn how to easily integrate live Xero data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Import Real-Time Guru Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Guru data in ColdFusion.
-
Access Live Telegram Data in Coginiti Pro
Connect to and query live Telegram data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate with Zuora Data in JReport Designer
Create charts and reports based on Zuora data in JReport Designer.
-
Create Confluence-Connected Nintex Workflows
Use CData Connect AI to connect to Confluence Data from Nintex Workflow Cloud and build custom workflows using live Confluence data.
-
Query Procore Data in DataGrip
Create a Data Source for Procore in DataGrip and use SQL to query live Procore data.
-
Create Reports with Testmonitor Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Testmonitor data.
-
Automated Continuous AlloyDB Replication to Oracle
Use CData Sync for automated, continuous, customizable AlloyDB replication to Oracle.
-
Automated Continuous Dotmailer Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Dotmailer replication to delimited files (CSV/TSV).
-
Create Dynamic Wave Financial Grids Using the Infragistics XamDataGrid
Learn how you can connect Wave Financial to Infragistics XamDataGrid to build dynamic grids.
-
Build Data Flows from SQL Server to Square through SSIS
Easily push SQL Server data to Square using the CData SSIS Tasks for Square.
-
Object-Relational Mapping (ORM) with Google Sheets Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Google Sheets data into a Java-based ORM framework, Hibernate.
-
Visualize Google Search Results in Sisense
Create an ElastiCube in Sisense app with access to Google Search results.
-
ConstantContact Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ConstantContact data through CData Connect AI using different applications and tools.
-
Design BIRT Reports on Wrike Data
Provide current Wrike data to your embedded analytics.
-
Automate AdRoll Data Replication to Azure Data Lake
Use CData Sync to customize and automate AdRoll data replication to Azure Data Lake.
-
Access QuickBooks Data from MySQL in PHP
Connect to QuickBooks through the standard MySQL libraries in PHP.
-
Easily Integrate ZohoExpense Data in Lazarus Pascal IDE
Learn how to easily integrate live ZohoExpense data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Kiro with Klaviyo 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.
-
Seamlessly Bring Yelp Data into Retool Using CData Connect AI
Integrate Yelp data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Easily Integrate Azure Analysis Services Data in Lazarus Pascal IDE
Learn how to easily integrate live Azure Analysis Services data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create SSAS Tabular Models from Presto Data
How to build a SQL Server Analysis Service Tabular Model from Presto data using CData drivers.
-
Explore Geographical Relationships in Google Cloud Storage Data with Power Map
Create data visualizations with Google Cloud Storage data in Power Map.
-
Analyze Google Cloud Storage Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Cloud Storage from Power Pivot. You will use the Table Import Wizard to load Google Cloud Storage data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate QuickBooks Data in Pentaho Data Integration
Build ETL pipelines based on QuickBooks data in the Pentaho Data Integration tool.
-
Connect to SAP HANA Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP HANA data from Crystal Reports.
-
Provide OData Services of Outreach.io Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Outreach.io data by developing a WCF Service Application.
-
Build SAP Business Warehouse-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 SAP Business Warehouse data without replication.
-
Build Data Flows from SQL Server to Salesforce Pardot through SSIS
Easily push SQL Server data to Salesforce Pardot using the CData SSIS Tasks for Salesforce Pardot.
-
Building Dynamic Web Pages with Box Data Using AngularJS
Create single-page applications with live connectivity to Box using the CData API Server.
-
Connect to Grafana Data in HULFT Integrate
Connect to Grafana as a JDBC data source in HULFT Integrate
-
Use the CData Software JDBC Driver for Act-On in MicroStrategy
Connect to Act-On data in MicroStrategy Developer using the CData Software JDBC Driver for Act-On.
-
Enable the REST JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with REST data.
-
Automated Continuous Yelp Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Yelp replication to Amazon S3.
-
Integrating Claude Code CLI with WordPress 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.
-
Analyze Scrapfly Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Scrapfly data with the CData JDBC Driver for Scrapfly.
-
Design BIRT Reports on Eventbrite Data
Provide current Eventbrite data to your embedded analytics.
-
Visualize Live Coinbase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Coinbase data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Zoho Projects Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zoho Projects data in the Denodo Virtual DataPort Administrator.
-
Build Bullhorn CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Bullhorn CRM Data and create custom apps in Mendix.
-
Use the CData ODBC Driver for Figshare from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Figshare to connect to Figshare data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Figshare data in Excel.
-
Automated Continuous Teamgate Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Teamgate replication to Apache Kafka.
-
Publish Microsoft Entra ID-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Entra ID data.
-
How to create Visio diagrams from NetSuite Data
Automatically update NetSuite data with the changes you make to Visio master shapes.
-
Getting Started with the CData ADO.NET Provider for Basecamp
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Basecamp.
-
Replicate Drip Data in Heroku for Use in Salesforce Connect
Replicate Drip data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Model VWO Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and VWO, enabling the direct import of real-time VWO data.
-
Connect to ZohoInvoice Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live ZohoInvoice data.
-
Automated Continuous RSS Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable RSS replication to Azure SQL Database.
-
How to Work with Rootly Data in AWS Glue Jobs Using JDBC
Connect to Rootly from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Amazon Marketplace-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Amazon Marketplace data.
-
Use the CData Software JDBC Driver for Amazon Athena in MicroStrategy Desktop
Connect to Amazon Athena data in MicroStrategy Desktop using the CData Software JDBC Driver for Amazon Athena.
-
Work with Mailgun Data in FoxPro
Load Mailgun data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect BigQuery to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect BigQuery with IBM WebSphere for seamless data integration and connectivity.
-
Integrating Codex with Mode 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.
-
How to Connect YouTube Analytics Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live YouTube Analytics data in real time using natural language.
-
Connect to Neo4J Data in ACL Analytics
Connect to Neo4J data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Neo4J data.
-
Build Apps with Live SFTP data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SFTP data into the Adalo platform and build custom mobile and web applications with real-time SFTP data.
-
Build MVC Applications with Connectivity to Marketo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Marketo from an ASP.NET MVC application.
-
Connecting Agentforce with Couchbase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Couchbase data for you.
-
Connect to SAP Hybris C4C Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Hybris C4C as an External Source in Dremio.
-
Write a Simple Go Application to work with Tally Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Tally data.
-
Access Box Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Box data from HeidiSQL.
-
Connect to Coda Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Coda data.
-
Automate Microsoft Ads Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Ads data replication to Couchbase.
-
Analyze Gmail Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Gmail data and visualize Gmail data in SAP Analytics Cloud.
-
Connect Everhour Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Everhour data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Live SAP Business Warehouse Data in MicroStrategy through CData Connect AI
Create a live connection to SAP Business Warehouse Data in CData Connect AI and connect to your SAP Business Warehouse data from MicroStrategy.
-
A PostgreSQL Interface for Salesforce Data 360 Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce Data 360 ODBC Driver to create a PostgreSQL entry-point for data access.
-
Rapidly Develop Toggl-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 Toggl.
-
Build Agents in Relevance AI with Access to Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on BambooHR data within intelligent agent workflows.
-
Create Microsoft Planner-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Microsoft Planner Data from Klipfolio and build custom visualizations using live Microsoft Planner data.
-
Connect to Google Contacts Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Contacts as an External Source in Dremio.
-
Build Pipelines with Live Sybase IQ Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Sybase IQ from Google Cloud Data Fusion, enabling the integration of live Sybase IQ data into the building and management of effective data pipelines.
-
How to Work with ConvertAPI Data in AWS Glue Jobs Using JDBC
Connect to ConvertAPI from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate SingleStore with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SingleStore with External Services.
-
How to Easily Query Sage Cloud Accounting Data in OpenOffice Base
Connect to Sage Cloud Accounting data in OpenOffice Base using the CData ODBC Driver for Sage Cloud Accounting and generate reports with live data insights.
-
Access Live GitHub Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate GitHub data into the statistical analysis tools available in SAS JMP. This article shows how to use GitHub data in the Graph Builder and Query Builder.
-
Extract, Transform, and Load Freshsales Data in Informatica PowerCenter
Create a simple Workflow for Freshsales data in Informatica PowerCenter.
-
Migrating data from Google Drive to Databricks using CData SSIS Components.
Easily push Google Drive data to Databricks using the CData SSIS Tasks for Google Drive and Databricks.
-
Access Live Freshdesk Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Freshdesk data into the statistical analysis tools available in SAS JMP. This article shows how to use Freshdesk data in the Graph Builder and Query Builder.
-
Use the CData SSIS Components to Insert New or Update Existing Snapchat Ads Records from SQL Server
Easily push SQL Server data to Snapchat Ads using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Snapchat Ads or update existing records with data from a SQL Server database.
-
Analyze Live Act-On Data in SAS Viya
Use CData Connect AI to connect to Act-On data from SAS Viya and deploy self-service analytics using live Act-On data.
-
Manage ZohoSubscriptions Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ZohoSubscriptions.
-
Connect to Email Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Email Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use JayDeBeApi to access Avalara AvaTax Data in Python
Use standard Python scripting and the development environment of your choice to access live Avalara AvaTax data.
-
Write a Simple Go Application to work with Marketo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Marketo data.
-
Build Charts with MailerLite Data in Clear Analytics
Create dynamic charts and perform analytics based on MailerLite data in Clear Analytics.
-
Connect to Short.io Data in NetBeans
Connect to Short.io data in NetBeans with the data source configuration wizard.
-
Integrate Dify with Live Sage Intacct 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 Sage Intacct data.
-
Connect to Live Hive Data in MicroStrategy through CData Connect AI
Create a live connection to Hive Data in CData Connect AI and connect to your Hive data from MicroStrategy.
-
Connect to Sage 300 Data in HULFT Integrate
Connect to Sage 300 as a JDBC data source in HULFT Integrate
-
Add HubSpot Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HubSpot with the Informatica Enterprise Data Catalog to classify and organize data.
-
Visualize Clari Data in Tableau
The CData ODBC driver for Clari enables you integrate Clari data into Tableau dashboards.
-
Import Real-Time Samanage Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Samanage data in ColdFusion.
-
Link Gumroad with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Gumroad data in Filemaker Pro for Mac or Windows.
-
How to connect PolyBase to Microsoft OneDrive
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft OneDrive data.