CData Software - Knowledge Base
Recent Articles
-
DataBind Charts to ShipEngine Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ShipEngine 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.
-
Build Dashboards with ZohoDesk Data in DBxtra
Create dynamic dashboards and perform analytics based on ZohoDesk data in DBxtra.
-
Use Dash to Build Web Apps on Teradata Data via CData Connect AI
Build interactive Dash web apps on live Teradata data using pandas and the CData Connect AI Python SDK.
-
Prepare, Blend, and Analyze Hacker News Data in Alteryx Designer (ODBC)
Build workflows to access live Hacker News data for self-service data analytics.
-
Connect to SAP Business Warehouse Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Business Warehouse data from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Business Warehouse.
-
Replicate Copper Data in Heroku for Use in Salesforce Connect
Replicate Copper data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to work with MailerLite Data in Apache Spark using SQL
Access and process MailerLite Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Stripe in MicroStrategy
Connect to Stripe data in MicroStrategy Developer using the CData Software ODBC Driver for Stripe.
-
Automated Continuous Paddle Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Paddle replication to Amazon Redshift.
-
How to integrate Metabase with Wave Financial Data
Use CData Connect AI to connect to live Wave Financial data and create an interactive dashboard in Metabase from Wave Financial data.
-
How to Access Salesforce Data 360 Data Using Entity Framework
This article shows how to access Salesforce Data 360 data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Stripe Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Stripe from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect PolyBase to IBM Informix
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live IBM Informix data.
-
Link PayPal with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PayPal data in Filemaker Pro for Mac or Windows.
-
Create iContact-Connected Nintex Workflows
Use CData Connect AI to connect to iContact Data from Nintex Workflow Cloud and build custom workflows using live iContact data.
-
DataBind Azure Data Catalog Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Azure Data Catalog with the DevExpress Windows Forms and Web controls to provide Azure Data Catalog data to a chart.
-
Migrating data from Moosend to Google BigQuery using CData SSIS Components.
Easily push Moosend data to Google BigQuery using the CData SSIS Tasks for Moosend and Google BigQuery.
-
How to Connect to & Open Stack Exchange Data in Microsoft Excel
This article uses the CData ODBC driver for Stack Exchange to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Unbounce Data Replication to SAP HANA
Use CData Sync to customize and automate Unbounce data replication to SAP HANA.
-
Automated Continuous Adobe Analytics Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to AlloyDB.
-
DataBind Charts to Gorgias Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Gorgias 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.
-
Add Mouseflow Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mouseflow with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Outreach.io Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Outreach.io data.
-
Publish Reports with Square Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Square data.
-
Use JayDeBeApi to access Act CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Act CRM data.
-
Easily Integrate with Any RESTful API Using the CData API Driver
Configure the CData API Driver to enable codeless API connectivity between apps and APIs.
-
How to Query CircleCI Data in MySQL Workbench
Execute MySQL queries against live CircleCI data from MySQL Workbench.
-
Automated Continuous Sage 300 Replication to MySQL
Use CData Sync for automated, continuous, customizable Sage 300 replication to MySQL.
-
Connect to ZohoDesk Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZohoDesk and work with ZohoDesk data in your FileMaker applications.
-
Build Dashboards with MessageBird Data in DBxtra
Create dynamic dashboards and perform analytics based on MessageBird data in DBxtra.
-
Create Dynamic Customer.io Grids Using the Infragistics XamDataGrid
Learn how you can connect Customer.io to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Dataiku with XML Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live XML data.
-
Analyze REST Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze REST data with the CData JDBC Driver for REST.
-
How to Seamlessly Import Lakebase Data into IBM SPSS Modeler
Integrate Lakebase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to Yelp Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Yelp data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Office 365 in SpagoBI
Create reports featuring live Office 365 data in SpagoBI Studio. Host Office 365 reports on SpagoBI Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Discourse
Provide connectivity to Discourse data through an SAP BusinessObjects universe.
-
How to Visualize LinkedIn Ads 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 LinkedIn Ads data in Python.
-
Building Dynamic Web Pages with Office 365 Data Using AngularJS
Create single-page applications with live connectivity to Office 365 using the CData API Server.
-
How to connect to Strava Data with Squirrel SQL client
Connect to Strava data and execute queries in the Squirrel SQL Client.
-
Build Odoo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Odoo data and build web apps with connectivity to live Odoo data.
-
Access Live Moosend Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Moosend data from your Google Sheets.
-
Search External LinkedIn Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of LinkedIn Ads data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create LinkedIn Ads Data objects that you can access from apps and the dashboard.
-
How to use SQLAlchemy ORM to access JotForm Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of JotForm data.
-
Connect to Shopify Data in NetBeans
Connect to Shopify data in NetBeans with the data source configuration wizard.
-
Publish Reports with Sage 300 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage 300 data.
-
Connect to Dropbox Data in RapidMiner
Integrate Dropbox data with standard components and data source configuration wizards in RapidMiner Studio.
-
Load Google Spanner Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Spanner data to a database.
-
Connect to Google Directory Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Directory data in Google Apps Script.
-
Access Live Certinia Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Certinia data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Amazon Athena Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Amazon Athena data. Leverage the pyodbc module for ODBC in Python.
-
Integrating LangChain with Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sage 200 data within automated workflows.
-
Connect to MariaDB Data from PowerBuilder via JDBC
This article demonstrates how to access MariaDB data from PowerBuilder using the MariaDB JDBC Driver.
-
DataBind Charts to Freshdesk Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Freshdesk 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 Build an ETL App for LDAP Objects in Python with CData
Create ETL applications and real-time data pipelines for LDAP objects in Python with petl.
-
How to Create Power BI Visual Reports with Real-Time Amazon Athena Data
Use CData Power BI Connectors to visualize Amazon Athena data in Power BI.
-
Analyze Asana Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Asana from Power Pivot. You will use the Table Import Wizard to load Asana data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Trae with Live Anaplan Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Anaplan data from within the AI-powered IDE.
-
Use the CData Software ODBC Driver for Google Search in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Search results in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Search.
-
How to Seamlessly Import Facebook Data into IBM SPSS Modeler
Integrate Facebook data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
DataBind Perplexity Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Perplexity data to a chart.
-
Access Highrise Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Highrise data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Facebook Ads
Provide connectivity to Facebook Ads data through an SAP BusinessObjects universe.
-
Getting Started with the CData Excel Add-In for Printful
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Printful.
-
Integrate Goose with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Azure Data Lake Storage data from within the local AI agent.
-
Access Salesforce Marketing Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Salesforce Marketing data from HeidiSQL.
-
Easily Integrate Retently Data in Lazarus Pascal IDE
Learn how to easily integrate live Retently data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Intercom Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Intercom replication to Apache Kafka.
-
Connecting Pipedream with xBase 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 xBase data in real time.
-
Connect to Google Sheets Data in NetBeans
Connect to Google Sheets data in NetBeans with the data source configuration wizard.
-
Visualize Monday.com Data in TIBCO Spotfire through ADO.NET
Integrate Monday.com data into dashboards in TIBCO Spotfire.
-
Replicate Multiple SAP Netweaver Gateway Accounts via the CData Sync CLI
Replicate multiple SAP Netweaver Gateway accounts to one or many databases.
-
How to Connect to Live PostgreSQL Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your PostgreSQL data for you.
-
How to integrate Aha! with Apache Airflow
Access and process Aha! data in Apache Airflow using the CData JDBC Driver.
-
Integrate Rebilly Data in the Pentaho Report Designer
Publish reports based on Rebilly data in the Pentaho BI tool.
-
How to connect to Rebilly Data from Spring Boot
Connect to Rebilly in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Microsoft OneDrive Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft OneDrive data in the Denodo Virtual DataPort Administrator.
-
How to Use a Microsoft Access Database to Update Microsoft Teams Data in Real Time
Update Microsoft Teams data by creating a linked table in Microsoft Access with the CData Microsoft Teams ODBC Driver.
-
Build a Simple VCL Application for ClickTime Data
How to build a simple VCL Application to view ClickTime data in RAD Studio using the CData ODBC Driver for ClickTime.
-
Build Oracle Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle data and build visualizations in Tableau.
-
How to Query SendInBlue Data in MySQL Workbench
Execute MySQL queries against live SendInBlue data from MySQL Workbench.
-
Integrate Live Salesforce Marketing Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Salesforce Marketing from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Salesforce Marketing data.
-
Easily Integrate Cloudflare Data in Lazarus Pascal IDE
Learn how to easily integrate live Cloudflare data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Clio Data Replication to Teradata
Use CData Sync to Customize and automate Clio data replication to Teradata.
-
Use ChatGPT to Talk to Your Dynamics NAV 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 Dynamics NAV data for you.
-
Connect to and Visualize Live CapsuleCRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live CapsuleCRM data.
-
How to Connect to Trello Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Trello data. Leverage the pyodbc module for ODBC in Python.
-
Build Semantic Layer Views for Guru Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Guru data.
-
Use the CData Software ODBC Driver for Coda in MicroStrategy
Connect to Coda data in MicroStrategy Developer using the CData Software ODBC Driver for Coda.
-
Connect SendPulse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SendPulse data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Real-Time Odoo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Odoo and Dataflow to import and use Odoo data in Power Apps.
-
Build Semantic Layer Views for SQL Analysis Services Data in APOS Live Data Gateway
Use the CData Connector for SQL Analysis Services in APOS Live Data Gateway to build Semantic Layer Views for SQL Analysis Services data.
-
Integrating Gumloop with SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP HANA data within automated workflows.
-
Working with ZeroBounce Data in LINQPad
Execute LINQ queries to ZeroBounce data in LINQPad.
-
Build AI/ML Models with Live Guru Data using Dataiku
Connect Guru Data with Dataiku using the CData API Driver for JDBC.
-
Integrate CampaignMonitor with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CampaignMonitor with External Services.
-
Integrate Open WebUI with Live ZohoInvoice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ZohoInvoice data from within the chat interface.
-
Automated Continuous Salesforce CRM Analytics Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Apache Cassandra.
-
Back Up Reckon Accounts Hosted data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Reckon Accounts Hosted. In this article, we will employ an SSIS workflow to populate a database with Reckon Accounts Hosted data data.
-
Create Reports from Google Ads Data in Looker Studio
Use CData Connect AI to gain access to live Google Ads data and create custom reports in Looker Studio.