CData Software - Knowledge Base

Recent Articles

---

• «
• 289
• 290
• 291
• 292
• 293
• 294
• 295
• 296
• 297
• 298
• »

• Connect Exact Online to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Exact Online with IBM WebSphere for seamless data integration and connectivity.

• Use Biml to Build SSIS Tasks to Replicate SAP Concur Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Concur to SQL Server.

• Automated Continuous RSS Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable RSS replication to Amazon S3.

• Build ServiceNow-Connected Web Apps in Servoy

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

• Explore Geographical Relationships in Outlook Data with Power Map

  Create data visualizations with Outlook in Power Map.

• Query Live Sugar CRM Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Sugar CRM directly from the development environment.

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

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

• Analyze Snowflake Data in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Snowflake and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.

• Use the CData ODBC Driver for Float from SharePoint Excel Services

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

• Build Dashboards with Planio Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Planio in Dundas BI.

• Replicate Multiple Front Accounts via the CData Sync CLI

  Replicate multiple Front accounts to one or many databases.

• Build Spark-Connected Apps in Choreo

  Use CData Connect AI to connect to Spark Data from Choreo and build custom apps using live Apache Spark SQL.

• Automate Stripe Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Stripe and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Integrating Gumloop with GraphQL Data via CData Connect AI

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

• Import Real-Time Jodoo Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Jodoo in ColdFusion.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Salesforce Data 360 to Power BI dashboards. Simply drag and drop Salesforce Data 360 into data visuals on the Power BI canvas.

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

  Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.

• Integrate Front with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Front with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Front.

• Integrate Act CRM Data in Your Informatica Cloud Instance

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

• Connect Rebilly to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Rebilly using the CData Python MCP Server.

• How to Connect to Live Dynamics 365 Business Central 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 Dynamics 365 Business Central for you.

• Work with Vault CRM Data in FoxPro

  Load Veeva Vault & Vault CRM into a FoxPro database. This article includes full code and a walk-through of the process.

• How to Connect the Power BI Service to LionDesk: Complete Guide

  Connect to the CData Software Power BI Connector for LionDesk from PowerBI.com to provide real-time LionDesk across the organization.

• Use CData Connect AI to Access Shopify Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live Shopify in the Power Pivot business intelligence tool.

• Natively Connect to Facebook Ads Data in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Facebook Ads. Leverage the native support for ODBC in PHP.

• Getting Started with the CData SSIS Components for WordPress

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for WordPress.

• Bidirectional Access to Cloudant Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate IBM Cloudant in Filemaker Pro for Mac or Windows.

• LINQ to Mixpanel 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 Mixpanel Data Provider.

• Automated Continuous Shippo Replication to Azure SQL Database

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

• Bitly Reporting in OBIEE with the Bitly JDBC Driver

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

• Connect to SendPulse Data from PowerBuilder via ODBC

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

• Use Claude to Talk to Your Presto Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Presto for you.

• Getting Started with the CData Excel Add-In for Zoho Inventory

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zoho Inventory.

• Connect to Couchbase Data from HeidiSQL

  Use CData Connect AI to connect to and query live Couchbase from HeidiSQL.

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

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

• Connect to Reckon Accounts Hosted Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for Reckon Accounts Hosted and the Script function in FileMaker Pro to connect to Reckon Accounts Hosted and work with Reckon Accounts Hosted in your FileMaker application.

• Publish Reports with ClickTime Data in SAP Crystal Reports

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

• Build DocuSign-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to DocuSign Data from Zoho Analytics and import live DocuSign.

• Migrating data from Jira to Google BigQuery using CData SSIS Components.

  Easily push Atlassian Jira to Google BigQuery using the CData SSIS Tasks for Jira and Google BigQuery.

• Use the CData Software JDBC Driver for Sendwithus in MicroStrategy Web

  Connect to Sendwithus in MicroStrategy Web using the CData Software JDBC Driver for Sendwithus.

• Integrating EmailOctopus Data in Talend Cloud Data Management Platform

  Connect EmailOctopus Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.

• Connect to Stripe Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for Stripe and the Script function in FileMaker Pro to connect to Stripe and work with Stripe in your FileMaker application.

• Use JayDeBeApi to access Onfleet Data in Python

  Use standard Python scripting and the development environment of your choice to access live Onfleet.

• Integrate LinkedIn Ads Data in Pentaho Data Integration

  Build ETL pipelines based on LinkedIn Ads in the Pentaho Data Integration tool.

• How to connect and process Oracle Financials Cloud from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Financials Cloud.

• Provide OData Services of Printful Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Printful by developing a WCF Service Application.

• Consume Avalara AvaTax OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Avalara AvaTax feeds that reflect any changes in SAP Lumira.

• Import Real-Time Microsoft OneDrive Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Microsoft OneDrive in ColdFusion.

• How to Retrieve More Than 5000 Records in CData SharePoint Drivers

  Work around the SharePoint 5,000-item list view threshold with CData SharePoint Drivers. Solutions and configuration for SOAP and REST schemas.

• Operational Reporting on Google Drive Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Google Drive.

• How to Visualize ADP Data in Python with pandas

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for ConvertKit

  Provide connectivity to ConvertKit through an SAP BusinessObjects universe.

