CData Software - Knowledge Base
Recent Articles
-
Build Bullhorn CRM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Bullhorn CRM data and build visualizations in Tableau.
-
Access PostgreSQL Data from MySQL in Amazon QuickSight
Connect to PostgreSQL and build visualizations of PostgreSQL data using a MySQL Connection in Amazon QuickSight.
-
Integrate Freshsales with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Freshsales with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Freshsales data.
-
Connect to LinkedIn Data from HeidiSQL
Use CData Connect AI to connect to and query live LinkedIn data from HeidiSQL.
-
Connect to SingleStore Data from a Connection Pool in Jetty
The SingleStore JDBC Driver supports connection pooling: This article shows how to connect faster to SingleStore data from Web apps in Jetty.
-
Use the CData Software ODBC Driver for WordPress in MicroStrategy Web
Connect to WordPress data in MicroStrategy Web using the CData Software ODBC Driver for WordPress.
-
How to Connect Vertica Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Vertica data in real time using natural language.
-
Connect to Phoenix from a Connection Pool in WebLogic
Use the CData JDBC Driver for Phoenix to connect to Phoenix data from Web applications running on WebLogic.
-
Create Data Visualizations Based On Salesforce Data 360 Data in Mode
Use CData Connect AI to connect to Salesforce Data 360 Data from Mode and build visualizations using live Salesforce Data 360 data.
-
Connect Mistral AI to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Mistral AI data using the CData Python MCP Server.
-
Automated Continuous Google Translate Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Translate replication to Apache Kafka.
-
Use the CData ODBC Driver for Snowflake in Microsoft Power Query
You can use the CData Snowflake ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Snowflake data into Microsoft Power Query.
-
Choosing the Best Method to Connect Intercom to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Intercom data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Rootly 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 Rootly data into TIBCO Spotfire.
-
Feed Contentful Data into FineReport
How to set Contentful data as a JDBC data source in FineReport.
-
Build Semantic Layer Views for Vimeo Data in APOS Live Data Gateway
Use the CData Connector for Vimeo in APOS Live Data Gateway to build Semantic Layer Views for Vimeo data.
-
Access Dynamics CRM Data from MySQL in Amazon QuickSight
Connect to Dynamics CRM and build visualizations of Dynamics CRM data using a MySQL Connection in Amazon QuickSight.
-
Visualize ElevenLabs Data in Tableau
The CData ODBC driver for ElevenLabs enables you integrate ElevenLabs data into Tableau dashboards.
-
Create Dashboards and Visualize Live Notion Data in Geckoboard
Use CData Connect AI to connect to live Notion data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use the CData Software JDBC Driver for Keap in MicroStrategy Desktop
Connect to Keap data in MicroStrategy Desktop using the CData Software JDBC Driver for Keap.
-
How to import Presto Data into Apache Solr
Use the CData Software JDBC Driver for Presto in Data Import Handler and create an automated import of Presto data to Apache Solr Enterprise Search platform.
-
How to Connect Vault CRM Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Vault CRM data in real time using natural language.
-
Automated Continuous Microsoft Entra ID Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to IBM DB2.
-
Import and Visualize Eventbrite Data in Power View
Create data visualizations based on Eventbrite data in Excel.
-
How to Create Power BI Visual Reports with Real-Time Outlook Data
Use CData Power BI Connectors to visualize Outlook data in Power BI.
-
Back Up Azure DevOps data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure DevOps. In this article, we will employ an SSIS workflow to populate a database with Azure DevOps data data.
-
Manage Bugsnag Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Bugsnag.
-
How to Query ShipEngine Data in MySQL Workbench
Execute MySQL queries against live ShipEngine data from MySQL Workbench.
-
Access Google Tasks Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Tasks data from HeidiSQL.
-
Bidirectional Access to Cosmos DB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Cosmos DB data in Filemaker Pro for Mac or Windows.
-
Integrating Kiro with Oracle SCM 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.
-
Automated Continuous EnterpriseDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Azure SQL Database.
-
Build Automated Workflows with Live Twilio Data in Workato
Use CData Connect AI to connect to live Twilio data and build automated workflows in Workato.
-
Integrate OpenCode with Live Paylocity Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Paylocity data from within your AI coding agent.
-
Connect to ElevenLabs Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ElevenLabs to connect to ElevenLabs data and execute queries in PowerBuilder.
-
Access Live Mouseflow Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Mouseflow data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate Helpscout Data Replication to SAP HANA
Use CData Sync to customize and automate Helpscout data replication to SAP HANA.
-
Connect to Live Sage 200 Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sage 200 in CData Connect AI and connect to your Sage 200 data from PostgreSQL.
-
Establish a Live Connection with SendGrid Data using Tableau Bridge
The CData ODBC Driver for SendGrid enables you to integrate live SendGrid data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to SingleStore Data in RazorSQL
Connect to SingleStore from wizards and query SingleStore data from the GUI in the RazorSQL database management tool.
-
Use the CData Software JDBC Driver for ConstantContact in MicroStrategy
Connect to ConstantContact data in MicroStrategy Developer using the CData Software JDBC Driver for ConstantContact.
-
Create Google Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Ads data access from reports, embedded analytics, and more.
-
Build Sybase IQ Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Sybase IQ data and build visualizations in Tableau.
-
Getting Started with the CData Power BI Connector for Highrise
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Highrise.
-
Getting Started with the CData ADO.NET Provider for SAS xpt
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAS xpt.
-
Use the CData Software JDBC Driver for ConvertAPI in MicroStrategy Desktop
Connect to ConvertAPI data in MicroStrategy Desktop using the CData Software JDBC Driver for ConvertAPI.
-
Build Oracle Financials Cloud-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Oracle Financials Cloud data without replication.
-
How to Access Live Short.io Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Short.io enables you to integrate Short.io data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Gumloop with Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Dynamics 365 data within automated workflows.
-
Automated Continuous Exa Replication to Oracle
Use CData Sync for automated, continuous, customizable Exa replication to Oracle.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP SuccessFactors LMS
Create an ODBC connection to SAP SuccessFactors LMS in Informatica and browse and transfer SAP SuccessFactors LMS data.
-
Automated Continuous Zoho Books Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zoho Books replication to SingleStore.
-
Visualize Azure DevOps 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 Azure DevOps data into TIBCO Spotfire.
-
Connect to Pipeliner CRM Data from a Connection Pool in JBoss
Integrate Pipeliner CRM data into Java servlets: Use the Management Console in JBoss to install the Pipeliner CRM JDBC Driver.
-
Establish a Live Connection with Perplexity Data using Tableau Bridge
The CData ODBC Driver for Perplexity enables you to integrate live Perplexity data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to PhantomBuster Data from IntelliJ
Integrate connectivity to PhantomBuster data with wizards in IntelliJ.
-
Build MVC Applications with Connectivity to SFTP Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SFTP from an ASP.NET MVC application.
-
Build Calendly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Calendly data and build web apps with connectivity to live Calendly data.
-
Automate Klaviyo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Klaviyo data from PowerShell? This article demonstrates how to utilize the Klaviyo Cmdlets for tasks like connecting to Klaviyo data, automating operations, downloading data, and more.
-
How to Build an ETL App for Freshsales Data in Python with CData
Create ETL applications and real-time data pipelines for Freshsales data in Python with petl.
-
Import Instagram Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Instagram Data and provide access to live Instagram data for custom reports in the Power BI Service.
-
Create Dynamic MailChimp Grids Using the Infragistics XamDataGrid
Learn how you can connect MailChimp to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software ODBC Driver for Microsoft Exchange in MicroStrategy
Connect to Microsoft Exchange data in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft Exchange.
-
Integrate Dify with Live ZohoInvoice Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live ZohoInvoice data.
-
Analyze Zoho Inventory Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zoho Inventory data and visualize Zoho Inventory data in SAP Analytics Cloud.
-
Integrate Goose with Live SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP SuccessFactors LMS data from within the local AI agent.
-
Visualize Live ConvertAPI Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ConvertAPI data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating OpenCode with Parquet 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 Oracle Financials Cloud to Google BigQuery using CData SSIS Components.
Easily push Oracle Financials Cloud data to Google BigQuery using the CData SSIS Tasks for Oracle Financials Cloud and Google BigQuery.
-
Integrate Live PingOne Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to PingOne from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live PingOne data.
-
Interact with Live Azure Analysis Services Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Azure Analysis Services data.
-
How to connect Amazon QuickSight to Paymo Data
Create a connection to Paymo data in CData Connect AI and insert Paymo data into Amazon QuickSight SPICE to build interactive dashboards.
-
Access RSS Feeds from MySQL in Amazon QuickSight
Connect to RSS and build visualizations of RSS feeds using a MySQL Connection in Amazon QuickSight.
-
Query Typeform Data as a SQL Server Database in Node.js
Execute SQL Server queries against Typeform data from Node.js.
-
DataBind Charts to Dynamics 365 Business Central Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Dynamics 365 Business Central data 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.
-
How to integrate Metabase with Microsoft Exchange Data
Use CData Connect AI to connect to live Microsoft Exchange data and create an interactive dashboard in Metabase from Microsoft Exchange data.
-
Publish Crystal Reports on Demio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Demio data.
-
DataBind Controls to Microsoft Teams Data in C++Builder
DataBind to Microsoft Teams data in C++Builder with standard components and controls.
-
Connecting Moonlit Workflow with JSON Services 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 JSON services in real time.
-
Import Oracle Sales Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle Sales Data from Azure Data Factory and import live Oracle Sales data.
-
Getting Started with the CData SSIS Components for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData SSIS Components for QuickBooks Time.
-
How to Connect to GitLab Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to GitLab data. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Bitbucket Data in DBVisualizer
Integrate Bitbucket data with visual data analysis tools and data connection wizards in DBVisualizer
-
Seamlessly Bring BigQuery Data into Retool Using CData Connect AI
Integrate BigQuery data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Visualize Facebook Ads 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 Facebook Ads data in Python.
-
Connect SendInBlue to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SendInBlue with IBM WebSphere for seamless data integration and connectivity.
-
Analyze Live Guru Data in SAS Viya
Use CData Connect AI to connect to Guru data from SAS Viya and deploy self-service analytics using live Guru data.
-
Connect to Klaviyo Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Klaviyo Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Import and Visualize iContact Data in Power View
Create data visualizations based on iContact data in Excel.
-
Natively Connect to Placid Data in PHP
The CData ODBC driver for Placid enables you to create PHP applications with connectivity to Placid data. Leverage the native support for ODBC in PHP.
-
Integrate ServiceNow Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ServiceNow data from Informatica Cloud.
-
Connect and Visualize Live Power BI XMLA Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Power BI XMLA data into the Databricks platform and create visualization dashboards with real-time Power BI XMLA data.
-
Build Spark-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Spark Data from Zoho Analytics and import live Spark data.
-
Build SageHR-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SageHR data.
-
Connect to Amazon Athena Data from HeidiSQL
Use CData Connect AI to connect to and query live Amazon Athena data from HeidiSQL.
-
Build AI/ML Models with Live GitLab Data using Dataiku
Connect GitLab Data with Dataiku using the CData API Driver for JDBC.
-
Deploy the ADO.NET Provider for Stack Exchange on an SSRS Report Server
Connect to Stack Exchange data 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.
-
Create SSAS Tabular Models from Humanity Data
How to build a SQL Server Analysis Service Tabular Model from Humanity data using CData drivers.
-
How to integrate Azure DevOps with Apache Airflow
Access and process Azure DevOps data in Apache Airflow using the CData JDBC Driver.
-
Build Charts with Pipeline CRM Data in Clear Analytics
Create dynamic charts and perform analytics based on Pipeline CRM data in Clear Analytics.