CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for Google Translate Data using the CData ODBC Driver
Use the SQL Gateway and Google Translate ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Google Spanner Data in Coginiti Pro
Connect to and query live Google Spanner data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Vault CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Vault CRM replication to MongoDB.
-
Create Dashboards and Visualize Live Sugar CRM Data in Geckoboard
Use CData Connect AI to connect to live Sugar CRM data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build AI/ML Models with Live Exact Online Data using Dataiku
Connect Exact Online Data with Dataiku using the CData JDBC Driver for Exact Online.
-
Create Informatica Mappings From/To a JDBC Data Source for BigQuery
Create BigQuery data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to and Visualize Live Dynamics 365 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Dynamics 365 data.
-
Migrating data from Snapchat Ads to Databricks using CData SSIS Components.
Easily push Snapchat Ads data to Databricks using the CData SSIS Tasks for Snapchat Ads and Databricks.
-
Automated SendPulse Data Replication to Teradata
Use CData Sync to Customize and automate SendPulse data replication to Teradata.
-
Build Pipelines with Live Exact Online Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Exact Online from Google Cloud Data Fusion, enabling the integration of live Exact Online data into the building and management of effective data pipelines.
-
Create SSAS Tabular Models from Oracle Service Cloud Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Service Cloud data using CData drivers.
-
Build Data Flows from Cvent to SQL Server using SSIS
Easily back up Cvent data to SQL Server using the SSIS components for Cvent.
-
How to Connect to Live Active Directory Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Active Directory data securely in real time.
-
Connect SharePoint to SQL Server through SSIS
Easily back-up SharePoint data to SQL Server using the SharePoint Data Provider for ADO.NET. This example uses an SSIS workflow to populate a database with SharePoint data using the SharePoint ADO.NET Data Provider.
-
Consume Box OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Box feeds that reflect any changes in SAP Lumira.
-
Access Live Chargebee Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Chargebee data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Sentry Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sentry replication to Apache Kafka.
-
Integrate OpenCode with Live HBase Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live HBase data from within your AI coding agent.
-
Connect to MongoDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MongoDB data.
-
Import RSS Feeds Using Azure Data Factory
Use CData Connect AI to connect to RSS Feeds from Azure Data Factory and import live RSS feeds.
-
Build Voice Agents in ElevenLabs with access to Live Microsoft Exchange Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Microsoft Exchange data.
-
Visualize Live Guru Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Guru data into custom reports in Power BI.
-
Bind Live HCL Domino Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live HCL Domino data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Create Informatica Mappings From/To an ODBC Data Source for Everhour
Create an ODBC connection to Everhour in Informatica and browse and transfer Everhour data.
-
Create Gong-Connected Dashboards in Grafana
Connect to Gong Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Gong data.
-
Interact with Live WordPress Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live WordPress data.
-
Connect Square to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Square data using the CData Python MCP Server.
-
Connect to Placid Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Placid data using standard SQL.
-
Create Power BI Reports on Real-Time Microsoft Entra ID Data
Use the CData ODBC Driver for Microsoft Entra ID to visualize Microsoft Entra ID data in Power BI Desktop.
-
How to Connect to & Open Discord Data in Microsoft Excel
This article uses the CData ODBC driver for Discord to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Freshservice-Connected Nintex Workflows
Use CData Connect AI to connect to Freshservice Data from Nintex Workflow Cloud and build custom workflows using live Freshservice data.
-
Integrate Dify with Live Guru 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 Guru data.
-
Automated Continuous DB2 for i Replication to MongoDB
Use CData Sync for automated, continuous, customizable DB2 for i replication to MongoDB.
-
Deploy the ADO.NET Provider for Access on an SSRS Report Server
Connect to Access 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.
-
Getting Started with the CData JDBC Driver for YouTube Analytics
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for YouTube Analytics.
-
CSV: Unable to Retrieve Columns for Table "csv"
In this entry you will find the resolution for the error: unable to retrieve columns for table "csv".
-
Use Manus AI to Talk to Your Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Toggl data.
-
How to Connect Impala 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 Impala data in real time using natural language.
-
Connect to Real-Time WooCommerce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for WooCommerce and Dataflow to import and use WooCommerce data in Power Apps.
-
Integrate Avaza Data in the Pentaho Report Designer
Publish reports based on Avaza data in the Pentaho BI tool.
-
Integrating Dataiku with SAP Business Warehouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Business Warehouse data.
-
Use the CData Software JDBC Driver for SAP Business One in MicroStrategy Desktop
Connect to SAP Business One data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Business One.
-
Build LinkedIn-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live LinkedIn data and build LinkedIn-connected web apps with Axios.
-
How to work with GitLab Data in Apache Spark using SQL
Access and process GitLab Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Azure Data Lake Storage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Google BigQuery.
-
Connect to Apollo Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Apollo data.
-
How to Connect to Pipedrive Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pipedrive data. Leverage the pyodbc module for ODBC in Python.
-
Visualize Zoho CRM Data in Tableau
The CData ODBC driver for Zoho CRM enables you integrate Zoho CRM data into Tableau dashboards.
-
Provide OData Services of Opsgenie Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Opsgenie data by developing a WCF Service Application.
-
How to Create Power BI Visual Reports with Real-Time Bannerbear Data
Use CData Power BI Connectors to visualize Bannerbear data in Power BI.
-
Getting Started with the CData SSIS Components for Asana
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Asana.
-
Visualize Sendwithus Data in Sisense
Create an ElastiCube in Sisense app with access to Sendwithus data.
-
Migrating data from SAP HANA XS Advanced to Databricks using CData SSIS Components.
Easily push SAP HANA XS Advanced data to Databricks using the CData SSIS Tasks for SAP HANA XS Advanced and Databricks.
-
Connect and Visualize Live Twilio Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Twilio data into the Databricks platform and create visualization dashboards with real-time Twilio data.
-
Use the CData Software ODBC Driver for Power BI XMLA in MicroStrategy
Connect to Power BI XMLA data in MicroStrategy Developer using the CData Software ODBC Driver for Power BI XMLA.
-
Integrate Google's Vertex AI Agent with Live ShipStation 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 ShipStation data within intelligent workflows.
-
Integrating Boomi Agentstudio with CSV Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to CSV data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate Dify with Live LinkedIn Ads 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 LinkedIn Ads data.
-
Analyze Customer.io Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Customer.io data with the CData JDBC Driver for Customer.io.
-
Create Dynamic Notion Grids Using the Infragistics XamDataGrid
Learn how you can connect Notion to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze Google Calendar Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Calendar data for self-service data analytics.
-
Query Live Twitter Ads 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 Twitter Ads data directly from the development environment.
-
Connect and Query Live Certinia Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Certinia data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Live Cloudflare Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Cloudflare from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Cloudflare data.
-
Visualize Amazon Marketplace Data in Tableau
The CData ODBC driver for Amazon Marketplace enables you integrate Amazon Marketplace data into Tableau dashboards.
-
Write a Simple Go Application to work with Close Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Close data.
-
Connecting Mastra with Sybase IQ 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 Sybase IQ data, no replication required.
-
Access Live Salesforce Marketing Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Salesforce Marketing data from your Excel spreadsheets.
-
Back Up Kafka data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Kafka. In this article, we will employ an SSIS workflow to populate a database with Kafka data data.
-
Integrate Devin with Live Google Analytics Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Google Analytics data.
-
Create Informatica Mappings From/To an ODBC Data Source for SAS Data Sets
Create an ODBC connection to SAS Data Sets in Informatica and browse and transfer SAS Data Sets data.
-
Automated Continuous SAP Business One Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP Business One replication to Google Cloud SQL.
-
Feed Elasticsearch Data into FineReport
How to set Elasticsearch data as a JDBC data source in FineReport.
-
How to Connect the Power BI Service to Google Contacts: Complete Guide
Connect to the CData Software Power BI Connector for Google Contacts from PowerBI.com to provide real-time Google Contacts data across the organization.
-
Access Cloudant Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Cloudant data from your Oracle system.
-
Integrate LibreChat with Live Typeform Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Typeform data from within the chat interface.
-
How to connect Amazon QuickSight to Azure Analysis Services Data
Create a connection to Azure Analysis Services data in CData Connect AI and insert Azure Analysis Services data into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Live PingOne 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 PingOne data through MCP integration.
-
Publish Reports with PhantomBuster Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PhantomBuster data.
-
Create Data Visualizations in Cognos BI with Pipeliner CRM Data
Access Pipeliner CRM data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live ZohoMarketingHub 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 ZohoMarketingHub data through MCP integration.
-
Use Biml to Build SSIS Tasks to Replicate Coinbase Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Coinbase data to SQL Server.
-
Automated Continuous Omnisend Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Omnisend replication to Azure SQL Database.
-
Import and Visualize ADP Data in Power View
Create data visualizations based on ADP data in Excel.
-
Access Live Nethunt Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Nethunt data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Excel Spreadsheet Automation on ConstantContact Data with the QUERY Formula
Pull data from ConstantContact, automate spreadsheets, and more with the QUERY formula.
-
Access Live Campaigner Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Campaigner data from your Excel spreadsheets.
-
Integrate SingleStore Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SingleStore data from Informatica Cloud.
-
Integrating Dataiku with HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live HBase data.
-
Integrating GitHub Copilot with Quickbase 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.
-
Build Apps with Live Shopify Data Using the Low-Code Development Platform of Mendix
Connect Shopify data with Mendix to build apps using the CData JDBC Driver for Shopify.
-
How to Seamlessly Import ClickTime Data into IBM SPSS Modeler
Integrate ClickTime data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to and Query Mocean Data in QlikView over ODBC
Create data visualizations with Mocean data in QlikView.
-
Create Power BI Reports on Real-Time PhantomBuster Data
Use the CData ODBC Driver for PhantomBuster to visualize PhantomBuster data in Power BI Desktop.
-
Zendesk Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zendesk facts in real time.
-
Create Bitly-Connected Nintex Workflows
Use CData Connect AI to connect to Bitly Data from Nintex Workflow Cloud and build custom workflows using live Bitly data.
-
Automated Continuous Teradata Replication to Oracle
Use CData Sync for automated, continuous, customizable Teradata replication to Oracle.
-
Natively Connect to WooCommerce Data in PHP
The CData ODBC driver for WooCommerce enables you to create PHP applications with connectivity to WooCommerce data. Leverage the native support for ODBC in PHP.
-
Connect to Qualaroo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Qualaroo data.
-
Use the CData Software JDBC Driver for Microsoft Dataverse in MicroStrategy Web
Connect to Microsoft Dataverse data in MicroStrategy Web using the CData Software JDBC Driver for Microsoft Dataverse.