CData Software - Knowledge Base

Recent Articles

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

• Automated Continuous xBase Replication to Local Delimited Files

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

• How to Work with Zuora in ETL Validator JDBC

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

• Integrate with Adobe Commerce in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Adobe Commerce in SnapLogic.

• Visualize Live SurveyMonkey in the Power BI Service

  Use CData Connect Cloud to connect to live SurveyMonkey and create custom reports in the Power BI Service through the On-Premises Gateway.

• How to integrate Shippo with Apache Airflow

  Access and process Shippo in Apache Airflow using the CData JDBC Driver.

• DataBind Charts to Cvent

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

• How to Access Live PostgreSQL in Power Automate Desktop via ODBC

  The CData ODBC Driver for PostgreSQL enables you to integrate PostgreSQL into workflows built using Microsoft Power Automate Desktop.

• Automated Continuous OneNote Replication to PostgreSQL

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

• Integrate SAP HANA XS Advanced in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP HANA XS Advanced from Informatica Cloud.

• How to create Visio diagrams from DB2

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

• DataBind Kafka to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Kafka with the DevExpress Windows Forms and Web controls to provide Apache Kafka to a chart.

• Publish Sybase IQ-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Sybase IQ.

• Visualize Live Azure Table of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Azure Table Storage using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Automate Bullhorn CRM Tasks in Power Automate Using CData API Server

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

• Use the CData ODBC Driver for Google Analytics from SharePoint Excel Services

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

• Import Real-Time Act-On via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Act-On in ColdFusion.

• Add HubSpot to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for HubSpot with the Informatica Enterprise Data Catalog to classify and organize data.

• Automate Sage Cloud Accounting Tasks in Power Automate Using CData API Server

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

• Create SSAS Tabular Models from ADP

  How to build a SQL Server Analysis Service Tabular Model from ADP using CData drivers.

• Build PayPal-Connected Apps in Choreo

  Use CData Connect Cloud to connect to PayPal from Choreo and build custom apps using live PayPal.

• Replicate Zuora in Heroku for Use in Salesforce Connect

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

• Connect to Sugar CRM from Asprova with CData Software ODBC Driver for Sugar CRM

  This article shows how to connect faster to Sugar CRM data from Asprova.

• Natively Connect to PostgreSQL in PHP

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

• Create Power BI Reports on Real-Time Facebook Ads

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

• Perform Batch Operations with LDAP Objects in Apache NiFi

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

• Analyze SAS Data Sets in Slingshot with CData API Server

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

• Use the CData API Server to Access PayPal in Microsoft PowerPivot

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

• Using the CData Software ODBC Driver for Email in PyCharm

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

• Connect and Visualize Live Cosmos DB Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Azure Cosmos DB into the Databricks platform and create visualization dashboards with real-time Azure Cosmos DB.

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

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

• Analyze Outreach.io in Looker

  Use CData Connect Cloud to connect to Outreach.io from Looker and build custom apps using live Outreach.io.

• LINQ to CSV

  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 CSV Data Provider.

• DataBind Controls to Impala in C++Builder

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

• Easily Integrate Zoho Books in Lazarus Pascal IDE

  Learn how to easily integrate live Zoho Books in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Automate LDAP Integration Tasks from PowerShell

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

• How to Connect to Microsoft Exchange in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Microsoft Exchange. Leverage the pyodbc module for ODBC in Python.

• Automated Continuous BigCommerce Replication to MongoDB

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

• Query Calendly as a MySQL Database in Node.js

  Execute MySQL queries against Calendly from Node.js.

• Klipfolio Reporting in OBIEE with the Klipfolio JDBC Driver

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

• How to Query Live SAP Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live SAP ERP/NetWeaver data in natural language using Python.

• Connect to Salesforce Marketing from PowerBuilder via JDBC

  This article demonstrates how to access Salesforce Marketing Cloud from PowerBuilder using the Salesforce Marketing JDBC Driver.

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

  Connect to MongoDB from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• How to Connect to Live Oracle Service Cloud in n8n Workflows and Agents (via CData Connect Cloud)

  Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Oracle Service Cloud for you.

• Integrate with MYOB AccountRight using Apache Camel2

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

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

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

• Connect to MySQL from PowerBuilder via ODBC

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

• Integrate with Azure Active Directory in JReport Designer

  Create charts and reports based on Azure Active Directory in JReport Designer.

• How to Connect to Live Salesforce in n8n Workflows and Agents (via CData Connect Cloud)

  Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Salesforce & Force.com for you.

• Connect to Aha in RazorSQL

  Connect to Aha from wizards and query Aha! from the GUI in the RazorSQL database management tool.

• Build Dashboards with Authorize.Net in DBxtra

  Create dynamic dashboards and perform analytics based on Authorize.Net in DBxtra.

• Working with Raisers Edge NXT in LINQPad

  Execute LINQ queries to Raisers Edge NXT in LINQPad.

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

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

