CData Software - Knowledge Base
Recent Articles
-
Connect to Real-Time Azure Data Lake Storage Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Azure Data Lake Storage and Dataflow to import and use Azure Data Lake Storage data in Power Apps.
-
How to Easily Query Short.io Data in OpenOffice Base
Connect to Short.io data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous SAP Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP replication to SingleStore.
-
Connect to SFTP Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SFTP and the Script function in FileMaker Pro to connect to SFTP and work with SFTP data in your FileMaker application.
-
Create a Data Access Object for Google Contacts Data using JDBI
A brief overview of creating a SQL Object API for Google Contacts data in JDBI.
-
DataBind Reckon Accounts Hosted Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Reckon Accounts Hosted with the DevExpress Windows Forms and Web controls to provide Reckon Accounts Hosted data to a chart.
-
Build ActiveCampaign-Connected Apps in Choreo
Use CData Connect AI to connect to ActiveCampaign Data from Choreo and build custom apps using live ActiveCampaign data.
-
Connect to GraphQL Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to GraphQL.
-
How to create an RPA flow for xBase Data in UiPath Studio
Use the xBase ODBC Driver to create workflows that access real-time xBase data without any coding.
-
How to Seamlessly Import HubSpot Data into IBM SPSS Modeler
Integrate HubSpot data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Access MailerSend Data Using Entity Framework
This article shows how to access MailerSend data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to ShipStation Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ShipStation as an External Source in Dremio.
-
Using the CData Software ODBC Driver for Authorize.Net in PyCharm
Connect to Authorize.Net as an ODBC data source in PyCharm using the CData Software ODBC Driver for Authorize.Net.
-
Migrating data from Exact Online to Databricks using CData SSIS Components.
Easily push Exact Online data to Databricks using the CData SSIS Tasks for Exact Online and Databricks.
-
Access Live ScrapingBee Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ScrapingBee data into the statistical analysis tools available in SAS JMP. This article shows how to use ScrapingBee data in the Graph Builder and Query Builder.
-
Moving Data from Sentry to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Sentry data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Miro Data in Aqua Data Studio
Access Miro data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Customer.io Data from PowerBuilder via ADO.NET
This article demonstrates how to access Customer.io data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Build an ETL App for Klipfolio Data in Python with CData Connect AI
Extract and transform live Klipfolio data in Python with petl and the CData Connect AI Python SDK.
-
Automated Continuous Miro Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Miro replication to IBM DB2.
-
Query Power BI XMLA Data in DataGrip
Create a Data Source for Power BI XMLA in DataGrip and use SQL to query live Power BI XMLA data.
-
Create SAP Netweaver Gateway Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Netweaver Gateway data access from reports, embedded analytics, and more.
-
Build SuiteCRM-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 SuiteCRM data without replication.
-
Build Apps with Live Workday Data Using the Low-Code Development Platform of Mendix
Connect Workday data with Mendix to build apps using the CData JDBC Driver for Workday.
-
Build Apps with Live Certinia data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Certinia data into the Adalo platform and build custom mobile and web applications with real-time Certinia data.
-
Automated Continuous Highrise Replication to Vertica
Use CData Sync for automated, continuous, customizable Highrise replication to Vertica.
-
How to Connect the Power BI Service to Bitly: Complete Guide
Connect to the CData Software Power BI Connector for Bitly from PowerBI.com to provide real-time Bitly data across the organization.
-
Build Office 365-Connected Apps in Choreo
Use CData Connect AI to connect to Office 365 Data from Choreo and build custom apps using live Office 365 data.
-
Connecting Mastra with Act CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Act CRM data, no replication required.
-
Visualize Oracle SCM Data in Sisense
Create an ElastiCube in Sisense app with access to Oracle SCM data.
-
Automated Continuous Oracle Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle replication to MySQL.
-
Connect to Omnisend Data from Crystal Reports
Use CData Connect AI to connect to and report on live Omnisend data from Crystal Reports.
-
Design BIRT Reports on Sage 300 Data
Provide current Sage 300 data to your embedded analytics.
-
Analyze ServiceNow Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of ServiceNow data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous ActiveCampaign Replication to SQLite
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to SQLite.
-
Use Dash to Build Web Apps on HDFS Data via CData Connect AI
Build interactive Dash web apps on live HDFS data using pandas and the CData Connect AI Python SDK.
-
Build a Simple VCL Application for DB2 Data
How to build a simple VCL Application to view DB2 data in RAD Studio using the CData ODBC Driver for DB2.
-
How to connect to xBase Data from Spring Boot
Connect to xBase in a Spring Boot Application using the CData JDBC Driver for xBase
-
Back Up Placid 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 Placid data data.
-
Enable the SurveyMonkey JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SurveyMonkey data.
-
Connect to Close Data in CloverDX (formerly CloverETL)
Transfer Close data using the visual workflow in the CloverDX data integration tool.
-
Connect to Certinia Data in ACL Analytics
Connect to Certinia data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Certinia data.
-
Automated Continuous SAP Ariba Procurement Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to IBM DB2.
-
Automated Continuous Grafana Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Grafana replication to Google BigQuery.
-
Access Zoho Books 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 Zoho Books data.
-
How to Connect to & Open ConstantContact Data in Microsoft Excel
This article uses the CData ODBC driver for ConstantContact to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Datasets from Productboard in Domo Workbench and Build Visualizations of Productboard Data in Domo
Use the CData Software ODBC Driver for Productboard to create datasets from Productboard data in Domo Workbench and then build visualizations in the Domo service.
-
Integrating Boomi Agentstudio with Microsoft Planner Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Planner data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Acumatica
Provide connectivity to Acumatica data through an SAP BusinessObjects universe.
-
Automate Factorial Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Factorial data from PowerShell? This article demonstrates how to utilize the Factorial Cmdlets for tasks like connecting to Factorial data, automating operations, downloading data, and more.
-
How to Work with Datadog Data in AWS Glue Jobs Using JDBC
Connect to Datadog from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Real-Time LightSpeedRetail Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use LightSpeedRetail data in Power Apps.
-
Connect to Live Blackbaud FE NXT Data in MicroStrategy through CData Connect AI
Create a live connection to Blackbaud FE NXT Data in CData Connect AI and connect to your Blackbaud FE NXT data from MicroStrategy.
-
Access ChargeOver 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 ChargeOver data.
-
Access Live Microsoft OneDrive Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Microsoft OneDrive data through MCP integration.
-
Use Azure AI Foundry to Talk to Your Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Timely data for you.
-
Integrate Open WebUI with Live PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live PingOne data from within the chat interface.
-
Automate AlloyDB Data Replication to SAP HANA
Use CData Sync to customize and automate AlloyDB data replication to SAP HANA.
-
Feed Clockify Data into FineReport
How to set Clockify data as a JDBC data source in FineReport.
-
How to Connect to AlloyDB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to AlloyDB data. Leverage the pyodbc module for ODBC in Python.
-
Use Claude to Talk to Your BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your BenchmarkEmail data for you.
-
How to Visualize SharePoint 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 SharePoint data in Python.
-
Integrate Goose with Live Grafana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Grafana data from within the local AI agent.
-
How to create Helpscout federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Helpscout data in MySQL .
-
Use the CData Software ODBC Driver for WooCommerce in MicroStrategy
Connect to WooCommerce data in MicroStrategy Developer using the CData Software ODBC Driver for WooCommerce.
-
Connect to Basecamp Data in HULFT Integrate
Connect to Basecamp as a JDBC data source in HULFT Integrate
-
Connect to Okta from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Okta data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate Campaigner Data in Heroku for Use in Salesforce Connect
Replicate Campaigner data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Trello Data from AWS Glue
Use CData Connect AI to gain access to live Trello data from your AWS Glue jobs.
-
Use Biml to Build SSIS Tasks to Replicate Procore Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Procore data to SQL Server.
-
Connect to Elasticsearch Data in RapidMiner
Integrate Elasticsearch data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live HubSpot Data in TIBCO Data Virtualization
Use the HubSpot Tibco DV Adapter to create a HubSpot data data source in TIBCO Data Virtualization Studio and gain access to live HubSpot data from your TDV Server.
-
A PostgreSQL Interface for BigCommerce Data using the CData ODBC Driver
Use the SQL Gateway and BigCommerce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query MailChimp Data in ColdFusion
Write standard ColdFusion data access code to connect to MailChimp data.
-
Connect to Cohere Data from PowerBuilder via ADO.NET
This article demonstrates how to access Cohere data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Apps with Live Wave Financial data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Wave Financial data into the Adalo platform and build custom mobile and web applications with real-time Wave Financial data.
-
DataBind Controls to Freshdesk Data in Delphi
DataBind to Freshdesk data in Delphi with standard data access components and controls.
-
Connect to Nonstandard OData Services
Extend the included schemas to connect to nonstandard OData services.
-
Link ConstantContact with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ConstantContact data in Filemaker Pro for Mac or Windows.
-
Bind Live QuickBooks Time Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks Time data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Create Power BI XMLA-Connected Applications in Appsmith
Connect to Power BI XMLA Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Power BI XMLA data.
-
Access Onfleet Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Onfleet data from HeidiSQL.
-
Connect to Real-Time SAS xpt Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAS xpt and Dataflow to import and use SAS xpt data in Power Apps.
-
Create ZohoInvoice-Connected Dashboards in Grafana
Connect to ZohoInvoice Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ZohoInvoice data.
-
Query Jira Assets Data in ColdFusion
Write standard ColdFusion data access code to connect to Jira Assets data.
-
Visualize Facebook Ads Data in TIBCO Spotfire through OData
Integrate Facebook Ads data into dashboards in TIBCO Spotfire.
-
How to connect and process Neo4J data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Neo4J data.
-
Working with Bannerbear Data in LINQPad
Execute LINQ queries to Bannerbear data in LINQPad.
-
Connect Azure Table to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Azure Table data using the CData Python MCP Server.
-
Using the CData Software ODBC Driver for AdRoll in PyCharm
Connect to AdRoll as an ODBC data source in PyCharm using the CData Software ODBC Driver for AdRoll.
-
Visualize Harvest Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Harvest data.
-
Automated Continuous Klipfolio Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Klipfolio replication to Apache Cassandra.
-
Integrate with ServiceDesk Plus Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ServiceDesk Plus data to a JSON file on disk.
-
LINQ to Reply.io 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 Reply.io Data Provider.
-
Replicate Multiple Cloudant Accounts
Replicate multiple Cloudant accounts to one or many databases.
-
Integrate Google's Antigravity Agent with Live Notion Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Notion data using the Model Context Protocol.
-
How to Work with SparkPost Data in AWS Glue Jobs Using JDBC
Connect to SparkPost from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish RSS-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live RSS feeds.
-
Feed JDBC-ODBC Bridge Data into FineReport
How to set JDBC-ODBC Bridge data as a JDBC data source in FineReport.
-
Connect to SAS Data Sets Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAS Data Sets data.