CData Software - Knowledge Base

Recent Articles

---

• «
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• »

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

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

• Integrate with Zoho Inventory Data using Apache Camel2

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

• Connect to Gmail Data from HeidiSQL

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

• How to Access Live Pipeliner CRM Data in Power Automate Desktop via ODBC

  The CData ODBC Driver for Pipeliner CRM enables you to integrate Pipeliner CRM into workflows built using Microsoft Power Automate Desktop.

• Connecting GenSpark with SAP SuccessFactors LMS Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP SuccessFactors LMS without any replication or custom integration required.

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

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

• Bidirectional Access to Oracle Sales Data from FileMaker Pro

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

• How to Access Invoiced Data Using Entity Framework

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

• Replicate EnterpriseDB Data to Multiple Databases via the CData Sync CLI

  Replicate EnterpriseDB to disparate databases with a single configuration.

• Integrate with Printify Data in JReport Designer

  Create charts and reports based on Printify in JReport Designer.

• ETL CapsuleCRM in Oracle Data Integrator

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

• Automate Freshsales Data Replication to Azure Data Lake

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

• Use the CData Software JDBC Driver for Float in MicroStrategy

  Connect to Float in MicroStrategy Developer using the CData Software JDBC Driver for Float.

• Connect Accelo to IBM WebSphere Using the CData JDBC Driver

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

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

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

• Query, Visualize, and Share live Microsoft Planner Data in Redash

  Use CData Connect AI to connect to live Microsoft Planner in Redash for querying, visualizing, and sharing.

• How to connect to Google Translate Data in DBVisualizer

  Integrate Google Translate with visual data analysis tools and data connection wizards in DBVisualizer

• Automated Continuous Aweber Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Aweber replication to IBM DB2.

• Google Ad Manager Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Google Ad Manager 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 .

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

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

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

• Getting Started with the CData Python Connector for QuickBooks

  Learn to install and license the CData Python Connector

• How to Work with Samanage Data in ETL Validator JDBC

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

• Easily Integrate GetResponse Data in Lazarus Pascal IDE

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

• Build Sage Intacct-Connected Apps in Mendix

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

• Create Salesforce CRM Analytics-Connected Nintex Workflows

  Use CData Connect AI to connect to Salesforce CRM Analytics Data from Nintex Workflow Cloud and build custom workflows using live Salesforce CRM Analytics.

• Design BIRT Reports on Vault CRM Data

  Provide current Veeva Vault & Vault CRM to your embedded analytics.

• Automated Continuous PolarTeamPro Replication to Google Cloud SQL

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

• DataBind Sybase Data to the DevExpress Data Grid

  Use the CData ADO.NET Provider for Sybase with the DevExpress Windows Forms and Web controls to provide Sybase to a chart.

• Connect to Jumpseller Data in Ruby

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

• Load ServiceNow Data to a Database Using Embulk

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

• Use the CData Software ODBC Driver for Customer.io in MicroStrategy Desktop

  Connect to Customer.io in MicroStrategy Desktop using the CData Software ODBC Driver for Customer.io.

• Connect to Suadeo Data from PowerBuilder via ADO.NET

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

• Connect SuiteCRM to IBM WebSphere Using the CData JDBC Driver

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

• Connect to SAP Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for SAP to connect to SAP ERP/NetWeaver and execute queries in PowerBuilder.

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

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

• Automate Email Data Replication to Azure Data Lake

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

• Connect to Workday Data from a Connection Pool in JBoss

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

• Integrate FreshBooks with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate FreshBooks with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to FreshBooks.

• Build Apps with Live ZohoExpense Data Using the Low-Code Development Platform of Mendix

  Connect ZohoExpense with Mendix to build apps using the CData API Driver for JDBC.

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

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

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

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

• Build Sage 200-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Sage 200 Data from Zoho Analytics and import live Sage 200.

• Connect Miro Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Miro using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Build an OLAP Cube in SSAS from SAP ByDesign Data

  Establish a connection to SAP Business ByDesign data from SQL Server Analysis Services, and use the SAP ByDesign Data Provider to build OLAP cubes for use in analytics and reporting.

• Build Dashboards with Yelp Data in Dundas BI

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

• Connect to Google Search Results in HULFT Integrate

  Connect to Google Search as a JDBC data source in HULFT Integrate

• Automated Continuous Reckon Accounts Hosted Replication to Local Delimited Files

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

• Integrate Goose with Live PayPal Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live PayPal from within the local AI agent.

