CData Software - Knowledge Base
Recent Articles
-
Create Apps from Sybase IQ Data in Qlik Sense Cloud
Use CData Connect AI to connect to Sybase IQ Data and build apps from live Sybase IQ in Qlik Sense Cloud.
-
DataBind Controls to Oracle SCM Data in C++Builder
DataBind to Oracle SCM in C++Builder with standard components and controls.
-
How to Connect to & Open FormSite Data in Microsoft Excel
This article uses the CData ODBC driver for FormSite to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Datasets from CapsuleCRM in Domo Workbench and Build Visualizations of CapsuleCRM Data in Domo
Use the CData Software ODBC Driver for CapsuleCRM to create datasets from CapsuleCRM in Domo Workbench and then build visualizations in the Domo service.
-
Create SAS Data Sets-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAS Data Sets Data from OutSystems and build custom enterprise apps using live SAS Data Sets.
-
Access Live Drift Data in Coginiti Pro
Connect to and query live Drift from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Datasets from Factorial in Domo Workbench and Build Visualizations of Factorial Data in Domo
Use the CData Software ODBC Driver for Factorial to create datasets from Factorial in Domo Workbench and then build visualizations in the Domo service.
-
Connect to PolarTeamPro Data in RapidMiner
Integrate PolarTeamPro with standard components and data source configuration wizards in RapidMiner Studio.
-
Provide OData Services of Attio Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Attio by developing a WCF Service Application.
-
Bind Live Paylocity Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Paylocity data
-
Access Live Cvent Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Cvent from your Excel spreadsheets.
-
Integrate Live Okta Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Okta and integrate live Okta into apps built in Microsoft Power Apps.
-
Connect PabblySubscriptions to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PabblySubscriptions with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Google Cloud Storage Data into Power Automate Desktop using CData Connect
CData Connect for Google Cloud Storage Data enables you to integrate Google Cloud Storage into workflows built using Microsoft Power Automate Desktop.
-
Replicate ScrapingBee Data from PowerShell
Write a quick PowerShell script to query ScrapingBee. Use connectivity to the live data to replicate ScrapingBee to SQL Server.
-
Viewing Authorize.Net Data in RAD Studio Data Explorer
How to view Authorize.Net in RAD Studio Data Explorer using the CData ODBC Driver for Authorize.Net.
-
Automated Continuous SAP BusinessObjects BI Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to IBM DB2.
-
Create Power BI Reports on Real-Time Twilio Data
Use the CData ODBC Driver for Twilio to visualize Twilio in Power BI Desktop.
-
Access Live Elasticsearch 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 Elasticsearch through MCP integration.
-
Build Dashboards with Epicor Kinetic Data in DBxtra
Create dynamic dashboards and perform analytics based on Epicor Kinetic in DBxtra.
-
Analyze Azure DevOps Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Azure DevOps and visualize Azure DevOps in SAP Analytics Cloud.
-
Connect to Marketo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Marketo using standard SQL.
-
Automated Outreach.io Data Replication to Teradata
Use CData Sync to Customize and automate Outreach.io replication to Teradata.
-
Access Live Excel Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Excel in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze xBase Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of xBase and visualize live xBase in Infragistics Reveal.
-
How to use SQLAlchemy ORM to access Exact Online Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Exact Online.
-
Explore Geographical Relationships in AgileCRM Data with Power Map
Create data visualizations with AgileCRM in Power Map.
-
Load ZohoDesk Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoDesk to a database.
-
Automated Continuous Calendly Replication to Databricks
Use CData Sync for automated, continuous, customizable Calendly replication to Databricks.
-
Create a Data Access Object for Insightly Data using JDBI
A brief overview of creating a SQL Object API for Insightly in JDBI.
-
Automate Pipeliner CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Pipeliner CRM replication to SAP HANA.
-
Create Avalara AvaTax-Connected Nintex Workflows
Use CData Connect AI to connect to Avalara AvaTax Data from Nintex Workflow Cloud and build custom workflows using live Avalara AvaTax.
-
Back Up Testmonitor 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 Testmonitor data.
-
Access Live Odoo Data in AWS Lambda
Connect to live Odoo ERP in AWS Lambda using the CData JDBC Driver.
-
Integrate LibreChat with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Monday.com from within the chat interface.
-
DataBind Controls to ChargeOver Data in Delphi
DataBind to ChargeOver in Delphi with standard data access components and controls.
-
Connect to CloudConvert Data from a Connection Pool in JBoss
Integrate CloudConvert into Java servlets: Use the Management Console in JBoss to install the CloudConvert JDBC Driver.
-
How to Query Superchat Data in MySQL Workbench
Execute MySQL queries against live Superchat from MySQL Workbench.
-
Build Dashboards with Azure Data Lake Storage Data in Dundas BI
Create dynamic dashboards and perform analytics based on Azure Data Lake Storage in Dundas BI.
-
Connect to Instagram Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Instagram in Airbyte.
-
Build Automated MySQL-Connected Workflows in Zapier
Use CData Connect AI to connect to live MySQL and build automated workflows in Zapier.
-
How to Connect Paylocity 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 Paylocity data in real time using natural language.
-
How to work with ShipEngine Data in Apache Spark using SQL
Access and process ShipEngine Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous LaunchDarkly Replication to AlloyDB
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to AlloyDB.
-
Automated Continuous SendInBlue Replication to Oracle
Use CData Sync for automated, continuous, customizable SendInBlue replication to Oracle.
-
Connect to Retently Data in CloverDX (formerly CloverETL)
Transfer Retently using the visual workflow in the CloverDX data integration tool.
-
Build Semantic Layer Views for Google Search Results in APOS Live Data Gateway
Use the CData Connector for Google Search in APOS Live Data Gateway to build Semantic Layer Views for Google Search.
-
Getting Started with the CData JDBC Driver for ADP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ADP.
-
Visualize Live Suadeo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Suadeo.
-
Building Dynamic Web Pages with HubSpot Data Using AngularJS
Create single-page applications with live connectivity to HubSpot using the CData API Server.
-
Getting Started with the CData Tableau Connector for Act CRM
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Act CRM.
-
Build Apps with Live PayPal in Adalo using CData Connect AI
Use CData Connect AI to integrate live PayPal into the Adalo platform and build custom mobile and web applications with real-time PayPal.
-
Moving Data from Snapchat Ads to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Snapchat Ads data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to SAP Business Warehouse Data in Jaspersoft Studio
Execute SQL to remote SAP Business Warehouse in Jaspersoft Studio.
-
Bridge Snowflake Connectivity with Apache NiFi
Access and process Snowflake in Apache NiFi using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PDFMonkey
Provide connectivity to PDFMonkey through an SAP BusinessObjects universe.
-
Use Microsoft Copilot Studio to talk to your LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your LinkedIn for you.
-
Access Live Google Translate Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Translate into the statistical analysis tools available in SAS JMP. This article shows how to use Google Translate in the Graph Builder and Query Builder.
-
Build a Salesforce Integration with C# and MCP Server
Learn how to build a bidirectional Salesforce integration in C# using CData MCP Server with Cursor AI and the CData Salesforce ADO.NET Driver for complete CRUD operations.
-
Model Twilio Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Twilio, enabling the direct import of real-time Twilio.
-
How to Visualize Cohere Data in Python with pandas
Use pandas and other modules to analyze and visualize live Cohere in Python.
-
How to connect to ChartMogul Data from IntelliJ
Integrate connectivity to ChartMogul with wizards in IntelliJ.
-
Connect to and Query SAS Data Sets Data in QlikView over ODBC
Create data visualizations with SAS Data Sets in QlikView.
-
How to Work with BenchmarkEmail Data in AWS Glue Jobs Using JDBC
Connect to BenchmarkEmail from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build RSS-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live RSS Feeds.
-
Use the CData Software JDBC Driver for Kintone in MicroStrategy Desktop
Connect to Kintone in MicroStrategy Desktop using the CData Software JDBC Driver for Kintone.
-
Enable the Salesforce CRM Analytics JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesforce CRM Analytics.
-
Build Charts with Apollo Data in Clear Analytics
Create dynamic charts and perform analytics based on Apollo in Clear Analytics.
-
Import Google Cloud Storage Data Using Azure Data Factory
Use CData Connect AI to connect to Google Cloud Storage Data from Azure Data Factory and import live Google Cloud Storage.
-
How to Create Power BI Visual Reports with Real-Time GitHub Data
Use CData Power BI Connectors to visualize GitHub in Power BI.
-
A PostgreSQL Interface for Rootly Data using the CData ODBC Driver
Use the SQL Gateway and Rootly ODBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from ClickTime to Google BigQuery using CData SSIS Components.
Easily push ClickTime to Google BigQuery using the CData SSIS Tasks for ClickTime and Google BigQuery.
-
Use the CData ODBC Driver for Printify from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Printify to connect to Printify from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Printify in Excel.
-
Bidirectional Access to Instagram Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Instagram in Filemaker Pro for Mac or Windows.
-
Access SAS xpt Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SAS XPORT.
-
Connect to Aircall Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Aircall and work with Aircall in your FileMaker application.
-
Build AI/ML Models with Live Drift Data using Dataiku
Connect Drift Data with Dataiku using the CData API Driver for JDBC.
-
How to Connect AlloyDB 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 AlloyDB data in real time using natural language.
-
How to Design Oracle Service Cloud Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Oracle Service Cloud from mobile and tablet Power Apps.
-
Visualize Live Sage Cloud Accounting Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sage Business Cloud Accounting using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Google Search Results from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Search.
-
How to connect to OData Services with Squirrel SQL client
Connect to OData and execute queries in the Squirrel SQL Client.
-
Access Live Coinbase Data in AWS Lambda
Connect to live Coinbase in AWS Lambda using the CData JDBC Driver.
-
Connect to Jira Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Atlassian Jira from Filemaker Pro on Mac.
-
Getting Started with the CData Power BI Connector for Freshsales
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automate Email Data Replication to Couchbase
Use CData Sync to Customize and automate Email replication to Couchbase.
-
Automated Active Directory Data Replication to Teradata
Use CData Sync to Customize and automate Active Directory replication to Teradata.
-
Getting Started with the CData Tableau Connector for ZarMoney
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Retently Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Retently replication to Amazon S3.
-
Use the CData Software ODBC Driver for Nuclia in MicroStrategy Web
Connect to Nuclia in MicroStrategy Web using the CData Software ODBC Driver for Nuclia.
-
Automate Twitter Ads Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Twitter Ads and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Provide OData Services of Azure Synapse Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Azure Synapse by developing a WCF Service Application.
-
ETL Everhour in Oracle Data Integrator
This article shows how to transfer Everhour into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData SSIS Components for Gong
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Gong.
-
Analyze Access Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Access with the CData JDBC Driver for Access.
-
Getting Started with the CData Excel Add-In for Accelo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Accelo.
-
How to Connect to Live Splunk Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Splunk securely in real time.
-
Publish Reports with Azure Synapse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Synapse.
-
Automated Continuous FreshBooks Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable FreshBooks replication to OneLake in Microsoft Fabric.
-
How to work with RabbitMQ Data in Apache Spark using SQL
Access and process RabbitMQ Data in Apache Spark using the CData Software JDBC Driver.