CData Software - Knowledge Base

Recent Articles

---

• «
• 173
• 174
• 175
• 176
• 177
• 178
• 179
• 180
• 181
• 182
• »

• Use the CData SSIS Components to Insert New or Update Existing Exact Online Records from SQL Server

  Easily push SQL Server data to Exact Online using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Exact Online or update existing records with data from a SQL Server database.

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

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

• Build MVC Applications with Connectivity to Accelo Data

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

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

• ETL Billsby in Oracle Data Integrator

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

• Extend Google Sheets with Nethunt Data

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

• Perform Batch Operations with Active Directory Data in Apache NiFi

  Connect to Active Directory and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• How to Connect to & Open Vault CRM Data in Microsoft Excel

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

• Getting Started with the CData ODBC Driver for LightSpeedRetail

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

• DataBind Apify Data to the DevExpress Data Grid

  Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Apify to a chart.

• Query, Visualize, and Share live Twitter Ads Data in Redash

  Use CData Connect AI to connect to live Twitter Ads in Redash for querying, visualizing, and sharing.

• Moving Data from PabblySubscriptions to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live PabblySubscriptions data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Bind Live Parquet Data in Wijmo FlexGrid with CData API Server

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

• Connect to Real-Time SparkPost Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData API Driver for Power BI and Dataflow to import and use SparkPost in Power Apps.

• Automated Continuous Cloudflare Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Cloudflare replication to SingleStore.

• Square Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Square through CData Connect AI using different applications and tools.

• Automated Continuous Trello Replication to PostgreSQL

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

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

• Automated Continuous Salesforce Pardot Replication to Vertica

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

• Connecting Moonlit Workflow with Trello Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Trello in real time.

• Automate Box Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Box replication to Azure Data Lake.

• How to connect and process Todoist from Azure Databricks

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

• DataBind Charts to SAP HANA XS Advanced Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP HANA XS Advanced 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.

• Work with EmailOctopus Data in FoxPro

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

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

• How to Seamlessly Import Superchat Data into IBM SPSS Modeler

  Integrate Superchat data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• How to connect SharePoint with ZohoMarketingHub Data through external lists

  Provide ZohoMarketingHub to SharePoint users as an external list.

• How to Query LDAP Objects in MySQL Workbench

  Execute MySQL queries against live LDAP from MySQL Workbench.

• Creating LinkedIn Ads-Connected Applications in Unqork

  You can use CData Connect AI to feed LinkedIn Ads to Unqork and build custom business apps.

