CData Software - Knowledge Base

Recent Articles

---

• «
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• 218
• 219
• 220
• »

• Automated Continuous Vault CRM Replication to Vertica

  Use CData Sync for automated, continuous, customizable Vault CRM replication to Vertica.

• Validate CapsuleCRM Data with QuerySurge

  Access and validate CapsuleCRM in QuerySurge using the CData JDBC Driver.

• Consume HubDB OData Feeds in PowerBuilder

  This article demonstrates how to consume HubDB as OData feeds from PowerBuilder using the API Server.

• Automated Continuous ZendeskSell Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable ZendeskSell replication to Azure SQL Database.

• Integrate Cline with Live Google Calendar Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Calendar from within your IDE.

• Build Neo4J-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Neo4J.

• Build a Simple VCL Application for Tickspot Data

  How to build a simple VCL Application to view Tickspot in RAD Studio using the CData ODBC Driver for Tickspot.

• Integrating Kiro CLI with Smartsheet Data via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

• DataBind Charts to Avro Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Avro 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.

• Load Front Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Front to a database.

• Create Reports with Gumroad Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Gumroad.

• Access Live Zuora Data in Coginiti Pro

  Connect to and query live Zuora from the GUI in the Coginiti Pro: SQL Analytics Tool.

• How to connect to IBM Cloud Object Storage Data from IntelliJ

  Integrate connectivity to IBM Cloud Object Storage with wizards in IntelliJ.

• Getting Started with the CData ADO.NET Provider for RSS

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for RSS.

• ETL Sybase in Oracle Data Integrator

  This article shows how to transfer Sybase into a data warehouse using Oracle Data Integrator.

• Analyze Codat Data with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Codat from Power Pivot. You will use the Table Import Wizard to load Codat. You can visually build the import query or use any SQL supported by the driver.

• Analyze Hubstaff Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Hubstaff and visualize live Hubstaff in Infragistics Reveal.

• Build Data Flows from SAP BusinessObjects BI to SQL Server using SSIS

  Easily back up SAP BusinessObjects BI to SQL Server using the SSIS components for SAP BusinessObjects BI.

• Natively Connect to Zoho Creator Data in PHP

  The CData ODBC driver for Zoho Creator enables you to create PHP applications with connectivity to Zoho Creator. Leverage the native support for ODBC in PHP.

• Use the CData API Server to Access Gmail Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Gmail in the Power Pivot business intelligence tool.

• Create Power BI Reports on Real-Time JobNimbus Data

  Use the CData ODBC Driver for JobNimbus to visualize JobNimbus in Power BI Desktop.

• Use the CData Software ODBC Driver for Google Directory in MicroStrategy Desktop

  Connect to Google Directory in MicroStrategy Desktop using the CData Software ODBC Driver for Google Directory.

• Replicate Bullhorn CRM Data from PowerShell

  Write a quick PowerShell script to query Bullhorn CRM. Use connectivity to the live data to replicate Bullhorn CRM to SQL Server.

• Visualize Snowflake Data in TIBCO Spotfire through OData

  Integrate Snowflake into dashboards in TIBCO Spotfire.

• Connect to Cloudflare from Asprova with CData Software ODBC Driver for Cloudflare

  This article shows how to connect faster to Cloudflare data from Asprova.

• Connect Snowflake Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Snowflake using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Consume Amazon S3 OData Feeds in PowerBuilder

  This article demonstrates how to consume Amazon S3 as OData feeds from PowerBuilder using the API Server.

• Replicate Hacker News Data from PowerShell

  Write a quick PowerShell script to query Hacker News. Use connectivity to the live data to replicate Hacker News to SQL Server.

• Automated Continuous Couchbase Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Couchbase replication to MongoDB.

• How to connect SharePoint with Dynamics CRM Data through external lists

  Provide Microsoft Dynamics CRM to SharePoint users as an external list.

• Rapidly Develop Nuclia-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 Nuclia.

