CData Software - Knowledge Base

Recent Articles

---

• «
• 364
• 365
• 366
• 367
• 368
• 369
• 370
• 371
• 372
• 373
• »

• Integrate Reckon Accounts Hosted with JetBrains RubyMine using CData JDBC Drivers

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

• Connect to Live SAP Fieldglass Data in MicroStrategy through CData Connect AI

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

• How to Work with Keap Data in ETL Validator JDBC

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

• Automated Continuous Epicor Kinetic Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to OneLake in Microsoft Fabric.

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

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

• Getting Started with the CData Python Connector for Codat

  Learn to install and license the CData Python Connector

• Connect to DocuSign Data as a Linked Server via SQL Gateway

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

• Query Elasticsearch Data from Node.js

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

• Access Live FTP Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live FTP Servers from your Excel spreadsheets.

• Automated Continuous Neo4J Replication to SQL Server

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

• Replicate Yelp Data in Heroku for Use in Salesforce Connect

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

• Automated Continuous Cvent Replication to MySQL

  Use CData Sync for automated, continuous, customizable Cvent replication to MySQL.

• How to Connect the Power BI Service to OData: Complete Guide

  Connect to the CData Software Power BI Connector for OData from PowerBI.com to provide real-time OData across the organization.

• Build Semantic Layer Views for Oracle HCM Cloud Data in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Oracle HCM Cloud.

• Automated Pingdom Data Replication to Teradata

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

• How to connect PolyBase to ScrapingBee

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

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

• Connect to SAP BusinessObjects BI Data in Aqua Data Studio

  Access SAP BusinessObjects BI from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Easily Integrate Oracle HCM Cloud Data in Lazarus Pascal IDE

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

• Integrating Cursor CLI with Office 365 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.

• Analyze Vimeo Data in R via ODBC

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

• How to integrate Metabase with Microsoft Planner Data

  Use CData Connect AI to connect to live Microsoft Planner and create an interactive dashboard in Metabase from Microsoft Planner.

• Access Live Stripe Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Stripe from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Connect to Real-Time SuiteCRM Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for SuiteCRM and Dataflow to import and use SuiteCRM in Power Apps.

• Integrating GitHub Copilot CLI with SurveyMonkey 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.

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

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

• Build an OLAP Cube in SSAS from Parallel Data

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

• Integrate Cloudant with External Services using SnapLogic

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

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

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

• Integrate Box with External Services using SnapLogic

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

• How to use SQLAlchemy ORM to access Google Ad Manager Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Ad Manager.

• Create Apps from Active Directory Data in Qlik Sense Cloud

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

• Access Act CRM Data from MySQL in PHP

  Connect to Act CRM through the standard MySQL libraries in PHP.

• How to integrate Metabase with Epicor Kinetic Data

  Use CData Connect AI to connect to live Epicor Kinetic and create an interactive dashboard in Metabase from Epicor Kinetic.

• Work with LinkedIn Data in FoxPro

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

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

  Connect to Printify 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 to SharePoint from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft SharePoint, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Enable the Gong JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Gong.

• Using the CData Software ODBC Driver for Timely in PyCharm

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

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

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

• Connect to Datadog Data in CloverDX (formerly CloverETL)

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

• Replicate Multiple LaunchDarkly Accounts

  Replicate multiple LaunchDarkly accounts to one or many databases.

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

  Easily push Facebook Ads to Google BigQuery using the CData SSIS Tasks for Facebook Ads and Google BigQuery.

• Build a Simple VCL Application for Bugsnag Data

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

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

  Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.

• Use Databricks Agent Bricks to Talk to Your Microsoft Dataverse Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Dataverse (CDS) for you.

• Connect to Excel Data in CloverDX (formerly CloverETL)

  Transfer Microsoft Excel using the visual workflow in the CloverDX data integration tool.

• Feed Avalara AvaTax Data into FineReport

  How to set Avalara AvaTax as a JDBC data source in FineReport.

• Connecting Mastra with Acumatica Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Acumatica ERP, no replication required.

• Visualize BenchmarkEmail Data in Sisense

  Create an ElastiCube in Sisense app with access to BenchmarkEmail.

• Build Copper-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Copper and build web apps with connectivity to live Copper.

