CData Software - Knowledge Base

Recent Articles

---

• «
• 392
• 393
• 394
• 395
• 396
• 397
• 398
• 399
• 400
• 401
• »

• Import and Visualize SAP ByDesign Data in Power View

  Create data visualizations based on SAP Business ByDesign in Excel.

• Build Data Flows from xBase to SQL Server using SSIS

  Easily back up xBase to SQL Server using the SSIS components for xBase.

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

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

• Use Grok to Talk to Your Twilio 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 Twilio for you.

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

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

• Replicate SAP ByDesign Data from PowerShell

  Write a quick PowerShell script to query SAP Business ByDesign. Use connectivity to the live data to replicate SAP Business ByDesign to SQL Server.

• Use Biml to Build SSIS Tasks to Replicate Parallel Data to SQL Server

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

• Automated Continuous SurveyMonkey Replication to Databricks

  Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Databricks.

• Automated Continuous Nethunt Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Nethunt replication to PostgreSQL.

• Build AI/ML Models with Live Oracle Service Cloud Data using Dataiku

  Connect Oracle Service Cloud Data with Dataiku using the CData JDBC Driver for Oracle Service Cloud.

• Integrating OpenCode Terminal with Google Ads 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.

• Build SAP Netweaver Gateway-Powered Applications in Claude Code with CData MCP Server

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

• Analyze Placid Data with Power Pivot

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

• Build Automated Jira Assets-Connected Workflows in Zapier

  Use CData Connect AI to connect to live Jira Assets and build automated workflows in Zapier.

• ETL Gmail in Oracle Data Integrator

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for BigQuery

  Provide connectivity to Google BigQuery through an SAP BusinessObjects universe.

• Build Charts with Google Forms Data in Clear Analytics

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

• Create DB2-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to DB2 Data from OutSystems and build custom enterprise apps using live IBM DB2.

• How to Query Live LinkedIn Data in Claude Desktop

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

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

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

• Back Up Facebook Ads to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Facebook Ads. In this article, we will employ an SSIS workflow to populate a database with Facebook Ads data.

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

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

• Model Presto Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Presto, enabling the direct import of real-time Presto.

• Getting Started with the CData JDBC Driver for AgileCRM

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for AgileCRM.

• Work with ZohoInvoice Data in FoxPro

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

• How to Query Live SAP Concur Data in Perplexity MacOS Desktop

  Connect to and query live SAP Concur Data in Perplexity Desktop using CData MCP Server.

• Automated Continuous Clari Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Clari replication to Google Cloud SQL.

• Connect to Excel Data in RazorSQL

  Connect to Excel from wizards and query Microsoft Excel from the GUI in the RazorSQL database management tool.

• How to Connect DBeaver to REST via a JDBC Driver

  Manage REST with visual tools in DBeaver like the query browser.

• Edit and Search External Dynamics 365 Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of Microsoft Dynamics 365 to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Dynamics 365 Data objects that you can access from apps and the dashboard.

• How to Work with Dynamics 365 Data in AWS Glue Jobs Using JDBC

  Connect to Dynamics 365 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Build Semantic Layer Views for Cvent Data in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Cvent.

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

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

• Build Charts with Impala Data in Clear Analytics

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

• Query Google Search Results using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Google Search entities in PHP by modeling them as objects.

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

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

• Connect to Neo4J Data from PowerBuilder via JDBC

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

• Automate Zuora Data Replication to Couchbase

  Use CData Sync to Customize and automate Zuora replication to Couchbase.

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

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

• Visualize Live Salesforce Data 360 Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Salesforce Data 360.

• How to load Deel data into Elasticsearch via Logstash

  Introducing a simple method to load Deel data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Build Dashboards with Reply.io Data in Dundas BI

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

• Connect to Wistia Data in DBeaver

  Use the CData ODBC Driver to connect to Wistia in DBeaver.

• Front Reporting in OBIEE with the Front JDBC Driver

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

• Automate Stripe Data Replication to Couchbase

  Use CData Sync to Customize and automate Stripe replication to Couchbase.

• Natively Connect to Factorial Data in PHP

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

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

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

• Provide OData Services of Databricks Data from a WCF Application

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

• Bidirectional Access to ChartMogul Data from FileMaker Pro

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

• Work with Live Avalara AvaTax Data in Power Query

  Use CData Connect AI to connect to Avalara AvaTax and work with live Avalara AvaTax in Microsoft Power Query.

