CData Software - Knowledge Base

Recent Articles

---

• «
• 763
• 764
• 765
• 766
• 767
• 768
• 769
• 770
• 771
• 772
• »

• Automated Continuous Salesforce CRM Analytics Replication to Local Delimited Files

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

• How to Easily Query Databricks Data in OpenOffice Base

  Connect to Databricks data in OpenOffice Base using the CData ODBC Driver for Databricks and generate reports with live data insights.

• Build Redis-Powered Applications in GitHub Copilot with CData MCP Server

  Use the CData MCP Server for Redis to explore live Redis Data in GitHub Copilot to assist with building Redis-powered applications.

• Manage Zuora Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Zuora.

• Build Asana Visualizations in Tableau Cloud

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

• Visualize AlloyDB Data in TIBCO Spotfire through ADO.NET

  Integrate Google AlloyDB into dashboards in TIBCO Spotfire.

• Connect to Active Directory Data from HeidiSQL

  Use CData Connect AI to connect to and query live Active Directory from HeidiSQL.

• Connect to SAP Ariba Procurement Data from AWS Glue

  Use CData Connect AI to gain access to live SAP Ariba Procurement from your AWS Glue jobs.

• Replicate Todoist Data in Heroku for Use in Salesforce Connect

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

• How to connect to Shopify Data from Spring Boot

  Connect to Shopify in a Spring Boot Application using the CData JDBC Driver for Shopify

• Extract, Transform, and Load Dynamics 365 Data in Informatica PowerCenter

  Create a simple Workflow for Microsoft Dynamics 365 in Informatica PowerCenter.

• How to load MariaDB data into Elasticsearch via Logstash

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

• Getting Started with the CData SSIS Components for DocuSign

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for DocuSign.

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

  Provide connectivity to Billsby through an SAP BusinessObjects universe.

• Publish Reports with Azure Data Lake Storage Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Azure Data Lake Storage.

• Connect to Twitter Ads Data in Jaspersoft Studio

  Execute SQL to remote Twitter Ads in Jaspersoft Studio.

• Connect Sage 200 to IBM WebSphere Using the CData JDBC Driver

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

• Create Oracle-Connected Nintex Workflows

  Use CData Connect AI to connect to Oracle Data from Nintex Workflow Cloud and build custom workflows using live Oracle Database.

• Create Power BI Reports on Real-Time DB2 Data

  Use the CData ODBC Driver for DB2 to visualize IBM DB2 in Power BI Desktop.

• Analyze JobNimbus Data with Power Pivot

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

• Oracle Reporting and Star Schemas in OBIEE

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

• Automated Continuous Vault CRM Replication to Amazon Redshift

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

• Connect to Landbot Data in the Denodo Platform

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

• Work with Aircall Data in FoxPro

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

• Use Microsoft Copilot Studio to talk to your BigQuery Data 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 Google BigQuery for you.

• Getting Started with the CData Tableau Connector for SAS Data Sets

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAS Data Sets.

• Automate SFTP Tasks in Power Automate Using CData API Server

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

• How to Query Google Translate Data in MySQL Workbench

  Execute MySQL queries against live Google Translate from MySQL Workbench.

• Automated Continuous Planio Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Planio replication to Snowflake.

• Build Charts with Azure Data Lake Storage Data in Clear Analytics

  Create dynamic charts and perform analytics based on Azure Data Lake Storage in Clear Analytics.

• Automated Continuous Excel Replication to Google Cloud SQL

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

• Bridge Webflow Connectivity with Apache NiFi

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

• Automated Continuous Azure DevOps Replication to Amazon S3

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

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

  Create an ODBC connection to TigerGraph in Informatica and browse and transfer TigerGraph.

• Integrate Greenhouse with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Greenhouse with External Services.

• How to connect SharePoint with Certinia Data through external lists

  Provide Certinia to SharePoint users as an external list.

• Visualize AgileCRM Data in TIBCO Spotfire through ODBC

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

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

  Provide connectivity to Pivotal GreenPlum through an SAP BusinessObjects universe.

• How to import Sybase IQ Data into Apache Solr

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

• Connect and Query Live Marketo Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Marketo into Databricks

• Analyze Trello Data in R via ODBC

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

• Excel Spreadsheet Automation on ZohoExpense Data with the QUERY Formula

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

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

  Connect to Gumroad 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.

• Create a Data Access Object for ElevenLabs Data using JDBI

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

• How to Connect to & Open Microsoft OneDrive Data in Microsoft Excel

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

• Build Automated Workflows with Live LinkedIn Ads Data in Workato

  Use CData Connect AI to connect to live LinkedIn Ads and build automated workflows in Workato.