• Build Dashboards with Sage 50 UK in DBxtra

  Create dynamic dashboards and perform analytics based on Sage 50 UK in DBxtra.

• Integrate with Excel Online in JReport Designer

  Create charts and reports based on Microsoft Excel Online in JReport Designer.

• Excel Spreadsheet Automation on Salesforce with the QUERY Formula

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

• Replicate IBM Cloud Object Storage to Multiple Databases

  Replicate IBM Cloud Object Storage to disparate databases with a point-and-click configuration.

• Automated Continuous Certinia Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Certinia replication to Microsoft Access.

• Connect to Sage 300 in Jaspersoft Studio

  Execute SQL to remote Sage 300 in Jaspersoft Studio.

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

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

• How to work with Google Drive in Apache Spark using SQL

  Access and process Google Drive in Apache Spark using the CData Software JDBC Driver.

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

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

• Bidirectional Access to Power BI XMLA from FileMaker Pro

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

• How to connect SharePoint with HDFS through external lists

  Provide Apache HDFS to SharePoint users as an external list.

• How to integrate Amazon DynamoDB with Apache Airflow

  Access and process Amazon DynamoDB in Apache Airflow using the CData JDBC Driver.

• A PostgreSQL Interface for Reckon using the CData ODBC Driver

  Use the SQL Gateway and Reckon ODBC Driver to create a PostgreSQL entry-point for data access.

• Create a Data Access Object for Google Cloud Storage using JDBI

  A brief overview of creating a SQL Object API for Google Cloud Storage in JDBI.

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

  Connect to Google Spanner from a connection pool in Tomcat.

• Design BIRT Reports on Parquet

  Provide current Apache Parquet to your embedded analytics.

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

  Provide connectivity to Sage 300 through an SAP BusinessObjects universe.

• Analyze ADP with Power Pivot

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

• Connect to Avro in DBeaver

  Use the CData ODBC Driver to connect to Apache Avro in DBeaver.

• How to integrate Metabase with Azure Active Directory

  Use CData Connect Cloud to connect to live Azure Active Directory and create an interactive dashboard in Metabase from Azure Active Directory.

• Connect to and Visualize Live Odoo in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Odoo ERP.

• Bidirectional Access to SAP HANA XS Advanced from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate SAP HANA XS Advanced in Filemaker Pro for Mac or Windows.

• Connect and Visualize Live SAP HANA Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live SAP HANA into the Databricks platform and create visualization dashboards with real-time SAP HANA.

• Integrate Microsoft Dataverse in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Dataverse (CDS) from Informatica Cloud.

• Building a JDBC-based MCP Server: A Developer Guide

  This guide explains the architecture, design, and purpose of the MCP Server for JDBC Drivers project.

• Operational Reporting on Amazon Athena from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Amazon Athena.

• Connect to Todoist in Aqua Data Studio

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

• How to connect to Dynamics 365 from Spring Boot

  Connect to Dynamics 365 in a Spring Boot Application using CData JDBC Dynamics 365 Driver

• Bridge Amazon DynamoDB Connectivity with Apache NiFi

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

• Provide OData Services of Instagram from a WCF Application

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

• Design BIRT Reports on Oracle Financials Cloud

  Provide current Oracle Financials Cloud to your embedded analytics.

• Use Biml to Build SSIS Tasks to Replicate Oracle Sales to SQL Server

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

• How to connect and process Authorize.Net from Azure Databricks

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

• Automated Continuous Highrise Replication to Oracle

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

• Build Data Flows from SingleStore to SQL Server using SSIS

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

• Replicate Parquet to Multiple Databases

  Replicate Apache Parquet to disparate databases with a point-and-click configuration.

• Integrate Real-Time Access to Google Search in SAPUI5 MVC Apps

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

• Automated Continuous Amazon S3 Replication to SQL Server

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

• Query GraphQL in DataGrip

  Create a Data Source for GraphQL in DataGrip and use SQL to query live GraphQL.

• How to Query MYOB AccountRight in MySQL Workbench

  Execute MySQL queries against live MYOB AccountRight from MySQL Workbench.

• How to Access Live Typeform in Power Automate Desktop via ODBC

  The CData ODBC Driver for Typeform enables you to integrate Typeform into workflows built using Microsoft Power Automate Desktop.

• Automated Continuous Marketo Replication to Vertica

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

• Connect to Zoho Creator from AWS Glue

  Use CData Connect Cloud to gain access to live Zoho Creator from your AWS Glue jobs.

• Connect to and Query MariaDB in QlikView over ODBC

  Create data visualizations with MariaDB in QlikView.

• Analyze Slack in Cognos Analytics

  Use CData Connect Cloud to connect to Slack from Cognos Analytics and analyze live Slack.

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

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

• Automated Continuous Excel Online Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Excel Online replication to Apache Kafka.

• Connect to Monday.com in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Monday.com in Google Apps Script.

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