• How to use SQLAlchemy ORM to access Yelp Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Yelp.

• Connect to Google Search Results in Google Apps Script via Connect AI

  Use CData Connect AI to access Google Search in Google Apps Script.

• Query Redshift Data as a MySQL Database in Node.js

  Execute MySQL queries against Amazon Redshift from Node.js.

• Getting Started with the CData Power BI Connector for Wrike

  Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.

• How to Query ZohoDesk Data in MySQL Workbench

  Execute MySQL queries against live ZohoDesk from MySQL Workbench.

• Visualize Live ZohoExpense Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live ZohoExpense.

• ETL SendInBlue in Oracle Data Integrator

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

• Getting Started with the CData Excel Add-In for Anaplan

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

• Use Grok to Talk to Your MySQL Data via CData Connect AI

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

• Analyze Sage Intacct Data in R via ODBC

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

• Access Live Microsoft Exchange Data in AWS Lambda (with IntelliJ IDEA)

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

• How to integrate NetSuite with Apache Airflow

  Access and process NetSuite CRM & ERP in Apache Airflow using the CData JDBC Driver.

• How to Seamlessly Import ServiceDesk Plus Data into IBM SPSS Modeler

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

• Automated Continuous Zoho Creator Replication to Databricks

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

• Connect to Nuclia Data from a Connection Pool in JBoss

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

• ETL Grafana in Oracle Data Integrator

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

• How to connect SharePoint with Act-On Data through external lists

  Provide Act-On to SharePoint users as an external list.

• Work with Avaza Data in FoxPro

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

• Build Data Flows from Google Calendar to SQL Server using SSIS

  Easily back up Google Calendar to SQL Server using the SSIS components for Google Calendar.

• Visualize Live Microsoft Ads Data in the Power BI Service

  Use CData Connect AI to connect to live Microsoft Ads and create custom reports in the Power BI Service through the On-Premises Gateway.

• Natively Connect to SAP Netweaver Gateway Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to SAP Netweaver Gateway. Leverage the native support for ODBC in PHP.

• Use the CData Software JDBC Driver for Exact Online in MicroStrategy

  Connect to Exact Online in MicroStrategy Developer using the CData Software JDBC Driver for Exact Online.

• Replicate Google Analytics Data from PowerShell

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

• Integrating OpenCode Terminal with Zoho Projects 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.

• Getting Started with the CData Python Connector for Asana

  Learn to install and license the CData Python Connector

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

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

• How to Connect to Live CouchDB Data from Gemini CLI (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Apache CouchDB for you.

• Use JayDeBeApi to access Shopify Data in Python

  Use standard Python scripting and the development environment of your choice to access live Shopify.

• Connect to Reckon Data in Claris FileMaker Pro

  Use the CData ODBC Driver for Reckon in FileMaker Pro to connect to Reckon and work with Reckon in your FileMaker applications.

• Rapidly Develop Unbounce-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Unbounce.

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

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

• Automated Continuous Paylocity Replication to Snowflake

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

• Visualize Live Contentful Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Contentful.

• Visualize Dotmailer Data in Tableau

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

• Edit and Search External Amazon Marketplace Objects in Salesforce Connect

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

• Automated Continuous QuickBooks Online Replication to Google Cloud SQL

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

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

  Gain real-time, database-like connectivity to Access from mobile and tablet Power Apps.

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

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

• Visualize Bitbucket Data from Tableau

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

• Operational Reporting on Excel Online Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Excel Online.

• Access Live Sybase IQ Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Sybase IQ data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Connect to Acumatica Data in CloverDX (formerly CloverETL)

  Transfer Acumatica ERP using the visual workflow in the CloverDX data integration tool.

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

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

• Automated Continuous Snapchat Ads Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Snapchat Ads replication to IBM DB2.

• Explore Geographical Relationships in Zuora Data with Power Map

  Create data visualizations with Zuora in Power Map.

• Getting Started with the CData Connect AI Python SDK for Cvent

  Install the CData Connect AI Python SDK to read and write live Cvent with standard DB-API 2.0 Python code.

• Build Charts with Email Data in Clear Analytics

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

• Query ServiceNow Data as a SQL Server Database in Node.js

  Execute SQL Server queries against ServiceNow from Node.js.

• Build HubSpot-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for HubSpot to explore live HubSpot Data in Cursor to assist with building HubSpot-powered applications.

• Access Adobe Target Data from MySQL in PHP

  Connect to Adobe Target through the standard MySQL libraries in PHP.

• «
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• »