• Connect to Optimizely Data in RapidMiner

  Integrate Optimizely with standard components and data source configuration wizards in RapidMiner Studio.

• Integrate with JDBC-ODBC Bridge Data in JReport Designer

  Create charts and reports based on JDBC-ODBC Bridge in JReport Designer.

• Extend Google Sheets with Deel Data

  Make calls to Deel from Google Apps Script via the API Server.

• Validate Spotify Data with QuerySurge

  Access and validate Spotify in QuerySurge using the CData JDBC Driver.

• Automated Continuous Greenplum Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Greenplum replication to AlloyDB.

• Getting Started with the CData Power BI Connector for Azure Table

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Azure.

• Use the CData API Server to Access Reckon Accounts Hosted Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Reckon Accounts Hosted in the Power Pivot business intelligence tool.

• Connect to ClickUp Data from PowerBuilder via JDBC

  This article demonstrates how to access ClickUp from PowerBuilder using the ClickUp JDBC Driver.

• Salesforce Pardot Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Salesforce Pardot facts in real time.

• View Reports on Real-Time Ontraport Data in Power BI Report Server

  Use the CData ODBC Driver for Ontraport to visualize Ontraport in Power BI Desktop and then publish them to Power BI Report Server.

• Use the CData API Server to Access Figshare Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Figshare in the Power Pivot business intelligence tool.

• Automate Tasks in Power Automate Using the CData API Server

  Automate Basecamp actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Use the CData ODBC Driver for Stack Exchange from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Stack Exchange to connect to Stack Exchange from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Stack Exchange in Excel.

• Automated Continuous Yelp Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Yelp replication to Azure SQL Database.

• Visualize Live Dynamics CRM Data in the Power BI Service

  Use CData Connect AI to connect to live Microsoft Dynamics CRM and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to connect and process Workable from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Workable.

• Integrating Gumloop with Avro Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Apache Avro within automated workflows.

• Build MVC Applications with Connectivity to Drift Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Drift from an ASP.NET MVC application.

• Analyze FreeAgent Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of FreeAgent and visualize live FreeAgent in Infragistics Reveal.

• Import LightSpeedRetail Data into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access LightSpeedRetail. In this article, you will use the OData format to import LightSpeedRetail into Microsoft Power Query.

• Publish Shortcut-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Shortcut.

• Connecting Pipedream with Trello 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 Trello data in real time.

• Build PivotalTracker-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to PivotalTracker and build web apps with connectivity to live PivotalTracker.

• Create a Data Access Object for REST Data using JDBI

  A brief overview of creating a SQL Object API for REST in JDBI.

• Create Dynamic ZohoMarketingHub Grids Using the Infragistics XamDataGrid

  Learn how you can connect ZohoMarketingHub to Infragistics XamDataGrid to build dynamic grids.

• Create Microsoft Dataverse-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to Microsoft Dataverse Data from Klipfolio and build custom visualizations using live Microsoft Dataverse (CDS).

• Visualize ConstantContact Data in TIBCO Spotfire through OData

  Integrate ConstantContact into dashboards in TIBCO Spotfire.

• How to Import Data from Tickspot into Google Sheets

  Import Tickspot into a Google spreadsheet that is automatically refreshed.

• Replicate Multiple Omnisend Accounts via the CData Sync CLI

  Replicate multiple Omnisend accounts to one or many databases.

• Connect to OneNote Data in Jaspersoft Studio

  Execute SQL to remote Microsoft OneNote in Jaspersoft Studio.

• Integrate Real-Time Access to Clari in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Clari in real time.

• Integrate with Live Cloudant Data in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Cloudant from the MuleSoft Anypoint Platform to integrate live IBM Cloudant into custom reports and dashboards.

• How to connect and process Azure Cosmos DB from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Cosmos DB.

• How to Access Live Helpscout Data in Visual Studio Code via Cline

  Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Helpscout from the Cline extension in Visual Studio Code.

