CData Software - Knowledge Base

Recent Articles

---

• «
• 356
• 357
• 358
• 359
• 360
• 361
• 362
• 363
• 364
• 365
• »

• Replicate Klipfolio Data from PowerShell

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

• Design BIRT Reports on TaxJar Data

  Provide current TaxJar to your embedded analytics.

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

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

• How to connect PolyBase to Oracle

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

• Query eBay Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume eBay entities in PHP by modeling them as objects.

• Access Retently Data from MySQL in HeidiSQL

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

• Automated Continuous Teamwork Replication to Google Cloud SQL

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

• Create HBase-Connected Nintex Workflows

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

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

• Migrating data from Reply.io to Databricks using CData SSIS Components.

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

• Connecting Moonlit Workflow with IBM Informix Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your IBM Informix in real time.

• Automated Continuous Sybase Replication to Google Cloud SQL

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

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

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

• Back Up MailChimp to SQL Server through SSIS

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

• Bidirectional Access to ZendeskSell Data from FileMaker Pro

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

• Import Real-Time Square Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Square in ColdFusion.

• Automated Continuous RSS Replication to SingleStore

  Use CData Sync for automated, continuous, customizable RSS replication to SingleStore.

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

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

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

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

• Validate Google Analytics Data with QuerySurge

  Access and validate Google Analytics in QuerySurge using the CData JDBC Driver.

• Build a Simple VCL Application for ConvertKit Data

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

• Working with SpaceX Data in LINQPad

  Execute LINQ queries to SpaceX in LINQPad.

• Create LinkedIn Ads Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for LinkedIn Ads from PowerBI.com to create Power BI Dataflows with real-time data.

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

• Trigger Dynamics 365 IFTTT Flows in Azure App Service

  Automate IFTTT (if-this-then-that) workflows for Dynamics 365 with standard wizards in Logic Apps.

• How to Create Power BI Visual Reports with Real-Time Apify Data

  Use CData Power BI Connectors to visualize Apify in Power BI.

• Import Authorize.Net Data into the Power BI Service for Visualizations

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

• Workday Reporting and Star Schemas in OBIEE

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

• Access Live Excel Online 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 Microsoft Excel Online through MCP integration.

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

  Use CData API Driver for Power BI and Dataflow to import and use Shippo in Power Apps.

• Integrate with live Google Drive Data in Jitterbit

  Use CData Connect AI to connect to and integrate live Google Drive in Jitterbit.

• ETL Redshift in Oracle Data Integrator

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

• Integrating Dataiku with Salesforce Pardot Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Salesforce Pardot.

• Seamlessly Bring Confluence Data into Retool Using CData Connect AI

  Integrate Confluence data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.

• Automate Quickbase Data Replication to Couchbase

  Use CData Sync to Customize and automate Quickbase replication to Couchbase.

• Connect to Highrise Data from a Connection Pool in Jetty

  The Highrise JDBC Driver supports connection pooling: This article shows how to connect faster to Highrise CRM from Web apps in Jetty.

• Access Live SharePoint Data in Emergent via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Microsoft SharePoint through MCP integration.

• How to Visualize Oracle Eloqua Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Oracle Eloqua in Python.

• Analyze Excel Online Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Microsoft Excel Online with the CData JDBC Driver for Excel Online.

• Getting Started with the CData Tableau Connector for Scrapfly

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

• Automated Continuous Jira Assets Replication to Databricks

  Use CData Sync for automated, continuous, customizable Jira Assets replication to Databricks.

• How to Easily Query Exa Data in OpenOffice Base

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

• How to Work with Clio Data in AWS Glue Jobs Using JDBC

  Connect to Clio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• DataBind Charts to Cvent Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Cvent 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.

• Microsoft Ads Reporting in OBIEE with the Microsoft Ads JDBC Driver

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

• How to Access Live Highrise Data in Visual Studio Code via Cline

  Run CData MCP Server for Highrise on Windows Subsytem for Linux (WSL) and connect to live Highrise CRM from the Cline extension in Visual Studio Code.

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

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

• Connect to and Visualize Live Jira Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Atlassian Jira.

• Create Power BI Reports on Real-Time Cvent Data

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

• Excel Spreadsheet Automation on iContact Data with the QUERY Formula

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

• Enable the Authorize.Net JDBC Driver in KNIME

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

• How to Visualize Google Analytics Data in Python with pandas via CData Connect AI

  Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Google Analytics in Python.

• Prepare, Blend, and Analyze Telegram Data in Alteryx Designer (ODBC)

  Build workflows to access live Telegram for self-service data analytics.

