CData Software - Knowledge Base
Recent Articles
-
Building Dynamic Web Pages with Box Data Using AngularJS
Create single-page applications with live connectivity to Box using the CData API Server.
-
Automated Continuous Notion Replication to Databricks
Use CData Sync for automated, continuous, customizable Notion replication to Databricks.
-
Prepare, Blend, and Analyze SAS xpt Data in Alteryx Designer (Connect AI)
Build workflows to access live SAS XPORT for self-service data analytics.
-
Enable the ChargeOver JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ChargeOver.
-
Use the CData ODBC Driver for Bullhorn CRM in Microsoft Power Query
You can use the CData Bullhorn CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Bullhorn CRM into Microsoft Power Query.
-
Create Google Ads-Connected Dashboards in Grafana
Connect to Google Ads Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Ads.
-
Connect Microsoft Exchange Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Exchange using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate with Rootly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Rootly to a JSON file on disk.
-
Automated Continuous Teamgate Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Teamgate replication to Apache Kafka.
-
Connecting Moonlit Workflow with Snapchat Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Snapchat Ads in real time.
-
Create Reports with Xero Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Xero Accounting.
-
Integrating Antigravity CLI with Spotify via CData CLI
Connect Spotify to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Google Analytics Data Replication to Teradata
Use CData Sync to Customize and automate Google Analytics replication to Teradata.
-
Connecting Moonlit Workflow with Reckon Accounts Hosted Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Reckon Accounts Hosted in real time.
-
How to Connect the Power BI Service to ZohoPeople: Complete Guide
Connect to the CData Software Power BI Connector for ZohoPeople from PowerBI.com to provide real-time ZohoPeople across the organization.
-
Import Amazon Athena Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Amazon Athena. In this article, you will use the OData format to import Amazon Athena into Microsoft Power Query.
-
Object-Relational Mapping (ORM) with Postmark Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Postmark into a Java-based ORM framework, Hibernate.
-
How to Connect to Live Splunk Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Splunk without replication.
-
Connect BigQuery to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect BigQuery with IBM WebSphere for seamless data integration and connectivity.
-
Add Sybase IQ Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sybase IQ with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use JayDeBeApi to access Hubstaff Data in Python
Use standard Python scripting and the development environment of your choice to access live Hubstaff.
-
Access Live Shortcut Data in AWS Lambda
Connect to live Shortcut in AWS Lambda using the CData JDBC Driver.
-
Query Spotify Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Spotify from Node.js.
-
Use Microsoft Copilot Studio to talk to your Oracle Service Cloud 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 Oracle Service Cloud for you.
-
Connect to Zoho Inventory from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoho Inventory, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Google Analytics Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Analytics replication to Amazon S3.
-
Visualize Vimeo Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Vimeo into TIBCO Spotfire.
-
Configure the CData JDBC Driver for Parallel in a Connection Pool in Tomcat
Connect to Parallel from a connection pool in Tomcat.
-
Write a Simple Go Application to work with Tally Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Tally ERP.
-
Connect to Airtable Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Airtable using standard SQL.
-
Use the CData Software ODBC Driver for Trello in MicroStrategy Web
Connect to Trello in MicroStrategy Web using the CData Software ODBC Driver for Trello.
-
Visualize Live Lakebase Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Lakebase into custom reports in Power BI.
-
Build Agents in Relevance AI with Access to Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on BambooHR within intelligent agent workflows.
-
Access Live Optimizely Data in AWS Lambda
Connect to live Optimizely in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Airtable in MicroStrategy Web
Connect to Airtable in MicroStrategy Web using the CData Software ODBC Driver for Airtable.
-
Integrate with Opsgenie Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Opsgenie to a JSON file on disk.
-
Connect to Templated Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Templated using standard SQL.
-
How to import AfterShip Data into Apache Solr
Use the CData Software JDBC Driver for AfterShip in Data Import Handler and create an automated import of AfterShip to Apache Solr Enterprise Search platform.
-
Connect and Query Live PostgreSQL Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live PostgreSQL into Databricks
-
How to Work with SendPulse Data in AWS Glue Jobs Using JDBC
Connect to SendPulse from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect to ZeroBounce Data in DBVisualizer
Integrate ZeroBounce with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Claude to Talk to Your Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Twitter Ads for you.
-
Access Workable Data from MySQL in PHP
Connect to Workable through the standard MySQL libraries in PHP.
-
Bridge ZohoSubscriptions Connectivity with Apache NiFi
Access and process ZohoSubscriptions in Apache NiFi using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Contentful in a Connection Pool in Tomcat
Connect to Contentful from a connection pool in Tomcat.
-
Connect to Short.io Data in NetBeans
Connect to Short.io in NetBeans with the data source configuration wizard.
-
Create Freshdesk Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Freshdesk from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Charts with AfterShip Data in Clear Analytics
Create dynamic charts and perform analytics based on AfterShip in Clear Analytics.
-
Create SSAS Tabular Models from Billsby Data
How to build a SQL Server Analysis Service Tabular Model from Billsby using CData drivers.
-
Migrating data from Reply.io to Snowflake using CData SSIS Components.
Easily push Reply.io to Snowflake using the CData SSIS Tasks for Reply.io and Snowflake.
-
Create Datasets from MarkLogic in Domo Workbench and Build Visualizations of MarkLogic Data in Domo
Use the CData Software ODBC Driver for MarkLogic to create datasets from MarkLogic in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Twitter Ads Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Twitter Ads replication to PostgreSQL.
-
Create Data Visualizations in Cognos BI with Moosend Data
Access Moosend as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Prepare, Blend, and Analyze SQL Analysis Services Data in Alteryx Designer (ODBC)
Build workflows to access live SQL Analysis Services for self-service data analytics.
-
Build Charts with LeadDesk Data in Clear Analytics
Create dynamic charts and perform analytics based on LeadDesk in Clear Analytics.
-
Integrate Live Vault CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Vault CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Veeva Vault & Vault CRM.
-
Automated Continuous Sage Intacct Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Snowflake.
-
How to connect PolyBase to Microsoft OneDrive
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft OneDrive.
-
Integrate Live Zendesk Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zendesk to Blue Prism using the CData ODBC Driver for Zendesk to create automated workflows for repetitive business tasks.
-
Integrate Couchbase Data in the Pentaho Report Designer
Publish reports based on Couchbase in the Pentaho BI tool.
-
Create Informatica Mappings From/To a JDBC Data Source for ConvertKit
Create ConvertKit data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Reports with Auth0 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Auth0.
-
Integrate Strava Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Strava from Informatica Cloud.
-
Query LinkedIn Ads Data in ColdFusion
Write standard ColdFusion data access code to connect to LinkedIn Ads.
-
Prepare, Blend, and Analyze AlloyDB Data in Alteryx Designer (ODBC)
Build workflows to access live Google AlloyDB for self-service data analytics.
-
Replicate CockroachDB Data from PowerShell
Write a quick PowerShell script to query CockroachDB. Use connectivity to the live data to replicate CockroachDB to SQL Server.
-
Integrate SendInBlue Data in Pentaho Data Integration
Build ETL pipelines based on SendInBlue in the Pentaho Data Integration tool.
-
Build Automated Salesforce Marketing-Connected Workflows in Zapier
Use CData Connect AI to connect to live Salesforce Marketing Cloud and build automated workflows in Zapier.
-
Getting Started with the CData JDBC Driver for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Blackbaud FE NXT.
-
Migrating data from AlloyDB to Databricks using CData SSIS Components.
Easily push Google AlloyDB to Databricks using the CData SSIS Tasks for AlloyDB and Databricks.
-
Integrate with Templated Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Templated to a JSON file on disk.
-
Analyze Printful Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Printful from Power Pivot. You will use the Table Import Wizard to load Printful. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Python Connector for Scrapfly
Learn to install and license the CData Python Connector
-
Analyze Live Greenhouse Data in SAS Viya
Use CData Connect AI to connect to Greenhouse from SAS Viya and deploy self-service analytics using live Greenhouse.
-
Build Pipelines with Live SAP Ariba Source Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP Ariba Source from Google Cloud Data Fusion, enabling the integration of live SAP Ariba Source into the building and management of effective data pipelines.
-
Visualize CircleCI Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to CircleCI.
-
Bridge LDAP Connectivity with Apache NiFi
Access and process LDAP in Apache NiFi using the CData JDBC Driver.
-
Integrating LangChain with Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Quickbase within automated workflows.
-
Use Biml to Build SSIS Tasks to Replicate ChargeOver Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ChargeOver to SQL Server.
-
Back Up Rootly 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 Rootly data.
-
Stream Snapchat Ads Data into Apache Kafka Topics
Access and stream Snapchat Ads in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to PagerDuty Data in RazorSQL
Connect to PagerDuty from wizards and query PagerDuty from the GUI in the RazorSQL database management tool.
-
Create Datasets from Onfleet in Domo Workbench and Build Visualizations of Onfleet Data in Domo
Use the CData Software ODBC Driver for Onfleet to create datasets from Onfleet in Domo Workbench and then build visualizations in the Domo service.
-
Connect to MailerLite Data in Jaspersoft Studio
Execute SQL to remote MailerLite in Jaspersoft Studio.
-
Connect to Real-Time Procore Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Procore in Power Apps.
-
Visualize Live Redshift Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Amazon Redshift using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to work with Zoho Creator Data in Apache Spark using SQL
Access and process Zoho Creator Data in Apache Spark using the CData Software JDBC Driver.
-
Build AI/ML Models with Live Tavily Data using Dataiku
Connect Tavily Data with Dataiku using the CData API Driver for JDBC.
-
Back Up Google Campaign Manager 360 to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Campaign Manager 360. In this article, we will employ an SSIS workflow to populate a database with Google Campaign Manager 360 data.
-
Back Up Planio 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 Planio data.
-
View Reports on Real-Time Salesforce Pardot Data in Power BI Report Server
Use the CData ODBC Driver for Salesforce Pardot to visualize Salesforce Pardot in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Webex Data in DBeaver
Use the CData ODBC Driver to connect to Webex in DBeaver.
-
Use the CData Software JDBC Driver for Monday.com in MicroStrategy Web
Connect to Monday.com in MicroStrategy Web using the CData Software JDBC Driver for Monday.com.
-
Query Microsoft Teams Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Teams from Node.js.
-
How to Seamlessly Import SendInBlue Data into IBM SPSS Modeler
Integrate SendInBlue data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use Azure AI Foundry to Talk to Your Gong Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Gong for you.
-
How to Connect Flowise AI Agents to Live SAP Ariba Source 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 SAP Ariba Source without replication.
-
How to Access Timely Data Using Entity Framework
This article shows how to access Timely using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect to Paymo Data with Squirrel SQL client
Connect to Paymo and execute queries in the Squirrel SQL Client.
-
Use Dash to Build to Web Apps on FormSite Data
Create Python applications that use pandas and Dash to build FormSite-connected web apps.