CData Software - Knowledge Base

Recent Articles

• «
• 798
• 799
• 800
• 801
• 802
• 803
• 804
• 805
• 806
• 807
• »

• Getting Started with the CData Excel Add-In for JotForm

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

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

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

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

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

  Connect to Elasticsearch from a connection pool in Tomcat.

• Working with ConstantContact in LINQPad

  Execute LINQ queries to ConstantContact in LINQPad.

• Back Up Tally ERP to SQL Server through SSIS

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

• How to Access Live GitHub in Visual Studio Code via Cline

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

• Analyze Zoho Books in Infragistics Reveal

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

• Getting Started with the CData Excel Add-In for SAS xpt

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

• ETL Certinia in Oracle Data Integrator

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

• DataBind Controls to HBase in Delphi

  DataBind to Apache HBase in Delphi with standard data access components and controls.

• How to update AlloyDB from Excel

  This article explains how to transfer data from Excel to AlloyDB using the Excel Add-In for AlloyDB.

• Excel Spreadsheet Automation on DocuSign with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Connect to Clio in Ruby

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

• Operational Reporting on Dynamics CRM from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Dynamics CRM.

• Build Data Flows from SQL Server to Splunk through SSIS

  Easily push SQL Server data to Splunk using the CData SSIS Tasks for Splunk.

• Perform Batch Operations with MongoDB in Apache NiFi

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

• Use JayDeBeApi to access EnterpriseDB in Python

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

• Connect to Drip in Aqua Data Studio

  Access Drip from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Extend Google Sheets with Avalara AvaTax

  Make calls to the API Server from Google Apps Script.

• Query Elasticsearch through ODBC in Node.js

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

• Process & Analyze Twilio in Databricks (AWS)

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

• How to Access BigCommerce Using Entity Framework

  This article shows how to access BigCommerce using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Access Live Acumatica in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Acumatica ERP from your Excel spreadsheets.

• Automated Continuous Google Sheets Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Google Sheets replication to OneLake in Microsoft Fabric.

• Connect to Sage Cloud Accounting in Ruby

  Connect to Sage Business Cloud Accounting in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Viewing Amazon Marketplace in RAD Studio Data Explorer

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

• Write a Simple Go Application to work with GitHub on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to GitHub.

• Access Live GraphQL in Excel 365 Online (Excel for the web)

  Connect to GraphQL from Excel 365 Online (Excel for the web) with CData Connect AI.

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

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

• PowerShell Scripting to Replicate Microsoft Exchange to MySQL

  Write a simple PowerShell script to replicate Microsoft Exchange to a MySQL database.

• Using the CData Software ODBC Driver for Act-On in PyCharm

  Connect to Act-On as an ODBC data source in PyCharm using the CData Software ODBC Driver for Act-On.

• Analyze Twitter Ads in Slingshot with CData API Server

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

• Connect to Reckon Accounts Hosted in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect Sage 50 UK to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

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

• Connect to Live SAP Hybris C4C in PostGresSQL Interface through CData Connect AI

  Create a live connection to SAP Hybris C4C in CData Connect AI and connect to your SAP Hybris C4C from PostgreSQL.

• DataBind Charts to IBM Informix

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

• Connect to and Query Splunk in QlikView over ODBC

  Create data visualizations with Splunk in QlikView.

• Build Oracle Eloqua Reporting-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Oracle Eloqua Reporting and build web apps with connectivity to live Oracle Eloqua Reporting.

• Connect to Databricks in JRuby

  Create a simple JRuby app with access to live Databricks.

• Create Dashboards and Visualize Live ADP in Geckoboard

  Use CData Connect AI to connect to live ADP and create dashboards for real-time monitoring and visualization in Geckoboard.

• Use the CData ODBC Driver for SAP Concur from SharePoint Excel Services

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

• Build Charts with Zoom in Clear Analytics

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

• Automated Continuous Google Calendar Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Google Calendar replication to Apache Cassandra.

• Access Instagram from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Instagram from HeidiSQL.

• Create SAP Hybris C4C-Connected Applications in Appsmith

  Connect to SAP Hybris C4C via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Hybris C4C.

• SAP Business One Reporting in OBIEE with the SAP Business One JDBC Driver

  Deploy the SAP Business One JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Integrate Live API into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to API from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live API.

• Integrating Dataiku with ServiceNow via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ServiceNow.

• How to connect to GraphQL from Spring Boot

  Connect to GraphQL in a Spring Boot Application using CData JDBC GraphQL Driver

• Use Dash to Build to Web Apps on FTP

  Create Python applications that use pandas and Dash to build FTP-connected web apps.

