CData Software - Knowledge Base
Recent Articles
-
Connect to IBM Informix Data in ACL Analytics
Connect to IBM Informix data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to IBM Informix data.
-
Use Biml to Build SSIS Tasks to Replicate BambooHR Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate BambooHR data to SQL Server.
-
Moving Data from Oracle Eloqua Reporting to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Oracle Eloqua Reporting data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build SingleStore-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SingleStore Data from Zoho Analytics and import live SingleStore data.
-
Access Live Sage Intacct Data in Coginiti Pro
Connect to and query live Sage Intacct data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Microsoft Planner Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Planner data.
-
Build Facebook Ads-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Facebook Ads data and build Facebook Ads-connected web apps with Axios.
-
Use ChatGPT to Talk to Your Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Email data for you.
-
How to Connect to Live Instagram Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Instagram data securely in real time.
-
Build Dashboards with Figshare Data in DBxtra
Create dynamic dashboards and perform analytics based on Figshare data in DBxtra.
-
Connect to Bullhorn CRM Data in HULFT Integrate
Connect to Bullhorn CRM as a JDBC data source in HULFT Integrate
-
Connect to ConstantContact Data from a Connection Pool in Jetty
The ConstantContact JDBC Driver supports connection pooling: This article shows how to connect faster to ConstantContact data from Web apps in Jetty.
-
How to import Aircall Data into Apache Solr
Use the CData Software JDBC Driver for Aircall in Data Import Handler and create an automated import of Aircall data to Apache Solr Enterprise Search platform.
-
Connect to LinkedIn Data in Aqua Data Studio
Access LinkedIn data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automate Azure Data Lake Storage Data Replication to Couchbase
Use CData Sync to Customize and automate Azure Data Lake Storage data replication to Couchbase.
-
How to Connect to Live Phoenix 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 Phoenix data for you.
-
Connect to EnterpriseDB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for EnterpriseDB to connect to EnterpriseDB data and execute queries in PowerBuilder.
-
ETL Bullhorn CRM in Oracle Data Integrator
This article shows how to transfer Bullhorn CRM data into a data warehouse using Oracle Data Integrator.
-
Deploy the ADO.NET Provider for PDFMonkey on an SSRS Report Server
Connect to PDFMonkey data 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.
-
How to Seamlessly Import Drip Data into IBM SPSS Modeler
Integrate Drip data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Live Quickbase Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Quickbase data.
-
Create Reports from Adobe Analytics Data in Looker Studio
Use CData Connect AI to gain access to live Adobe Analytics data and create custom reports in Looker Studio.
-
Use the CData Software JDBC Driver for Bright Data in MicroStrategy Desktop
Connect to Bright Data data in MicroStrategy Desktop using the CData Software JDBC Driver for Bright Data.
-
Build Voice Agents in ElevenLabs with access to Live Cloudant Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Cloudant data.
-
Replicate Multiple Hive Accounts
Replicate multiple Hive accounts to one or many databases.
-
How to create an RPA flow for FHIR Data in UiPath Studio
Use the FHIR ODBC Driver to create workflows that access real-time FHIR data without any coding.
-
Use the CData Software JDBC Driver for Opsgenie in MicroStrategy Desktop
Connect to Opsgenie data in MicroStrategy Desktop using the CData Software JDBC Driver for Opsgenie.
-
Connect to OneNote Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time OneNote data using standard SQL.
-
How to Use a Microsoft Access Database to Update SuiteCRM Data in Real Time
Update SuiteCRM data by creating a linked table in Microsoft Access with the CData SuiteCRM ODBC Driver.
-
Visualize Supabase 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 Supabase data into TIBCO Spotfire.
-
Connecting Pipedream with Mode Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Mode data in real time.
-
Connect to Freshteam Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Freshteam and work with Freshteam data in your FileMaker application.
-
How to Connect to Live MongoDB Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your MongoDB data through natural language.
-
Connecting Moonlit Workflow with Monday.com 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 Monday.com data in real time.
-
Connecting Moonlit Workflow with SAP Business Warehouse 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 SAP Business Warehouse data in real time.
-
Visualize Live Bitbucket Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Bitbucket data into custom reports in Power BI.
-
Natively Connect to Zoho Books Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoho Books data. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Stripe in MicroStrategy Web
Connect to Stripe data in MicroStrategy Web using the CData Software ODBC Driver for Stripe.
-
Analyze Impala Data in Cognos Analytics
Use CData Connect AI to connect to Impala Data from Cognos Analytics and analyze live Impala data.
-
Connect to Freshteam Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Freshteam Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Live Acumatica 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 Acumatica data through MCP integration.
-
Automated Continuous Clio Replication to SingleStore
Use CData Sync for automated, continuous, customizable Clio replication to SingleStore.
-
Automated Continuous Databricks Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Databricks replication to Google BigQuery.
-
How to use SQLAlchemy ORM to access WordPress Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of WordPress data.
-
Model, Search, and Visualize Live Samanage Data in ThoughtSpot
Use CData Connect AI to connect to live Samanage data for modeling, searching, and visualizing.
-
Replicate CloudConvert Data to Multiple Databases
Replicate CloudConvert data to disparate databases with a point-and-click configuration.
-
Build Data Flows from Wrike to SQL Server using SSIS
Easily back up Wrike data to SQL Server using the SSIS components for Wrike.
-
Connect to Freshsales Data in RapidMiner
Integrate Freshsales data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Vercel Data from MySQL in Amazon QuickSight
Connect to Vercel and build visualizations of Vercel data using a MySQL Connection in Amazon QuickSight.
-
Using the CData Software ODBC Driver for Samanage in PyCharm
Connect to Samanage as an ODBC data source in PyCharm using the CData Software ODBC Driver for Samanage.
-
How to connect to Templated Data with Squirrel SQL client
Connect to Templated data and execute queries in the Squirrel SQL Client.
-
How to import YouTube Analytics Data into Apache Solr
Use the CData Software JDBC Driver for YouTube Analytics in Data Import Handler and create an automated import of YouTube Analytics data to Apache Solr Enterprise Search platform.
-
Build AI/ML Models with Live Flowlu Data using Dataiku
Connect Flowlu Data with Dataiku using the CData API Driver for JDBC.
-
Integrate Cline with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Ads data from within your IDE.
-
Moving Data from Opsgenie to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Opsgenie data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Provide OData Services of IBM Informix Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for IBM Informix data by developing a WCF Service Application.
-
DataBind Controls to DB2 Data in C++Builder
DataBind to DB2 data in C++Builder with standard components and controls.
-
Connect to Nuclia Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Nuclia and work with Nuclia data in your FileMaker applications.
-
Access Live Discord Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Discord data from your Google Sheets.
-
Back Up ADP data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for ADP. In this article, we will employ an SSIS workflow to populate a database with ADP data data.
-
Connect to Live Apollo Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Apollo in CData Connect AI and connect to your Apollo data from PostgreSQL.
-
Feed Shortcut Data into FineReport
How to set Shortcut data as a JDBC data source in FineReport.
-
SAP HANA Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP HANA facts in real time.
-
Publish Cohere-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Cohere data.
-
Integrate Live Procore Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Procore from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Procore data.
-
Feed ZohoExpense Data into FineReport
How to set ZohoExpense data as a JDBC data source in FineReport.
-
ETL Pushbullet in Oracle Data Integrator
This article shows how to transfer Pushbullet data into a data warehouse using Oracle Data Integrator.
-
Query SparkPost Data in ColdFusion
Write standard ColdFusion data access code to connect to SparkPost data.
-
Automated Continuous Google Translate Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Translate replication to SQL Server.
-
Access Shippo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Shippo data from HeidiSQL.
-
Build Visualizations of ZohoSubscriptions Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZohoSubscriptions data in Birst.
-
Automate Excel Data Replication to Azure Synapse
Use CData Sync to customize and automate Excel data replication to Azure Synapse.
-
Integrate Trae with Live Google Ads Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Google Ads data from within the AI-powered IDE.
-
Analyze SAP Business One Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP Business One data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to ClickTime Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ClickTime to connect to ClickTime data and execute queries in PowerBuilder.
-
Migrating data from Retently to Google BigQuery using CData SSIS Components.
Easily push Retently data to Google BigQuery using the CData SSIS Tasks for Retently and Google BigQuery.
-
Write a Simple Go Application to work with JSON Services on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to JSON services.
-
How to Create Power BI Visual Reports with Real-Time Retently Data
Use CData Power BI Connectors to visualize Retently data in Power BI.
-
Integrate Live Basecamp Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Basecamp from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Basecamp data.
-
Bridge Procore Connectivity with Apache NiFi
Access and process Procore data in Apache NiFi using the CData JDBC Driver.
-
Natively Connect to Vault CRM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Vault CRM data. Leverage the native support for ODBC in PHP.
-
Access Live ZohoDesk Data in Coginiti Pro
Connect to and query live ZohoDesk data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Google Analytics Data in DBArtisan
Use wizards in DBArtisan to configure Google Analytics data as a data source.
-
Provide OData Services of SAP HANA Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP HANA data by developing a WCF Service Application.
-
Integrate Live Supabase Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Supabase data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to WooCommerce Data in Ruby
Connect to WooCommerce data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to Facebook Data with Squirrel SQL client
Connect to Facebook data and execute queries in the Squirrel SQL Client.
-
Connect to Egnyte Data from PowerBuilder via ADO.NET
This article demonstrates how to access Egnyte data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData Software JDBC Driver for Toggl in MicroStrategy Web
Connect to Toggl data in MicroStrategy Web using the CData Software JDBC Driver for Toggl.
-
Migrating data from REST to Google BigQuery using CData SSIS Components.
Easily push REST data to Google BigQuery using the CData SSIS Tasks for REST and Google BigQuery.
-
Build a PostgreSQL Interface for Office 365 Data using the CData JDBC Driver
Use the Remoting features of the Office 365 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Back Up Quaderno data 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 Quaderno data data.
-
Create Dashboards and Visualize Live Highrise Data in Geckoboard
Use CData Connect AI to connect to live Highrise data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
DataBind Charts to Google Directory Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Directory data 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.
-
Replicate CapsuleCRM Data in Heroku for Use in Salesforce Connect
Replicate CapsuleCRM data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate Simplesat Data from PowerShell
Write a quick PowerShell script to query Simplesat data. Use connectivity to the live data to replicate Simplesat data to SQL Server.
-
Automated Continuous Simplesat Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Simplesat data replication to OneLake in Microsoft Fabric.
-
Build Semantic Layer Views for Todoist Data in APOS Live Data Gateway
Use the CData Connector for Todoist in APOS Live Data Gateway to build Semantic Layer Views for Todoist data.
-
Use the CData Software ODBC Driver for Auth0 in MicroStrategy
Connect to Auth0 data in MicroStrategy Developer using the CData Software ODBC Driver for Auth0.
-
Connect to ServiceNow Data in DBArtisan
Use wizards in DBArtisan to configure ServiceNow data as a data source.