CData Software - Knowledge Base
Recent Articles
-
Natively Connect to Mouseflow Data in PHP
The CData ODBC driver for Mouseflow enables you to create PHP applications with connectivity to Mouseflow. Leverage the native support for ODBC in PHP.
-
Automated Wave Financial Data Replication to Teradata
Use CData Sync to Customize and automate Wave Financial replication to Teradata.
-
Automated Continuous Campaigner Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Campaigner replication to delimited files (CSV/TSV).
-
Analyze Instagram Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Instagram with the CData JDBC Driver for Instagram.
-
Connect ADP Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your ADP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automate Dynamics 365 Business Central Data Replication to Azure Synapse
Use CData Sync to customize and automate Dynamics 365 Business Central replication to Azure Synapse.
-
Operational Reporting on Elorus Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Elorus.
-
Connect to and Query Facebook Data in QlikView over ODBC
Create data visualizations with Facebook in QlikView.
-
Analyze Jira Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Atlassian Jira and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Oracle HCM Cloud Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Amazon Redshift.
-
Connect to SAP Netweaver Gateway Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP Netweaver Gateway Data and connect to SAP Netweaver Gateway in Akorbi Digital RunMyProcess.
-
Visualize Live Klipfolio Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Klipfolio using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData SSIS Components for ZohoExpense
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZohoExpense.
-
Import and Visualize ZohoPeople Data in Power View
Create data visualizations based on ZohoPeople in Excel.
-
How to Connect the Power BI Service to Cloudflare: Complete Guide
Connect to the CData Software Power BI Connector for Cloudflare from PowerBI.com to provide real-time Cloudflare across the organization.
-
Enable the HDFS JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache HDFS.
-
Build Dashboards with Miro Data in DBxtra
Create dynamic dashboards and perform analytics based on Miro in DBxtra.
-
Integrating Cursor CLI with FreeAgent 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.
-
Work with SAP HANA Data in FoxPro
Load SAP HANA into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to QuickBooks Time Data in Jaspersoft Studio
Execute SQL to remote QuickBooks Time in Jaspersoft Studio.
-
Connect to Retently from a Connection Pool in WebLogic
Use the CData JDBC Driver for Retently to connect to Retently from Web applications running on WebLogic.
-
Automated Continuous Cloudant Replication to Snowflake
Use CData Sync for automated, continuous, customizable Cloudant replication to Snowflake.
-
Connect to FreshBooks Data as an External Source in Dremio
Use the CData JDBC Driver to connect to FreshBooks as an External Source in Dremio.
-
Connect to Google Ad Manager Data in Claris FileMaker Pro
Use the CData ODBC Driver for Google Ad Manager in FileMaker Pro to connect to Google Ad Manager and work with Google Ad Manager in your FileMaker applications.
-
Connect to Vault CRM Data in Aqua Data Studio
Access Veeva Vault & Vault CRM from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Creating Highrise-Connected Applications in Unqork
You can use CData Connect AI to feed Highrise CRM to Unqork and build custom business apps.
-
How to Create Power BI Visual Reports with Real-Time HubSpot Data
Use CData Power BI Connectors to visualize HubSpot in Power BI.
-
Integrating Dataiku with PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live PayPal.
-
Create SSAS Tabular Models from Gumroad Data
How to build a SQL Server Analysis Service Tabular Model from Gumroad using CData drivers.
-
Automated Continuous Vault CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Vault CRM replication to IBM DB2.
-
Use ChatGPT to Talk to Your JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your JSON for you.
-
Integrate with live Facebook Data in Jitterbit
Use CData Connect AI to connect to and integrate live Facebook in Jitterbit.
-
How to Import Data from Sage Cloud Accounting into Google Sheets
Import Sage Business Cloud Accounting into a Google spreadsheet that is automatically refreshed.
-
Automate CouchDB Data Replication to Azure Synapse
Use CData Sync to customize and automate Apache CouchDB replication to Azure Synapse.
-
How to connect and process Amazon S3 from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Amazon S3.
-
Consume LinkedIn Ads OData Feeds in PowerBuilder
This article demonstrates how to consume LinkedIn Ads as OData feeds from PowerBuilder using the API Server.
-
Replicate Greenhouse Data in Heroku for Use in Salesforce Connect
Replicate Greenhouse to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Cursor with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Elasticsearch from within the editor.
-
Connect to PabblySubscriptions Data from PowerBuilder via ADO.NET
This article demonstrates how to access PabblySubscriptions from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect SpaceX Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SpaceX using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Perplexity Data in Aqua Data Studio
Access Perplexity from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Splunk Data from AWS Glue
Use CData Connect AI to gain access to live Splunk from your AWS Glue jobs.
-
How to connect to SageHR Data from IntelliJ
Integrate connectivity to SageHR with wizards in IntelliJ.
-
Automate Salesforce Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Salesforce & Force.com from PowerShell? This article demonstrates how to utilize the Salesforce Cmdlets for tasks like connecting to Salesforce & Force.com, automating operations, downloading data, and more.
-
Automate Onfleet Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Onfleet from PowerShell? This article demonstrates how to utilize the Onfleet Cmdlets for tasks like connecting to Onfleet, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for CircleCI in MicroStrategy Web
Connect to CircleCI in MicroStrategy Web using the CData Software JDBC Driver for CircleCI.
-
Create Snapchat Ads-Connected Applications in Appsmith
Connect to Snapchat Ads Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Snapchat Ads.
-
Integrating Cursor CLI with MYOB AccountRight 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.
-
Publish Apify-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apify.
-
Build Data Flows from Facebook to SQL Server using SSIS
Easily back up Facebook to SQL Server using the SSIS components for Facebook.
-
Connect to Epicor Kinetic Data in ACL Analytics
Connect to Epicor Kinetic via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Epicor Kinetic.
-
Enable the Retently JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Retently.
-
Automated Continuous Google Spanner Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Spanner replication to MongoDB.
-
Automated Continuous Instagram Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Instagram replication to Google Cloud SQL.
-
Query Exact Online Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Exact Online from Node.js.
-
Connect to PivotalTracker Data in JRuby
Create a simple JRuby app with access to live PivotalTracker.
-
Connect to Cassandra from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apache Cassandra, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Connect to & Open Scrapfly Data in Microsoft Excel
This article uses the CData ODBC driver for Scrapfly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Configure the CData JDBC Driver for Oracle Service Cloud in a Connection Pool in Tomcat
Connect to Oracle Service Cloud from a connection pool in Tomcat.
-
Deploy the ADO.NET Provider for Redis on an SSRS Report Server
Connect to Redis 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.
-
Visualize BenchmarkEmail Data in Tableau
The CData ODBC driver for BenchmarkEmail enables you integrate BenchmarkEmail into Tableau dashboards.
-
Build Dashboards with Splunk Data in Dundas BI
Create dynamic dashboards and perform analytics based on Splunk in Dundas BI.
-
Feed IBM Informix Data into FineReport
How to set IBM Informix as a JDBC data source in FineReport.
-
Query Freshsales Data in ColdFusion
Write standard ColdFusion data access code to connect to Freshsales.
-
Publish Crystal Reports on Missive Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Missive.
-
Extract, Transform, and Load Sugar CRM Data in Informatica PowerCenter
Create a simple Workflow for Sugar CRM in Informatica PowerCenter.
-
Integrating Cursor CLI with SAS Data Sets 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.
-
Connect to SQL Server Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SQL Server Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Work with Gong Data in AWS Glue Jobs Using JDBC
Connect to Gong from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to LinkedIn Ads Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to LinkedIn Ads. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to SAP HANA XS Advanced Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP HANA XS Advanced. Leverage the pyodbc module for ODBC in Python.
-
Use the CData Software JDBC Driver for Azure Data Lake Storage in MicroStrategy
Connect to Azure Data Lake Storage in MicroStrategy Developer using the CData Software JDBC Driver for Azure Data Lake Storage.
-
DataBind Charts to ScrapingBee Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ScrapingBee 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.
-
Connect to Microsoft Dataverse Data in CloverDX (formerly CloverETL)
Transfer Microsoft Dataverse (CDS) using the visual workflow in the CloverDX data integration tool.
-
Automate Oracle Eloqua Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Oracle Eloqua from PowerShell? This article demonstrates how to utilize the Oracle Eloqua Cmdlets for tasks like connecting to Oracle Eloqua, automating operations, downloading data, and more.
-
Connect to Act CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Act CRM from PowerBuilder using the Act CRM JDBC Driver.
-
Use CData Connect AI to Access NetSuite Data in Microsoft Power Pivot
Use CData Connect AI to connect to live NetSuite CRM & ERP in the Power Pivot business intelligence tool.
-
Connect Microsoft Dataverse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Microsoft Dataverse with IBM WebSphere for seamless data integration and connectivity.
-
Connect to and Query CloudConvert Data in QlikView over ODBC
Create data visualizations with CloudConvert in QlikView.
-
How to connect to Mouseflow Data with Squirrel SQL client
Connect to Mouseflow and execute queries in the Squirrel SQL Client.
-
Prepare, Blend, and Analyze Campaigner Data in Alteryx Designer (ODBC)
Build workflows to access live Campaigner for self-service data analytics.
-
Build Data Flows from SQL Server to Lakebase through SSIS
Easily push SQL Server data to Lakebase using the CData SSIS Tasks for Lakebase.
-
Access Live Google Sheets Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Sheets from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Automated Workflows with Live SAP Ariba Source Data in Workato
Use CData Connect AI to connect to live SAP Ariba Source and build automated workflows in Workato.
-
Create Datasets from ServiceDesk Plus in Domo Workbench and Build Visualizations of ServiceDesk Plus Data in Domo
Use the CData Software ODBC Driver for ServiceDesk Plus to create datasets from ServiceDesk Plus in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Elorus with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Elorus with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Elorus.
-
Automated Continuous PagerDuty Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable PagerDuty replication to OneLake in Microsoft Fabric.
-
Connect to Mocean from a Connection Pool in WebLogic
Use the CData JDBC Driver for Mocean to connect to Mocean from Web applications running on WebLogic.
-
Build Pipedrive-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Pipedrive Data from Zoho Analytics and import live Pipedrive.
-
Build Phoenix-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Phoenix Data and create custom apps in Bubble.
-
How to Visualize ZohoSubscriptions Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoSubscriptions in Python.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Okta to Power BI dashboards. Simply drag and drop Okta into data visuals on the Power BI canvas.
-
Use the CData Software JDBC Driver for Salesforce Marketing in MicroStrategy
Connect to Salesforce Marketing Cloud in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce Marketing.
-
Visualize Live NetSuite Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live NetSuite CRM & ERP using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze FHIR Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for FHIR from Power Pivot. You will use the Table Import Wizard to load FHIR. You can visually build the import query or use any SQL supported by the driver.
-
Connect to and Visualize Live Paylocity Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Paylocity.
-
Connect to FTP Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with FTP Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect Flowise AI Agents to Live MarkLogic Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live MarkLogic without replication.
-
Use the CData ODBC Driver for Confluence from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Confluence to connect to Atlassian Confluence from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Atlassian Confluence in Excel.
-
Connect to FormSite Data in Aqua Data Studio
Access FormSite from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.