• Stream SurveyMonkey Data into Apache Kafka Topics

  Access and stream SurveyMonkey in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Query Kafka Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Apache Kafka and perform CRUD operations on Kafka from Node.js.

• Extend Google Sheets with SAP Data

  Make calls to SAP from Google Apps Script via the API Server.

• Operational Reporting on MariaDB Data from Spotfire Server

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

• Excel Spreadsheet Automation on ScrapingBee Data with the QUERY Formula

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

• Connect to Sugar CRM Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Sugar CRM to connect to Sugar CRM and execute queries in PowerBuilder.

• Replicate Postmark Data from PowerShell

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

• A PostgreSQL Interface for Cvent Data (MySQL Remoting via JDBC)

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

• How to connect PolyBase to Redshift

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

• Automated Continuous SAP Hybris C4C Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to IBM DB2.

• Build Semantic Layer Views for Facebook Ads Data in APOS Live Data Gateway

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

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

  Use LlamaIndex to query live Avalara AvaTax data in natural language using Python.

• View Reports on Real-Time SAP Business Warehouse Data in Power BI Report Server

  Use the CData ODBC Driver for SAP Business Warehouse to visualize SAP Business Warehouse in Power BI Desktop and then publish them to Power BI Report Server.

• How to load SharePoint Excel Services data into Elasticsearch via Logstash

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

• Connect to and Query ChargeOver Data in QlikView over ODBC

  Create data visualizations with ChargeOver in QlikView.

• Design BIRT Reports on MariaDB Data

  Provide current MariaDB to your embedded analytics.

• Analyze Dropbox Data in SAP Analytics Cloud

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

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

  Connect to Wrike from a connection pool in Tomcat.

• Access CockroachDB Data as a Remote Oracle Database

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

• Build Dashboards with Pipeliner CRM Data in Dundas BI

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

• How to publish and share Timely Data dashboards with Tableau Server

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

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

• Bridge Paddle Connectivity with Apache NiFi

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

• Access Live BambooHR Data in AWS Lambda

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

• How to Connect to Live SharePoint Data in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft SharePoint without replication.

• Stream Qualaroo Data into Apache Kafka Topics

  Access and stream Qualaroo in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Automated Rebilly Data Replication to Teradata

  Use CData Sync to Customize and automate Rebilly replication to Teradata.

• Use the CData Software ODBC Driver for Confluence in MicroStrategy Web

  Connect to Atlassian Confluence in MicroStrategy Web using the CData Software ODBC Driver for Confluence.

• Connect to ServiceDesk Plus Data in Aqua Data Studio

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

• Connect to SAP SuccessFactors LMS Data in Ruby

  Connect to SAP SuccessFactors LMS in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Connect to Recurly Data in CloverDX (formerly CloverETL)

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

• Analyze Amazon Athena Data in Slingshot with CData API Server

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

• Automated Continuous Invoiced Replication to Vertica

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

• Import and Visualize DB2 Data in Power View

  Create data visualizations based on IBM DB2 in Excel.

• Connect to OpenWeatherMap Data in RapidMiner

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

• How to integrate EnterpriseDB with Apache Airflow

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

• Automated Presto Data Replication to Teradata

  Use CData Sync to Customize and automate Presto replication to Teradata.

• Integrating Kiro CLI with Zoho Books Data via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

• Publish Reports with Hubstaff Data in SAP Crystal Reports

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

• How to publish and share Aha! Data dashboards with Tableau Server

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

• Design BIRT Reports on IBM Informix Data

  Provide current IBM Informix to your embedded analytics.

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

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

• Connect to Avro in SpagoBI

  Create reports featuring live Apache Avro in SpagoBI Studio. Host Avro reports on SpagoBI Server.

• How to work with Hive Data in Apache Spark using SQL

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

• Use ChatGPT to Talk to Your Cassandra Data via CData Connect AI

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

• Getting Started with the CData JDBC Driver for ZeroBounce

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

• Access Live BambooHR Data in Excel (Desktop) via Connect AI

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

• Build ActiveCampaign-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for ActiveCampaign Data and create custom apps in Mendix.

• Analyze Vertica Data in SAP Analytics Cloud

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

• Process & Analyze CouchDB Data in Databricks (AWS)

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

• Visualize Live WordPress Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live WordPress using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Import Real-Time OneNote Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Microsoft OneNote in ColdFusion.

• Connect to Nethunt Data in Google Apps Script via SQL Gateway

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

• How to Use a Microsoft Access Database to Update Act CRM Data in Real Time

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

• «
• 763
• 764
• 765
• 766
• 767
• 768
• 769
• 770
• 771
• 772
• »