CData Software - Knowledge Base

Recent Articles

• «
• 178
• 179
• 180
• 181
• 182
• 183
• 184
• 185
• 186
• 187
• »

• Build Agents in Relevance AI with Access to Live Redis via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Redis within intelligent agent workflows.

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

  Use CData Power BI Connectors to visualize REST in Power BI.

• Build a Singer.io Tap for Azure Data Catalog With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Azure Data Catalog data using

• Import Dynamics 365 into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Dynamics 365. In this article, you will use the OData format to import Microsoft Dynamics 365 into Microsoft Power Query.

• Connect to SAP Concur 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 SAP Concur.

• Connect to MariaDB 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 MariaDB.

• Connect to Microsoft Planner from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live Microsoft Planner from Filemaker Pro on Mac.

• Create a Data Access Object for Salesforce Pardot using JDBI

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

• Access Salesforce Marketing from MySQL in Amazon QuickSight

  Connect to Salesforce Marketing and build visualizations of Salesforce Marketing Cloud using a MySQL Connection in Amazon QuickSight.

• ETL Avalara AvaTax in Oracle Data Integrator

  This article shows how to transfer Avalara AvaTax into a data warehouse using Oracle Data Integrator.

• Access Bullhorn CRM from MySQL in Amazon QuickSight

  Connect to Bullhorn CRM and build visualizations of Bullhorn CRM using a MySQL Connection in Amazon QuickSight.

• Use the CData ODBC Driver for LinkedIn Ads from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for LinkedIn Ads to connect to LinkedIn Ads from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LinkedIn Ads in Excel.

• Automated Continuous Odoo Replication to Oracle

  Use CData Sync for automated, continuous, customizable Odoo replication to Oracle.

• Query LinkedIn through ODBC in Node.js

  Use node-odbc to execute SQL queries against LinkedIn from Node.js.

• Use the CData SSIS Components to Insert New or Update Existing Microsoft Dataverse Records from SQL Server

  Easily push SQL Server data to Microsoft Dataverse using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Dataverse or update existing records with data from a SQL Server database.

• Access Live Kintone in SAS JMP via ODBC

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

• Building Dynamic Web Pages with Instagram Using AngularJS

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

• Choosing the Best Method to Connect CouchDB to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Apache CouchDB from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Analyze WordPress in Looker

  Use CData Connect AI to connect to WordPress from Looker and build custom apps using live WordPress.

• Access Live YouTube Analytics in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live YouTube Analytics from your Google Sheets.

• Access NetSuite 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 NetSuite CRM & ERP.

• Automated Continuous QuickBooks Replication to Vertica

  Use CData Sync for automated, continuous, customizable QuickBooks replication to Vertica.

• Use the CData API Server in Microsoft Power BI

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

• Connect and Visualize Live BigCommerce Data in Databricks Lakehouse Federation with CData Connect AI

  Use CData Connect AI to integrate live BigCommerce into the Databricks platform and create visualization dashboards with real-time BigCommerce.

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

  Provide connectivity to Xero Accounting through an SAP BusinessObjects universe.

• Connect to Microsoft Project from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Project, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Access SAP Netweaver Gateway from MySQL in Amazon QuickSight

  Connect to SAP Netweaver Gateway and build visualizations of SAP Netweaver Gateway using a MySQL Connection in Amazon QuickSight.

• Visualize HubDB in Tableau

  The CData ODBC driver for HubDB enables you integrate HubDB into Tableau dashboards.

• Integrating Gumloop with Twilio via CData Connect AI

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

• Create Data Visualizations in Cognos BI with ShipStation

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

• Natively Connect to Cosmos DB in PHP

  The CData ODBC driver for Cosmos DB enables you to create PHP applications with connectivity to Azure Cosmos DB. Leverage the native support for ODBC in PHP.

• Replicate CockroachDB in Heroku for Use in Salesforce Connect

  Replicate CockroachDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Working with ClickUp in LINQPad

  Execute LINQ queries to ClickUp in LINQPad.

• Use CData Connect AI to Access eBay in Microsoft Power Pivot

  Use CData Connect AI to connect to live eBay in the Power Pivot business intelligence tool.

• Analyze SAP Fieldglass with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for SAP Fieldglass from Power Pivot. You will use the Table Import Wizard to load SAP Fieldglass. You can visually build the import query or use any SQL supported by the driver.

• Visualize Procore in TIBCO Spotfire through ADO.NET

  Integrate Procore into dashboards in TIBCO Spotfire.

• How to connect to SAP Fieldglass from IntelliJ

  Integrate connectivity to SAP Fieldglass with wizards in IntelliJ.

• How to Work with Sage 50 UK in AWS Glue Jobs Using JDBC

  Connect to Sage 50 UK from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Integrate Adobe Commerce in the Pentaho Report Designer

  Publish reports based on Adobe Commerce in the Pentaho BI tool.

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

• How to load Highrise data into Elasticsearch via Logstash

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

• Query Sage 50 UK in DataGrip

  Create a Data Source for Sage 50 UK in DataGrip and use SQL to query live Sage 50 UK.

• Automate EventBrite Replication to Couchbase

  Use CData Sync to Customize and automate Eventbrite replication to Couchbase.

• Integrate Azure Active Directory in the Pentaho Report Designer

  Publish reports based on Azure Active Directory in the Pentaho BI tool.

• Build YouTube Analytics-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to YouTube Analytics and build web apps with connectivity to live YouTube Analytics.

