CData Software - Knowledge Base

Recent Articles

---

• «
• 826
• 827
• 828
• 829
• 830
• 831
• 832
• 833
• 834
• 835
• »

• Create a Data Access Object for Google Sheets Data using JDBI

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

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

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

• Publish Apollo-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Apollo.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Sheets within intelligent workflows.

• How to Access Oracle Eloqua Reporting Data Using Entity Framework

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

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

• Migrating data from Freshdesk to Snowflake using CData SSIS Components.

  Easily push Freshdesk to Snowflake using the CData SSIS Tasks for Freshdesk and Snowflake.

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

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

• How to connect PolyBase to Salesforce Marketing

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesforce Marketing Cloud.

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

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

• Migrating data from Redis to Databricks using CData SSIS Components.

  Easily push Redis to Databricks using the CData SSIS Tasks for Redis and Databricks.

• Integrate SAP Netweaver Gateway Data in the Pentaho Report Designer

  Publish reports based on SAP Netweaver Gateway in the Pentaho BI tool.

• Integrate with Strava Data using Apache Camel2

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

• How to Replicate Data Between MySQL and SQL Server with CData

  In this entry you will find how to replicate MySQL data into SQL Server (and vice versa) using CData.

• Build a Simple VCL Application for SAP Business One Data

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

• Integrate Live Zoom Data in the Windsurf IDE via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Windsurf

• Replicate Multiple OnePageCrm Accounts

  Replicate multiple OnePageCrm accounts to one or many databases.

• How to integrate QuickBooks with Apache Airflow

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

• Integrating Codex CLI with Azure DevOps 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.

• Connecting GenSpark with Freshdesk Data via CData Connect AI MCP Server

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

• Connect to Attio from Asprova with CData Software ODBC Driver for Attio

  This article shows how to connect faster to Attio data from Asprova.

• Create Dynamic Pipeliner CRM Grids Using the Infragistics XamDataGrid

  Learn how you can connect Pipeliner CRM to Infragistics XamDataGrid to build dynamic grids.

• Connect to Datadog Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Datadog from Appeon PowerBuilder using the CData API Driver for ADO.NET.

• Access Cosmos DB Data from MySQL in Amazon QuickSight

  Connect to Cosmos DB and build visualizations of Azure Cosmos DB using a MySQL Connection in Amazon QuickSight.

• Bind Live Oracle Financials Cloud Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Oracle Financials Cloud data

• Migrating data from Timely to Databricks using CData SSIS Components.

  Easily push Timely to Databricks using the CData SSIS Tasks for Timely and Databricks.

• Publish Airtable-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Airtable.

• Query Live SAP BusinessObjects BI Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAP BusinessObjects BI directly from the development environment.

• Automate Exact Online Data Replication to Azure Synapse

  Use CData Sync to customize and automate Exact Online replication to Azure Synapse.

• Visualize Live Bitbucket Data in Tableau

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

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

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

• Automated Continuous Google Tasks Replication to SQLite

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

• How to Connect to PostgreSQL Data in Using Python: 6 Steps

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

• Integrate Twilio with External Services using SnapLogic

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

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

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

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

  Provide connectivity to Templated through an SAP BusinessObjects universe.

• Replicate OData Services to Multiple Databases via the CData Sync CLI

  Replicate OData to disparate databases with a single configuration.

• Automate Pinterest Data Replication to Azure Data Lake

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

• Use Manus AI to Talk to Your Airtable Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Airtable.

• Connect to SparkPost Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Integrate Azure Analysis Services with JetBrains RubyMine using CData JDBC Drivers

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

• Connecting Agentforce with Epicor Kinetic Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Epicor Kinetic for you.

• Replicate Azure Analysis Services Data from PowerShell

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

• Publish Egnyte-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Egnyte.

• Publish Azure Analysis Services-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Azure Analysis Services.

• How to Connect DBeaver to CouchDB via a JDBC Driver

  Manage Apache CouchDB with visual tools in DBeaver like the query browser.

• A PostgreSQL Interface for Dynamics NAV Data using the CData ODBC Driver

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

• How to Connect to Live Elasticsearch 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 Elasticsearch without replication.

• Access Reckon Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Reckon from HeidiSQL.

• Use Grok to Talk to Your Google Analytics 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 Google Analytics for you.

• Connect Twilio to IBM WebSphere Using the CData JDBC Driver

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

• Getting Started with the CData ADO.NET Provider for Odoo

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Odoo.

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

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

