CData Software - Knowledge Base
Recent Articles
-
Import Sage 200 into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sage 200. In this article, you will use the OData format to import Sage 200 into Microsoft Power Query.
-
Viewing Zendesk in RAD Studio Data Explorer
How to view Zendesk in RAD Studio Data Explorer using the CData ODBC Driver for Zendesk.
-
How to Visualize Facebook Ads Data in Python with pandas
Use pandas and other modules to analyze and visualize live Facebook Ads in Python.
-
Migrating data from Google Analytics to Snowflake using CData SSIS Components.
Easily push Google Analytics to Snowflake using the CData SSIS Tasks for Google Analytics and Snowflake.
-
Create Dynamic SAP SuccessFactors Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP SuccessFactors to Infragistics XamDataGrid to build dynamic grids.
-
Access Live SAP ByDesign in AWS Lambda
Connect to live SAP Business ByDesign in AWS Lambda using the CData JDBC Driver.
-
How to Query Live Email in Claude Desktop
Connect to and query live Email in Claude Desktop using the CData MCP Server.
-
Connect to Drip in NetBeans
Connect to Drip in NetBeans with the data source configuration wizard.
-
Integrate Salesforce Pardot in Pentaho Data Integration
Build ETL pipelines based on Salesforce Pardot in the Pentaho Data Integration tool.
-
How to use SQLAlchemy ORM to access Sage 50 UK in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sage 50 UK.
-
Connect to Oracle Service Cloud in ACL Analytics
Connect to Oracle Service Cloud via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Service Cloud.
-
Connect to Email in NetBeans
Connect to Email in NetBeans with the data source configuration wizard.
-
Load Google Cloud Storage to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Cloud Storage to a database.
-
Getting Started with the CData SSIS Components for DB2
Complete guide to installing, licensing, and connecting with the CData SSIS Components for DB2.
-
Build Active Directory-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Active Directory from Zoho Analytics and import live Active Directory.
-
Use ChatGPT to Talk to Your Act-On via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Act-On for you.
-
Build MVC Applications with Connectivity to EventBrite
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access EventBrite from an ASP.NET MVC application.
-
Connect to Reckon in Google Apps Script via Connect AI
Use CData Connect AI to access Reckon in Google Apps Script.
-
Create Informatica Mappings From/To an ODBC Data Source for SAS Data Sets
Create an ODBC connection to SAS Data Sets in Informatica and browse and transfer SAS Data Sets.
-
Access LinkedIn from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LinkedIn from HeidiSQL.
-
How to Connect DBeaver to Twitter Ads via a JDBC Driver
Manage Twitter Ads with visual tools in DBeaver like the query browser.
-
How to import Asana into Apache Solr
Use the CData Software JDBC Driver for Asana in Data Import Handler and create an automated import of Asana to Apache Solr Enterprise Search platform.
-
Visualize Live Reckon of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Reckon using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query API from Node.js
Use the OData endpoint of the CData API Server to connect to your API and perform CRUD operations on API from Node.js.
-
Work with Live ServiceNow in Power Query
Use CData Connect AI to connect to ServiceNow and work with live ServiceNow in Microsoft Power Query.
-
Use Biml to Build SSIS Tasks to Replicate SAP Ariba Procurement to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Ariba Procurement to SQL Server.
-
Connect to NetSuite in ACL Analytics
Connect to NetSuite CRM & ERP via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to NetSuite CRM & ERP.
-
Write a Simple Go Application to work with ActiveCampaign on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ActiveCampaign.
-
Use Dash to Build to Web Apps on Box
Create Python applications that use pandas and Dash to build Box-connected web apps.
-
How to Build an ETL App for Epicor Kinetic in Python with CData
Create ETL applications and real-time data pipelines for Epicor Kinetic in Python with petl.
-
A PostgreSQL Interface for HDFS using the CData ODBC Driver
Use the SQL Gateway and HDFS ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Dynamic MYOB AccountRight Grids Using the Infragistics XamDataGrid
Learn how you can connect MYOB AccountRight to Infragistics XamDataGrid to build dynamic grids.
-
How to Query TaxJar in MySQL Workbench
Execute MySQL queries against live TaxJar from MySQL Workbench.
-
Automated Freshdesk Replication to Teradata
Use CData Sync to Customize and automate Freshdesk replication to Teradata.
-
Publish Crystal Reports on SingleStore
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SingleStore.
-
Rapidly Develop Bullhorn CRM-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
How to connect and process Zoho Projects from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Zoho Projects.
-
Analyze Google Drive in Looker
Use CData Connect AI to connect to Google Drive from Looker and build custom apps using live Google Drive.
-
Integrate with Live Dynamics 365 in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Dynamics 365 from the MuleSoft Anypoint Platform to integrate live Microsoft Dynamics 365 into custom reports and dashboards.
-
Connect to Trello from a Connection Pool in JBoss
Integrate Trello into Java servlets: Use the Management Console in JBoss to install the Trello JDBC Driver.
-
Create Data Visualizations in Cognos BI with Highrise
Access Highrise CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to create Visio diagrams from SFTP
Automatically update SFTP with the changes you make to Visio master shapes.
-
Create Dynamic Amazon S3 Grids Using the Infragistics XamDataGrid
Learn how you can connect Amazon S3 to Infragistics XamDataGrid to build dynamic grids.
-
Build Dashboards with Oracle SCM in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle SCM in Dundas BI.
-
Model, Search, and Visualize Live Xero in ThoughtSpot
Use CData Connect AI to connect to live Xero Accounting for modeling, searching, and visualizing.
-
Connect to ActiveCampaign from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ActiveCampaign from Filemaker Pro on Mac.
-
Build Acumatica Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Acumatica ERP and build visualizations in Tableau Cloud.
-
Consume Google Spanner OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Spanner feeds that reflect any changes in SAP Lumira.
-
How to create Visio diagrams from Microsoft Dataverse
Automatically update Microsoft Dataverse (CDS) with the changes you make to Visio master shapes.
-
Automated Continuous Amazon DynamoDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to SingleStore.
-
Use ChatGPT to Talk to Your SAP Hybris C4C via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP Hybris C4C for you.
-
Build CockroachDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for CockroachDB and create custom apps in Bubble.
-
Automated Continuous Marketo Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Marketo replication to Azure SQL Database.
-
Connect to Vault CRM as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Veeva Vault & Vault CRM.
-
Use the CData Software ODBC Driver for Cloudant in MicroStrategy Desktop
Connect to IBM Cloudant in MicroStrategy Desktop using the CData Software ODBC Driver for Cloudant.
-
Integrate DocuSign with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate DocuSign with External Services.
-
Use Azure AI Foundry to Talk to Your Google Analytics 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 Google Analytics for you.
-
Use the CData Software ODBC Driver for Gmail in MicroStrategy
Connect to Gmail in MicroStrategy Developer using the CData Software ODBC Driver for Gmail.
-
Feed Adobe Commerce into FineReport
How to set Adobe Commerce as a JDBC data source in FineReport.
-
How to Connect Flowise AI Agents to Live Kintone via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Query Sybase using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sybase entities in PHP by modeling them as objects.
-
Visualize BambooHR in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load BambooHR into TIBCO Spotfire.
-
DataBind ShipStation to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for ShipStation with the DevExpress Windows Forms and Web controls to provide ShipStation to a chart.
-
How to Connect to Live Oracle HCM Cloud in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Oracle HCM Cloud for you.
-
Migrating data from SAP Hybris C4C to Google BigQuery using CData SSIS Components.
Easily push SAP Hybris C4C to Google BigQuery using the CData SSIS Tasks for SAP Hybris C4C and Google BigQuery.
-
Creating BigQuery-Connected Applications in Unqork
You can use CData Connect AI to feed Google BigQuery to Unqork and build custom business apps.
-
Connect to Power BI XMLA in HULFT Integrate
Connect to Power BI XMLA as a JDBC data source in HULFT Integrate
-
Connect to Facebook in the Denodo Platform
Use CData driver technologies to create a virtual data source for Facebook in the Denodo Virtual DataPort Administrator.
-
Connect to SFTP in CloverDX (formerly CloverETL)
Transfer SFTP using the visual workflow in the CloverDX data integration tool.
-
Query Square using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Square entities in PHP by modeling them as objects.
-
Connect to QuickBooks Online in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for QuickBooks Online and connect to QuickBooks Online in Akorbi Digital RunMyProcess.
-
Analyze Printify with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Printify from Power Pivot. You will use the Table Import Wizard to load Printify. You can visually build the import query or use any SQL supported by the driver.
-
How to create an RPA flow for Instagram in UiPath Studio
Use the Instagram ODBC Driver to create workflows that access real-time Instagram without any coding.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Cloudant
Provide connectivity to IBM Cloudant through an SAP BusinessObjects universe.
-
How to publish and share Pinterest dashboards with Tableau Server
The CData ODBC driver for Pinterest enables you integrate Pinterest into Tableau dashboards.
-
A PostgreSQL Interface for Certinia (MySQL Remoting via JDBC)
Use the Remoting features of the Certinia JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Real-Time Kintone Data in Power Apps Using Dataflows to Build Custom Applications
-