• Connect to Adobe Analytics in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for Adobe Analytics and connect to Adobe Analytics in Akorbi Digital RunMyProcess.

• Automated Continuous Confluence Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Confluence replication to Google BigQuery.

• Automated Continuous MYOB AccountRight Replication to SQLite

  Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to SQLite.

• Create Zoho Books-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Zoho Books from OutSystems and build custom enterprise apps using live Zoho Books.

• Build Visualizations of WooCommerce in Birst

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

• Connect to Google Campaign Manager 360 in DBArtisan

  Use wizards in DBArtisan to configure Google Campaign Manager 360 as a data source.

• Bidirectional Access to Kafka from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Apache Kafka in Filemaker Pro for Mac or Windows.

• Automate Certinia Replication to Azure Data Lake

  Use CData Sync to customize and automate Certinia replication to Azure Data Lake.

• How to work with Greenhouse in Apache Spark using SQL

  Access and process Greenhouse in Apache Spark using the CData Software JDBC Driver.

• Connect to Snowflake in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for Snowflake in Airbyte.

• How to Seamlessly Import Basecamp Data into IBM SPSS Modeler

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

• Visualize Phoenix in TIBCO Spotfire through OData

  Integrate Apache Phoenix into dashboards in TIBCO Spotfire.

• Replicate EnterpriseDB in Heroku for Use in Salesforce Connect

  Replicate EnterpriseDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Create Google Campaign Manager 360-Connected Nintex Workflows

  Use CData Connect AI to connect to Google Campaign Manager 360 from Nintex Workflow Cloud and build custom workflows using live Google Campaign Manager 360.

• Connect to ADP in Aqua Data Studio

  Access ADP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• How to Query Live QuickBooks Time in Perplexity MacOS Desktop

  Connect to and query live QuickBooks Time in Perplexity Desktop using the CData MCP Server.

• DataBind Sage 50 UK to the DevExpress Data Grid

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

• FTP Reporting and Star Schemas in OBIEE

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

• Excel Spreadsheet Automation on Twilio with the QUERY Formula

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

• How to connect Amazon QuickSight to Oracle Service Cloud

  Create a connection to Oracle Service Cloud in CData Connect AI and insert Oracle Service Cloud into Amazon QuickSight SPICE to build interactive dashboards.

• Connect to EnterpriseDB in the Denodo Platform

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

• Automated Continuous EnterpriseDB Replication to Databricks

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

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

• Connect to WooCommerce in RazorSQL

  Connect to WooCommerce from wizards and query WooCommerce from the GUI in the RazorSQL database management tool.

• Build a PostgreSQL Interface for Snapchat Ads using the CData JDBC Driver

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

• How to create Oracle Eloqua Reporting federated tables in MySQL

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

• Build TaxJar-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to TaxJar and build web apps with connectivity to live TaxJar.

• Connect to Live Facebook Ads in MicroStrategy through CData Connect AI

  Create a live connection to Facebook Ads in CData Connect AI and connect to your Facebook Ads from MicroStrategy.

• Integrate Real-Time Access to xBase in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to xBase in real time.

• Create Acumatica-Connected Applications in Appsmith

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

• Design BIRT Reports on Todoist

  Provide current Todoist to your embedded analytics.

• Build a PostgreSQL Interface for Smartsheet using the CData JDBC Driver

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

• How to work with Shippo in Apache Spark using SQL

  Access and process Shippo in Apache Spark using the CData Software JDBC Driver.

• Seamlessly Bring SurveyMonkey into Retool Using CData Connect AI

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

• Getting Started with the CData Excel Add-In for Azure Table

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure Table.

• Access Live Oracle SCM in SAS JMP via ODBC

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

• Publish LinkedIn Ads-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live LinkedIn Ads.

• Publish Reports with Microsoft Project in SAP Crystal Reports

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

• Process & Analyze JotForm in Databricks (AWS)

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

• How to Connect DBeaver to Raisers Edge NXT via a JDBC Driver

  Manage Raisers Edge NXT with visual tools in DBeaver like the query browser.

• Migrating data from GraphQL to Google BigQuery using CData SSIS Components.

  Easily push GraphQL to Google BigQuery using the CData SSIS Tasks for GraphQL and Google BigQuery.

• Create Cassandra-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Cassandra from OutSystems and build custom enterprise apps using live Apache Cassandra.

• Replicate ConstantContact to Multiple Databases

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

• Integrate with MariaDB using Apache Camel2

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

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

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

• Build a Simple VCL Application for CockroachDB

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

• Connect to Cvent from a Connection Pool in JBoss

  Integrate Cvent into Java servlets: Use the Management Console in JBoss to install the Cvent JDBC Driver.

• Trigger Pipedrive IFTTT Flows in Azure App Service

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

• Automated Continuous Oracle Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Oracle replication to Amazon Redshift.

• Easily Integrate WordPress in Lazarus Pascal IDE

  Learn how to easily integrate live WordPress in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Connect to Sage Cloud Accounting in RapidMiner

  Integrate Sage Business Cloud Accounting with standard components and data source configuration wizards in RapidMiner Studio.

• Manage Oracle HCM Cloud in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Oracle HCM Cloud.

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

  Connect to Typeform from a connection pool in Tomcat.

• Access Live Oracle Sales in AWS Lambda (with IntelliJ IDEA)

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

• Access Authorize.Net as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Authorize.Net from your Oracle system.

• «
• 178
• 179
• 180
• 181
• 182
• 183
• 184
• 185
• 186
• 187
• »