CData Software - Knowledge Base
Recent Articles
-
Back Up Hacker News 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 Hacker News data data.
-
Create Dashboards and Visualize Live FHIR Data in Geckoboard
Use CData Connect AI to connect to live FHIR data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Migrating data from Postmark to Google BigQuery using CData SSIS Components.
Easily push Postmark data to Google BigQuery using the CData SSIS Tasks for Postmark and Google BigQuery.
-
Access Live AfterShip Data in Coginiti Pro
Connect to and query live AfterShip data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Excel Add-In for Dynamics 365
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dynamics 365.
-
Build a Simple VCL Application for Amazon Athena Data
How to build a simple VCL Application to view Amazon Athena data in RAD Studio using the CData ODBC Driver for Amazon Athena.
-
Connect to Zoho Creator Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zoho Creator data from Crystal Reports.
-
Analyze Vimeo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Vimeo from Power Pivot. You will use the Table Import Wizard to load Vimeo data. You can visually build the import query or use any SQL supported by the driver.
-
Use JayDeBeApi to access Autopilot Data in Python
Use standard Python scripting and the development environment of your choice to access live Autopilot data.
-
LINQ to Samanage Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Samanage Data Provider.
-
Integrate Sage Intacct Data in Pentaho Data Integration
Build ETL pipelines based on Sage Intacct data in the Pentaho Data Integration tool.
-
Connecting Pipedream with DB2 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 DB2 data in real time.
-
Query, Visualize, and Share live SAP SuccessFactors Data in Redash
Use CData Connect AI to connect to live SAP SuccessFactors data in Redash for querying, visualizing, and sharing.
-
Connect to Zendesk Data from AWS Glue
Use CData Connect AI to gain access to live Zendesk data from your AWS Glue jobs.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Smartsheet
Provide connectivity to Smartsheet data through an SAP BusinessObjects universe.
-
Process & Analyze Retently Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Retently Data.
-
How to create BigQuery federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for BigQuery data in MySQL .
-
How to Access IBM Informix Data Using Entity Framework
This article shows how to access IBM Informix data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Redis Data from a Connection Pool in Jetty
The Redis JDBC Driver supports connection pooling: This article shows how to connect faster to Redis data from Web apps in Jetty.
-
Integrate Cline with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Teams data from within your IDE.
-
Connect and Query Live Authorize.Net Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Authorize.Net data into Databricks and enable direct, live querying and analysis without replication.
-
Build Dashboards with Cohere Data in DBxtra
Create dynamic dashboards and perform analytics based on Cohere data in DBxtra.
-
Build JSON Visualizations in Tableau Cloud
Use CData Connect AI to connect to live JSON services and build visualizations in Tableau Cloud.
-
Connect to SAP Data in RapidMiner
Integrate SAP data with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Power BI Connector for Pipeline CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Pinterest Data from Crystal Reports
Use CData Connect AI to connect to and report on live Pinterest data from Crystal Reports.
-
Automate Phoenix Data Replication to Azure Synapse
Use CData Sync to customize and automate Phoenix data replication to Azure Synapse.
-
Automated Continuous Rebilly Replication to SQLite
Use CData Sync for automated, continuous, customizable Rebilly replication to SQLite.
-
Automated Continuous GitHub Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable GitHub data replication to OneLake in Microsoft Fabric.
-
Feed Factorial Data into FineReport
How to set Factorial data as a JDBC data source in FineReport.
-
Use Dash to Build to Web Apps on SAP BusinessObjects BI Data
Create Python applications that use pandas and Dash to build SAP BusinessObjects BI-connected web apps.
-
Integrate Open WebUI with Live Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Toggl data from within the chat interface.
-
Connecting Mastra with Samanage Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Samanage data, no replication required.
-
Natively Connect to Teradata Data in PHP
The CData ODBC driver for Teradata enables you to create PHP applications with connectivity to Teradata data. Leverage the native support for ODBC in PHP.
-
Choosing the Best Method to Connect LDAP to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LDAP objects from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Snapchat Ads Data in Google Apps Script via Connect AI
Use CData Connect AI to access Snapchat Ads data in Google Apps Script.
-
Query Oracle Financials Cloud Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Financials Cloud data.
-
DataBind Controls to Hugging Face Data in C++Builder
DataBind to Hugging Face data in C++Builder with standard components and controls.
-
Connect to GetResponse Data from a Connection Pool in JBoss
Integrate GetResponse data into Java servlets: Use the Management Console in JBoss to install the GetResponse JDBC Driver.
-
Connect to GitHub Data in RazorSQL
Connect to GitHub from wizards and query GitHub data from the GUI in the RazorSQL database management tool.
-
Connect to Oracle HCM Cloud Data in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle HCM Cloud in FileMaker Pro to connect to Oracle HCM Cloud and work with Oracle HCM Cloud data in your FileMaker applications.
-
Access Live SAS Data Sets Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAS Data Sets data from your Excel spreadsheets.
-
Integrate Google's Vertex AI Agent with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live QuickBooks Time data within intelligent workflows.
-
Easily Integrate Dynamics CRM Data in Lazarus Pascal IDE
Learn how to easily integrate live Dynamics CRM data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Manage Workable Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Workable.
-
Automated Continuous Browserless Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Browserless replication to IBM DB2.
-
Integrate Dify with Live Klipfolio 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 Klipfolio data.
-
Bridge GraphQL Connectivity with Apache NiFi
Access and process GraphQL data in Apache NiFi using the CData JDBC Driver.
-
Provide OData Services of Perplexity Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Perplexity data by developing a WCF Service Application.
-
DataBind Controls to Act-On Data in Delphi
DataBind to Act-On data in Delphi with standard data access components and controls.
-
Analyze Live Jira Data in SAS Viya
Use CData Connect AI to connect to Jira data from SAS Viya and deploy self-service analytics using live Jira data.
-
Integrate Omnisend with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Omnisend with External Services.
-
Build a Singer.io Tap for Odoo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Odoo data using the CData Python Connector.
-
Import Real-Time Nethunt Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Nethunt data in ColdFusion.
-
Build Hive-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Hive data and build Hive-connected web apps with Axios.
-
Build Charts with Salesforce Marketing Data in Clear Analytics
Create dynamic charts and perform analytics based on Salesforce Marketing data in Clear Analytics.
-
Connect to Salesloft Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Salesloft and the SQL Gateway to access Salesloft data from Google Apps Script.
-
Visualize Live Slack Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Slack data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Procore-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Procore Data and create custom apps in Mendix.
-
Consume TaxJar OData Feeds in PowerBuilder
This article demonstrates how to consume TaxJar data as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Moosend Replication to Snowflake
Use CData Sync for automated, continuous, customizable Moosend replication to Snowflake.
-
Integrate with Live SAP SuccessFactors LMS Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP SuccessFactors LMS from the MuleSoft Anypoint Platform to integrate live SAP SuccessFactors LMS data into custom reports and dashboards.
-
Integrate LibreChat with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure Synapse data from within the chat interface.
-
Rapidly Develop MarkLogic-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 MarkLogic.
-
DataBind Controls to Freshservice Data in Delphi
DataBind to Freshservice data in Delphi with standard data access components and controls.
-
How to Easily Query MariaDB Data in OpenOffice Base
Connect to MariaDB data in OpenOffice Base using the CData ODBC Driver for MariaDB and generate reports with live data insights.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce
Provide connectivity to Salesforce data through an SAP BusinessObjects universe.
-
Moving Data from Zoho Inventory to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho Inventory data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Contentful Data from a Connection Pool in JBoss
Integrate Contentful data into Java servlets: Use the Management Console in JBoss to install the Contentful JDBC Driver.
-
Getting Started with the CData JDBC Driver for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Netweaver Gateway.
-
Connect to and Visualize Live GetResponse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live GetResponse data.
-
How to Access Okta Data Using Entity Framework
This article shows how to access Okta data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Jodoo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Jodoo replication to SingleStore.
-
Access QuickBooks Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access QuickBooks data from your Oracle system.
-
How to integrate Raisers Edge NXT with Apache Airflow
Access and process Raisers Edge NXT data in Apache Airflow using the CData JDBC Driver.
-
Connect to Google Campaign Manager 360 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Campaign Manager 360 and the SQL Gateway to access Google Campaign Manager 360 data from Google Apps Script.
-
Build a Singer.io Tap for PDFMonkey With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PDFMonkey data using the CData Python Connector.
-
Access Live OneNote Data in TIBCO Data Virtualization
Use the OneNote Tibco DV Adapter to create a OneNote data data source in TIBCO Data Virtualization Studio and gain access to live OneNote data from your TDV Server.
-
Visualize Live Smartsheet Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Smartsheet data into custom reports in Power BI.
-
How to Work with Pushbullet Data in ETL Validator JDBC
Connect to Pushbullet from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Semantic Layer Views for Act-On Data in APOS Live Data Gateway
Use the CData Connector for Act-On in APOS Live Data Gateway to build Semantic Layer Views for Act-On data.
-
Access VWO Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live VWO data from HeidiSQL.
-
Create SSAS Tabular Models from Phoenix Data
How to build a SQL Server Analysis Service Tabular Model from Phoenix data using CData drivers.
-
A PostgreSQL Interface for SAP Data using the CData ODBC Driver
Use the SQL Gateway and SAP ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with Live Google Calendar Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Calendar from the MuleSoft Anypoint Platform to integrate live Google Calendar data into custom reports and dashboards.
-
Analyze OpenWeatherMap Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze OpenWeatherMap data in Microsoft R Open.
-
Bridge AlloyDB Connectivity with Apache NiFi
Access and process AlloyDB data in Apache NiFi using the CData JDBC Driver.
-
Build Opsgenie-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Opsgenie data.
-
Moving Data from Jira to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Jira data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
A PostgreSQL Interface for HubDB Data using the CData ODBC Driver
Use the SQL Gateway and HubDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Close Data in RazorSQL
Connect to Close from wizards and query Close data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Stack Exchange Replication to Oracle
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Oracle.
-
Use Agno to Talk to Your Google Forms Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Google Forms data for you.
-
Integrate Acumatica Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Acumatica data from Informatica Cloud.
-
Integrate with eBay Analytics Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy eBay Analytics data to a JSON file on disk.
-
Use Grok to Talk to Your Sage 300 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Sage 300 data for you.
-
How to Connect to ConvertKit Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ConvertKit data. Leverage the pyodbc module for ODBC in Python.
-
Analyze Mailjet Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mailjet data in Microsoft R Open.
-
Use the CData Software ODBC Driver for Suadeo in MicroStrategy
Connect to Suadeo data in MicroStrategy Developer using the CData Software ODBC Driver for Suadeo.
-
Connect Microsoft Ads to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Microsoft Ads with IBM WebSphere for seamless data integration and connectivity.