CData Software - Knowledge Base

Recent Articles

• «
• 345
• 346
• 347
• 348
• 349
• 350
• 351
• 352
• 353
• 354
• »

• Connect to Acumatica as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Acumatica ERP.

• Publish Crystal Reports on MariaDB

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MariaDB.

• Integrate with ActiveCampaign using Apache Camel2

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

• Create Gmail-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Gmail from OutSystems and build custom enterprise apps using live Gmail.

• How to Connect to & Open PingOne in Microsoft Excel

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

• Import RSS Feeds into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for RSS and create custom reports in the Power BI Service.

• Build a PostgreSQL Interface for Zoho Creator using the CData JDBC Driver

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

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

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

• Bridge SAP ByDesign Connectivity with Apache NiFi

  Access and process SAP Business ByDesign in Apache NiFi using the CData JDBC Driver.

• Automated Continuous YouTube Analytics Replication to Microsoft Access

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

• Connect to CSV in HULFT Integrate

  Connect to CSV as a JDBC data source in HULFT Integrate

• Build Redshift-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Redshift and create custom apps in Mendix.

• How to Work with Bitbucket in AWS Glue Jobs Using JDBC

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

• Load Twilio to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Twilio to a database.

• Rapidly Develop Google Directory-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Integrate Microsoft Exchange in Pentaho Data Integration

  Build ETL pipelines based on Microsoft Exchange in the Pentaho Data Integration tool.

• Connect to Reckon from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Reckon from Filemaker Pro on Mac.

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

  Execute SQL Server queries against Pivotal GreenPlum from Node.js.

• Visualize Live HarperDB in Tableau

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

• Edit and Search External MarkLogic Objects in Salesforce Connect

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

• Automated Continuous Microsoft Teams Replication to AlloyDB

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

• Query Smartsheet as a MySQL Database in Node.js

  Execute MySQL queries against Smartsheet from Node.js.

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

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

• Connect to BigCommerce in JRuby

  Create a simple JRuby app with access to live BigCommerce.

• Author and Share Power BI Reports on Real-Time Zoho Books

  Use the CData ODBC Driver for Zoho Books to visualize Zoho Books in Power BI Desktop and then upload to the Power BI service.

• How to connect to Kintone from IntelliJ

  Integrate connectivity to Kintone with wizards in IntelliJ.

• Automated Continuous Bing Search Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Bing Search replication to Azure SQL.

• Access Live Kintone in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Kintone to create a Kintone source in TIBCO Data Virtualization Studio and gain access to live Kintone from your TDV Server.

• DataBind Charts to Smartsheet

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Smartsheet 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 connect PolyBase to Blackbaud FE NXT

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Blackbaud FE NXT.

• Connect to Shippo from a Connection Pool in WebLogic

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

• Automated Continuous MarkLogic Replication to Microsoft Access

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

• How to Work with SAP SuccessFactors in ETL Validator JDBC

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

• Connect to Zuora as an External Source in Dremio

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

• Replicate Multiple Kafka Accounts via the CData Sync CLI

  Replicate multiple Kafka accounts to one or many databases.

• Connect to Epicor Kinetic from PowerBuilder via ODBC

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce Data Cloud

  Provide connectivity to Salesforce Data Cloud through an SAP BusinessObjects universe.

• Automated Continuous Printify Replication to AlloyDB

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

• How to integrate Gmail with Apache Airflow

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

• Connect to Microsoft Project in Aqua Data Studio

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

• LINQ to Aha

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

• Visualize HBase in Tableau

  The CData ODBC driver for HBase enables you integrate Apache HBase into Tableau dashboards.

• Object-Relational Mapping (ORM) with Klipfolio 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 Klipfolio into a Java-based ORM framework, Hibernate.

• Build Automated Workflows with Live SingleStore in Workato

  Use CData Connect Cloud to connect to live SingleStore and build automated workflows in Workato.

• Visualize Hive in TIBCO Spotfire through OData

  Integrate Apache Hive into dashboards in TIBCO Spotfire.

• Explore Geographical Relationships in Sybase with Power Map

  Create data visualizations with Sybase in Power Map.

• Model LinkedIn Using Azure Analysis Services

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

• Connect to Oracle HCM Cloud from Asprova with CData Software ODBC Driver for Oracle HCM Cloud

  This article shows how to connect faster to Oracle HCM Cloud data from Asprova.

• Import and Visualize NetSuite in Power View

  Create data visualizations based on NetSuite CRM & ERP in Excel.

• Excel Spreadsheet Automation on SAP Ariba Source with the QUERY Formula

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

• LINQ to Harvest

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

• Create Oracle HCM Cloud Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Query Reckon Accounts Hosted through ODBC in Node.js

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

