CData Software - Knowledge Base

Recent Articles

---

• «
• 385
• 386
• 387
• 388
• 389
• 390
• 391
• 392
• 393
• 394
• »

• Working with MongoDB Data in LINQPad

  Execute LINQ queries to MongoDB in LINQPad.

• Automate Freshservice Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Freshservice from PowerShell? This article demonstrates how to utilize the Freshservice Cmdlets for tasks like connecting to Freshservice, automating operations, downloading data, and more.

• Access Mistral AI Data from MySQL in Amazon QuickSight

  Connect to Mistral AI and build visualizations of Mistral AI using a MySQL Connection in Amazon QuickSight.

• Automated Continuous Tally Replication to SQL Server

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

• Trello Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Trello through CData Connect AI using different applications and tools.

• Build AI Agents with Airtable Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Airtable through CData Connect AI.

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

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

• Provide OData Services of Customer.io Data from a WCF Application

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

• Connect to Rebilly Data in Claris FileMaker Pro

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

• Visualize Live ShipEngine Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live ShipEngine using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Publish Reports with Wrike Data in SAP Crystal Reports

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

• Query LinkedIn Ads Data from Node.js

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

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

  Use CData Connect AI to integrate live Email into Databricks

• Using the CData Software ODBC Driver for Acumatica in PyCharm

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

• Connect to ServiceDesk Plus Data in CloverDX (formerly CloverETL)

  Transfer ServiceDesk Plus using the visual workflow in the CloverDX data integration tool.

• Publish Avro-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Apache Avro.

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

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

• Build HubSpot-Connected Web Apps in Servoy

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

• Build Dashboards with Wave Financial Data in Dundas BI

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

• Integrating LangChain with Cassandra Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Apache Cassandra within automated workflows.

• Stream Dynamics CRM Data into Apache Kafka Topics

  Access and stream Microsoft Dynamics CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• How to Visualize REST Data in Python with pandas

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

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

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

• Build Charts with Unbounce Data in Clear Analytics

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

• Import and Visualize Dynamics CRM Data in Power View

  Create data visualizations based on Microsoft Dynamics CRM in Excel.

• Connect to Rootly Data in DBeaver

  Use the CData ODBC Driver to connect to Rootly in DBeaver.

• Integrate Live Reply.io Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Reply.io to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

• Publish Reports with Webex Data in SAP Crystal Reports

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

• Build Tally-Connected Web Apps in Servoy

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

• Replicate QuickBooks Online Data to Multiple Databases via the CData Sync CLI

  Replicate QuickBooks Online to disparate databases with a single configuration.

• Connect to Google Search Results from PowerBuilder via JDBC

  This article demonstrates how to access Google Search from PowerBuilder using the Google Search JDBC Driver.

• Enable the Microsoft Planner JDBC Driver in KNIME

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

• Use Claude to Talk to Your Google Cloud Storage 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 Google Cloud Storage for you.

• Moving Data from Facebook Ads to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live Facebook Ads data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Automated Continuous Hubstaff Replication to SQL Server

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

• Connect to IBM Cloud Object Storage from a Connection Pool in WebLogic

  Use the CData JDBC Driver for IBM Cloud Object Storage to connect to IBM Cloud Object Storage from Web applications running on WebLogic.

• How to Import Data from Sage 200 into Google Sheets

  Import Sage 200 into a Google spreadsheet that is automatically refreshed.

• Integrate Google Analytics Data in Pentaho Data Integration

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

• Connect to ChartMogul Data in Claris FileMaker Pro

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

• How to Work with Sage 300 Data in ETL Validator JDBC

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

• ETL Teradata in Oracle Data Integrator

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

• Automate Microsoft Entra ID Data Replication to Couchbase

  Use CData Sync to Customize and automate Microsoft Entra ID replication to Couchbase.

• Access Live Samanage Data in Coginiti Pro

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

• Work with ShipStation Data in FoxPro

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

• Automated Continuous FreeAgent Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable FreeAgent replication to Azure SQL Database.

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

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

• Connect to Campaigner from a Connection Pool in WebLogic

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

• Import Oracle Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Oracle Database. In this article, you will use the OData format to import Oracle Database into Microsoft Power Query.

• Integrate with live Redshift Data in Jitterbit

  Use CData Connect AI to connect to and integrate live Amazon Redshift in Jitterbit.

