CData Software - Knowledge Base

Recent Articles

---

• «
• 332
• 333
• 334
• 335
• 336
• 337
• 338
• 339
• 340
• 341
• »

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

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

• Connect to ClickUp from PowerBuilder via JDBC

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

• How to connect to Excel from Spring Boot

  Connect to Excel in a Spring Boot Application using CData JDBC Excel Driver

• How to Connect to Live Bullhorn CRM 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 Bullhorn CRM for you.

• Slowly Changing Dimensions (SCD): A No-Code Approach

  This article introduces SCD and demonstrates implementing SCDs using CData Sync with CDC, dbt, and ELT.

• Operational Reporting on Zuora from Spotfire Server

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

• Create Power BI Reports on Real-Time Google Spanner

  Use the CData ODBC Driver for Google Spanner to visualize Google Spanner in Power BI Desktop.

• Publish Crystal Reports on Google Drive

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

• Automate Facebook Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Facebook and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Connect to ActiveCampaign in DBArtisan

  Use wizards in DBArtisan to configure ActiveCampaign as a data source.

• Connect to HubDB in the Denodo Platform

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

• Automated Continuous Blackbaud FE NXT Replication to MySQL

  Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to MySQL.

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

• Create Reports with Redis in SAP Crystal Reports

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

• Integrate with Bitbucket using Apache Camel2

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

• Create Reports with ADP in SAP Crystal Reports

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

• How to Work with Azure Active Directory in AWS Glue Jobs Using JDBC

  Connect to Azure Active Directory from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

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

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

• How to Connect to Live SurveyMonkey from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SurveyMonkey through natural language.

• Connect to Adobe Commerce from Crystal Reports

  Use CData Connect AI to connect to and report on live Adobe Commerce from Crystal Reports.

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

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

• Connect and Query Live Salesforce Pardot Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Salesforce Pardot into Databricks

• Excel Spreadsheet Automation on ADP with the QUERY Formula

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

• Use the CData Software JDBC Driver for Salesforce in MicroStrategy

  Connect to Salesforce & Force.com in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce.

• Automate Zoom Replication to Azure Synapse

  Use CData Sync to customize and automate Zoom replication to Azure Synapse.

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

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

• Integrate with MYOB AccountRight using Apache Camel2

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

• How to Import Data from Zendesk into Google Sheets

  Import Zendesk into a Google spreadsheet that is automatically refreshed.

• Analyze ClickUp with Power Pivot

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

• Creating Google Contacts-Connected Applications in Unqork

  You can use CData Connect AI to feed Google Contacts to Unqork and build custom business apps.

• Automate SAP HANA Replication to Couchbase

  Use CData Sync to Customize and automate SAP HANA replication to Couchbase.

• Connect to MongoDB as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for MongoDB.

• Connect to Couchbase as an External Source in Dremio

  Use the CData JDBC Driver to connect to Couchbase as an External Source in Dremio.

• Integrate with Live Jira in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Jira from the MuleSoft Anypoint Platform to integrate live Atlassian Jira into custom reports and dashboards.

• Connect to Greenplum from HeidiSQL

  Use CData Connect AI to connect to and query live Pivotal GreenPlum from HeidiSQL.

• Connect to Spark in CloverDX (formerly CloverETL)

  Transfer Apache Spark SQL using the visual workflow in the CloverDX data integration tool.

• Access Live Clio in Coginiti Pro

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

• Build NetSuite-Connected Apps in Choreo

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

• How to Connect to & Open Neo4J in Microsoft Excel

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

• Automated Continuous Google Contacts Replication to SQLite

  Use CData Sync for automated, continuous, customizable Google Contacts replication to SQLite.

• How to Access Confluence Using Entity Framework

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

• Extend Google Sheets with Azure Active Directory

  Make calls to the API Server from Google Apps Script.

• Query Amazon S3 through ODBC in Node.js

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

• Publish IBM Informix-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live IBM Informix.

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

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

• A PostgreSQL Interface for Jira Service Management using the CData ODBC Driver

  Use the SQL Gateway and Jira Service Management ODBC Driver to create a PostgreSQL entry-point for data access.

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

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

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

• Build Dashboards with HDFS in DBxtra

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

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

