CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Tableau Connector for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Fieldglass.
-
Automated Continuous Freshteam Replication to SQL Server
Use CData Sync for automated, continuous, customizable Freshteam replication to SQL Server.
-
Create Wave Financial Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Wave Financial data access from reports, embedded analytics, and more.
-
Object-Relational Mapping (ORM) with Aweber 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 Aweber data into a Java-based ORM framework, Hibernate.
-
How to create an RPA flow for OneNote Data in UiPath Studio
Use the OneNote ODBC Driver to create workflows that access real-time OneNote data without any coding.
-
Use the CData ODBC Driver for LinkedIn Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LinkedIn Ads to connect to LinkedIn Ads data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LinkedIn Ads data in Excel.
-
Import Real-Time WordPress Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use WordPress data in ColdFusion.
-
Connect to Bitbucket Data in RazorSQL
Connect to Bitbucket from wizards and query Bitbucket data from the GUI in the RazorSQL database management tool.
-
Stream Microsoft Planner Data into Apache Kafka Topics
Access and stream Microsoft Planner data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Oracle HCM Cloud Data in the Pentaho Report Designer
Publish reports based on Oracle HCM Cloud data in the Pentaho BI tool.
-
Getting Started with the CData Power BI Connector for Campaigner
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Outreach.io Replication to Vertica
Use CData Sync for automated, continuous, customizable Outreach.io replication to Vertica.
-
Add Ontraport Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Ontraport with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Phoenix Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Phoenix replication to delimited files (CSV/TSV).
-
Build Semantic Layer Views for Copper Data in APOS Live Data Gateway
Use the CData Connector for Copper in APOS Live Data Gateway to build Semantic Layer Views for Copper data.
-
Connect to Certinia from a Connection Pool in WebLogic
Use the CData JDBC Driver for Certinia to connect to Certinia data from Web applications running on WebLogic.
-
Create Power BI Reports on Real-Time ZohoPeople Data
Use the CData ODBC Driver for ZohoPeople to visualize ZohoPeople data in Power BI Desktop.
-
Automated Continuous Hubstaff Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Hubstaff replication to AlloyDB.
-
Build Semantic Layer Views for Apify Data in APOS Live Data Gateway
Use the CData Connector for Apify in APOS Live Data Gateway to build Semantic Layer Views for Apify data.
-
Integrate Power BI XMLA with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Power BI XMLA with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Power BI XMLA data.
-
A PostgreSQL Interface for Procore Data (MySQL Remoting via JDBC)
Use the Remoting features of the Procore JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Twitter Ads Replication to SingleStore
Use CData Sync for automated, continuous, customizable Twitter Ads replication to SingleStore.
-
Connect to Klipfolio Data in RapidMiner
Integrate Klipfolio data with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze Live NetSuite SuiteAnalytics Data in SAS Viya
Use CData Connect AI to connect to NetSuite SuiteAnalytics data from SAS Viya and deploy self-service analytics using live NetSuite SuiteAnalytics data.
-
Use JayDeBeApi to access Access Data in Python
Use standard Python scripting and the development environment of your choice to access live Access data.
-
Connect to AdRoll Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for AdRoll and the SQL Gateway to access AdRoll data from Google Apps Script.
-
Extract, Transform, and Load Notion Data in Informatica PowerCenter
Create a simple Workflow for Notion data in Informatica PowerCenter.
-
Build a Singer.io Tap for Slack With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Slack data using the CData Python Connector.
-
Edit and Search External GitHub Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of GitHub data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create GitHub Data objects that you can access from apps and the dashboard.
-
Publish Snapchat Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Snapchat Ads data.
-
Access Live Redshift Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Redshift data from your Excel spreadsheets.
-
Use Manus AI to Talk to Your Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Google Ads data.
-
Analyze Live Stripe Data in SAS Viya
Use CData Connect AI to connect to Stripe data from SAS Viya and deploy self-service analytics using live Stripe data.
-
Publish Microsoft OneDrive-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft OneDrive data.
-
Import GitLab Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to GitLab Data and provide access to live GitLab data for custom reports in the Power BI Service.
-
Create a Data Access Object for Sage 300 Data using JDBI
A brief overview of creating a SQL Object API for Sage 300 data in JDBI.
-
Query Demio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Demio data from Node.js.
-
How to connect PolyBase to HubSpot
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HubSpot data.
-
Connect SageHR to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SageHR data using the CData Python MCP Server.
-
Connect to Printful Data in RazorSQL
Connect to Printful from wizards and query Printful data from the GUI in the RazorSQL database management tool.
-
Extract, Transform, and Load QuickBooks Time Data in Informatica PowerCenter
Create a simple Workflow for QuickBooks Time data in Informatica PowerCenter.
-
Natively Connect to Clari Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Clari data. Leverage the native support for ODBC in PHP.
-
Create Cvent-Connected Dashboards in Grafana
Connect to Cvent Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Cvent data.
-
Build eBay-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for eBay Data and create custom apps in Mendix.
-
Freshteam Reporting in OBIEE with the Freshteam JDBC Driver
Deploy the Freshteam JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Explore Geographical Relationships in Basecamp Data with Power Map
Create data visualizations with Basecamp data in Power Map.
-
View Reports on Real-Time Sage Cloud Accounting Data in Power BI Report Server
Use the CData ODBC Driver for Sage Cloud Accounting to visualize Sage Cloud Accounting data in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize Live Aircall Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Aircall data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Power BI Connector for BenchmarkEmail
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use Dash to Build to Web Apps on SAP Data
Create Python applications that use pandas and Dash to build SAP-connected web apps.
-
How to load Flowlu data into Elasticsearch via Logstash
Introducing a simple method to load Flowlu data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Open WebUI with Live SAP Business Warehouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Business Warehouse data from within the chat interface.
-
Automated Continuous Oracle Eloqua Reporting Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to delimited files (CSV/TSV).
-
Integrate Dify with Live Airtable Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Airtable data.
-
Natively Connect to Drip Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Drip data. Leverage the native support for ODBC in PHP.
-
Integrating LangChain with GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on GitHub data within automated workflows.
-
Build Pipelines with Live Campaigner Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Campaigner from Google Cloud Data Fusion, enabling the integration of live Campaigner data into the building and management of effective data pipelines.
-
Sync Google Contacts with QuickBooks
The CData ADO.NET Providers offer an easy way to integrate with different data sources. This article walks through the downloadable, fully functional application that can be used to synchronize contacts between Google and QuickBooks.
-
Visualize Twitter Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Twitter Ads data.
-
Work with Live Box Data in Power Query
Use CData Connect AI to connect to Box data and work with live Box data in Microsoft Power Query.
-
Video: Connecting with MongoDB Data from Microsoft Excel
This video shows how to use the CData ODBC Driver for MongoDB to connect to MongoDB. You will create a DSN and then use the Data Connection Wizard in Excel to retrieve MongoDB data.
-
Access Live Snapchat Ads 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 Snapchat Ads data through MCP integration.
-
Access Live HCL Domino Data in TIBCO Data Virtualization
Use the HCL Domino Tibco DV Adapter to create a HCL Domino data data source in TIBCO Data Virtualization Studio and gain access to live HCL Domino data from your TDV Server.
-
Import Real-Time TigerGraph Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use TigerGraph data in ColdFusion.
-
Create REST Dataflows on PowerBI.com
Connect to the CData Power BI Connector for REST from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData SSIS Components for iContact
Complete guide to installing, licensing, and connecting with the CData SSIS Components for iContact.
-
Choosing the Best Method to Connect FTP to SQL Server: 5 Options Explained
Discover multiple ways to connect and use FTP data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Viewing Instantly Data in RAD Studio Data Explorer
How to view Instantly data in RAD Studio Data Explorer using the CData ODBC Driver for Instantly.
-
Build a PostgreSQL Interface for SendPulse Data using the CData JDBC Driver
Use the Remoting features of the SendPulse JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Google Sheets Data from a Connection Pool in JBoss
Integrate Google Sheets data into Java servlets: Use the Management Console in JBoss to install the Google Sheets JDBC Driver.
-
Build Semantic Layer Views for Sendwithus Data in APOS Live Data Gateway
Use the CData Connector for Sendwithus in APOS Live Data Gateway to build Semantic Layer Views for Sendwithus data.
-
How to Create Power BI Visual Reports with Real-Time Azure Table Data
Use CData Power BI Connectors to visualize Azure Table data in Power BI.
-
Analyze Live Wistia Data in SAS Viya
Use CData Connect AI to connect to Wistia data from SAS Viya and deploy self-service analytics using live Wistia data.
-
How to Easily Query Missive Data in OpenOffice Base
Connect to Missive data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Pipedrive with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Pipedrive with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pipedrive data.
-
Query LaunchDarkly Data as a MySQL Database in Node.js
Execute MySQL queries against LaunchDarkly data from Node.js.
-
Getting Started with the CData Power BI Connector for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Snapchat Ads.
-
Automated Continuous Wrike Replication to MongoDB
Use CData Sync for automated, continuous, customizable Wrike replication to MongoDB.
-
Access Freshdesk Data from MySQL in Amazon QuickSight
Connect to Freshdesk and build visualizations of Freshdesk data using a MySQL Connection in Amazon QuickSight.
-
Access Campaigner Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Campaigner data from HeidiSQL.
-
Build Azure Data Catalog-Connected Apps in Choreo
Use CData Connect AI to connect to Azure Data Catalog Data from Choreo and build custom apps using live Azure Data Catalog data.
-
Connecting GenSpark with Azure Table Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Azure Table data without any replication or custom integration required.
-
Use Dash to Build Web Apps on Sage Cloud Accounting Data via CData Connect AI
Build interactive Dash web apps on live Sage Cloud Accounting data using pandas and the CData Connect AI Python SDK.
-
Analyze Apify Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apify data in Microsoft R Open.
-
DataBind Controls to Toggl Data in Delphi
DataBind to Toggl data in Delphi with standard data access components and controls.
-
Automated Continuous Accelo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Accelo replication to Google BigQuery.
-
Connect to Tanda Data in Jaspersoft Studio
Execute SQL to remote Tanda data in Jaspersoft Studio.
-
Build Todoist-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Todoist data.
-
Create Freshdesk-Connected Business Apps in AppSheet
Connect to Freshdesk Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Freshdesk data.
-
Access Live Zoho CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho CRM data from your Excel spreadsheets.
-
Build Data Flows from Airtable to SQL Server using SSIS
Easily back up Airtable data to SQL Server using the SSIS components for Airtable.
-
Connect to Access Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Access.
-
Build a Simple VCL Application for Vimeo Data
How to build a simple VCL Application to view Vimeo data in RAD Studio using the CData ODBC Driver for Vimeo.
-
Access Live Google Forms Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Forms data from your Excel spreadsheets.
-
Connect to Marketo Data in JRuby
Create a simple JRuby app with access to live Marketo data.
-
Process & Analyze Zoho Inventory Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho Inventory Data.
-
Getting Started with the CData JDBC Driver for Azure Table
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Azure Table.
-
How to Use a Microsoft Access Database to Update Cosmos DB Data in Real Time
Update Cosmos DB data by creating a linked table in Microsoft Access with the CData Cosmos DB ODBC Driver.
-
Integrate Pipeliner CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Pipeliner CRM with External Services.
-
Use the CData ODBC Driver for SendInBlue in Microsoft Power Query
You can use the CData SendInBlue ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SendInBlue data into Microsoft Power Query.