CData Software - Knowledge Base
Recent Articles
-
Use CData Connect AI to Access Slack in Microsoft Power Pivot
Use CData Connect AI to connect to live Slack in the Power Pivot business intelligence tool.
-
How to connect to Cvent with Squirrel SQL client
Connect to Cvent and execute queries in the Squirrel SQL Client.
-
Replicate Google Spanner in Heroku for Use in Salesforce Connect
Replicate Google Spanner to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build MVC Applications with Connectivity to Freshdesk
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Freshdesk from an ASP.NET MVC application.
-
Bridge SAP Ariba Procurement Connectivity with Apache NiFi
Access and process SAP Ariba Procurement in Apache NiFi using the CData JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Procore
Create Procore data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate Google Data Catalog Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Google Data Catalog and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Query Live MailChimp Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MailChimp data in natural language using Python.
-
Visualize Live Act CRM in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Act CRM into custom reports in Power BI.
-
Build a PostgreSQL Interface for Google Campaign Manager 360 using the CData JDBC Driver
Use the Remoting features of the Google Campaign Manager 360 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from HCL Domino to Databricks using CData SSIS Components.
Easily push HCL Domino to Databricks using the CData SSIS Tasks for HCL Domino and Databricks.
-
DataBind Controls to Impala in C++Builder
DataBind to Apache Impala in C++Builder with standard components and controls.
-
Connect to MySQL in HULFT Integrate
Connect to MySQL as a JDBC data source in HULFT Integrate
-
Create Data Visualizations in Cognos BI with Google Analytics
Access Google Analytics as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous SAP Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP replication to IBM DB2.
-
Replicate Stripe from PowerShell
Write a quick PowerShell script to query Stripe. Use connectivity to the live data to replicate Stripe to SQL Server.
-
Access Zendesk from MySQL in PHP
Connect to Zendesk through the standard MySQL libraries in PHP.
-
Visualize Microsoft Planner in Tableau
The CData ODBC driver for Microsoft Planner enables you integrate Microsoft Planner into Tableau dashboards.
-
Work with Live Redis in Power Query
Use CData Connect AI to connect to Redis and work with live Redis in Microsoft Power Query.
-
Publish Crystal Reports on SAP HANA
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP HANA.
-
How to Access Live LinkedIn Ads in Visual Studio Code via Cline
Run the CData MCP Server for LinkedIn Ads on Windows Subsytem for Linux (WSL) and connect to live LinkedIn Ads from the Cline extension in Visual Studio Code.
-
Build Microsoft Teams-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Teams from Choreo and build custom apps using live Microsoft Teams.
-
Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy Web
Connect to SAP Netweaver Gateway in MicroStrategy Web using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
Create Dashboards and Visualize Live DocuSign in Geckoboard
Use CData Connect AI to connect to live DocuSign and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Design FTP Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Integrate Real-Time Access to Excel Online in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Excel Online in real time.
-
ETL Zoho Inventory in Oracle Data Integrator
This article shows how to transfer Zoho Inventory into a data warehouse using Oracle Data Integrator.
-
How to Import Data from Amazon DynamoDB into Google Sheets
Import Amazon DynamoDB into a Google spreadsheet that is automatically refreshed.
-
Extract, Transform, and Load Greenhouse in Informatica PowerCenter
Create a simple Workflow for Greenhouse in Informatica PowerCenter.
-
Connect to Jira Service Management in NetBeans
Connect to Atlassian Jira Service Management in NetBeans with the data source configuration wizard.
-
Replicate Google Campaign Manager 360 to Multiple Databases via the CData Sync CLI
Replicate Google Campaign Manager 360 to disparate databases with a single configuration.
-
Automate HDFS Replication to Couchbase
Use CData Sync to Customize and automate Apache HDFS replication to Couchbase.
-
DataBind Charts to QuickBooks Online
Use the standard ADO.NET procedures for databinding to provide bidirectional access to QuickBooks 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.
-
Automated Continuous LDAP Objects Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LDAP replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData JDBC Driver for GitHub
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for GitHub.
-
Create Pinterest Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pinterest data access from reports, embedded analytics, and more.
-
Consume XML OData Feeds in SAP Lumira
Use the API Server to create data visualizations on XML feeds that reflect any changes in SAP Lumira.
-
Connect to Live Google Sheets in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Sheets in CData Connect AI and connect to your Google Sheets from PostgreSQL.
-
DataBind Charts to Bing Ads
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bing Ads 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.
-
Connect to SAP Fieldglass from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Fieldglass using standard SQL.
-
Analyze SAP Business One in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP Business One and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Connect to Live OneNote 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 Microsoft OneNote for you.
-
Connect to Twilio as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Twilio.
-
Access Klaviyo 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 Klaviyo.
-
Automated Continuous ClickUp Replication to SQLite
Use CData Sync for automated, continuous, customizable ClickUp replication to SQLite.
-
Connecting Mastra with WooCommerce 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 data across 300+ enterprise sources no replication required.
-
Work with Bing Ads in FoxPro
Load Bing Ads into a FoxPro database. This article includes full code and a walk-through of the process.
-
Explore Geographical Relationships in GraphQL with Power Map
Create data visualizations with GraphQL in Power Map.
-
DataBind SAS Data Sets to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for SAS Data Sets with the DevExpress Windows Forms and Web controls to provide SAS Data Sets to a chart.
-
Integrate SAP HANA with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP HANA with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP HANA.
-
Deploy the ADO.NET Provider for Wave Financial on an SSRS Report Server
Connect to Wave Financial from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Connect the Power BI Service to Active Directory: Complete Guide
Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.
-
How to Connect to Dynamics CRM in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Dynamics CRM. Leverage the pyodbc module for ODBC in Python.
-
Migrating data from Microsoft Dataverse to Google BigQuery using CData SSIS Components.
Easily push Microsoft Dataverse (CDS) to Google BigQuery using the CData SSIS Tasks for Microsoft Dataverse and Google BigQuery.
-
Replicate Multiple CockroachDB Accounts via the CData Sync CLI
Replicate multiple CockroachDB accounts to one or many databases.
-
Connecting GenSpark with Azure DevOps via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Load Snapchat Ads to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Snapchat Ads to a database.
-
Use Dash to Build to Web Apps on Outreach.io
Create Python applications that use pandas and Dash to build Outreach.io-connected web apps.
-
Import Zuora into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zuora and provide access to live Zuora for custom reports in the Power BI Service.
-
How to Connect to Live Microsoft Planner Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft Planner securely in real time.
-
How to publish and share Reckon Accounts Hosted dashboards with Tableau Server
The CData ODBC driver for Reckon Accounts Hosted enables you integrate Reckon Accounts Hosted into Tableau dashboards.
-
Connect to ShipStation as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live ShipStation.
-
How to work with Email in Apache Spark using SQL
Access and process Email in Apache Spark using the CData Software JDBC Driver.
-
Connect REST to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your REST using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Query Live Spark Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache Spark SQL data in natural language using Python.
-
Getting Started with the CData Excel Add-In for MYOB AccountRight
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MYOB AccountRight.
-
Rapidly Develop Highrise-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 work with Splunk in Apache Spark using SQL
Access and process Splunk in Apache Spark using the CData Software JDBC Driver.
-
Connecting GenSpark with Act CRM via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Create Datasets from Oracle Eloqua Reporting in Domo Workbench and Build Visualizations of Oracle Eloqua Reporting in Domo
Use the CData Software ODBC Driver for Oracle Eloqua Reporting to create datasets from Oracle Eloqua Reporting in Domo Workbench and then build visualizations in the Domo service.
-
How to Query HDFS in MySQL Workbench
Execute MySQL queries against live Apache HDFS from MySQL Workbench.
-
Integrate ConstantContact in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ConstantContact from Informatica Cloud.
-
Create SSAS Tabular Models from Zendesk
How to build a SQL Server Analysis Service Tabular Model from Zendesk using CData drivers.
-
Use the CData SSIS Components to Insert New or Update Existing AlloyDB Records from SQL Server
Easily push SQL Server data to AlloyDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into AlloyDB or update existing records with data from a SQL Server database.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Concur using the Model Context Protocol.
-
DataBind Avalara AvaTax to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Avalara AvaTax with the DevExpress Windows Forms and Web controls to provide Avalara AvaTax to a chart.
-
How to Visualize NetSuite Data in Python with pandas
Use pandas and other modules to analyze and visualize live NetSuite CRM & ERP in Python.
-
Connect to Google Drive in Ruby
Connect to Google Drive in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
DataBind Charts to SAP SuccessFactors
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP SuccessFactors 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.
-
Provide OData Services of Oracle HCM Cloud from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle HCM Cloud by developing a WCF Service Application.
-
Integrate Oracle Service Cloud into Automated Tasks with Power Automate
Use CData Connect AI to connect to Oracle Service Cloud and integrate live Oracle Service Cloud into your Power Automate tasks.
-
Build SAP Ariba Procurement-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP Ariba Procurement from Zoho Analytics and import live SAP Ariba Procurement.
-
Query Paylocity in DataGrip
Create a Data Source for Paylocity in DataGrip and use SQL to query live Paylocity.
-
Build Automated MariaDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live MariaDB and build automated workflows in Zapier.
-
Analyze Salesforce Marketing in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Salesforce Marketing Cloud in Microsoft R Open.
-
Visualize Live Zoom in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoom.
-
Create Dynamic MarkLogic Grids Using the Infragistics XamDataGrid
Learn how you can connect MarkLogic to Infragistics XamDataGrid to build dynamic grids.
-
LINQ to Acumatica
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 Acumatica Data Provider.
-
Build Pipelines with Live Sage 200 in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Sage 200 from Google Cloud Data Fusion, enabling the integration of live Sage 200 into the building and management of effective data pipelines.
-
Provide OData Services of MySQL from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MySQL by developing a WCF Service Application.
-
Automated Continuous Microsoft Teams Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to PostgreSQL.
-
Create SSAS Tabular Models from Acumatica
How to build a SQL Server Analysis Service Tabular Model from Acumatica ERP using CData drivers.
-
How to import MailChimp into Apache Solr
Use the CData Software JDBC Driver for MailChimp in Data Import Handler and create an automated import of MailChimp to Apache Solr Enterprise Search platform.
-
Work with Klipfolio in FoxPro
Load Klipfolio into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous ShipStation Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ShipStation replication to delimited files (CSV/TSV).
-
Bind Live NetSuite Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live NetSuite data
-
Connect to Okta in Jaspersoft Studio
Execute SQL to remote Okta in Jaspersoft Studio.
-
Replicate Stripe in Heroku for Use in Salesforce Connect
Replicate Stripe to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Easily Query Amazon S3 in OpenOffice Base
-