CData Software - Knowledge Base

Recent Articles

---

• «
• 492
• 493
• 494
• 495
• 496
• 497
• 498
• 499
• 500
• 501
• »

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

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

• How to integrate Metabase with SingleStore

  Use CData Connect AI to connect to live SingleStore and create an interactive dashboard in Metabase from SingleStore.

• Use the CData Software JDBC Driver for SurveyMonkey in MicroStrategy Web

  Connect to SurveyMonkey in MicroStrategy Web using the CData Software JDBC Driver for SurveyMonkey.

• Connect Hive to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Hive with IBM WebSphere for seamless data integration and connectivity.

• Integrate with Google Ads in JReport Designer

  Create charts and reports based on Google Ads in JReport Designer.

• Connect to Bing Ads in CloverDX (formerly CloverETL)

  Transfer Bing Ads using the visual workflow in the CloverDX data integration tool.

• How to create Visio diagrams from Google Directory

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

• Build Dynamics 365-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Dynamics 365 from Zoho Analytics and import live Microsoft Dynamics 365.

• Create SSAS Tabular Models from SAP

  How to build a SQL Server Analysis Service Tabular Model from SAP ERP/NetWeaver using CData drivers.

• Connect to Adobe Target from PowerBuilder via JDBC

  This article demonstrates how to access Adobe Target from PowerBuilder using the Adobe Target JDBC Driver.

• Use Manus AI to Talk to Your Impala via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Apache Impala.

• Trigger MongoDB IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

• Build Pipelines with Live SendGrid in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to SendGrid from Google Cloud Data Fusion, enabling the integration of live SendGrid into the building and management of effective data pipelines.

• Import Real-Time Dropbox via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Dropbox in ColdFusion.

• Build Voice Agents in ElevenLabs with access to Live Elasticsearch

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Elasticsearch.

• Getting Started with the CData Python Connector for Power BI XMLA

  Learn to install and license the CData Python Connector

• Automate MYOB AccountRight Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access MYOB AccountRight from PowerShell? This article demonstrates how to utilize the MYOB AccountRight Cmdlets for tasks like connecting to MYOB AccountRight, automating operations, downloading data, and more.

• Bind Live Basecamp Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Basecamp data

• Build Visualizations of TaxJar in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of TaxJar in Birst.

• Trigger Greenplum IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

• Design BIRT Reports on Calendly

  Provide current Calendly to your embedded analytics.

• Access Sage Cloud Accounting 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 Sage Business Cloud Accounting.

• Connect to Azure Table in Ruby

  Connect to Azure Table Storage in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Consume Oracle Financials Cloud OData Feeds in PowerBuilder

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

• Integrate with Slack in SnapLogic

  Use CData Connect AI to connect to and integrate with live Slack in SnapLogic.

• Create Reports from Bing Ads in Looker Studio

  Use CData Connect AI to gain access to live Bing Ads and create custom reports in Looker Studio.

• Query Couchbase as a MySQL Database in Node.js

  Execute MySQL queries against Couchbase from Node.js.

• Use Agno to Talk to Your Impala via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Apache Impala for you.

• Build Azure Data Lake Storage-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for Azure Data Lake Storage and create custom apps in Bubble.

• Use Microsoft Copilot Studio to talk to your Jira 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 Atlassian Jira for you.

• Building Dynamic Web Pages with SurveyMonkey Using AngularJS

  Create single-page applications with live connectivity to SurveyMonkey using the CData API Server.

• Automated Continuous NetSuite SuiteAnalytics Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Microsoft Access.

• Connect to Azure Synapse in Ruby

  Connect to Azure Synapse in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Access Live Kintone in AWS Lambda (with IntelliJ IDEA)

  Connect to live Kintone in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Connect to WooCommerce from a Connection Pool in Jetty

  The WooCommerce JDBC Driver supports connection pooling: This article shows how to connect faster to WooCommerce from Web apps in Jetty.

• Process & Analyze CSV in Databricks (AWS)

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

• Analyze PayPal in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze PayPal in Microsoft R Open.

• Analyze Live Excel Online in SAS Viya

  Use CData Connect AI to connect to Microsoft Excel Online from SAS Viya and deploy self-service analytics using live Microsoft Excel Online.

• Connect to Tally in JRuby

  Create a simple JRuby app with access to live Tally ERP.

• Integrate SAS xpt in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAS XPORT from Informatica Cloud.

• Visualize SQL Analysis Services in TIBCO Spotfire through ADO.NET

  Integrate SQL Analysis Services into dashboards in TIBCO Spotfire.

• Bind Live Epicor Kinetic Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Epicor Kinetic data

• Visualize CSV in Tableau

  The CData ODBC driver for CSV enables you integrate CSV/TSV Files into Tableau dashboards.

• Connect to Dynamics 365 in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Microsoft Dynamics 365 in the Denodo Virtual DataPort Administrator.

• How to create Salesforce Pardot federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce Pardot in MySQL .

• Publish Crystal Reports on HubSpot

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

• PowerShell Scripting to Replicate Unbounce to MySQL

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

• Connect to Procore in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Google Ad Manager in NetBeans

  Connect to Google Ad Manager in NetBeans with the data source configuration wizard.

• Build Salesforce Marketing-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Salesforce Marketing Cloud and build web apps with connectivity to live Salesforce Marketing Cloud.

• How to Create Power BI Visual Reports with Real-Time QuickBooks

  Use CData Power BI Connectors to visualize QuickBooks Desktop in Power BI.

