CData Software - Knowledge Base

Recent Articles

• «
• 614
• 615
• 616
• 617
• 618
• 619
• 620
• 621
• 622
• 623
• »

• Create a Data Access Object for QuickBooks using JDBI

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

• Use ChatGPT to Talk to Your Facebook Ads via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Facebook Ads for you.

• Write a Simple Go Application to work with Zoho Books on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zoho Books.

• How to load Google Sheets data into Elasticsearch via Logstash

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

• How to use SQLAlchemy ORM to access Office 365 in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Office 365.

• Access Live Epicor Kinetic in Coginiti Pro

  Connect to and query live Epicor Kinetic from the GUI in the Coginiti Pro: SQL Analytics Tool.

• How to Design WooCommerce Power Apps with Database-Like Connectivity

  This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.

• Integrating Dataiku with Couchbase via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Couchbase.

• How to Connect to & Open Power BI XMLA in Microsoft Excel

  This article uses the CData ODBC driver for Power BI XMLA to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Automate Paylocity Replication to Couchbase

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

• Explore Geographical Relationships in Freshdesk with Power Map

  Create data visualizations with Freshdesk in Power Map.

• Create Salesloft Reports on JasperReports Server

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

• Build ActiveCampaign-Connected Web Apps in Servoy

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

• DataBind Controls to Spark in C++Builder

  DataBind to Apache Spark SQL in C++Builder with standard components and controls.

• How to Connect to & Open AlloyDB in Microsoft Excel

  This article uses the CData ODBC driver for AlloyDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Connect to Cvent in Ruby

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

• Edit and Search External Microsoft Dataverse Objects in Salesforce Connect

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

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

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

• Seamlessly Bring LinkedIn Ads into Retool Using CData Connect AI

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

• Integrate with SAP BusinessObjects BI in JReport Designer

  Create charts and reports based on SAP BusinessObjects BI in JReport Designer.

• Consume SAP Business One OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on SAP Business One feeds that reflect any changes in SAP Lumira.

• Automated Continuous Amazon Athena Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Amazon Athena replication to SQL Server.

• Connect to Live Oracle Service Cloud in PostGresSQL Interface through CData Connect AI

  Create a live connection to Oracle Service Cloud in CData Connect AI and connect to your Oracle Service Cloud from PostgreSQL.

• Create Zuora-Connected Dashboards in Grafana

  Connect to Zuora via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zuora.

• Automated Continuous Cassandra Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Cassandra replication to delimited files (CSV/TSV).

• Work with Pinterest in FoxPro

  Load Pinterest into a FoxPro database. This article includes full code and a walk-through of the process.

• Access Live Jira in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Atlassian Jira from your Excel spreadsheets.

• Query HDFS through ODBC in Node.js

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

• Create Dashboards and Visualize Live IBM Informix in Geckoboard

  Use CData Connect AI to connect to live IBM Informix and create dashboards for real-time monitoring and visualization in Geckoboard.

• Process & Analyze SAP SuccessFactors in Databricks (AWS)

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

• How to Access Act CRM Using Entity Framework

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

• A PostgreSQL Interface for Bullhorn CRM using the CData ODBC Driver

  Use the SQL Gateway and Bullhorn CRM ODBC Driver to create a PostgreSQL entry-point for data access.

• How to Access Live ActiveCampaign in Visual Studio Code via Cline

  Run the CData MCP Server for ActiveCampaign on Windows Subsytem for Linux (WSL) and connect to live ActiveCampaign from the Cline extension in Visual Studio Code.

• Build Greenplum-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live Pivotal GreenPlum and build Greenplum-connected web apps with Axios.

• How to work with Oracle Eloqua in Apache Spark using SQL

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

• Deploy the ADO.NET Provider for Oracle Eloqua on an SSRS Report Server

  Connect to Oracle Eloqua 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.

• Connect to Excel Online in Jaspersoft Studio

  Execute SQL to remote Microsoft Excel Online in Jaspersoft Studio.

• Configure the CData JDBC Driver for Oracle Service Cloud in a Connection Pool in Tomcat

  Connect to Oracle Service Cloud from a connection pool in Tomcat.

• Create Reports with Bing Ads in SAP Crystal Reports

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

• How to Connect to Live Confluence from Claude Agent SDK (via CData Connect AI)

  Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Atlassian Confluence for you.

• Query Coinbase as a MySQL Database in Node.js

  Execute MySQL queries against Coinbase from Node.js.

• How to Connect to Live WordPress from Google ADK Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your WordPress for you.

• Build a Singer.io Tap for Dynamics 365 Business Central With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Dynamics 365 Business Central data using

• Getting Started with the CData JDBC Driver for Harvest

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Harvest.

• Object-Relational Mapping (ORM) with Kafka Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Apache Kafka into a Java-based ORM framework, Hibernate.

• Publish Sage 200-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Sage 200.

• Connect to IBM Informix from a Connection Pool in WebLogic

  Use the CData JDBC Driver for IBM Informix to connect to IBM Informix from Web applications running on WebLogic.

