CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To an ODBC Data Source for Excel Online
Create an ODBC connection to Excel Online in Informatica and browse and transfer Microsoft Excel Online.
-
Integrate Real-Time Access to Oracle Service Cloud in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Service Cloud in real time.
-
Perplexity Reporting in OBIEE with the Perplexity JDBC Driver
Deploy the Perplexity JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Visualizations of Short.io Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Short.io in Birst.
-
LINQ to Wistia 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 Wistia Data Provider.
-
Integrate Twilio Data in Pentaho Data Integration
Build ETL pipelines based on Twilio in the Pentaho Data Integration tool.
-
Use the CData API Server to Access IBM Cloud Object Storage Data in Microsoft PowerPivot
Use the CData API Server to connect to live IBM Cloud Object Storage in the Power Pivot business intelligence tool.
-
Visualize Perplexity Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Perplexity.
-
Build Apps with Live Google Contacts in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Contacts into the Adalo platform and build custom mobile and web applications with real-time Google Contacts.
-
How to work with MarkLogic Data in Apache Spark using SQL
Access and process MarkLogic Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Tableau Connector for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Analyze MYOB AccountRight Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MYOB AccountRight and visualize live MYOB AccountRight in Infragistics Reveal.
-
How to Connect to Live Gong Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Gong for you.
-
Build Dashboards with Presto Data in DBxtra
Create dynamic dashboards and perform analytics based on Presto in DBxtra.
-
Connecting GenSpark with Gmail Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Gmail without any replication or custom integration required.
-
Extract, Transform, and Load Egnyte Data in Informatica PowerCenter
Create a simple Workflow for Egnyte in Informatica PowerCenter.
-
Connect to iContact Data in Jaspersoft Studio
Execute SQL to remote iContact in Jaspersoft Studio.
-
Build Data Flows from SQL Server to SAP SuccessFactors through SSIS
Easily push SQL Server data to SAP SuccessFactors using the CData SSIS Tasks for SAP SuccessFactors.
-
Analyze Live Google Campaign Manager 360 Data in SAS Viya
Use CData Connect AI to connect to Google Campaign Manager 360 from SAS Viya and deploy self-service analytics using live Google Campaign Manager 360.
-
How to use SQLAlchemy ORM to access Front Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Front.
-
Bidirectional Access to Calendly Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Calendly in Filemaker Pro for Mac or Windows.
-
Replicate ServiceNow Data in Heroku for Use in Salesforce Connect
Replicate ServiceNow to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to work with Brex Data in Apache Spark using SQL
Access and process Brex Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for JotForm in MicroStrategy Web
Connect to JotForm in MicroStrategy Web using the CData Software ODBC Driver for JotForm.
-
Build a PostgreSQL Interface for Facebook Ads Data using the CData JDBC Driver
Use the Remoting features of the Facebook Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for GraphQL in MicroStrategy Web
Connect to GraphQL in MicroStrategy Web using the CData Software ODBC Driver for GraphQL.
-
A PostgreSQL Interface for ConvertKit Data using the CData ODBC Driver
Use the SQL Gateway and ConvertKit ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Insightly Data in Aqua Data Studio
Access Insightly from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Create Power BI Visual Reports with Real-Time Autopilot Data
Use CData Power BI Connectors to visualize Autopilot in Power BI.
-
Use JayDeBeApi to access Xero Data in Python
Use standard Python scripting and the development environment of your choice to access live Xero Accounting.
-
How to Connect to Live SendGrid Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SendGrid for you.
-
How to Access IBM Cloud Object Storage Data Using Entity Framework
This article shows how to access IBM Cloud Object Storage using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to work with Jira Data in Apache Spark using SQL
Access and process Jira Data in Apache Spark using the CData Software JDBC Driver.
-
DataBind Charts to Jodoo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Jodoo 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 update BigQuery from Excel
This article explains how to transfer data from Excel to BigQuery using the Excel Add-In for BigQuery.
-
Connect to Oracle Eloqua Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle Eloqua from PowerBuilder using the Oracle Eloqua JDBC Driver.
-
Connect to Discord Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Discord as an External Source in Dremio.
-
How to connect to Facebook Data from Spring Boot
Connect to Facebook in a Spring Boot Application using the CData JDBC Driver for Facebook
-
How to Seamlessly Import Salesforce Marketing Data into IBM SPSS Modeler
Integrate Salesforce Marketing data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Salesloft Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build PingOne-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PingOne and build web apps with connectivity to live PingOne.
-
Build Sybase IQ-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Sybase IQ to explore live Sybase IQ Data in Gemini Code Assist to assist with building Sybase IQ-powered applications.
-
Create Bright Data Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Bright Data from PowerBI.com to create Power BI Dataflows with real-time data.
-
Bridge Azure Analysis Services Connectivity with Apache NiFi
Access and process Azure Analysis Services in Apache NiFi using the CData JDBC Driver.
-
Write a Simple Go Application to work with Adobe Commerce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Adobe Commerce.
-
Connect to and Visualize Live PabblySubscriptions Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PabblySubscriptions.
-
Connect to Live WordPress Data in MicroStrategy through CData Connect AI
Create a live connection to WordPress Data in CData Connect AI and connect to your WordPress from MicroStrategy.
-
How to Access Live Freshdesk Data in Visual Studio Code via Cline
Run CData MCP Server for Freshdesk on Windows Subsytem for Linux (WSL) and connect to live Freshdesk from the Cline extension in Visual Studio Code.
-
Integrate Cline with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Klaviyo from within your IDE.
-
Use the CData ODBC Driver for PhantomBuster from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PhantomBuster to connect to PhantomBuster from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PhantomBuster in Excel.
-
Import Sage 200 Data Using Azure Data Factory
Use CData Connect AI to connect to Sage 200 Data from Azure Data Factory and import live Sage 200.
-
How to connect to Bitbucket Data from IntelliJ
Integrate connectivity to Bitbucket with wizards in IntelliJ.
-
Automate RSS Feeds Replication to Couchbase
Use CData Sync to Customize and automate RSS Feeds replication to Couchbase.
-
Access Live Avaza Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Avaza in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData Tableau Connector for Testmonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Facebook Ads Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Facebook Ads replication to delimited files (CSV/TSV).
-
Analyze Shopify Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Shopify and visualize Shopify in SAP Analytics Cloud.
-
Bridge Excel Connectivity with Apache NiFi
Access and process Microsoft Excel in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Oracle Financials Cloud Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to SQL Server.
-
Connect and Visualize Live Zoho Inventory Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zoho Inventory into the Databricks platform and create visualization dashboards with real-time Zoho Inventory.
-
Integrating Gumloop with SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Hybris C4C within automated workflows.
-
Automated Continuous HubSpot Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable HubSpot replication to Google Cloud SQL.
-
Integrate Cline with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Facebook Ads from within your IDE.
-
How to Work with ADP Data in ETL Validator JDBC
Connect to ADP from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Kafka Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Getting Started with the CData Power BI Connector for Landbot
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Retently Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Retently in the Denodo Virtual DataPort Administrator.
-
Integrate Live SAP Business One Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create SSAS Tabular Models from CockroachDB Data
How to build a SQL Server Analysis Service Tabular Model from CockroachDB using CData drivers.
-
Integrating Dataiku with Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Planner.
-
Connect to EmailOctopus Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for EmailOctopus to connect to EmailOctopus and execute queries in PowerBuilder.
-
LINQ to Telegram 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 Telegram Data Provider.
-
Create Apps from Avro Data in Qlik Sense Cloud
Use CData Connect AI to connect to Avro Data and build apps from live Apache Avro in Qlik Sense Cloud.
-
How to connect to Close Data with Squirrel SQL client
Connect to Close and execute queries in the Squirrel SQL Client.
-
Automated Continuous FHIR Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable FHIR replication to OneLake in Microsoft Fabric.
-
Import and Visualize Act CRM Data in Power View
Create data visualizations based on Act CRM in Excel.
-
Getting Started with the CData Power BI Connector for Outreach.io
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Outreach.io.
-
Integrating LlamaIndex with Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Microsoft Office 365 in real time.
-
Access Live Google Spanner 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 Google Spanner through MCP integration.
-
Integrating Boomi Agentstudio with Azure Analysis Services Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Azure Analysis Services, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Strava Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Strava and work with Strava in your FileMaker applications.
-
Use the CData Software JDBC Driver for Amazon Athena in MicroStrategy Web
Connect to Amazon Athena in MicroStrategy Web using the CData Software JDBC Driver for Amazon Athena.
-
Create Data Visualizations in Cognos BI with SAP ByDesign Data
Access SAP Business ByDesign as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create FHIR Dataflows on PowerBI.com
Connect to the CData Power BI Connector for FHIR from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use Grok to Talk to Your Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your IBM Cloudant for you.
-
Integrating GitHub Copilot CLI with Hugging Face 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 Presto Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Presto replication to IBM DB2.
-
Updating a Column from Another Column with CData Drivers
Learn how to use SQL statements, such as the UPDATE statement, with CData Drivers to copy values from one column to another.
-
Visualize Live SFTP Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SFTP.
-
Create Typeform Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Typeform data access from reports, embedded analytics, and more.
-
Use the CData Software ODBC Driver for Zoho Inventory in SAS for Real-Time Reporting and Analytics
Connect to real-time Zoho Inventory in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zoho Inventory.
-
Query Google Translate Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Translate from Node.js.
-
Using the CData Software ODBC Driver for Workday in PyCharm
Connect to Workday as an ODBC data source in PyCharm using the CData Software ODBC Driver for Workday.
-
Automated Continuous IBM Cloud Object Storage Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Azure SQL Database.
-
Build Pipedrive-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Pipedrive Data and create custom apps in Mendix.
-
Build Data Flows from SQL Server to WordPress through SSIS
Easily push SQL Server data to WordPress using the CData SSIS Tasks for WordPress.
-
Integrate Cursor with Live Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Pivotal GreenPlum from within the editor.
-
Klipfolio Reporting in OBIEE with the Klipfolio JDBC Driver
Deploy the Klipfolio JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live Twilio Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Twilio for you.
-
Getting Started with the CData SSIS Components for Marketo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Marketo.