• How to Connect to Live Microsoft Teams Data from Gemini CLI (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Microsoft Teams for you.

• Enable the HubDB JDBC Driver in KNIME

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

• Visualize Sybase Data in TIBCO Spotfire through OData

  Integrate Sybase into dashboards in TIBCO Spotfire.

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

• How to create Visio diagrams from IBM Informix Data

  Automatically update IBM Informix with the changes you make to Visio master shapes.

• Access Live Office 365 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 Microsoft Office 365 through MCP integration.

• How to Connect DBeaver to Google Ad Manager via a JDBC Driver

  Manage Google Ad Manager with visual tools in DBeaver like the query browser.

• How to connect Amazon QuickSight to Shopify Data

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

• Connect to SAP Business One Data from PowerBuilder via ODBC

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

• Work with Amazon S3 Data in FoxPro

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

• Create Data Visualizations in Cognos BI with Sugar CRM Data

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

• Choosing the Best Method to Connect SAP BusinessObjects BI to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use SAP BusinessObjects BI from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• How to integrate SAS Data Sets with Apache Airflow

  Access and process SAS Data Sets in Apache Airflow using the CData JDBC Driver.

• Visualize Unbounce Data in TIBCO Spotfire through OData

  Integrate Unbounce into dashboards in TIBCO Spotfire.

• Integrate Impala with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Impala with External Services.

• Work with Perigon Data in FoxPro

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

• Design BIRT Reports on Google Translate Data

  Provide current Google Translate to your embedded analytics.

• Use the CData Software JDBC Driver for SAP HANA XS Advanced in MicroStrategy

  Connect to SAP HANA XS Advanced in MicroStrategy Developer using the CData Software JDBC Driver for SAP HANA XS Advanced.

• How to Import Data from Qualaroo into Google Sheets

  Import Qualaroo into a Google spreadsheet that is automatically refreshed.

• Create Data Visualizations in Cognos BI with Recurly Data

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

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

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

• Integrate Redshift with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Redshift with External Services.

• Grafana Reporting in OBIEE with the Grafana JDBC Driver

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

• Manage Zoho Books Data in DBArtisan as a JDBC Source

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

• Access Live SQL Analysis Services Data in TIBCO Data Virtualization

  Use the SQL Analysis Services Tibco DV Adapter to create a SQL Analysis Services data source in TIBCO Data Virtualization Studio and gain access to live SQL Analysis Services from your TDV Server.

• Analyze Teamwork Data with Power Pivot

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

• Build Couchbase-Connected Web Apps in Servoy

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

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

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

• Build an OLAP Cube in SSAS from PingOne Data

  Establish a connection to PingOne data from SQL Server Analysis Services, and use the PingOne Data Provider to build OLAP cubes for use in analytics and reporting.

• Connect to SAP Concur Data in JRuby

  Create a simple JRuby app with access to live SAP Concur.

• Automated Continuous Pipeliner CRM Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Amazon Redshift.

• Query Reckon Accounts Hosted Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Reckon Accounts Hosted from Node.js.

• Manage SAS xpt Data in DBArtisan as a JDBC Source

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

• Deploy the ADO.NET Provider for Optimizely on an SSRS Report Server

  Connect to Optimizely from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Configure the CData JDBC Driver for ZohoMarketingHub in a Connection Pool in Tomcat

  Connect to ZohoMarketingHub from a connection pool in Tomcat.

• Automate SharePoint Data Replication to Couchbase

  Use CData Sync to Customize and automate Microsoft SharePoint replication to Couchbase.

• Build PostgreSQL-Connected Visualizations in datapine

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

• Create Dynamic Certinia Grids Using the Infragistics XamDataGrid

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

• How to Connect DBeaver to MySQL via a JDBC Driver

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

• Connect to Authorize.Net Data in HULFT Integrate

  Connect to Authorize.Net as a JDBC data source in HULFT Integrate

• Extend Google Sheets with xBase Data

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

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

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

• Connect to SendPulse Data in Ruby

  Connect to SendPulse in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

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

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

• Import and Visualize Xero Data in Power View

  Create data visualizations based on Xero Accounting in Excel.

• Access Live Microsoft Ads Data in Coginiti Pro

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

• Build FTP-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live FTP Servers.

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

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

• Integrate Live Foursquare Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Foursquare to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

• Connect to Microsoft Dataverse Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dataverse (CDS).

• Build Google Contacts-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live Google Contacts and build Google Contacts-connected web apps with Axios.

• Connect to Live Adobe Analytics Data in MicroStrategy through CData Connect AI

  Create a live connection to Adobe Analytics Data in CData Connect AI and connect to your Adobe Analytics from MicroStrategy.

• Access Teamwork Data from MySQL in PHP

  Connect to Teamwork through the standard MySQL libraries in PHP.

• How to Create Power BI Visual Reports with Real-Time Neo4J Data

  Use CData Power BI Connectors to visualize Neo4J in Power BI.

• Replicate Raisers Edge NXT Data to Multiple Databases

  Replicate Raisers Edge NXT to disparate databases with a point-and-click configuration.

• Connect to Datadog from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Datadog to connect to Datadog from Web applications running on WebLogic.

• Migrating data from Invoiced to Databricks using CData SSIS Components.

  Easily push Invoiced to Databricks using the CData SSIS Tasks for Invoiced and Databricks.

• Automated Continuous Elorus Replication to Azure SQL Database

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

• Build Semantic Layer Views for Zoho Inventory Data in APOS Live Data Gateway

  Use the CData Connector for Zoho Inventory in APOS Live Data Gateway to build Semantic Layer Views for Zoho Inventory.

• How to connect Amazon QuickSight to NetSuite Data

  Create a connection to NetSuite CRM & ERP in CData Connect AI and insert NetSuite CRM & ERP into Amazon QuickSight SPICE to build interactive dashboards.

• Back Up SurveyMonkey to SQL Server through SSIS

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

• How to integrate Metabase with Twilio Data

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

• Connect to Zoho Inventory Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Zoho Inventory Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Edit and Search QuickBooks External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of QuickBooks Desktop to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create QuickBooks objects that you can access from apps and the dashboard.

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

  Create a simple Workflow for Elasticsearch in Informatica PowerCenter.

• How to connect SharePoint with CloudConvert Data through external lists

  Provide CloudConvert to SharePoint users as an external list.

• Connecting Mastra with AlloyDB 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 Google AlloyDB, no replication required.

• Automated Continuous Sendwithus Replication to AlloyDB

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

• Work with Contentful Data in FoxPro

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

• DataBind Controls to Authorize.Net Data in Delphi

  DataBind to Authorize.Net in Delphi with standard data access components and controls.

• Automate Tasks in Power Automate Using the CData API Server

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

• «
• 173
• 174
• 175
• 176
• 177
• 178
• 179
• 180
• 181
• 182
• »