• Create Anaplan Reports on JasperReports Server

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

• Connect to Instagram Data in the Denodo Platform

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

• Bind Live Google Analytics Data in Wijmo FlexGrid with CData API Server

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

• Excel Spreadsheet Automation on Vault CRM Data with the QUERY Formula

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

• Create Apps from Microsoft Exchange Data in Qlik Sense Cloud

  Use CData Connect AI to connect to Microsoft Exchange Data and build apps from live Microsoft Exchange in Qlik Sense Cloud.

• Consume Salesforce Data 360 OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Salesforce Data 360 feeds that reflect any changes in SAP Lumira.

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

  Connect to Microsoft OneDrive 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 Avalara AvaTax to IBM WebSphere Using the CData JDBC Driver

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

• How to Query Live SAP ByDesign Data in Perplexity MacOS Desktop

  Connect to and query live SAP ByDesign Data in Perplexity Desktop using CData MCP Server.

• Using the CData Software ODBC Driver for EmailOctopus in PyCharm

  Connect to EmailOctopus as an ODBC data source in PyCharm using the CData Software ODBC Driver for EmailOctopus.

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

  Execute MySQL queries against Paylocity from Node.js.

• Extract, Transform, and Load Salesforce Pardot Data in Informatica PowerCenter

  Create a simple Workflow for Salesforce Pardot in Informatica PowerCenter.

• Integrate Theia IDE with Live Oracle Service Cloud Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Theia IDE

• Getting Started with the CData SSIS Components for GraphQL

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

• Process & Analyze Couchbase Data in Databricks (AWS)

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

• How to Connect to Live Phoenix 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 Apache Phoenix without replication.

• Migrating data from Mailgun to Snowflake using CData SSIS Components.

  Easily push Mailgun to Snowflake using the CData SSIS Tasks for Mailgun and Snowflake.

• How to Connect to Live SurveyMonkey Data in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SurveyMonkey for you.

• Integrate with SAP Netweaver Gateway Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live SAP Netweaver Gateway in SnapLogic.

• Use the CData ODBC Driver for Bright Data from SharePoint Excel Services

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

• Connect to Unbounce Data in NetBeans

  Connect to Unbounce in NetBeans with the data source configuration wizard.

• Consume SAP HANA XS Advanced OData Feeds in PowerBuilder

  This article demonstrates how to consume SAP HANA XS Advanced as OData feeds from PowerBuilder using the API Server.

• Connect to Highrise Data in RapidMiner

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

• Connect to and Query ZohoPeople Data in QlikView over ODBC

  Create data visualizations with ZohoPeople in QlikView.

• Validate CampaignMonitor Data with QuerySurge

  Access and validate CampaignMonitor in QuerySurge using the CData JDBC Driver.

• Integrate with JDBC-ODBC Bridge Data using Apache Camel2

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

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

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

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

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

• Automated Continuous Procore Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Procore replication to Apache Kafka.

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

  Use CData ODBC drivers to import and use Pinecone in ColdFusion.

• Integrate with live Greenplum Data in Jitterbit

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

• Create Data Visualizations Based On Sybase IQ Data in Mode

  Use CData Connect AI to connect to Sybase IQ Data from Mode and build visualizations using live

• Create Instagram-Connected Enterprise Applications in OutSystems

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

• Integrating Codex CLI with Salesforce Marketing Cloud 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.

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

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

• Load Amazon S3 Data to a Database Using Embulk

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

• Create Hive-Connected Enterprise Applications in OutSystems

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

• Work with Live Zoho Creator Data in Power Query

  Use CData Connect AI to connect to Zoho Creator and work with live Zoho Creator in Microsoft Power Query.

• Access Chargebee Data as a Remote Oracle Database

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

• Operational Reporting on Wrike Data from Spotfire Server

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

• How to Build an ETL App for API Data in Python with CData Connect AI

  Build ETL pipelines that read and write live API in Python with petl and the CData Connect AI Python SDK.

• Build MVC Applications with Connectivity to CouchDB Data

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

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

  Use CData Connect AI to connect to live Zoho Projects and build Zoho Projects-connected web apps with Axios.

• How to connect to Placid Data from IntelliJ

  Integrate connectivity to Placid with wizards in IntelliJ.

• Access Mouseflow Data as a Remote Oracle Database

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

• Build an OLAP Cube in SSAS from QuickBooks Time Data

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

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

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

• «
• 826
• 827
• 828
• 829
• 830
• 831
• 832
• 833
• 834
• 835
• »