• DataBind Charts to Elasticsearch

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

• Query Airtable using the OData SDK for PHP

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

• Publish Reports with Oracle Eloqua Reporting in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Oracle Eloqua Reporting.

• How to Connect to Live Impala from Google ADK Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Apache Impala for you.

• Connect to Microsoft Project as a Linked Server via SQL Gateway

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

• Work with Zoho Books in FoxPro

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

• Connect Jira Service Management to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Atlassian Jira Service Management using the CData Python MCP Server.

• Access Live Excel in Coginiti Pro

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

• DataBind Controls to Splunk in C++Builder

  DataBind to Splunk in C++Builder with standard components and controls.

• Replicate Zoom to Multiple Databases via the CData Sync CLI

  Replicate Zoom to disparate databases with a single configuration.

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

  Connect to SAP HANA XS Advanced in MicroStrategy Desktop using the CData Software ODBC Driver for SAP HANA XS Advanced.

• Build an OLAP Cube in SSAS from SAP Fieldglass

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

• Migrating data from Amazon Athena to Snowflake using CData SSIS Components.

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

• Build a PostgreSQL Interface for HubSpot using the CData JDBC Driver

  Use the Remoting features of the HubSpot JDBC Driver to create a PostgreSQL entry-point for data access.

• Access Sybase in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Sybase.

• Extract, Transform, and Load Oracle Service Cloud in Informatica PowerCenter

  Create a simple Workflow for Oracle Service Cloud in Informatica PowerCenter.

• Access Live Kafka in Coginiti Pro

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

• Build a PostgreSQL Interface for Certinia using the CData JDBC Driver

  Use the Remoting features of the Certinia JDBC Driver to create a PostgreSQL entry-point for data access.

• Connect JDBC-ODBC Bridge to IBM WebSphere Using the CData JDBC Driver

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

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

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

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

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

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

  Provide connectivity to LinkedIn Ads through an SAP BusinessObjects universe.

• Natively Connect to Jira Assets in PHP via ODBC (Linux)

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

• Integrating LangChain with SAP Concur via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Concur within automated workflows.

• Getting Started with the CData ODBC Driver for Google Search

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

• Analyze API in Slingshot with CData API Server

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

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

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

• Object-Relational Mapping (ORM) with Sage 50 UK Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Sage 50 UK into a Java-based ORM framework, Hibernate.

• Create Datasets from eBay Analytics in Domo Workbench and Build Visualizations of eBay Analytics in Domo

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

• How to Create Power BI Visual Reports with Real-Time Facebook Ads

  Use CData Power BI Connectors to visualize Facebook Ads in Power BI.

• Use Biml to Build SSIS Tasks to Replicate Excel to SQL Server

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

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

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

• Connect to Salesforce Marketing in SpagoBI

  Create reports featuring live Salesforce Marketing Cloud in SpagoBI Studio. Host Salesforce Marketing reports on SpagoBI Server.

• Choosing the Best Method to Connect Okta to SQL Server: 5 Options Explained

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

• Extract, Transform, and Load Salesforce Pardot in Informatica PowerCenter

  Create a simple Workflow for Salesforce Pardot in Informatica PowerCenter.

• Automated Continuous eBay Analytics Replication to SQL Server

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

• Connect to REST from PowerBuilder via ADO.NET

  This article demonstrates how to access REST from Appeon PowerBuilder using the CData ADO.NET Provider for REST.

• DataBind Controls to SAS Data Sets in Delphi

  DataBind to SAS Data Sets in Delphi with standard data access components and controls.

• Use the CData API Server to Access Google Drive in Microsoft PowerPivot

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

• Query Smartsheet as a SQL Server Database in Node.js

  Execute SQL Server queries against Smartsheet from Node.js.

• Connect to SAP ByDesign from PowerBuilder via ADO.NET

  This article demonstrates how to access SAP Business ByDesign from Appeon PowerBuilder using the CData ADO.NET Provider for SAP ByDesign.

• Integrate with Highrise using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Highrise CRM to a JSON file on disk.

• Connect to Zoho Creator from PowerBuilder via ADO.NET

  This article demonstrates how to access Zoho Creator from Appeon PowerBuilder using the CData ADO.NET Provider for Zoho Creator.

• Integrate Adobe Commerce in Your Informatica Cloud Instance

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

• Visualize Live Drift in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Drift.

• How to connect PolyBase to Impala

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache Impala.

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

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

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

• «
• 798
• 799
• 800
• 801
• 802
• 803
• 804
• 805
• 806
• 807
• »