• Create Data Visualizations Based On CouchDB Data in Mode

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

• NASA Reporting and Star Schemas in OBIEE

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

• Integrating Claude Code CLI with PivotalTracker 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.

• Build Dashboards with OnePageCrm Data in Dundas BI

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

• Build Visualizations of Sybase IQ Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sybase IQ in Birst.

• Automated Continuous Email Replication to MongoDB

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

• Automated Continuous Databricks Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Databricks replication to delimited files (CSV/TSV).

• Use Databricks Agent Bricks to Talk to Your Amazon DynamoDB Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Amazon DynamoDB for you.

• Connect to Amazon S3 Data in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for Amazon S3 Data and connect to Amazon S3 in Akorbi Digital RunMyProcess.

• Automate Dropbox Integration Tasks from PowerShell

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

• Connect to HCL Domino Data from HeidiSQL

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

• Use Manus AI to Talk to Your Sage 200 Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Sage 200.

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

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

• Connect ZohoSubscriptions to IBM WebSphere Using the CData JDBC Driver

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

• CampaignMonitor Reporting in OBIEE with the CampaignMonitor JDBC Driver

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

• Automated Continuous Flowlu Replication to Vertica

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

• How to connect Amazon QuickSight to Oracle Sales Data

  Create a connection to Oracle Sales in CData Connect AI and insert Oracle Sales into Amazon QuickSight SPICE to build interactive dashboards.

• Integrate Jira Assets Data into Power Automate Desktop using CData Connect

  CData Connect for Jira Assets Data enables you to integrate Jira Assets into workflows built using Microsoft Power Automate Desktop.

• Connect to Microsoft Dataverse from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Dataverse (CDS), and over 250 other data sources, right inside your Excel and Google spreadsheets!

• How to Work with Sugar CRM Data in AWS Glue Jobs Using JDBC

  Connect to Sugar CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Getting Started with the CData Tableau Connector for Cassandra

  Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Cassandra.

• Query Rootly Data as a MySQL Database in Node.js

  Execute MySQL queries against Rootly from Node.js.

• Process & Analyze Databricks Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Databricks Data.

• Build Dashboards with Act-On Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Act-On in Dundas BI.

• Enable the JotForm JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with JotForm.

• Connect to Bitbucket Data as an External Source in Dremio

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

• Getting Started with the CData SSIS Components for Mocean

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

• Explore Geographical Relationships in Workable Data with Power Map

  Create data visualizations with Workable in Power Map.

• Automated Continuous Marketo Replication to Azure SQL Database

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

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

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

• Query Simplesat Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Simplesat from Node.js.

• Create Power BI Reports on Real-Time Instantly Data

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

• Connect to ClickTime Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Working with ScrapingBee Data in LINQPad

  Execute LINQ queries to ScrapingBee in LINQPad.

• Replicate Multiple Quickbase Accounts

  Replicate multiple Quickbase accounts to one or many databases.

• Create a Data Access Object for Invoiced Data using JDBI

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

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

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

• Connect to MariaDB Data in NetBeans

  Connect to MariaDB in NetBeans with the data source configuration wizard.

• Getting Started with the CData ODBC Driver for Jodoo

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

• How to Query Live Cvent Data in Claude Desktop

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

• Connect to Paymo Data in Jaspersoft Studio

  Execute SQL to remote Paymo in Jaspersoft Studio.

• How to use SQLAlchemy ORM to access TaxJar Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of TaxJar.

• Build Act-On-Powered Applications in Gemini Code Assist with CData MCP Server

  Use the CData MCP Server for Act-On to explore live Act-On Data in Gemini Code Assist to assist with building Act-On-powered applications.

• Create Reports from Microsoft Planner Data in Looker Studio

  Use CData Connect AI to gain access to live Microsoft Planner and create custom reports in Looker Studio.

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

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

• Create Informatica Mappings From/To an ODBC Data Source for Box

  Create an ODBC connection to Box in Informatica and browse and transfer Box.

• How to Use a Microsoft Access Database to Update Google Drive Data in Real Time

  Update Google Drive data by creating a linked table in Microsoft Access with the CData Google Drive ODBC Driver.

• Analyze HubDB Data with Power Pivot

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

• Connect to Workday Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Workday using standard SQL.

• Bind Live Facebook Ads Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Facebook Ads data

• «
• 392
• 393
• 394
• 395
• 396
• 397
• 398
• 399
• 400
• 401
• »