CData Software - Knowledge Base
Recent Articles
-
Validate Act CRM Data with QuerySurge
Access and validate Act CRM in QuerySurge using the CData JDBC Driver.
-
Build Charts with SAP Business One Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Business One in Clear Analytics.
-
Integrate Pipedrive Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pipedrive from Informatica Cloud.
-
Deploy the ADO.NET Provider for Browserless on an SSRS Report Server
Connect to Browserless 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.
-
Connecting Agentforce with Power BI XMLA Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Power BI XMLA for you.
-
Automated Continuous Microsoft OneLake Replication to SQL Server
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to SQL Server.
-
Migrating data from MarkLogic to Snowflake using CData SSIS Components.
Easily push MarkLogic to Snowflake using the CData SSIS Tasks for MarkLogic and Snowflake.
-
Choosing the Best Method to Connect Webflow to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Webflow from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Deploy the ADO.NET Provider for Google Ads on an SSRS Report Server
Connect to Google Ads 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.
-
DataBind Freshdesk Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Freshdesk with the DevExpress Windows Forms and Web controls to provide Freshdesk to a chart.
-
How to connect PolyBase to Google Campaign Manager 360
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Campaign Manager 360.
-
How to Import Data from Google Contacts into Google Sheets
Import Google Contacts into a Google spreadsheet that is automatically refreshed.
-
Consume SAS xpt OData Feeds in PowerBuilder
This article demonstrates how to consume SAS XPORT as OData feeds from PowerBuilder using the API Server.
-
Use Dash to Build to Web Apps on Zoho Inventory Data
Create Python applications that use pandas and Dash to build Zoho Inventory-connected web apps.
-
Choosing the Best Method to Connect Dynamics NAV to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Dynamics NAV from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Establish a Live Connection with XML Data using Tableau Bridge
The CData ODBC Driver for XML enables you to integrate live XML Files into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Quickbase Data in Ruby
Connect to Quickbase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
DataBind Controls to Cloudant Data in C++Builder
DataBind to IBM Cloudant in C++Builder with standard components and controls.
-
Use Microsoft Copilot Studio to talk to your Confluence 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 Atlassian Confluence for you.
-
Add Greenplum Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Greenplum with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to create Visio diagrams from Klaviyo Data
Automatically update Klaviyo with the changes you make to Visio master shapes.
-
ETL ChartMogul in Oracle Data Integrator
This article shows how to transfer ChartMogul into a data warehouse using Oracle Data Integrator.
-
Migrating data from QuickBooks Time to Databricks using CData SSIS Components.
Easily push QuickBooks Time to Databricks using the CData SSIS Tasks for QuickBooks Time and Databricks.
-
Automate Reckon Accounts Hosted Data Replication to Azure Data Lake
Use CData Sync to customize and automate Reckon Accounts Hosted replication to Azure Data Lake.
-
Bridge Helpscout Connectivity with Apache NiFi
Access and process Helpscout in Apache NiFi using the CData JDBC Driver.
-
Integrate with Office 365 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Office 365 to a JSON file on disk.
-
Validate Unbounce Data with QuerySurge
Access and validate Unbounce in QuerySurge using the CData JDBC Driver.
-
Build Dashboards with PostgreSQL Data in Dundas BI
Create dynamic dashboards and perform analytics based on PostgreSQL in Dundas BI.
-
Automated Continuous Elasticsearch Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Amazon S3.
-
Rapidly Develop SharePoint Excel Services-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by SharePoint Excel Services.
-
Connect HCL Domino to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HCL Domino with IBM WebSphere for seamless data integration and connectivity.
-
Build a PostgreSQL Interface for Clio Data using the CData JDBC Driver
Use the Remoting features of the Clio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Creating IBM Cloud Object Storage-Connected Applications in Unqork
You can use CData Connect AI to feed IBM Cloud Object Storage to Unqork and build custom business apps.
-
How to integrate ClickTime with Apache Airflow
Access and process ClickTime in Apache Airflow using the CData JDBC Driver.
-
Connect Reckon Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Reckon using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Parquet Data in Jaspersoft Studio
Execute SQL to remote Apache Parquet in Jaspersoft Studio.
-
How to update Amazon Athena from Excel
This article explains how to transfer data from Excel to Amazon Athena using the Excel Add-In for Amazon Athena.
-
Build Avro-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Apache Avro and build Avro-connected web apps with Axios.
-
Query Dynamics CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft Dynamics CRM from Node.js.
-
Integrate SingleStore with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SingleStore with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SingleStore.
-
Use the CData ODBC Driver for Vault CRM in Microsoft Power Query
You can use the CData Vault CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Veeva Vault & Vault CRM into Microsoft Power Query.
-
Connect to Airtable Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Airtable and the SQL Gateway to access Airtable from Google Apps Script.
-
Automate SAP ByDesign Data Replication to Couchbase
Use CData Sync to Customize and automate SAP Business ByDesign replication to Couchbase.
-
Easily Integrate IBM Informix Data in Lazarus Pascal IDE
Learn how to easily integrate live IBM Informix in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create SSAS Tabular Models from Power BI XMLA Data
How to build a SQL Server Analysis Service Tabular Model from Power BI XMLA using CData drivers.
-
Visualize Live IBM Cloud Object Storage Data in the Power BI Service
Use CData Connect AI to connect to live IBM Cloud Object Storage and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to OData Services in Jaspersoft Studio
Execute SQL to remote OData in Jaspersoft Studio.
-
Connect to Blackbaud FE NXT Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Blackbaud FE NXT.
-
Automated Continuous SAP HANA Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP HANA replication to SQLite.
-
Integrating Kiro CLI with IBM Informix 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.
-
Integrating Cvent Data in Talend Cloud Data Management Platform
Connect Cvent Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Cvent.
-
Integrate ActiveCampaign Data in Pentaho Data Integration
Build ETL pipelines based on ActiveCampaign in the Pentaho Data Integration tool.
-
Natively Connect to Testmonitor Data in PHP
The CData ODBC driver for Testmonitor enables you to create PHP applications with connectivity to Testmonitor. Leverage the native support for ODBC in PHP.
-
How to Visualize Front Data in Python with pandas
Use pandas and other modules to analyze and visualize live Front in Python.
-
How to Connect SAS Data Sets 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 SAS Data Sets data in real time using natural language.
-
Use the CData ODBC Driver for LaunchDarkly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LaunchDarkly to connect to LaunchDarkly from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LaunchDarkly in Excel.
-
Access Live Copper Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Copper in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to work with Gumroad Data in Apache Spark using SQL
Access and process Gumroad Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Zoho CRM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho CRM in FileMaker Pro to connect to Zoho CRM and work with Zoho CRM in your FileMaker applications.
-
Create a Data Access Object for CockroachDB Data using JDBI
A brief overview of creating a SQL Object API for CockroachDB in JDBI.
-
Publish Tally-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Tally ERP.
-
Connect to Bugsnag Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect Amazon QuickSight to Salesforce Marketing Data
Create a connection to Salesforce Marketing Cloud in CData Connect AI and insert Salesforce Marketing Cloud into Amazon QuickSight SPICE to build interactive dashboards.
-
How to work with Hubstaff Data in Apache Spark using SQL
Access and process Hubstaff Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Twilio Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Twilio data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Informatica Mappings From/To an ODBC Data Source for QuickBooks Time
Create an ODBC connection to QuickBooks Time in Informatica and browse and transfer QuickBooks Time.
-
Natively Connect to Vercel Data in PHP
The CData ODBC driver for Vercel enables you to create PHP applications with connectivity to Vercel. Leverage the native support for ODBC in PHP.
-
Work with Autopilot Data in FoxPro
Load Autopilot into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live LinkedIn within intelligent workflows.
-
Build Data Flows from REST to SQL Server using SSIS
Easily back up REST to SQL Server using the SSIS components for REST.
-
Connect to ClickUp Data in RazorSQL
Connect to ClickUp from wizards and query ClickUp from the GUI in the RazorSQL database management tool.
-
Connect to Azure Analysis Services Data from a Connection Pool in JBoss
Integrate Azure Analysis Services into Java servlets: Use the Management Console in JBoss to install the Azure Analysis Services JDBC Driver.
-
Replicate Google Forms Data in Heroku for Use in Salesforce Connect
Replicate Google Forms to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PDFMonkey
Provide connectivity to PDFMonkey through an SAP BusinessObjects universe.
-
ETL Tavily in Oracle Data Integrator
This article shows how to transfer Tavily into a data warehouse using Oracle Data Integrator.
-
Connect to and Query Box Data in QlikView over ODBC
Create data visualizations with Box in QlikView.
-
Connect to Raisers Edge NXT Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Raisers Edge NXT in the Denodo Virtual DataPort Administrator.
-
How to connect to Amazon Athena Data in DBVisualizer
Integrate Amazon Athena with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to CloudConvert Data with Squirrel SQL client
Connect to CloudConvert and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData SSIS Components for Salesforce Data 360
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Salesforce Data 360.
-
How to Work with DocuSign Data in AWS Glue Jobs Using JDBC
Connect to DocuSign from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to QuickBooks Time in SpagoBI
Create reports featuring live QuickBooks Time in SpagoBI Studio. Host QuickBooks Time reports on SpagoBI Server.
-
Connect to Tally Data in Google Apps Script via Connect AI
Use CData Connect AI to access Tally ERP in Google Apps Script.
-
Use CData Connect AI to Access FTP Data in Microsoft Power Pivot
Use CData Connect AI to connect to live FTP Servers in the Power Pivot business intelligence tool.
-
How to Connect the Power BI Service to WooCommerce: Complete Guide
Connect to the CData Software Power BI Connector for WooCommerce from PowerBI.com to provide real-time WooCommerce across the organization.
-
Automate Eventbrite Data Replication to Couchbase
Use CData Sync to Customize and automate Eventbrite replication to Couchbase.
-
Connect to Oracle HCM Cloud from Asprova with CData Software ODBC Driver for Oracle HCM Cloud
This article shows how to connect faster to Oracle HCM Cloud data from Asprova.
-
Automated Continuous Neo4J Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Neo4J replication to Google BigQuery.
-
Create Datasets from Outreach.io in Domo Workbench and Build Visualizations of Outreach.io Data in Domo
Use the CData Software ODBC Driver for Outreach.io to create datasets from Outreach.io in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Freshservice Data in DBeaver
Use the CData ODBC Driver to connect to Freshservice in DBeaver.
-
Replicate Insightly Data to Multiple Databases via the CData Sync CLI
Replicate Insightly to disparate databases with a single configuration.
-
Import Odoo Data Using Azure Data Factory
Use CData Connect AI to connect to Odoo Data from Azure Data Factory and import live Odoo ERP.
-
Build AI/ML Models with Live Zoho Projects Data using Dataiku
Connect Zoho Projects Data with Dataiku using the CData JDBC Driver for Zoho Projects.
-
Use the CData Software ODBC Driver for Parquet in MicroStrategy
Connect to Apache Parquet in MicroStrategy Developer using the CData Software ODBC Driver for Parquet.
-
Consume XML OData Feeds in PowerBuilder
This article demonstrates how to consume XML Files as OData feeds from PowerBuilder using the API Server.
-
How to publish and share Grafana Data dashboards with Tableau Server
The CData ODBC driver for Grafana enables you integrate Grafana into Tableau dashboards.
-
Connect to Google Ad Manager Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Ad Manager in the Denodo Virtual DataPort Administrator.
-
How to Connect to Live NetSuite 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 NetSuite CRM & ERP for you.
-
Creating Couchbase-Connected Applications in Unqork
You can use CData Connect AI to feed Couchbase to Unqork and build custom business apps.
-
How to Work with Vault CRM Data in ETL Validator JDBC
Connect to Vault CRM from ETL Validator jobs using the CData Software JDBC Driver.