CData Software - Knowledge Base
Recent Articles
-
Create Apps from Egnyte Data in Qlik Sense Cloud
Use CData Connect AI to connect to Egnyte Data and build apps from live Egnyte data in Qlik Sense Cloud.
-
How to connect Amazon QuickSight to Azure Synapse Data
Create a connection to Azure Synapse data in CData Connect AI and insert Azure Synapse data into Amazon QuickSight SPICE to build interactive dashboards.
-
Back Up CapsuleCRM data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with CapsuleCRM data data.
-
Enable the Calendly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Calendly data.
-
Visualize Sybase Data in TIBCO Spotfire through ADO.NET
Integrate Sybase data into dashboards in TIBCO Spotfire.
-
Automated Continuous Raisers Edge NXT Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Azure SQL Database.
-
Automated Continuous Strava Replication to Databricks
Use CData Sync for automated, continuous, customizable Strava replication to Databricks.
-
How to connect to PingOne Data in DBVisualizer
Integrate PingOne data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Data Visualizations in Cognos BI with REST Data
Access REST data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Query Salesforce CRM Analytics Data in MySQL Workbench
Execute MySQL queries against live Salesforce CRM Analytics data from MySQL Workbench.
-
Working with MongoDB Data in LINQPad
Execute LINQ queries to MongoDB data in LINQPad.
-
Automate Freshservice Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Freshservice data from PowerShell? This article demonstrates how to utilize the Freshservice Cmdlets for tasks like connecting to Freshservice data, 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 data 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 data 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 data 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 data 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 data 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 data 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 data.
-
Connect and Query Live Email Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Email data into Databricks and enable direct, live querying and analysis without replication.
-
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 data 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 Avro data.
-
Use the CData Software JDBC Driver for PhantomBuster in MicroStrategy Web
Connect to PhantomBuster data 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 data and build web apps with connectivity to live HubSpot data.
-
Build Dashboards with Wave Financial Data in Dundas BI
Create dynamic dashboards and perform analytics based on Wave Financial data 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 Cassandra data within automated workflows.
-
Stream Dynamics CRM Data into Apache Kafka Topics
Access and stream Dynamics CRM data 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 data 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 data into Microsoft Power Query.
-
Build Charts with Unbounce Data in Clear Analytics
Create dynamic charts and perform analytics based on Unbounce data in Clear Analytics.
-
Import and Visualize Dynamics CRM Data in Power View
Create data visualizations based on Dynamics CRM data in Excel.
-
Connect to Rootly Data in DBeaver
Use the CData ODBC Driver to connect to Rootly data in DBeaver.
-
Integrate Live Reply.io Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Reply.io data 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 data.
-
Build Tally-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Tally data and build web apps with connectivity to live Tally data.
-
Replicate QuickBooks Online Data to Multiple Databases via the CData Sync CLI
Replicate QuickBooks Online data to disparate databases with a single configuration.
-
Connect to Google Search Results from PowerBuilder via JDBC
This article demonstrates how to access Google Search results 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 data.
-
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 data 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 data from Web applications running on WebLogic.
-
Integrate Google Analytics Data in Pentaho Data Integration
Build ETL pipelines based on Google Analytics data 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 data 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 data 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 data replication to Couchbase.
-
Access Live Samanage Data in Coginiti Pro
Connect to and query live Samanage data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Work with ShipStation Data in FoxPro
Load ShipStation data 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 data from Web applications running on WebLogic.
-
Integrate with live Redshift Data in Jitterbit
Use CData Connect AI to connect to and integrate live Redshift data 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 data.
-
Use ChatGPT to Talk to Your ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your ServiceDesk Plus data for you.
-
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 data without replication.
-
Feed LeadDesk Data into FineReport
How to set LeadDesk data 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 data 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 data. 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 data to Snowflake using the CData SSIS Tasks for Act CRM and Snowflake.
-
Automated Continuous Vimeo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Vimeo replication to PostgreSQL.
-
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 data through MCP integration.
-
Automated Continuous Hacker News Replication to Databricks
Use CData Sync for automated, continuous, customizable Hacker News replication to Databricks.
-
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 data through MCP integration.
-
Integrate Campaigner Data into Power Automate Desktop using CData Connect
CData Connect for Campaigner Data enables you to integrate Campaigner data into workflows built using Microsoft Power Automate Desktop.
-
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 data.
-
Access Live SQL Server Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SQL Server data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Query Live Snowflake Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Snowflake data data in natural language using Python.
-
Prepare, Blend, and Analyze Suadeo Data in Alteryx Designer (Connect AI)
Build workflows to access live Suadeo data for self-service data analytics.
-
Connect and Visualize Live HubDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live HubDB data into the Databricks platform and create visualization dashboards with real-time HubDB data.
-
Creating Google Spanner-Connected Applications in Unqork
You can use CData Connect AI to feed Google Spanner data 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 data.
-
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 data from within your IDE.
-
Connect to Grafana Data from PowerBuilder via JDBC
This article demonstrates how to access Grafana data 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 data 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 data 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 data.
-
Integrating GitHub Copilot with Zoho CRM 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.
-
Use the CData Software JDBC Driver for Spark in MicroStrategy
Connect to Spark data in MicroStrategy Developer using the CData Software JDBC Driver for Spark.
-
Create Typeform-Connected Applications in Appsmith
Connect to Typeform Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Typeform data.
-
How to connect Amazon QuickSight to Zoho Projects Data
Create a connection to Zoho Projects data in CData Connect AI and insert Zoho Projects data 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 Confluence data in ColdFusion.
-
Validate Scrapfly Data with QuerySurge
Access and validate Scrapfly data 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 data in your FileMaker applications.
-
Integrate Google's Vertex AI Agent with Live Klipfolio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Klipfolio data within intelligent workflows.
-
Explore Geographical Relationships in Shortcut Data with Power Map
Create data visualizations with Shortcut data in Power Map.
-
Build Dashboards with CSV Data in Dundas BI
Create dynamic dashboards and perform analytics based on CSV data 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 data 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 data in SnapLogic.
-
Replicate Workday Data to Multiple Databases via the CData Sync CLI
Replicate Workday data to disparate databases with a single configuration.