CData Software - Knowledge Base

Recent Articles

---

• «
• 159
• 160
• 161
• 162
• 163
• 164
• 165
• 166
• 167
• 168
• »

• Back Up Acumatica ERP to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Acumatica. In this article, we will employ an SSIS workflow to populate a database with Acumatica ERP data.

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

  Replicate Mouseflow to disparate databases with a single configuration.

• Build Semantic Layer Views for IBM Informix Data in APOS Live Data Gateway

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

• Build Cosmos DB-Powered Applications in Cursor with CData MCP Server

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

• Connect to Sybase IQ Data from AWS Glue

  Use CData Connect AI to gain access to live Sybase IQ from your AWS Glue jobs.

• Integrate Cline with Live MySQL Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live MySQL from within your IDE.

• Migrating data from OneNote to Google BigQuery using CData SSIS Components.

  Easily push Microsoft OneNote to Google BigQuery using the CData SSIS Tasks for OneNote and Google BigQuery.

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

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

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

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

• Use the CData Software ODBC Driver for Redshift in MicroStrategy Desktop

  Connect to Amazon Redshift in MicroStrategy Desktop using the CData Software ODBC Driver for Redshift.

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

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

• Connect to Shortcut Data in DBArtisan

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

• Integrate MailerLite Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MailerLite from Informatica Cloud.

• Prepare, Blend, and Analyze Oracle Service Cloud Data in Alteryx Designer (Connect AI)

  Build workflows to access live Oracle Service Cloud for self-service data analytics.

• Use the CData API Server to Access SAP Ariba Source Data in Microsoft PowerPivot

  Use the CData API Server to connect to live SAP Ariba Source in the Power Pivot business intelligence tool.

• Integrate Oracle HCM Cloud Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle HCM Cloud from Informatica Cloud.

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

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

• Build AI/ML Models with Live Zoho Books Data using Dataiku

  Connect Zoho Books Data with Dataiku using the CData JDBC Driver for Zoho Books.

• Automated Continuous Humanity Replication to SQL Server

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

• Integrating Codex CLI with Dynamics 365 Business Central 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.

• Build Charts with ZarMoney Data in Clear Analytics

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

• Automated Continuous Kintone Replication to SQL Server

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

• Build Salesforce Marketing Visualizations in Tableau Desktop

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

• Integrate Real-Time Access to Office 365 in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Office 365 in real time.

• Operational Reporting on Discourse Data from Spotfire Server

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

• Access Live Access Data in Coginiti Pro

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

• Create SSAS Tabular Models from Vercel Data

  How to build a SQL Server Analysis Service Tabular Model from Vercel using CData drivers.

• How to Seamlessly Import MailChimp Data into IBM SPSS Modeler

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

• Automate Harvest Data Replication to SAP HANA

  Use CData Sync to customize and automate Harvest replication to SAP HANA.

• Build Oracle Financials Cloud Visualizations in Tableau Cloud

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

• Feed GitHub Data into FineReport

  How to set GitHub as a JDBC data source in FineReport.

• Bidirectional Access to Twitter Ads Data from FileMaker Pro

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

• Automated Continuous Act CRM Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Act CRM replication to OneLake in Microsoft Fabric.

• Connect to HDFS in SpagoBI

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

• Integrating Dataiku with Office 365 Data via CData Connect AI

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

• Import MailChimp Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to MailChimp Data and provide access to live MailChimp for custom reports in the Power BI Service.

• Use the CData ODBC Driver for AdRoll in Microsoft Power Query

  You can use the CData AdRoll ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import AdRoll into Microsoft Power Query.

• Build Data Flows from SQL Server to Salesforce Marketing through SSIS

  Easily push SQL Server data to Salesforce Marketing using the CData SSIS Tasks for Salesforce Marketing.

• Use Azure AI Foundry to Talk to Your Odoo Data 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 Odoo ERP for you.

• Getting Started with the CData SSIS Components for Mistral AI

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

• Build an OLAP Cube in SSAS from Supabase Data

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

• Use Claude to Talk to Your Splunk Data via CData Connect AI

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

• Automate ChargeOver Tasks in Power Automate Using CData API Server

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

• Analyze CockroachDB Data in Slingshot with CData API Server

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

• Connect to Live Authorize.Net Data in MicroStrategy through CData Connect AI

  Create a live connection to Authorize.Net Data in CData Connect AI and connect to your Authorize.Net from MicroStrategy.

• Create Oracle Eloqua-Connected Applications in Appsmith

  Connect to Oracle Eloqua Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle Eloqua.

• Automated Continuous Opsgenie Replication to IBM DB2

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

• Provide OData Services of Vimeo Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Vimeo by developing a WCF Service Application.

• Visualize IBM Cloud Object Storage Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to IBM Cloud Object Storage.

