CData Software - Knowledge Base

Recent Articles

---

• «
• 523
• 524
• 525
• 526
• 527
• 528
• 529
• 530
• 531
• 532
• »

• Replicate Multiple Trello Accounts

  Replicate multiple Trello accounts to one or many databases.

• Create Dynamic Zoho Inventory Grids Using the Infragistics XamDataGrid

  Learn how you can connect Zoho Inventory to Infragistics XamDataGrid to build dynamic grids.

• DataBind Controls to Redis in C++Builder

  DataBind to Redis in C++Builder with standard components and controls.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for JDBC-ODBC Bridge

  Provide connectivity to JDBC-ODBC Bridge through an SAP BusinessObjects universe.

• Automated Continuous SurveyMonkey Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Azure SQL Database.

• Build Semantic Layer Views for Marketo in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Marketo.

• DataBind Acumatica to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Acumatica with the DevExpress Windows Forms and Web controls to provide Acumatica ERP to a chart.

• How to use SQLAlchemy ORM to access SAP Ariba Procurement in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Ariba Procurement.

• Build Dashboards with Spark in DBxtra

  Create dynamic dashboards and perform analytics based on Apache Spark SQL in DBxtra.

• Connect to and Query Amazon Athena in QlikView over ODBC

  Create data visualizations with Amazon Athena in QlikView.

• Query Microsoft Exchange as a MySQL Database in Node.js

  Execute MySQL queries against Microsoft Exchange from Node.js.

• PowerShell Scripting to Replicate WooCommerce to MySQL

  Write a simple PowerShell script to replicate WooCommerce to a MySQL database.

• How to connect to Zoho Inventory from IntelliJ

  Integrate connectivity to Zoho Inventory with wizards in IntelliJ.

• Build a Singer.io Tap for SAS Data Sets With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live SAS Data Sets data using

• Prepare, Blend, and Analyze OData Services in Alteryx Designer (Connect AI)

  Build workflows to access live OData for self-service data analytics.

• Connect to CouchDB in Google Apps Script via SQL Gateway

  Use the ODBC Driver for CouchDB and the SQL Gateway to access Apache CouchDB from Google Apps Script.

• Feed Zoho Books into FineReport

  How to set Zoho Books as a JDBC data source in FineReport.

• Build a Simple VCL Application for Adobe Target

  How to build a simple VCL Application to view Adobe Target in RAD Studio using the CData ODBC Driver for Adobe Target.

• Create Redis Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Redis data access from reports, embedded analytics, and more.

• Publish Crystal Reports on Sugar CRM

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sugar CRM.

• Integrating Gumloop with Asana via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Asana within automated workflows.

• Use JayDeBeApi to access Bullhorn CRM in Python

  Use standard Python scripting and the development environment of your choice to access live Bullhorn CRM.

• How to pipe Databricks to CSV in PowerShell

  Use standard PowerShell cmdlets to access Databricks tables.

• Build Odoo-Connected Apps in Choreo

  Use CData Connect AI to connect to Odoo from Choreo and build custom apps using live Odoo ERP.

• Import API into the Power BI Service for Visualizations

  Use CData Connect AI to connect to API and provide access to live API for custom reports in the Power BI Service.

• Access Live SQL Server in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Microsoft SQL Server into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft SQL Server in the Graph Builder and Query Builder.

• A PostgreSQL Interface for Drip (MySQL Remoting via JDBC)

  Use the Remoting features of the Drip JDBC Driver to create a PostgreSQL entry-point for data access.

• Visualize Sugar CRM in TIBCO Spotfire through OData

  Integrate Sugar CRM into dashboards in TIBCO Spotfire.

• Visualize Blackbaud FE NXT from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Blackbaud FE NXT.

• How to Query Live Redshift in Perplexity MacOS Desktop

  Connect to and query live Redshift in Perplexity Desktop using CData Code Assist MCP.

