CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Snapchat Ads Replication to MongoDB
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to MongoDB.
-
Use the CData ODBC Driver for BigQuery in Microsoft Power Query
You can use the CData BigQuery ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google BigQuery into Microsoft Power Query.
-
Stream Redshift Data into Apache Kafka Topics
Access and stream Amazon Redshift in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Dash to Build to Web Apps on Google Sheets Data
Create Python applications that use pandas and Dash to build Google Sheets-connected web apps.
-
Stream YouTube Analytics Data into Apache Kafka Topics
Access and stream YouTube Analytics in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous ZendeskSell Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZendeskSell replication to AlloyDB.
-
How to Create Power BI Visual Reports with Real-Time Vault CRM Data
Use CData Power BI Connectors to visualize Veeva Vault & Vault CRM in Power BI.
-
Rapidly Develop HCL Domino-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 HCL Domino.
-
Analyze Twitter Ads Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Twitter Ads with the CData JDBC Driver for Twitter Ads.
-
Publish Crystal Reports on BambooHR Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date BambooHR.
-
How to connect to Bullhorn CRM Data from IntelliJ
Integrate connectivity to Bullhorn CRM with wizards in IntelliJ.
-
Build Agents in Relevance AI with Access to Live Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Smartsheet within intelligent agent workflows.
-
How to Easily Query Harvest Data in OpenOffice Base
Connect to Harvest data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Load Todoist Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Todoist to a database.
-
Build Pipelines with Live Facebook Ads Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Facebook Ads from Google Cloud Data Fusion, enabling the integration of live Facebook Ads into the building and management of effective data pipelines.
-
Build Dashboards with SendInBlue Data in Dundas BI
Create dynamic dashboards and perform analytics based on SendInBlue in Dundas BI.
-
Rapidly Develop ZohoPeople-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 ZohoPeople.
-
Connect to and Visualize Live QuickBooks Time Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live QuickBooks Time.
-
Manage AfterShip Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for AfterShip.
-
Build Apps with Live Typeform Data Using the Low-Code Development Platform of Mendix
Connect Typeform with Mendix to build apps using the CData API Driver for JDBC.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Ariba Source
Provide connectivity to SAP Ariba Source through an SAP BusinessObjects universe.
-
Automated Continuous Perplexity Replication to SingleStore
Use CData Sync for automated, continuous, customizable Perplexity replication to SingleStore.
-
Connect to MongoDB Data in Ruby
Connect to MongoDB in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to Smartsheet Data in DBVisualizer
Integrate Smartsheet with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Kintone-Connected Apps in Choreo
Use CData Connect AI to connect to Kintone Data from Choreo and build custom apps using live Kintone.
-
Build Data Flows from Bullhorn CRM to SQL Server using SSIS
Easily back up Bullhorn CRM to SQL Server using the SSIS components for Bullhorn CRM.
-
Connect to Box Data in Aqua Data Studio
Access Box from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Bridge Active Directory Connectivity with Apache NiFi
Access and process Active Directory in Apache NiFi using the CData JDBC Driver.
-
How to Access Live FTP Data in Visual Studio Code via Cline
Run CData MCP Server for FTP on Windows Subsytem for Linux (WSL) and connect to live FTP Servers from the Cline extension in Visual Studio Code.
-
Stream Discord Data into Apache Kafka Topics
Access and stream Discord in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to Zoho Books Data in DBVisualizer
Integrate Zoho Books with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Avaza Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Avaza. Leverage the pyodbc module for ODBC in Python.
-
Analyze Instagram Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Instagram and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Optimizely Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Optimizely from your Oracle system.
-
Automated Continuous Oracle Financials Cloud Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Google Cloud SQL.
-
Design BIRT Reports on Supabase Data
Provide current Supabase to your embedded analytics.
-
How to integrate Kafka with Apache Airflow
Access and process Apache Kafka in Apache Airflow using the CData JDBC Driver.
-
Migrating data from FormSite to Databricks using CData SSIS Components.
Easily push FormSite to Databricks using the CData SSIS Tasks for FormSite and Databricks.
-
Visualize Float Data in TIBCO Spotfire through ADO.NET
Integrate Float into dashboards in TIBCO Spotfire.
-
Getting Started with the CData Connect AI Python SDK for SAP Netweaver Gateway
Install the CData Connect AI Python SDK to read and write live SAP Netweaver Gateway with standard DB-API 2.0 Python code.
-
Creating Microsoft Exchange-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Exchange to Unqork and build custom business apps.
-
How to Build an ETL App for Power BI XMLA Data in Python with CData Connect AI
Build ETL pipelines that read and write live Power BI XMLA in Python with petl and the CData Connect AI Python SDK.
-
Build a PostgreSQL Interface for OpenWeatherMap Data using the CData JDBC Driver
Use the Remoting features of the OpenWeatherMap JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous AdRoll Replication to SQL Server
Use CData Sync for automated, continuous, customizable AdRoll replication to SQL Server.
-
iContact Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on iContact facts in real time.
-
Visualize Live Lakebase Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Lakebase.
-
Connect to LionDesk Data in Jaspersoft Studio
Execute SQL to remote LionDesk in Jaspersoft Studio.
-
Visualize Dynamics NAV Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Dynamics NAV.
-
Feed OnePageCrm Data into FineReport
How to set OnePageCrm as a JDBC data source in FineReport.
-
Integrate Dynamics 365 Data into Power Automate Desktop using CData Connect
CData Connect for Dynamics 365 Data enables you to integrate Microsoft Dynamics 365 into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to LaunchDarkly Data in C++Builder
DataBind to LaunchDarkly in C++Builder with standard components and controls.
-
How to connect to HelloSign Data in DBVisualizer
Integrate HelloSign with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous MySQL Replication to SQLite
Use CData Sync for automated, continuous, customizable MySQL replication to SQLite.
-
Connect to Freshservice Data in ACL Analytics
Connect to Freshservice via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Freshservice.
-
How to connect PolyBase to Paymo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Paymo.
-
Connect to SingleStore Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to create an RPA flow for WordPress Data in UiPath Studio
Use the WordPress ODBC Driver to create workflows that access real-time WordPress without any coding.
-
Analyze Keap Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Keap in Microsoft R Open.
-
Create Data Visualizations in Cognos BI with Quaderno Data
Access Quaderno as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect ZohoDesk to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect ZohoDesk with IBM WebSphere for seamless data integration and connectivity.
-
Create Informatica Mappings From/To an ODBC Data Source for Vault CRM
Create an ODBC connection to Vault CRM in Informatica and browse and transfer Veeva Vault & Vault CRM.
-
Import Real-Time GitHub Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use GitHub in ColdFusion.
-
Getting Started with the CData Tableau Connector for Salesforce
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Salesforce.
-
Getting Started with the CData ODBC Driver for Amplitude
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Amplitude.
-
How to Create Power BI Visual Reports with Real-Time Aweber Data
Use CData Power BI Connectors to visualize Aweber in Power BI.
-
Connect to Greenplum Data in RapidMiner
Integrate Pivotal GreenPlum with standard components and data source configuration wizards in RapidMiner Studio.
-
Replicate Zoho Recruit Data from PowerShell
Write a quick PowerShell script to query Zoho Recruit. Use connectivity to the live data to replicate Zoho Recruit to SQL Server.
-
How to connect to Bright Data Data from IntelliJ
Integrate connectivity to Bright Data with wizards in IntelliJ.
-
Import Real-Time SuiteCRM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SuiteCRM in ColdFusion.
-
Connect to GitHub Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time GitHub using standard SQL.
-
Use the CData Software ODBC Driver for FreshBooks in MicroStrategy
Connect to FreshBooks in MicroStrategy Developer using the CData Software ODBC Driver for FreshBooks.
-
Create NetSuite-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to NetSuite Data from Klipfolio and build custom visualizations using live NetSuite CRM & ERP.
-
Publish Crystal Reports on Browserless Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Browserless.
-
Manage Notion Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Notion.
-
Manage Google Translate Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Translate.
-
Create Power BI Reports on Real-Time Odoo Data
Use the CData ODBC Driver for Odoo to visualize Odoo ERP in Power BI Desktop.
-
Connect Notion to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Notion with IBM WebSphere for seamless data integration and connectivity.
-
Moving Data from Hugging Face to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Hugging Face data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Real-Time Opsgenie Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Opsgenie in Power Apps.
-
Connect to Exact Online Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Exact Online and the SQL Gateway to access Exact Online from Google Apps Script.
-
Replicate IBM Informix Data from PowerShell
Write a quick PowerShell script to query IBM Informix. Use connectivity to the live data to replicate IBM Informix to SQL Server.
-
Create a Data Access Object for SAP Netweaver Gateway Data using JDBI
A brief overview of creating a SQL Object API for SAP Netweaver Gateway in JDBI.
-
Build Anaplan-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Anaplan to explore live Anaplan Data in Cursor to assist with building Anaplan-powered applications.
-
Easily Integrate Slack Data in Lazarus Pascal IDE
Learn how to easily integrate live Slack in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize SAP SuccessFactors Data in TIBCO Spotfire through OData
Integrate SAP SuccessFactors into dashboards in TIBCO Spotfire.
-
How to Work with SageHR Data in AWS Glue Jobs Using JDBC
Connect to SageHR from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Avalara AvaTax Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Avalara AvaTax in the Denodo Virtual DataPort Administrator.
-
Create Dynamics 365-Connected Nintex Workflows
Use CData Connect AI to connect to Dynamics 365 Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Dynamics 365.
-
Use the CData Software ODBC Driver for Zoho Inventory in MicroStrategy Web
Connect to Zoho Inventory in MicroStrategy Web using the CData Software ODBC Driver for Zoho Inventory.
-
Viewing Oracle Data in RAD Studio Data Explorer
How to view Oracle Database in RAD Studio Data Explorer using the CData ODBC Driver for Oracle.
-
Natively Connect to QuickBooks Time Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to QuickBooks Time. Leverage the native support for ODBC in PHP.
-
How to create Flowlu federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Flowlu in MySQL .
-
Access Bugsnag Data from MySQL in PHP
Connect to Bugsnag through the standard MySQL libraries in PHP.
-
Build Visualizations of Access Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Access in Birst.
-
Automated Continuous Cloudflare Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Cloudflare replication to IBM DB2.
-
Build Redshift-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Amazon Redshift.
-
How to publish and share IBM Cloud Object Storage Data dashboards with Tableau Server
The CData ODBC driver for IBM Cloud Object Storage enables you integrate IBM Cloud Object Storage into Tableau dashboards.
-
Build a Singer.io Tap for Reckon With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Reckon data using
-
Replicate Multiple Oracle Service Cloud Accounts via the CData Sync CLI
Replicate multiple Oracle Service Cloud accounts to one or many databases.
-
Integrating LangChain with QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on QuickBooks Time within automated workflows.