• How to Access Cloudflare Data Using Entity Framework

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

• Analyze MongoDB Data in Cognos Analytics

  Use CData Connect AI to connect to MongoDB Data from Cognos Analytics and analyze live MongoDB.

• Integrating LlamaIndex with Google Search Results via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Search in real time.

• Use the CData ODBC Driver for Power BI XMLA in Microsoft Power Query

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

• Getting Started with the CData Power BI Connector for Mouseflow

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

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

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

• Connect to Insightly Data in RapidMiner

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

• Bridge ShipEngine Connectivity with Apache NiFi

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

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

  Use the CData API Server to connect to live Google Ads in the Power Pivot business intelligence tool.

• Automated Continuous FormSite Data Replication to OneLake in Microsoft Fabric

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

• Integrate Printify Data in Pentaho Data Integration

  Build ETL pipelines based on Printify in the Pentaho Data Integration tool.

• Visualize CapsuleCRM Data in TIBCO Spotfire through ADO.NET

  Integrate CapsuleCRM into dashboards in TIBCO Spotfire.

• Use JayDeBeApi to access Spotify Data in Python

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

• Visualize Sybase Data in Sisense

  Create an ElastiCube in Sisense app with access to Sybase.

• How to connect Amazon QuickSight to Raisers Edge NXT Data

  Create a connection to Raisers Edge NXT in CData Connect AI and insert Raisers Edge NXT into Amazon QuickSight SPICE to build interactive dashboards.

• Getting Started with the CData JDBC Driver for Aweber

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

• Automated Continuous Jumpseller Replication to IBM DB2

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

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

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

• Use the CData Software ODBC Driver for PivotalTracker in MicroStrategy

  Connect to PivotalTracker in MicroStrategy Developer using the CData Software ODBC Driver for PivotalTracker.

• Query ZohoSubscriptions Data in DataGrip

  Create a Data Source for ZohoSubscriptions in DataGrip and use SQL to query live ZohoSubscriptions.

• Using the CData Software ODBC Driver for CSV in PyCharm

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

• Build SQL Analysis Services-Powered Applications in Cursor with CData MCP Server

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

• Access Email Data from MySQL in PHP

  Connect to Email through the standard MySQL libraries in PHP.

• Automate Hubstaff Data Replication to SAP HANA

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

• Replicate Teamwork Data in Heroku for Use in Salesforce Connect

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

• Query SAP SuccessFactors LMS Data in DataGrip

  Create a Data Source for SAP SuccessFactors LMS in DataGrip and use SQL to query live SAP SuccessFactors LMS.

• Connect to QuickBooks Time Data from PowerBuilder via ADO.NET

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

• Excel Spreadsheet Automation on SurveyMonkey Data with the QUERY Formula

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

• Integrate with Unbounce Data in JReport Designer

  Create charts and reports based on Unbounce in JReport Designer.

• How to Visualize Neo4J Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Neo4J in Python.

• Build ServiceDesk Plus-Connected ETL Processes in Google Data Fusion

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

• Visualize Twilio Data in Sisense

  Create an ElastiCube in Sisense app with access to Twilio.

• Connect to Cloudant Data in Google Apps Script via Connect AI

  Use CData Connect AI to access IBM Cloudant in Google Apps Script.

• Integrating GitHub Copilot CLI with FTP Servers 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 Semantic Layer Views for Miro Data in APOS Live Data Gateway

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

• Create Reports with CampaignMonitor Data in SAP Crystal Reports

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

• Build Dashboards with Reckon Accounts Hosted Data in DBxtra

  Create dynamic dashboards and perform analytics based on Reckon Accounts Hosted in DBxtra.

• How to connect PolyBase to ConstantContact

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

• How to Connect to SAP Business One Data in Using Python: 6 Steps

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

• Create SSAS Tabular Models from Oracle Financials Cloud Data

  How to build a SQL Server Analysis Service Tabular Model from Oracle Financials Cloud using CData drivers.

• Write a Simple Go Application to work with Oracle HCM Cloud Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle HCM Cloud.

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

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

• Consume SAP Business Warehouse OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on SAP Business Warehouse feeds that reflect any changes in SAP Lumira.

• Create Zoho Books-Connected Dashboards in Grafana

  Connect to Zoho Books Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Books.

• Connect to and Visualize Live MessageBird Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live MessageBird.

• Integrating Codex CLI with Sentry 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 Klaviyo Replication to IBM DB2

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

• «
• 356
• 357
• 358
• 359
• 360
• 361
• 362
• 363
• 364
• 365
• »