CData Software - Knowledge Base
Recent Articles
-
Back Up GitHub to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for GitHub. In this article, we will employ an SSIS workflow to populate a database with GitHub data.
-
Automated Continuous Azure Blob Storage Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Amazon S3.
-
How to Access Live Facebook in Power Automate Desktop via ODBC
The CData ODBC Driver for Facebook enables you to integrate Facebook into workflows built using Microsoft Power Automate Desktop.
-
Integrate with Eventbrite in JReport Designer
Create charts and reports based on Eventbrite in JReport Designer.
-
Bidirectional Access to Dynamics CRM from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dynamics CRM in Filemaker Pro for Mac or Windows.
-
Automated Parquet Replication to Teradata
Use CData Sync to Customize and automate Apache Parquet replication to Teradata.
-
Create Reports from Sage 200 in Looker Studio
Use CData Connect AI to gain access to live Sage 200 and create custom reports in Looker Studio.
-
Connect to Live Redis in PostGresSQL Interface through CData Connect AI
Create a live connection to Redis in CData Connect AI and connect to your Redis from PostgreSQL.
-
Integrate with Live Oracle HCM Cloud in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle HCM Cloud from the MuleSoft Anypoint Platform to integrate live Oracle HCM Cloud into custom reports and dashboards.
-
Use ChatGPT to Talk to Your Amazon Athena via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Amazon Athena for you.
-
How to Connect to Square in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Square. Leverage the pyodbc module for ODBC in Python.
-
Build MVC Applications with Connectivity to FHIR
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access FHIR from an ASP.NET MVC application.
-
Connect to Zoho Books in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zoho Books and connect to Zoho Books in Akorbi Digital RunMyProcess.
-
Build Dashboards with Drift in DBxtra
Create dynamic dashboards and perform analytics based on Drift in DBxtra.
-
Query SurveyMonkey from Node.js
Use the OData endpoint of the CData API Server to connect to your SurveyMonkey and perform CRUD operations on SurveyMonkey from Node.js.
-
How to update Oracle Sales from Excel
This article explains how to transfer data from Excel to Oracle Sales using the Excel Add-In for Oracle Sales.
-
Automated Continuous Couchbase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Couchbase replication to Google Cloud SQL.
-
Connect to Google Sheets from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Sheets, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Import ClickUp into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ClickUp. In this article, you will use the OData format to import ClickUp into Microsoft Power Query.
-
Query Wave Financial in ColdFusion
Write standard ColdFusion data access code to connect to Wave Financial.
-
Connect to SuiteCRM as an External Source in Dremio
Use the CData JDBC Driver to connect to SuiteCRM as an External Source in Dremio.
-
PowerShell Scripting to Replicate LinkedIn to MySQL
Write a simple PowerShell script to replicate LinkedIn to a MySQL database.
-
Query REST in ColdFusion
Write standard ColdFusion data access code to connect to REST.
-
Replicate RSS Feeds in Heroku for Use in Salesforce Connect
Replicate RSS Feeds to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Excel from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Excel from Appeon PowerBuilder using the CData ADO.NET Provider for Excel.
-
Analyze Act-On in Infragistics Reveal
Use the CData API Server to create an OData API on top of Act-On and visualize live Act-On in Infragistics Reveal.
-
DataBind Charts to Excel Online
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Excel Online 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 an OLAP Cube in SSAS from Marketo
Establish a connection to Marketo data from SQL Server Analysis Services, and use the Marketo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Publish Reports with Google Ads in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Ads.
-
Automated Continuous Harvest Replication to Databricks
Use CData Sync for automated, continuous, customizable Harvest replication to Databricks.
-
Import and Visualize Printful in Power View
Create data visualizations based on Printful in Excel.
-
Create Parquet Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Enable the BigCommerce JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with BigCommerce.
-
Connect to Avalara AvaTax as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Avalara AvaTax.
-
Replicate Multiple Google Contacts Accounts
Replicate multiple Google Contacts accounts to one or many databases.
-
Integrate Sage Intacct into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sage Intacct and integrate live Sage Intacct into your Power Automate tasks.
-
Connect to Salesloft in Ruby
Connect to Salesloft in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Viewing Google Ads in RAD Studio Data Explorer
How to view Google Ads in RAD Studio Data Explorer using the CData ODBC Driver for Google Ads.
-
How to connect to OneNote in DBVisualizer
Integrate Microsoft OneNote with visual data analysis tools and data connection wizards in DBVisualizer
-
Operational Reporting on Unbounce from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Unbounce.
-
Publish Trello-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Trello.
-
Using the CData Software ODBC Driver for Salesforce Data Cloud in PyCharm
Connect to Salesforce Data Cloud as an ODBC data source in PyCharm using the CData Software ODBC Driver for Salesforce Data Cloud.
-
Create Google Drive-Connected Dashboards in Grafana
Connect to Google Drive via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Drive.
-
Connect to Pinterest in Jaspersoft Studio
Execute SQL to remote Pinterest in Jaspersoft Studio.
-
Use Dash to Build to Web Apps on Zoho Projects
Create Python applications that use pandas and Dash to build Zoho Projects-connected web apps.
-
Create Tableau CRM Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Tableau CRM Analytics data access from reports, embedded analytics, and more.
-
Create Salesforce Pardot-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Salesforce Pardot from Klipfolio and build custom visualizations using live Salesforce Pardot.
-
How to connect SharePoint with Azure DevOps through external lists
Provide Azure DevOps to SharePoint users as an external list.
-
Automated Continuous Zoho Projects Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zoho Projects replication to OneLake in Microsoft Fabric.
-
PowerShell Scripting to Replicate AlloyDB to MySQL
Write a simple PowerShell script to replicate Google AlloyDB to a MySQL database.
-
Create a Data Access Object for Certinia using JDBI
A brief overview of creating a SQL Object API for Certinia in JDBI.
-
Tableau Connector Getting Started Guide
A basic guide to connecting Tableau to data from anywhere using the CData Tableau Connector.
-
Using ThreadID in CData Driver Logs to Debug Multi-Threaded Operations
Learn how ThreadID appears in CData Driver logs and how to use it for analyzing multi-threaded operations.
-
Use Microsoft Copilot Studio to talk to your Hive via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Apache Hive for you.
-
Build DB2-Powered Applications in Cursor with CData Code Assist MCP
-