• Connect to Adobe Target from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Adobe Target using standard SQL.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Project

  Provide connectivity to Microsoft Project through an SAP BusinessObjects universe.

• Access WooCommerce from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live WooCommerce from HeidiSQL.

• Consume XML OData Feeds in PowerBuilder

  This article demonstrates how to consume XML Files as OData feeds from PowerBuilder using the API Server.

• Zoho Books Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Zoho Books through CData Connect AI using different applications and tools.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for QuickBooks Online

  Provide connectivity to QuickBooks Online through an SAP BusinessObjects universe.

• Connect to Cvent in CloverDX (formerly CloverETL)

  Transfer Cvent using the visual workflow in the CloverDX data integration tool.

• DataBind Twitter Ads to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Twitter Ads with the DevExpress Windows Forms and Web controls to provide Twitter Ads to a chart.

• Model Adobe Commerce Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Adobe Commerce, enabling the direct import of real-time Adobe Commerce.

• How to connect PolyBase to FTP

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live FTP Servers.

• Load Redshift to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon Redshift to a database.

• Operational Reporting on Tableau CRM Analytics from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Tableau CRM Analytics.

• Automated Continuous Monday.com Replication to Databricks

  Use CData Sync for automated, continuous, customizable Monday.com replication to Databricks.

• Access Live SAS Data Sets Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live SAS Data Sets data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• How to Seamlessly Import Harvest Data into IBM SPSS Modeler

  Integrate Harvest data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Query Salesforce as a SQL Server Database in Node.js

  Execute SQL Server queries against Salesforce & Force.com from Node.js.

• Access PayPal 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 PayPal.

• Connect to LinkedIn in SpagoBI

  Create reports featuring live LinkedIn in SpagoBI Studio. Host LinkedIn reports on SpagoBI Server.

• Integrate Adobe Commerce with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Adobe Commerce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Adobe Commerce.

• Replicate WordPress to Multiple Databases

  Replicate WordPress to disparate databases with a point-and-click configuration.

• How to Import Data from ClickUp into Google Sheets

  Import ClickUp into a Google spreadsheet that is automatically refreshed.

• Connect to Redis in CloverDX (formerly CloverETL)

  Transfer Redis using the visual workflow in the CloverDX data integration tool.

• Build Dashboards with Marketo in Dundas BI

  Create dynamic dashboards and perform analytics based on Marketo in Dundas BI.

• Seamlessly Bring Google Calendar into Retool Using CData Connect AI

  Integrate Google Calendar data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.

• How to connect to ConstantContact in DBVisualizer

  Integrate ConstantContact with visual data analysis tools and data connection wizards in DBVisualizer

• How to load Trello data into Elasticsearch via Logstash

  Introducing a simple method to load Trello data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Use Azure AI Foundry to Talk to Your Google Ads 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 Ads for you.

• Replicate Multiple Redshift Accounts

  Replicate multiple Redshift accounts to one or many databases.

• Extend Google Sheets with Google Calendar

  Make calls to the API Server from Google Apps Script.

• Build Charts with Jira Assets in Clear Analytics

  Create dynamic charts and perform analytics based on Jira Assets in Clear Analytics.

• How to create Visio diagrams from Reckon

  Automatically update Reckon with the changes you make to Visio master shapes.

• Rapidly Develop HDFS-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.

• Operational Reporting on Zendesk from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Zendesk.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Xero Accounting to Power BI dashboards. Simply drag and drop Xero Accounting into data visuals on the Power BI canvas.

• Analyze ActiveCampaign in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of ActiveCampaign and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• Configure the CData JDBC Driver for Microsoft Project in a Connection Pool in Tomcat

  Connect to Microsoft Project from a connection pool in Tomcat.

• Access Typeform from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Typeform from HeidiSQL.

• Integrating Gumloop with Facebook Ads via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Facebook Ads within automated workflows.