• Visualize Live Azure Active Directory in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Active Directory.

• Object-Relational Mapping (ORM) with Google Contacts 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 Google Contacts into a Java-based ORM framework, Hibernate.

• Create Informatica Mappings From/To a JDBC Data Source for Microsoft Teams

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

• Integrating LangChain with Facebook Ads via CData Connect AI

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

• Build a PostgreSQL Interface for SAS Data Sets using the CData JDBC Driver

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

• Automated Continuous SAP Business One Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable SAP Business One replication to Amazon S3.

• Integrate with live Workday in Jitterbit

  Use CData Connect AI to connect to and integrate live Workday in Jitterbit.

• How to Build an ETL App for Pinterest in Python with CData

  Create ETL applications and real-time data pipelines for Pinterest in Python with petl.

• Build Kintone-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Kintone.

• Replicate Confluence in Heroku for Use in Salesforce Connect

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

• Build MVC Applications with Connectivity to Zoho Books

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

• Build Redis-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for Redis and create custom apps in Bubble.

• Bidirectional Access to Elasticsearch from FileMaker Pro

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

• Visualize WordPress from Tableau

  Use the Tableau Desktop business intelligence tool to connect to WordPress.

• Load Tally to a Database Using Embulk

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

• How to import Calendly into Apache Solr

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

• Prepare, Blend, and Analyze Cloudant in Alteryx Designer (ODBC)

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

• How to publish and share Pipedrive dashboards with Tableau Server

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

• How to Connect to Google Contacts in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Google Contacts. Leverage the pyodbc module for ODBC in Python.

• Establish a Live Connection with Salesforce Marketing using Tableau Bridge

  The CData ODBC Driver for Salesforce Marketing enables you to integrate live Salesforce Marketing Cloud into Tableau Cloud dashboards using the Tableau Bridge.

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

  Use LlamaIndex to query live Microsoft Dataverse (CDS) data in natural language using Python.

• How to Import Data from TaxJar into Google Sheets

  Import TaxJar into a Google spreadsheet that is automatically refreshed.

• How to publish and share Salesforce Marketing dashboards with Tableau Server

  The CData ODBC driver for Salesforce Marketing enables you integrate Salesforce Marketing Cloud into Tableau dashboards.

• Create xBase Reports on JasperReports Server

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Avro

  Provide connectivity to Apache Avro through an SAP BusinessObjects universe.

• Automated Continuous Blackbaud FE NXT Replication to Local Delimited Files

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

• Connect to FHIR from a Connection Pool in Jetty

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

• Build Semantic Layer Views for Adobe Commerce in APOS Live Data Gateway

  Use the CData Connector for Adobe Commerce in APOS Live Data Gateway to build Semantic Layer Views for Adobe Commerce.

• Excel Spreadsheet Automation on Square with the QUERY Formula

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

• How to Build an ETL App for Google Search Results in Python with CData

  Create ETL applications and real-time data pipelines for Google Search in Python with petl.

• Establish a Live Connection with JSON Services using Tableau Bridge

  The CData ODBC Driver for JSON enables you to integrate live JSON into Tableau Cloud dashboards using the Tableau Bridge.

• Viewing MYOB AccountRight in RAD Studio Data Explorer

  How to view MYOB AccountRight in RAD Studio Data Explorer using the CData ODBC Driver for MYOB AccountRight.

• Automate SAP SuccessFactors Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live SAP SuccessFactors and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Connect to Salesforce Pardot in RapidMiner

  Integrate Salesforce Pardot with standard components and data source configuration wizards in RapidMiner Studio.

• How to Access Typeform Using Entity Framework

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

• Visualize Sage 300 in Tableau

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

• Building Dynamic Web Pages with Dynamics 365 Using AngularJS

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

• How to Connect to Live Sage Intacct from crewAI Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Sage Intacct for you.

• How to Query Live Microsoft Project in Perplexity MacOS Desktop

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

• Automated Continuous Oracle Financials Cloud Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Apache Cassandra.

• Getting Started with the CData Tableau Connector for HubDB

• «
• 332
• 333
• 334
• 335
• 336
• 337
• 338
• 339
• 340
• 341
• »