• Build Google Sheets-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for Google Sheets to explore live Google Sheets Data in Cursor to assist with building Google Sheets-powered applications.

• Explore Geographical Relationships in Azure DevOps Data with Power Map

  Create data visualizations with Azure DevOps in Power Map.

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

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

• How to integrate Metabase with MySQL Data

  Use CData Connect AI to connect to live MySQL and create an interactive dashboard in Metabase from MySQL.

• Automated Continuous Teamwork Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Teamwork replication to Google BigQuery.

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

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

• Query Act-On Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Act-On from Node.js.

• Viewing Redshift Data in RAD Studio Data Explorer

  How to view Amazon Redshift in RAD Studio Data Explorer using the CData ODBC Driver for Redshift.

• Access Live Google Calendar Data in Coginiti Pro

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

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

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

• Design BIRT Reports on Sybase Data

  Provide current Sybase to your embedded analytics.

• Create Apps from Greenplum Data in Qlik Sense Cloud

  Use CData Connect AI to connect to Greenplum Data and build apps from live Pivotal GreenPlum in Qlik Sense Cloud.

• Connect to Beeminder Data from a Connection Pool in Jetty

  The Beeminder JDBC Driver supports connection pooling: This article shows how to connect faster to Beeminder from Web apps in Jetty.

• How to connect to CloudConvert Data in DBVisualizer

  Integrate CloudConvert with visual data analysis tools and data connection wizards in DBVisualizer

• Build MVC Applications with Connectivity to Cosmos DB Data

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

• Automated Continuous MongoDB Replication to SQLite

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

• Bidirectional Access to Cvent Data from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Cvent in Filemaker Pro for Mac or Windows.

• Build Redis-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for Redis to explore live Redis Data in Claude Code to assist with building Redis-powered applications.

• Getting Started with the CData ODBC Driver for Testmonitor

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Testmonitor.

• Automated Continuous API Replication to Snowflake

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

• Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer (Connect AI)

  Build workflows to access live Salesforce & Force.com for self-service data analytics.

• Automated Continuous Oracle SCM Replication to SQLite

  Use CData Sync for automated, continuous, customizable Oracle SCM replication to SQLite.

• How to Query Live Facebook Ads Data in Claude Desktop

  Connect to and query live Facebook Ads Data in Claude Desktop using CData MCP Server.

• Use Databricks Agent Bricks to Talk to Your Azure Data Lake Storage Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure Data Lake Storage for you.

• Access Live Sugar CRM Data in AWS Lambda

  Connect to live Sugar CRM in AWS Lambda using the CData JDBC Driver.

• Build Dashboards with TaxJar Data in DBxtra

  Create dynamic dashboards and perform analytics based on TaxJar in DBxtra.

• Publish Twilio-Connected Dashboards in Tableau Server via JDBC

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

• Analyze IBM Cloud Object Storage Data with Power Pivot

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

• Publish Reports with SQL Server Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft SQL Server.

• Visualize IBM Informix Data in Tableau

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

• Create Datasets from BenchmarkEmail in Domo Workbench and Build Visualizations of BenchmarkEmail Data in Domo

  Use the CData Software ODBC Driver for BenchmarkEmail to create datasets from BenchmarkEmail in Domo Workbench and then build visualizations in the Domo service.

• Natively Connect to Freshsales Data in PHP

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

• Query Instagram Data in ColdFusion

  Write standard ColdFusion data access code to connect to Instagram.

• Connect to Everhour Data in RapidMiner

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

• Visualize Microsoft Exchange Data in TIBCO Spotfire through ADO.NET

  Integrate Microsoft Exchange into dashboards in TIBCO Spotfire.

• How to Work with SendGrid Data in ETL Validator JDBC

  Connect to SendGrid from ETL Validator jobs using the CData Software JDBC Driver.

• How to Connect to & Open Microsoft Exchange Data in Microsoft Excel

  This article uses the CData ODBC driver for Microsoft Exchange to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Import Real-Time Apify Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Apify in ColdFusion.

• Import and Visualize Simplesat Data in Power View

  Create data visualizations based on Simplesat in Excel.

• Bridge Amplitude Connectivity with Apache NiFi

  Access and process Amplitude in Apache NiFi using the CData JDBC Driver.

• Manage PabblySubscriptions Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for PabblySubscriptions.

• Replicate Multiple Everhour Accounts

  Replicate multiple Everhour accounts to one or many databases.

• Building Dynamic Web Pages with Workday Data Using AngularJS

  Create single-page applications with live connectivity to Workday using the CData API Server.

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

• How to work with Invoiced Data in Apache Spark using SQL

  Access and process Invoiced Data in Apache Spark using the CData Software JDBC Driver.

• How to Build an ETL App for IBM Informix Data in Python with CData Connect AI

  Build ETL pipelines that read and write live IBM Informix in Python with petl and the CData Connect AI Python SDK.

• Create Data Visualizations in Cognos BI with Close Data

  Access Close as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Load Pipeliner CRM Data to a Database Using Embulk

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

• «
• 289
• 290
• 291
• 292
• 293
• 294
• 295
• 296
• 297
• 298
• »