• How to load Teamwork data into Elasticsearch via Logstash

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

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

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

• Excel Spreadsheet Automation on NASA Data with the QUERY Formula

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

• Create SSAS Tabular Models from Monday.com Data

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

• Back Up Monday.com to SQL Server through SSIS

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

• Load Dynamics NAV Data to a Database Using Embulk

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

• How to Seamlessly Import Oracle HCM Cloud Data into IBM SPSS Modeler

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

• Migrating data from SAP Ariba Source to Snowflake using CData SSIS Components.

  Easily push SAP Ariba Source to Snowflake using the CData SSIS Tasks for SAP Ariba Source and Snowflake.

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

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

• Analyze CouchDB Data in Looker

  Use CData Connect AI to connect to CouchDB Data from Looker and build custom apps using live Apache CouchDB.

• Integrating GitHub Copilot CLI with MySQL 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.

• Automated Continuous DB2 for i Replication to Google Cloud SQL

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

• Import Oracle Financials Cloud Data Using Azure Data Factory

  Use CData Connect AI to connect to Oracle Financials Cloud Data from Azure Data Factory and import live Oracle Financials Cloud.

• How to import Customer.io Data into Apache Solr

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

• Automated Continuous Chargebee Replication to SQL Server

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

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

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

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

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

• Connect to Monday.com Data in JRuby

  Create a simple JRuby app with access to live Monday.com.

• Integrating Claude Code CLI with BigQuery 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.

• Access OneNote Data from MySQL in HeidiSQL

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

• Connect to PingOne Data from PowerBuilder via ADO.NET

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

• SuiteCRM Reporting in OBIEE with the SuiteCRM JDBC Driver

  Deploy the SuiteCRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Easily Integrate Xero Data in Lazarus Pascal IDE

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

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

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

• Enable the Zoho Recruit JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Zoho Recruit.

• Connect to and Query LinkedIn Ads Data in QlikView over ODBC

  Create data visualizations with LinkedIn Ads in QlikView.

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

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

• Connect to Microsoft OneDrive Data from AWS Glue

  Use CData Connect AI to gain access to live Microsoft OneDrive from your AWS Glue jobs.

• Automated Continuous TaxJar Replication to Apache Kafka

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

• Build an OLAP Cube in SSAS from AgileCRM Data

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

• Build xBase-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to xBase and build web apps with connectivity to live xBase.

• Build Epicor Kinetic-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for Epicor Kinetic to explore live Epicor Kinetic Data in Claude Code to assist with building Epicor Kinetic-powered applications.

• Access Live HubSpot Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live HubSpot through MCP integration.

• Model MailChimp Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and MailChimp, enabling the direct import of real-time MailChimp.

• Build Amplitude-Connected ETL Processes in Google Data Fusion

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

• Automated Continuous Google Directory Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Google Directory replication to OneLake in Microsoft Fabric.

• Replicate Multiple Optimizely Accounts via the CData Sync CLI

  Replicate multiple Optimizely accounts to one or many databases.

• Publish BigQuery-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Google BigQuery.

• Integrate with Azure DevOps Data in JReport Designer

  Create charts and reports based on Azure DevOps in JReport Designer.

• Connect to Spotify Data Using the Script Function in Claris FileMaker Pro

  Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Spotify and work with Spotify in your FileMaker application.

• How to Create Power BI Visual Reports with Real-Time Customer.io Data

  Use CData Power BI Connectors to visualize Customer.io in Power BI.

• Design BIRT Reports on Wrike Data

  Provide current Wrike to your embedded analytics.

• Create SAP Netweaver Gateway-Connected Dashboards in Grafana

  Connect to SAP Netweaver Gateway Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Netweaver Gateway.

• Visualize Wistia Data from Tableau

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

• Getting Started with the CData Tableau Connector for ChargeOver

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

• Visualize Cvent Data in TIBCO Spotfire through OData

  Integrate Cvent into dashboards in TIBCO Spotfire.

• Create a Data Access Object for eBay Analytics Data using JDBI

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

• Connecting Agentforce with Zoom 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 Zoom for you.

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

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

• «
• 364
• 365
• 366
• 367
• 368
• 369
• 370
• 371
• 372
• 373
• »