• Connect to Twilio from HeidiSQL

  Use CData Connect Cloud to connect to and query live Twilio from HeidiSQL.

• Visualize Live GitHub in the Power BI Service

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

• Automated Continuous Vertica Replication to Amazon Redshift

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

• Build Salesforce Pardot Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Salesforce Pardot and build visualizations in Tableau.

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

  Provide connectivity to QuickBooks Desktop through an SAP BusinessObjects universe.

• Creating SQL Server-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Microsoft SQL Server to Unqork and build custom business apps.

• Query Amazon Athena as a SQL Server Database in Node.js

  Execute SQL Server queries against Amazon Athena from Node.js.

• Automated Continuous Oracle Sales Replication to Local Delimited Files

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

• Import MYOB AccountRight into FileMaker Pro

  Create reports that integrate MYOB AccountRight in Filemaker Pro.

• Build Visualizations of Oracle SCM in Birst

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

• Build QuickBooks Online-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for QuickBooks Online and create custom apps in Mendix.

• Access Live LinkedIn in Coginiti Pro

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

• How to Seamlessly Import IBM Informix Data into IBM SPSS Modeler

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

• Visualize Live Tally of Power BI Report Builder in Power BI Service

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

• Automated Continuous Sage 300 Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Sage 300 replication to Apache Kafka.

• Create Dynamic DocuSign Grids Using the Infragistics XamDataGrid

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

• Natively Connect to Exact Online in PHP

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

• Build Amazon DynamoDB-Connected Web Apps in Servoy

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

• Using the CData Software ODBC Driver for EventBrite in PyCharm

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

• How to update Twilio from Excel

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

• Connect to Dynamics 365 Business Central from PowerBuilder via JDBC

  This article demonstrates how to access Dynamics 365 Business Central from PowerBuilder using the Dynamics 365 Business Central JDBC Driver.

• Connect to Sage 50 UK in Aqua Data Studio

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

• View Reports on Real-Time Sybase IQ in Power BI Report Server

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

• How to create an RPA flow for Box in UiPath Studio

  Use the Box ODBC Driver to create workflows that access real-time Box without any coding.

• Connect to Oracle Financials Cloud in RazorSQL

  Connect to Oracle Financials Cloud from wizards and query Oracle Financials Cloud from the GUI in the RazorSQL database management tool.

• A PostgreSQL Interface for SAP HANA XS Advanced using the CData ODBC Driver

  Use the SQL Gateway and SAP HANA XS Advanced ODBC Driver to create a PostgreSQL entry-point for data access.

• Create CouchDB-Connected Nintex Workflows

  Use CData Software Connect Server to connect to CouchDB from Nintex Workflow Cloud and build custom workflows using live Apache CouchDB.

• Connect to Phoenix in CloverDX (formerly CloverETL)

  Transfer Apache Phoenix using the visual workflow in the CloverDX data integration tool.

• Connect to MailChimp from PowerBuilder via ODBC

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

• Load Greenhouse to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Greenhouse to a database.

• Integrate Shopify into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Shopify and integrate live Shopify into your Power Automate tasks.

• Connect to Splunk in RazorSQL

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

• Connect to Salesforce Pardot in RapidMiner

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

• How to Access Live Blackbaud FE NXT in Power Automate Desktop via ODBC

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

• Connect to and Visualize Live OData Services in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live OData.

• Create MarkLogic Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for MarkLogic to build custom dashboards in Bold BI.

• Build a Simple VCL Application for SAS Data Sets

  How to build a simple VCL Application to view SAS Data Sets in RAD Studio using the CData ODBC Driver for SAS Data Sets.

• Enable the Azure DevOps JDBC Driver in KNIME

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

• How to connect to xBase from Google Apps Script

  Use CData Software Connect Server to access xBase in Google Apps Script.

• Replicate Multiple Splunk Accounts

  Replicate multiple Splunk accounts to one or many databases.

• How to Seamlessly Import MarkLogic Data into IBM SPSS Modeler

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

• Use Dash to Build to Web Apps on Facebook Ads

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

• Access Live Google Sheets in Google Sheets via Connect Cloud

  Use CData Connect Cloud to gain access to live Google Sheets from your Google Sheets.

• Build Charts with Confluence in Clear Analytics

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

• DataBind Controls to SAP Ariba Source in C++Builder

  DataBind to SAP Ariba Source in C++Builder with standard components and controls.

• Integrate with Live Shopify in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Shopify from the MuleSoft Anypoint Platform to integrate live Shopify into custom reports and dashboards.

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

  Connect to QuickBooks Desktop 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.

• «
• 345
• 346
• 347
• 348
• 349
• 350
• 351
• 352
• 353
• 354
• »