• Using the CData Software ODBC Driver for Dynamics 365 in PyCharm

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

• How to integrate Google Campaign Manager 360 with Apache Airflow

  Access and process Google Campaign Manager 360 in Apache Airflow using the CData JDBC Driver.

• Building Dynamic Web Pages with Salesforce CRM Analytics Data Using AngularJS

  Create single-page applications with live connectivity to Salesforce CRM Analytics using the CData API Server.

• Integrating GitHub Copilot CLI with Amazon Redshift 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 Reports with Pushbullet Data in SAP Crystal Reports

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

• Build Data Flows from SQL Server to OData through SSIS

  Easily push SQL Server data to OData using the CData SSIS Tasks for OData.

• Integrate with SendGrid Data in JReport Designer

  Create charts and reports based on SendGrid in JReport Designer.

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

  Leverage the CData Connect AI Remote MCP Server to enable Windsurf

• Analyze Shippo Data with Power Pivot

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

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

  Use CData Connect AI to integrate live NetSuite CRM & ERP into Databricks

• Visualize CockroachDB Data from Tableau

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

• Replicate SendGrid Data in Heroku for Use in Salesforce Connect

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

• How to Query Live Monday.com Data in Claude Desktop

  Connect to and query live Monday.com Data in Claude Desktop using CData MCP Server.

• Use JayDeBeApi to access Sage Intacct Data in Python

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

• Automated Continuous SAP Concur Replication to Snowflake

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

• Use the CData Software JDBC Driver for SAP SuccessFactors LMS in MicroStrategy Desktop

  Connect to SAP SuccessFactors LMS in MicroStrategy Desktop using the CData Software JDBC Driver for SAP SuccessFactors LMS.

• How to integrate Impala with Apache Airflow

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

• Publish Crystal Reports on Ontraport Data

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

• Integrating Kiro CLI with AgileCRM 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.

• Connect to HDFS from a Connection Pool in WebLogic

  Use the CData JDBC Driver for HDFS to connect to Apache HDFS from Web applications running on WebLogic.

• How to connect to SendPulse Data in DBVisualizer

  Integrate SendPulse with visual data analysis tools and data connection wizards in DBVisualizer

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

  Connect to Sage 300 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.

• Connecting Agentforce with SAP BusinessObjects BI 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 SAP BusinessObjects BI for you.

• Build Oracle Visualizations in Tableau Cloud

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

• Excel Spreadsheet Automation on Parallel Data with the QUERY Formula

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

• Connect to BambooHR Data in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for BambooHR Data and connect to BambooHR in Akorbi Digital RunMyProcess.

• Bidirectional Access to SQL Server Data from FileMaker Pro

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

• Automate Microsoft OneDrive Tasks in Power Automate Using CData API Server

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

• Use the CData ODBC Driver for SuiteCRM in Microsoft Power Query

  You can use the CData SuiteCRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SuiteCRM into Microsoft Power Query.

• Integrate LibreChat with Live Slack Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Slack from within the chat interface.

• Edit and Search Harvest External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Harvest to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Harvest objects that you can access from apps and the dashboard.

• LINQ to Microsoft Teams Data

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Microsoft Teams Data Provider.

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

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

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

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

• Use the CData API Server to Access OneNote Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Microsoft OneNote in the Power Pivot business intelligence tool.

• Rapidly Develop Bugsnag-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 Bugsnag.

• Visualize Suadeo 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 Suadeo into TIBCO Spotfire.

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

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

• Connect to Phoenix Data in CloverDX (formerly CloverETL)

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

• Build Voice Agents in ElevenLabs with access to Live Sybase IQ Data

  Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sybase IQ.

• How to create an RPA flow for Xero Data in UiPath Studio

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

• DataBind Charts to Zoho Books Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Books from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Process & Analyze Close Data in Databricks (AWS)

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

• Visualize Guru Data in TIBCO Spotfire through OData

  Integrate Guru into dashboards in TIBCO Spotfire.

• Connect to Asana Data in RazorSQL

  Connect to Asana from wizards and query Asana from the GUI in the RazorSQL database management tool.

• Create Datasets from Pipeline CRM in Domo Workbench and Build Visualizations of Pipeline CRM Data in Domo

  Use the CData Software ODBC Driver for Pipeline CRM to create datasets from Pipeline CRM in Domo Workbench and then build visualizations in the Domo service.

• How to Seamlessly Import ZohoInvoice Data into IBM SPSS Modeler

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

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

• Creating Adobe Analytics-Connected Applications in Unqork

  You can use CData Connect AI to feed Adobe Analytics to Unqork and build custom business apps.

• Connect to Float Data in DBArtisan

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

• Write a Simple Go Application to work with SAP Ariba Source Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Ariba Source.

• «
• 159
• 160
• 161
• 162
• 163
• 164
• 165
• 166
• 167
• 168
• »