CData Software - Knowledge Base

Recent Articles

---

• «
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• »

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

  Build workflows to access live Certinia data 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 data 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 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Float data in Excel.

• Build Dashboards with Planio Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Planio data 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 Spark data.

• 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 data within automated workflows.

• Access Live SAP HANA XS Advanced Data in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live SAP HANA XS Advanced data from your Google Sheets.

• Replicate PDFMonkey Data in Heroku for Use in Salesforce Connect

  Replicate PDFMonkey data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

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

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

• Build Optimizely Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Optimizely data and build visualizations in Tableau Cloud.

• 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 data.

• Integrate Open WebUI with Live Supabase Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Supabase data from within the chat interface.

• Integrate Act CRM Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Act CRM data 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 data 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 data for you.

• Work with Vault CRM Data in FoxPro

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

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

  Use CData Connect AI to connect to live Shopify data 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 data. 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 Cloudant data 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 data 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 data 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 data from HeidiSQL.

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

  Use the CData ODBC Driver for Cvent to visualize Cvent data 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 data 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 data.

• Build DocuSign-Connected Dashboards Using Zoho Analytics

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

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

  Easily push Jira data 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 data 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 data 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 data.

• Integrate LinkedIn Ads Data in Pentaho Data Integration

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

• Query Adobe Experience Manager Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Adobe Experience Manager data from Node.js.

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

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

• 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 data 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 data 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 data.

• How to Visualize ADP Data in Python with pandas

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

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

  Provide connectivity to ConvertKit data through an SAP BusinessObjects universe.

• Explore Geographical Relationships in Azure DevOps Data with Power Map

  Create data visualizations with Azure DevOps data in Power Map.

• How to integrate Metabase with MySQL Data

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

• 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 data into Microsoft Power Query.

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

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

• Viewing Redshift Data in RAD Studio Data Explorer

  How to view Redshift data 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 data 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 data 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 Greenplum data 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 data from Web apps in Jetty.

• How to connect to CloudConvert Data in DBVisualizer

  Integrate CloudConvert data 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 data in Filemaker Pro for Mac or Windows.

• 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 data for self-service data analytics.

• Automated Continuous Oracle SCM Replication to SQLite

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

• Seamlessly Bring VWO Data into Retool Using CData Connect AI

  Integrate VWO data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.

• 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 data for you.

• Access Live Sugar CRM Data in AWS Lambda

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

• Build Dashboards with TaxJar Data in DBxtra

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

• Automated Productboard Data Replication to Teradata

  Use CData Sync to Customize and automate Productboard data replication to Teradata.

• Analyze Printify Data in Cognos Analytics

  Use CData Connect AI to connect to Printify Data from Cognos Analytics and analyze live Printify data.

• Publish Twilio-Connected Dashboards in Tableau Server via JDBC

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

• 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 data. 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 SQL Server data.

• Visualize IBM Informix Data in Tableau

  The CData ODBC driver for IBM Informix enables you integrate IBM Informix data 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 data 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 data. Leverage the native support for ODBC in PHP.

• Query Instagram Data in ColdFusion

  Write standard ColdFusion data access code to connect to Instagram data.

• Connect to Everhour Data in RapidMiner

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

• Access Live Figshare Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Figshare data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

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

  Integrate Microsoft Exchange data 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 data in ColdFusion.

• Import and Visualize Simplesat Data in Power View

  Create data visualizations based on Simplesat data in Excel.

• Bridge Amplitude Connectivity with Apache NiFi

  Access and process Amplitude data 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.

• How to Connect to Live Figshare Data from Sourcegraph Amp (via CData Connect AI)

  Integrate Sourcegraph Amp with CData Connect AI to query and manage live Figshare data securely in real time.

• Replicate Multiple Everhour Accounts

  Replicate multiple Everhour accounts to one or many databases.

• Connect to ZohoMarketingHub Data as an External Data Source using PolyBase

  Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live ZohoMarketingHub data.

• 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 data in Python with petl and the CData Connect AI Python SDK.

• Create Data Visualizations in Cognos BI with Close Data

  Access Close data 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 data to a database.

• How to connect and process IBM Cloud Object Storage data from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live IBM Cloud Object Storage data.

• Getting Started with the CData Power BI Connector for Strava

  Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.

• «
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• »