• Perform Batch Operations with Dynamics 365 Data in Apache NiFi

  Connect to Microsoft Dynamics 365 and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Access Live Salesforce Data in AWS Lambda

  Connect to live Salesforce & Force.com in AWS Lambda using the CData JDBC Driver.

• Build Dynamics 365-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Dynamics 365.

• Migrating data from ActiveCampaign to Snowflake using CData SSIS Components.

  Easily push ActiveCampaign to Snowflake using the CData SSIS Tasks for ActiveCampaign and Snowflake.

• How to Access Live Grafana Data in Visual Studio Code via Cline

  Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Grafana from the Cline extension in Visual Studio Code.

• Create Data Visualizations Based On SAP Fieldglass Data in Mode

  Use CData Connect AI to connect to SAP Fieldglass Data from Mode and build visualizations using live

• Access QuickBooks from Aqua Data Studio

  Connect to the CData JDBC Driver for QuickBooks through the Aqua Data Studio connection manager.

• Connect to Todoist Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Todoist.

• Automate Gumroad Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Gumroad from PowerShell? This article demonstrates how to utilize the Gumroad Cmdlets for tasks like connecting to Gumroad, automating operations, downloading data, and more.

• Use the CData ODBC Driver for SendGrid in Microsoft Power Query

  You can use the CData SendGrid ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SendGrid into Microsoft Power Query.

• Extract, Transform, and Load PhantomBuster Data in Informatica PowerCenter

  Create a simple Workflow for PhantomBuster in Informatica PowerCenter.

• Connect to Productboard Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Productboard as an External Source in Dremio.

• Integrating LlamaIndex with Adobe Commerce Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Adobe Commerce in real time.

• Build Azure Data Lake Storage-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Azure Data Lake Storage Data from Zoho Analytics and import live Azure Data Lake Storage.

• Connect to ZohoPeople Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for ZohoPeople to connect to ZohoPeople and execute queries in PowerBuilder.

• Access Live GitLab Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live GitLab through MCP integration.

• Visualize ADP Data in Tableau

  The CData ODBC driver for ADP enables you integrate ADP into Tableau dashboards.

• Build Charts with Gong Data in Clear Analytics

  Create dynamic charts and perform analytics based on Gong in Clear Analytics.

• Connect to Retently Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Retently from Appeon PowerBuilder using the CData API Driver for ADO.NET.

• How to connect to Adobe Target Data with Squirrel SQL client

  Connect to Adobe Target and execute queries in the Squirrel SQL Client.

• How to Visualize Delighted Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Delighted in Python.

• Import and Visualize Mailjet Data in Power View

  Create data visualizations based on Mailjet in Excel.

• Prepare, Blend, and Analyze Bitly Data in Alteryx Designer (ODBC)

  Build workflows to access live Bitly for self-service data analytics.

• Replicate Multiple Quaderno Accounts

  Replicate multiple Quaderno accounts to one or many databases.

• Load GraphQL Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load GraphQL to a database.

• Automated Continuous Parquet Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Parquet replication to Snowflake.

• Shippo Reporting in OBIEE with the Shippo JDBC Driver

  Deploy the Shippo JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Use the CData Software ODBC Driver for Todoist in MicroStrategy

  Connect to Todoist in MicroStrategy Developer using the CData Software ODBC Driver for Todoist.

• Connect to and Visualize Live Email Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Email.

• How to Connect to Google Contacts Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Google Contacts. Leverage the pyodbc module for ODBC in Python.

• Create Informatica Mappings From/To a JDBC Data Source for ZarMoney

  Create ZarMoney data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Automated Continuous Gorgias Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Gorgias replication to SQL Server.

• Connect to Supabase Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Supabase in the Denodo Virtual DataPort Administrator.

• Visualize Live Google Ads Data in the Power BI Service

  Use CData Connect AI to connect to live Google Ads and create custom reports in the Power BI Service through the On-Premises Gateway.

• Integrate Scrapfly Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Scrapfly from Informatica Cloud.

• «
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• 218
• 219
• 220
• »