• Visualize XML in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load XML Files into TIBCO Spotfire.

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

  Connect to Typeform from a connection pool in Tomcat.

• PowerShell Scripting to Replicate SendGrid to MySQL

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

• Analyze SAP ByDesign in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of SAP Business ByDesign and visualize live SAP Business ByDesign in Infragistics Reveal.

• How to Query Live Odoo Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Odoo ERP data in natural language using Python.

• Query Oracle Eloqua Reporting through ODBC in Node.js

  Use node-odbc to execute SQL queries against Oracle Eloqua Reporting from Node.js.

• Connect to TigerGraph in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to Connect DBeaver to Google Ad Manager via a JDBC Driver

  Manage Google Ad Manager with visual tools in DBeaver like the query browser.

• Analyze Greenhouse in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Greenhouse with the CData JDBC Driver for Greenhouse.

• How to Work with ActiveCampaign in ETL Validator JDBC

  Connect to ActiveCampaign from ETL Validator jobs using the CData Software JDBC Driver.

• Create Informatica Mappings From/To a JDBC Data Source for SAS xpt

  Create SAS xpt data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Use the CData API Server in Microsoft Power BI

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

• Bind Live Phoenix Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Phoenix data

• Automated Continuous CouchDB Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable CouchDB replication to Amazon S3.

• Create Reports with Drift in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Drift.

• ETL QuickBooks in Oracle Data Integrator

  This article shows how to transfer QuickBooks Desktop into a data warehouse using Oracle Data Integrator.

• Replicate MarkLogic from PowerShell

  Write a quick PowerShell script to query MarkLogic. Use connectivity to the live data to replicate MarkLogic to SQL Server.

• Create Power BI Reports on Real-Time SAS Data Sets

  Use the CData ODBC Driver for SAS Data Sets to visualize SAS Data Sets in Power BI Desktop.

• Create Informatica Mappings From/To an ODBC Data Source for RSS

  Create an ODBC connection to RSS in Informatica and browse and transfer RSS Feeds.

• Connect to Microsoft Dataverse in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for Microsoft Dataverse and connect to Microsoft Dataverse (CDS) in Akorbi Digital RunMyProcess.

• Connect to Lakebase from AWS Glue

  Use CData Connect AI to gain access to live Lakebase from your AWS Glue jobs.

• Connecting Moonlit Workflow with Oracle via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Oracle Database in real time.

• Build Data Flows from SQL Server to Vault CRM through SSIS

  Easily push SQL Server data to Vault CRM using the CData SSIS Tasks for Vault CRM.

• Use the CData Software JDBC Driver for Sybase IQ in MicroStrategy Web

  Connect to Sybase IQ in MicroStrategy Web using the CData Software JDBC Driver for Sybase IQ.

• How to Use a Microsoft Access Database to Update Sybase in Real Time

  Update Sybase data by creating a linked table in Microsoft Access with the CData Sybase ODBC Driver.

• Access Redis from MySQL in PHP

  Connect to Redis through the standard MySQL libraries in PHP.

• A Performance Comparison of Drivers for NoSQL

  An article comparing the read performance of CData Software Drivers for MongoDB.

• Build MVC Applications with Connectivity to Sybase IQ

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

• Query Presto in DataGrip

  Create a Data Source for Presto in DataGrip and use SQL to query live Presto.

• Create PingOne Reports on JasperReports Server

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

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

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

• Build Office 365 Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Microsoft Office 365 and build visualizations in Tableau.

• Query Drift as a MySQL Database in Node.js

  Execute MySQL queries against Drift from Node.js.

• Edit and Search External QuickBooks Online Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of QuickBooks Online to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create QuickBooks Online objects that you can access from apps and the dashboard.

• Automated Continuous Smartsheet Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Smartsheet replication to Google Cloud SQL.

• Automate eBay Analytics Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access eBay Analytics from PowerShell? This article demonstrates how to utilize the eBay Analytics Cmdlets for tasks like connecting to eBay Analytics, automating operations, downloading data, and more.

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

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

• Integrate Live SAP ByDesign into Custom Business Apps Built in Power Apps

  Use CData Connect AI to connect to SAP Business ByDesign and integrate live SAP Business ByDesign into apps built in Microsoft Power Apps.

• CSV Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on CSV facts in real time.

• How to create JotForm federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for JotForm in MySQL .

• Import Real-Time Salesforce Pardot via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Salesforce Pardot in ColdFusion.

• PowerShell Scripting to Replicate Box to MySQL

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

• Visualize SharePoint in TIBCO Spotfire through OData

  Integrate Microsoft SharePoint into dashboards in TIBCO Spotfire.

• Publish Crystal Reports on Sage Intacct

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

• How to create an RPA flow for PayPal in UiPath Studio

  Use the PayPal ODBC Driver to create workflows that access real-time PayPal without any coding.

• Replicate FHIR from PowerShell

  Write a quick PowerShell script to query FHIR. Use connectivity to the live data to replicate FHIR to SQL Server.

• Bidirectional Access to Microsoft Dataverse from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dataverse (CDS) in Filemaker Pro for Mac or Windows.

• Access MYOB AccountRight 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 MYOB AccountRight.

• DataBind Controls to Google Analytics in Delphi

  DataBind to Google Analytics in Delphi with standard data access components and controls.

• «
• 492
• 493
• 494
• 495
• 496
• 497
• 498
• 499
• 500
• 501
• »