• How to use SQLAlchemy ORM to access Hugging Face Data in Python

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

• How to Connect Flowise AI Agents to Live SQL Analysis Services Data via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live SQL Analysis Services without replication.

• Feed LeadDesk Data into FineReport

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

• How to import OpenWeatherMap Data into Apache Solr

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

• Analyze Yelp Data with Power Pivot

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

• Migrating data from Act CRM to Snowflake using CData SSIS Components.

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

• Access Live Oracle 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 Oracle Database through MCP integration.

• LINQ to FormSite 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 FormSite Data Provider.

• Access Live Square 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 Square through MCP integration.

• Import QuickBooks Online Data Using Azure Data Factory

  Use CData Connect AI to connect to QuickBooks Online Data from Azure Data Factory and import live QuickBooks Online.

• Access Live SQL Server Data in AWS Lambda (with IntelliJ IDEA)

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

• Connect to PivotalTracker Data in Claris FileMaker Pro

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

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

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

• Automate Tasks in Power Automate Using the CData API Server

  Automate Quickbase actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Creating Google Spanner-Connected Applications in Unqork

  You can use CData Connect AI to feed Google Spanner to Unqork and build custom business apps.

• Automated Continuous Recurly Replication to IBM DB2

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

• Build Freshservice-Connected Apps in Choreo

  Use CData Connect AI to connect to Freshservice Data from Choreo and build custom apps using live Freshservice.

• Integrate Cline with Live Marketo Data via CData Connect AI

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

• Connect to Grafana Data from PowerBuilder via JDBC

  This article demonstrates how to access Grafana from PowerBuilder using the Grafana JDBC Driver.

• Integrate Xero with External Services using SnapLogic

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

• Authenticate and Access Zoom API with OAuth and Postman

  Easily connect to Zoom API using OAuth and test it with Postman.

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

  Easily push NetSuite CRM & ERP to Google BigQuery using the CData SSIS Tasks for NetSuite and Google BigQuery.

• Replicate Multiple Sybase Accounts via the CData Sync CLI

  Replicate multiple Sybase accounts to one or many databases.

• Integrate SendPulse Data in Your Informatica Cloud Instance

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

• How to connect PolyBase to ZohoExpense

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

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

• Use the CData Software JDBC Driver for Spark in MicroStrategy

  Connect to Apache Spark SQL in MicroStrategy Developer using the CData Software JDBC Driver for Spark.

• Build Oracle Service Cloud-Powered Applications in Cursor with CData MCP Server

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

• How to connect Amazon QuickSight to Zoho Projects Data

  Create a connection to Zoho Projects in CData Connect AI and insert Zoho Projects into Amazon QuickSight SPICE to build interactive dashboards.

• How to load Rootly data into Elasticsearch via Logstash

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

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

  Use CData ODBC drivers to import and use Atlassian Confluence in ColdFusion.

• Validate Scrapfly Data with QuerySurge

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

• Connect to Amazon Athena Data in Claris FileMaker Pro

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

• Explore Geographical Relationships in Shortcut Data with Power Map

  Create data visualizations with Shortcut in Power Map.

• Build Dashboards with CSV Data in Dundas BI

  Create dynamic dashboards and perform analytics based on CSV/TSV Files in Dundas BI.

• Automated Continuous CampaignMonitor Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable CampaignMonitor replication to AlloyDB.

• Connect to Cvent Data in RapidMiner

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

• Integrate with Acumatica Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Acumatica ERP in SnapLogic.

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

  Replicate Workday to disparate databases with a single configuration.

• Analyze Sugar CRM Data with Power Pivot

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

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

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

• Extract, Transform, and Load Close Data in Informatica PowerCenter

  Create a simple Workflow for Close in Informatica PowerCenter.

• Easily Integrate Contentful Data in Lazarus Pascal IDE

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

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

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

• Connect CircleCI to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live CircleCI using the CData Python MCP Server.

• Replicate eBay Data to Multiple Databases

  Replicate eBay to disparate databases with a point-and-click configuration.

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

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

• Connect to Microsoft Planner Data in Ruby

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

• Automated Continuous Kafka Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Kafka replication to Amazon Redshift.

• Analyze Tavily Data in R via ODBC

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

• Connect to Kintone Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Kintone Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• «
• 385
• 386
• 387
• 388
• 389
• 390
• 391
• 392
• 393
• 394
• »