CData Software - Knowledge Base
Recent Articles
-
How to Use a Microsoft Access Database to Update Act-On Data in Real Time
Update Act-On data by creating a linked table in Microsoft Access with the CData Act-On ODBC Driver.
-
How to connect Amazon QuickSight to Epicor Kinetic Data
Create a connection to Epicor Kinetic data in CData Connect AI and insert Epicor Kinetic data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Live Mailjet Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Mailjet data from within the IDE.
-
How to connect PolyBase to Shippo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Shippo data.
-
Connect to MariaDB Data in RazorSQL
Connect to MariaDB from wizards and query MariaDB data from the GUI in the RazorSQL database management tool.
-
Connect to Live ADP Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ADP in CData Connect AI and connect to your ADP data from PostgreSQL.
-
Working with Neo4J Data in LINQPad
Execute LINQ queries to Neo4J data in LINQPad.
-
Migrating data from Clockify to Google BigQuery using CData SSIS Components.
Easily push Clockify data to Google BigQuery using the CData SSIS Tasks for Clockify and Google BigQuery.
-
Integrating Claude Code CLI with Pinecone 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.
-
How to connect to SAP ByDesign Data with Squirrel SQL client
Connect to SAP ByDesign data and execute queries in the Squirrel SQL Client.
-
Connect to Dynamics CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Dynamics CRM data using standard SQL.
-
Integrating Dataiku with Pinterest Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Pinterest data.
-
Connect to Stack Exchange Data in DBeaver
Use the CData ODBC Driver to connect to Stack Exchange data in DBeaver.
-
Automated Continuous Authorize.Net Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Apache Kafka.
-
Integrating GitHub Copilot with Aha! 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.
-
Natively Connect to SAP Ariba Source Data in PHP
The CData ODBC driver for SAP Ariba Source enables you to create PHP applications with connectivity to SAP Ariba Source data. Leverage the native support for ODBC in PHP.
-
Automate Sage Intacct Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sage Intacct data from PowerShell? This article demonstrates how to utilize the Sage Intacct Cmdlets for tasks like connecting to Sage Intacct data, automating operations, downloading data, and more.
-
Prepare, Blend, and Analyze Anaplan Data in Alteryx Designer (Connect AI)
Build workflows to access live Anaplan data for self-service data analytics.
-
Create Reports from Optimizely Data in Looker Studio
Use CData Connect AI to gain access to live Optimizely data and create custom reports in Looker Studio.
-
Query Live LinkedIn Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live LinkedIn data through a conversational interface.
-
Integrate Redis Data in the Pentaho Report Designer
Publish reports based on Redis data in the Pentaho BI tool.
-
How to import Retently Data into Apache Solr
Use the CData Software JDBC Driver for Retently in Data Import Handler and create an automated import of Retently data to Apache Solr Enterprise Search platform.
-
Extract, Transform, and Load SageHR Data in Informatica PowerCenter
Create a simple Workflow for SageHR data in Informatica PowerCenter.
-
Connect to GraphQL Data from Crystal Reports
Use CData Connect AI to connect to and report on live GraphQL data from Crystal Reports.
-
Connect to Avalara AvaTax Data from PowerBuilder via JDBC
This article demonstrates how to access Avalara AvaTax data from PowerBuilder using the Avalara AvaTax JDBC Driver.
-
DataBind Controls to XML Data in C++Builder
DataBind to XML data in C++Builder with standard components and controls.
-
Connect to Confluence Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Confluence data.
-
Create Twitter Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Twitter Ads data access from reports, embedded analytics, and more.
-
How to Access Live Gorgias Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Gorgias enables you to integrate Gorgias data into workflows built using Microsoft Power Automate Desktop.
-
Publish Crystal Reports on Shippo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Shippo data.
-
Creating Salesforce-Connected Applications in Unqork
You can use CData Connect AI to feed Salesforce data to Unqork and build custom business apps.
-
Create Power BI Reports on Real-Time Customer.io Data
Use the CData ODBC Driver for Customer.io to visualize Customer.io data in Power BI Desktop.
-
Connect to Google Sheets Data in DBArtisan
Use wizards in DBArtisan to configure Google Sheets data as a data source.
-
Visualize Live CapsuleCRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CapsuleCRM data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to SAP HANA Data in Ruby
Connect to SAP HANA data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
A PostgreSQL Interface for SAP Netweaver Gateway Data using the CData ODBC Driver
Use the SQL Gateway and SAP Netweaver Gateway ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for CapsuleCRM in MicroStrategy
Connect to CapsuleCRM data in MicroStrategy Developer using the CData Software JDBC Driver for CapsuleCRM.
-
DataBind Controls to Invoiced Data in C++Builder
DataBind to Invoiced data in C++Builder with standard components and controls.
-
Visualize Aircall 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 Aircall data into TIBCO Spotfire.
-
Build Apps with Live Azure Data Catalog Data Using the Low-Code Development Platform of Mendix
Connect Azure Data Catalog data with Mendix to build apps using the CData JDBC Driver for Azure Data Catalog.
-
How to create Visio diagrams from SAP Hybris C4C Data
Automatically update SAP Hybris C4C data with the changes you make to Visio master shapes.
-
Connect Reckon Accounts Hosted Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Reckon Accounts Hosted data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Voice Agents in ElevenLabs with access to Live MySQL Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live MySQL data.
-
Integrate with LinkedIn Ads Data in JReport Designer
Create charts and reports based on LinkedIn Ads data in JReport Designer.
-
Creating PostgreSQL-Connected Applications in Unqork
You can use CData Connect AI to feed PostgreSQL data to Unqork and build custom business apps.
-
Migrating data from SAP Fieldglass to Snowflake using CData SSIS Components.
Easily push SAP Fieldglass data to Snowflake using the CData SSIS Tasks for SAP Fieldglass and Snowflake.
-
How to Create Power BI Visual Reports with Real-Time SAP Hybris C4C Data
Use CData Power BI Connectors to visualize SAP Hybris C4C data in Power BI.
-
How to Connect DBeaver to Rebilly via a JDBC Driver
Manage Rebilly data with visual tools in DBeaver like the query browser.
-
Visualize Humanity Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Humanity data.
-
How to Visualize Cloudflare Data in Python with pandas
Use pandas and other modules to analyze and visualize live Cloudflare data in Python.
-
Connect to Hubstaff Data in RapidMiner
Integrate Hubstaff data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build a Simple VCL Application for XML Data
How to build a simple VCL Application to view XML data in RAD Studio using the CData ODBC Driver for XML.
-
Connect to Short.io Data in DBArtisan
Use wizards in DBArtisan to configure Short.io data as a data source.
-
Automated Continuous Close Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Close replication to Apache Kafka.
-
Connect to and Query Coda Data in QlikView over ODBC
Create data visualizations with Coda data in QlikView.
-
Visualize Perplexity Data in Sisense
Create an ElastiCube in Sisense app with access to Perplexity data.
-
Connect to Amazon S3 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Amazon S3 and the SQL Gateway to access Amazon S3 data from Google Apps Script.
-
Automated Continuous Contentful Replication to MongoDB
Use CData Sync for automated, continuous, customizable Contentful replication to MongoDB.
-
Use the CData Software ODBC Driver for SAP Business One in MicroStrategy Desktop
Connect to SAP Business One data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Business One.
-
Analyze Freshservice Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Freshservice data in Microsoft R Open.
-
Automate OnePageCrm Data Replication to Couchbase
Use CData Sync to Customize and automate OnePageCrm data replication to Couchbase.
-
Automated Continuous Opsgenie Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Opsgenie replication to Azure SQL Database.
-
Natively Connect to Active Directory Data in PHP
The CData ODBC driver for Active Directory enables you to create PHP applications with connectivity to Active Directory data. Leverage the native support for ODBC in PHP.
-
Create Dynamic SAP Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData ODBC Driver for CSV
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for CSV.
-
Design BIRT Reports on MailerSend Data
Provide current MailerSend data to your embedded analytics.
-
How to Connect DBeaver to JotForm via a JDBC Driver
Manage JotForm data with visual tools in DBeaver like the query browser.
-
Automated Continuous Kintone Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Kintone replication to Apache Cassandra.
-
Visualize Live Optimizely Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Optimizely data.
-
Build Voice Agents in ElevenLabs with access to Live ServiceNow Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ServiceNow data.
-
Connect to and Query Workday Data in QlikView over ODBC
Create data visualizations with Workday data in QlikView.
-
Build Adobe Experience Manager-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Adobe Experience Manager Data and create custom apps in Mendix.
-
Build Automated MongoDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live MongoDB data and build automated workflows in Zapier.
-
How to integrate SendPulse with Apache Airflow
Access and process SendPulse data in Apache Airflow using the CData JDBC Driver.
-
How to create Dynamics CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Dynamics CRM data in MySQL .
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Calendly
Provide connectivity to Calendly data through an SAP BusinessObjects universe.
-
How to create Hacker News federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Hacker News data in MySQL .
-
How to Connect SAP Hybris C4C 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 SAP Hybris C4C data in real time using natural language.
-
How to connect to Twitter Ads Data from Spring Boot
Connect to Twitter Ads in a Spring Boot Application using the CData JDBC Driver for Twitter Ads
-
Integrate Trae with Live Adobe Target Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Adobe Target data from within the AI-powered IDE.
-
Building Dynamic Web Pages with Google Calendar Data Using AngularJS
Create single-page applications with live connectivity to Google Calendar using the CData API Server.
-
Use Biml to Build SSIS Tasks to Replicate Google Drive Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Drive data to SQL Server.
-
Automate Jodoo Data Replication to SAP HANA
Use CData Sync to customize and automate Jodoo data replication to SAP HANA.
-
Publish Reports with ZeroBounce Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZeroBounce data.
-
Visualize Pinterest Data in Tableau
The CData ODBC driver for Pinterest enables you integrate Pinterest data into Tableau dashboards.
-
Model SingleStore Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SingleStore, enabling the direct import of real-time SingleStore data.
-
Connect to Reply.io Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Reply.io.
-
Connect to PostgreSQL Data in Jaspersoft Studio
Execute SQL to remote PostgreSQL data in Jaspersoft Studio.
-
Choosing the Best Method to Connect Shortcut to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Shortcut data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Live Excel Online Data in MicroStrategy through CData Connect AI
Create a live connection to Excel Online Data in CData Connect AI and connect to your Excel Online data from MicroStrategy.
-
How to Build an ETL App for SAP SuccessFactors LMS Data in Python with CData
Create ETL applications and real-time data pipelines for SAP SuccessFactors LMS data in Python with petl.
-
Integrate with Browserless Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Browserless data to a JSON file on disk.
-
Back Up FTP data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for FTP. In this article, we will employ an SSIS workflow to populate a database with FTP data data.
-
Automated Parallel Data Replication to Teradata
Use CData Sync to Customize and automate Parallel data replication to Teradata.
-
Interact with Live TaxJar Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live TaxJar data.
-
Connecting Mastra with Vault CRM 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 Vault CRM data, no replication required.
-
Automated Continuous Azure Blob Storage Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Google Cloud SQL.
-
Connect to Instagram Data in Jaspersoft Studio
Execute SQL to remote Instagram data in Jaspersoft Studio.
-
Query Live Hive Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Hive data directly from the development environment.
-
Use ChatGPT to Talk to Your CouchDB 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 CouchDB data for you.