• Create Data Visualizations in Cognos BI with ConstantContact

  Access ConstantContact as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Consume Marketo OData Feeds in PowerBuilder

  This article demonstrates how to consume Marketo as OData feeds from PowerBuilder using the API Server.

• Connect Smartsheet to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Smartsheet using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• How to use SQLAlchemy ORM to access ConstantContact in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ConstantContact.

• How to Access Oracle SCM Using Entity Framework

  This article shows how to access Oracle SCM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Operational Reporting on Facebook from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Facebook.

• How to import Paylocity into Apache Solr

  Use the CData Software JDBC Driver for Paylocity in Data Import Handler and create an automated import of Paylocity to Apache Solr Enterprise Search platform.

• Create Data Visualizations Based On Blackbaud FE NXT in Mode

  Use CData Connect AI to connect to Blackbaud FE NXT from Mode and build visualizations using live

• Excel Spreadsheet Automation on Adobe Experience Manager with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Integrate with PingOne using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PingOne to a JSON file on disk.

• Access Authorize.Net 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 Authorize.Net.

• Create Data Visualizations Based On Google Campaign Manager 360 in Mode

  Use CData Connect AI to connect to Google Campaign Manager 360 from Mode and build visualizations using live

• Create Amazon Marketplace-Connected Applications in Appsmith

  Connect to Amazon Marketplace via CData Connect AI in Appsmith and create custom business applications with real-time access to Amazon Marketplace.

• Build Charts with SQL Analysis Services in Clear Analytics

  Create dynamic charts and perform analytics based on SQL Analysis Services in Clear Analytics.

• Create a Data Access Object for WordPress using JDBI

  A brief overview of creating a SQL Object API for WordPress in JDBI.

• Process & Analyze Klaviyo in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Klaviyo .

• Create Dynamics 365 Business Central Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Dynamics 365 Business Central data access from reports, embedded analytics, and more.

• Getting Started with the CData ODBC Driver for DocuSign

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for DocuSign.

• Build Sage Cloud Accounting-Connected Apps in Choreo

  Use CData Connect AI to connect to Sage Cloud Accounting from Choreo and build custom apps using live Sage Business Cloud Accounting.

• Build MVC Applications with Connectivity to WordPress

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access WordPress from an ASP.NET MVC application.

• How to Query Live HCL Domino in Perplexity MacOS Desktop

  Connect to and query live HCL Domino in Perplexity Desktop using CData Code Assist MCP.

• Integrate SingleStore into Power Automate Desktop using CData Connect

  CData Connect for SingleStore enables you to integrate SingleStore into workflows built using Microsoft Power Automate Desktop.

• Use the CData Software ODBC Driver for Sage 300 in SAS for Real-Time Reporting and Analytics

  Connect to real-time Sage 300 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sage 300.

• Using the CData Software ODBC Driver for RSS in PyCharm

  Connect to RSS as an ODBC data source in PyCharm using the CData Software ODBC Driver for RSS.

• Use the CData API Server to Access SAS xpt in Microsoft PowerPivot

  Use the CData API Server to connect to live SAS XPORT in the Power Pivot business intelligence tool.

• Build AI Agents with Facebook Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can

• Analyze Pinterest in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Pinterest and visualize live Pinterest in Infragistics Reveal.

• Publish Azure Synapse-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Azure Synapse.

• Getting Started with the CData Python Connector for YouTube Analytics

  Learn to install and license the CData Python Connector

• Viewing Xero in RAD Studio Data Explorer

  How to view Xero Accounting in RAD Studio Data Explorer using the CData ODBC Driver for Xero.

• PowerShell Scripting to Replicate Adobe Commerce to MySQL

  Write a simple PowerShell script to replicate Adobe Commerce to a MySQL database.

• Natively Connect to Gmail in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Gmail. Leverage the native support for ODBC in PHP.

• «
• 523
• 524
• 525
• 526
• 527
• 528
• 529
• 530
• 531
• 532
• »