CData Software - Knowledge Base
Recent Articles
-
Use CData Connect AI to Access Authorize.Net Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Authorize.Net in the Power Pivot business intelligence tool.
-
Connect to Live QuickBooks Online Data in PostGresSQL Interface through CData Connect AI
Create a live connection to QuickBooks Online in CData Connect AI and connect to your QuickBooks Online from PostgreSQL.
-
Build Dashboards with Mailgun Data in DBxtra
Create dynamic dashboards and perform analytics based on Mailgun in DBxtra.
-
How to Access Live AgileCRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for AgileCRM enables you to integrate AgileCRM into workflows built using Microsoft Power Automate Desktop.
-
Connect to Square Data from a Connection Pool in Jetty
The Square JDBC Driver supports connection pooling: This article shows how to connect faster to Square from Web apps in Jetty.
-
Create Avro-Connected Nintex Workflows
Use CData Connect AI to connect to Avro Data from Nintex Workflow Cloud and build custom workflows using live Apache Avro.
-
A PostgreSQL Interface for SAP SuccessFactors Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP SuccessFactors JDBC Driver to create a PostgreSQL entry-point for data access.
-
Work with Live HubSpot Data in Power Query
Use CData Connect AI to connect to HubSpot and work with live HubSpot in Microsoft Power Query.
-
Automated Continuous CData Connect AI Replication to Vertica
Use CData Sync for automated, continuous, customizable CData Connect AI replication to Vertica.
-
Integrate Rootly Data in Pentaho Data Integration
Build ETL pipelines based on Rootly in the Pentaho Data Integration tool.
-
Analyze Amazon Marketplace Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Amazon Marketplace and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Bugsnag Data in Coginiti Pro
Connect to and query live Bugsnag from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect Active Directory Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Active Directory using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Reports with Adobe Experience Manager Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Experience Manager.
-
How to Access Live Gong Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Gong enables you to integrate Gong into workflows built using Microsoft Power Automate Desktop.
-
Connect to QuickBooks Data in JRuby
Create a simple JRuby app with access to live QuickBooks Desktop.
-
Working with Brex Data in LINQPad
Execute LINQ queries to Brex in LINQPad.
-
Build Dotmailer-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Dotmailer and build web apps with connectivity to live Dotmailer.
-
How to update Salesforce CRM Analytics from Excel
This article explains how to transfer data from Excel to Salesforce CRM Analytics using the Excel Add-In for Salesforce CRM Analytics.
-
How to Connect to & Open Act CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Act CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate with live SAP SuccessFactors LMS Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP SuccessFactors LMS in Jitterbit.
-
How to Build an ETL App for Databricks Data in Python with CData
Create ETL applications and real-time data pipelines for Databricks in Python with petl.
-
Connect to Cosmos DB Data in ACL Analytics
Connect to Azure Cosmos DB via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Azure Cosmos DB.
-
How to Connect to Live SAP Netweaver Gateway Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SAP Netweaver Gateway through natural language.
-
Connect to Google Directory Data in RazorSQL
Connect to Google Directory from wizards and query Google Directory from the GUI in the RazorSQL database management tool.
-
Build Semantic Layer Views for CircleCI Data in APOS Live Data Gateway
Use the CData Connector for CircleCI in APOS Live Data Gateway to build Semantic Layer Views for CircleCI.
-
Use the CData Software ODBC Driver for Azure Analysis Services in MicroStrategy
Connect to Azure Analysis Services in MicroStrategy Developer using the CData Software ODBC Driver for Azure Analysis Services.
-
How to Access Live Acumatica Data in Visual Studio Code via Cline
Run CData MCP Server for Acumatica on Windows Subsytem for Linux (WSL) and connect to live Acumatica ERP from the Cline extension in Visual Studio Code.
-
Integrating Claude Code CLI with Drip 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 to Live Okta Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Okta securely in real time.
-
DataBind Controls to Odoo Data in C++Builder
DataBind to Odoo ERP in C++Builder with standard components and controls.
-
Connect to LDAP Objects from PowerBuilder via ADO.NET
This article demonstrates how to access LDAP from Appeon PowerBuilder using the CData ADO.NET Provider for LDAP.
-
Connect to TigerGraph Data in Claris FileMaker Pro
Use the CData ODBC Driver for TigerGraph in FileMaker Pro to connect to TigerGraph and work with TigerGraph in your FileMaker applications.
-
Creating Greenhouse-Connected Applications in Unqork
You can use CData Connect AI to feed Greenhouse to Unqork and build custom business apps.
-
Access Live Avro Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache Avro into the statistical analysis tools available in SAS JMP. This article shows how to use Apache Avro in the Graph Builder and Query Builder.
-
Use JayDeBeApi to access MarkLogic Data in Python
Use standard Python scripting and the development environment of your choice to access live MarkLogic.
-
Automated Continuous Outreach.io Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Outreach.io replication to Google BigQuery.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SendInBlue
Provide connectivity to SendInBlue through an SAP BusinessObjects universe.
-
Query Guru Data in ColdFusion
Write standard ColdFusion data access code to connect to Guru.
-
How to create an RPA flow for Google Drive Data in UiPath Studio
Use the Google Drive ODBC Driver to create workflows that access real-time Google Drive without any coding.
-
Automate Accelo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Accelo replication to Azure Data Lake.
-
Access Live Zoho Projects 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 Zoho Projects through MCP integration.
-
Publish Google Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Ads.
-
Build AI/ML Models with Live Tickspot Data using Dataiku
Connect Tickspot Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Exa Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Exa replication to Apache Cassandra.
-
Excel Spreadsheet Automation on Moosend Data with the QUERY Formula
Pull data from Moosend, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for Testmonitor in MicroStrategy Web
Connect to Testmonitor in MicroStrategy Web using the CData Software ODBC Driver for Testmonitor.
-
Write a Simple Go Application to work with Presto Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Presto.
-
DataBind Controls to Vercel Data in C++Builder
DataBind to Vercel in C++Builder with standard components and controls.
-
Automated Continuous BenchmarkEmail Replication to Oracle
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Oracle.
-
Model, Search, and Visualize Live Procore Data in ThoughtSpot
Use CData Connect AI to connect to live Procore for modeling, searching, and visualizing.
-
How to Seamlessly Import Gumroad Data into IBM SPSS Modeler
Integrate Gumroad data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Dotmailer Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Dotmailer from Node.js.
-
DataBind Charts to SAP Fieldglass Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Fieldglass 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.
-
Creating CockroachDB-Connected Applications in Unqork
You can use CData Connect AI to feed CockroachDB to Unqork and build custom business apps.
-
Integrate Cline with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live CockroachDB from within your IDE.
-
Use the CData ODBC Driver for Brex from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Brex to connect to Brex from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Brex in Excel.
-
Access Live Slack Data in Excel 365 Online (Excel for the web)
Connect to Slack from Excel 365 Online (Excel for the web) with CData Connect AI.
-
LINQ to Highrise 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 Highrise Data Provider.
-
Connecting Pipedream with Sage 200 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 Sage 200 data in real time.
-
DataBind Charts to ShipEngine Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ShipEngine 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 in DBxtra.
-
Prepare, Blend, and Analyze Hacker News Data in Alteryx Designer (ODBC)
Build workflows to access live Hacker News 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 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 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 in MicroStrategy Developer using the CData Software ODBC Driver for Stripe.
-
How to Access Salesforce Data 360 Data Using Entity Framework
This article shows how to access Salesforce Data 360 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.
-
Bidirectional Access to PayPal Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PayPal in Filemaker Pro for Mac or Windows.
-
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 to a chart.
-
Migrating data from Moosend to Google BigQuery using CData SSIS Components.
Easily push Moosend 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 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 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.
-
Import Freshdesk Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Freshdesk. In this article, you will use the OData format to import Freshdesk into Microsoft Power Query.
-
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.
-
Publish Reports with Square Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Square.
-
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.
-
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 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 in your FileMaker applications.
-
Build Dashboards with MessageBird Data in DBxtra
Create dynamic dashboards and perform analytics based on MessageBird 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.
-
Analyze REST Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze REST 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. Leverage the pyodbc module for ODBC in Python.
-
Connect to Office 365 in SpagoBI
Create reports featuring live Microsoft Office 365 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 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 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 and execute queries in the Squirrel SQL Client.
-
Build Odoo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Odoo ERP and build web apps with connectivity to live Odoo ERP.
-
Edit and Search External LinkedIn Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of LinkedIn Ads 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.
-
Connect to Shopify Data in NetBeans
Connect to Shopify in NetBeans with the data source configuration wizard.