• Add Okta to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Okta with the Informatica Enterprise Data Catalog to classify and organize data.

• Connect to SendGrid from PowerBuilder via JDBC

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

• How to Visualize BigQuery Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Google BigQuery in Python.

• How to connect and process Invoiced from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Invoiced.

• Import Real-Time Dynamics 365 Business Central via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Dynamics 365 Business Central in ColdFusion.

• Excel Spreadsheet Automation on Pipedrive with the QUERY Formula

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

• Working with HarperDB in LINQPad

  Execute LINQ queries to HarperDB in LINQPad.

• How to Query Live SAP HANA in Perplexity MacOS Desktop

  Connect to and query live SAP HANA in Perplexity Desktop using the CData MCP Server.

• How to connect SharePoint with Microsoft Exchange through external lists

  Provide Microsoft Exchange to SharePoint users as an external list.

• Connect to SAS Data Sets in DBeaver

  Use the CData ODBC Driver to connect to SAS Data Sets in DBeaver.

• Connect to Redshift from PowerBuilder via ADO.NET

  This article demonstrates how to access Amazon Redshift from Appeon PowerBuilder using the CData ADO.NET Provider for Redshift.

• Automate LinkedIn Ads Integration Tasks from PowerShell

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

• Integrate MariaDB in the Pentaho Report Designer

  Publish reports based on MariaDB in the Pentaho BI tool.

• Build Charts with Quickbase in Clear Analytics

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

• Connect to Bullhorn CRM in Aqua Data Studio

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

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

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

• Visualize ConstantContact in TIBCO Spotfire through OData

  Integrate ConstantContact into dashboards in TIBCO Spotfire.

• Connect to Spark from Excel & GoogleSheets!

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

• How to Use a Microsoft Access Database to Update SAP Netweaver Gateway in Real Time

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

• Analyze Oracle Financials Cloud in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Oracle Financials Cloud and visualize Oracle Financials Cloud in SAP Analytics Cloud.

• Import SurveyMonkey Using Azure Data Factory

  Use CData Connect AI to connect to SurveyMonkey from Azure Data Factory and import live SurveyMonkey.

• How to integrate SAP HANA with Apache Airflow

  Access and process SAP HANA in Apache Airflow using the CData JDBC Driver.

• Access Presto from MySQL in PHP

  Connect to Presto through the standard MySQL libraries in PHP.

• Automated Continuous ShipStation Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable ShipStation replication to Apache Cassandra.

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

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

• Analyze LinkedIn in R via ODBC

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

• Automated Continuous Drip Replication to Google BigQuery

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

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

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

• Connect to Cloudant from a Connection Pool in JBoss

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

• Create HCL Domino-Connected Business Apps in AppSheet

  Connect to HCL Domino via CData Connect AI in Google AppSheet and create custom business applications with real-time access to HCL Domino.

• Build a Singer.io Tap for Couchbase With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Couchbase data using

• Import SAP Ariba Procurement into the Power BI Service for Visualizations

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

• Automate LinkedIn Replication to Couchbase

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

• Access Live QuickBooks in SAS JMP via ODBC

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

• Analyze Excel Online in Cognos Analytics

  Use CData Connect AI to connect to Excel Online from Cognos Analytics and analyze live Microsoft Excel Online.

• Integrating LangGraph with Presto via CData Connect AI

  Leverage CData Connect AI to enable LangGraph agents to securely access and act on Presto within automated workflows.

• Use the CData Software ODBC Driver for Excel Online in MicroStrategy Desktop

  Connect to Microsoft Excel Online in MicroStrategy Desktop using the CData Software ODBC Driver for Excel Online.

• Query Todoist as a MySQL Database in Node.js

  Execute MySQL queries against Todoist from Node.js.

• How to Seamlessly Import SharePoint Excel Services Data into IBM SPSS Modeler

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

• Bridge Twitter Connectivity with Apache NiFi

  Access and process Twitter in Apache NiFi using the CData JDBC Driver.

• Build Microsoft Project Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Microsoft Project and build visualizations in Tableau Cloud.

• Access Live Teradata in AWS Lambda

  Connect to live Teradata in AWS Lambda using the CData JDBC Driver.

• Connect to Oracle Financials Cloud in RazorSQL

  Connect to Oracle Financials Cloud from wizards and query Oracle Financials Cloud from the GUI in the RazorSQL database management tool.

• Connect to QuickBooks from PowerBuilder via JDBC

  This article demonstrates how to access QuickBooks Desktop from PowerBuilder using the QuickBooks JDBC Driver.

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

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

• Access Live Dynamics CRM in Excel 365 Online (Excel for the web)

  Connect to Microsoft Dynamics CRM from Excel 365 Online (Excel for the web) with CData Connect AI.

• Use Biml to Build SSIS Tasks to Replicate Google Ad Manager to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Ad Manager to SQL Server.

• Access Live LDAP Objects in TIBCO Data Virtualization

• «
• 614
• 615
• 616
• 617
• 618
• 619
• 620
• 621
• 622
• 623
• »