CData Software - Knowledge Base

Recent Articles

• «
• 189
• 190
• 191
• 192
• 193
• 194
• 195
• 196
• 197
• 198
• »

• Bridge MariaDB Connectivity with Apache NiFi

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

• Feed LinkedIn into FineReport

  How to set LinkedIn as a JDBC data source in FineReport.

• Query Oracle Sales as a MySQL Database in Node.js

  Execute MySQL queries against Oracle Sales from Node.js.

• Build a Simple VCL Application for NetSuite

  How to build a simple VCL Application to view NetSuite CRM & ERP in RAD Studio using the CData ODBC Driver for NetSuite.

• Analyze Oracle Eloqua in R

  Use standard R functions and the development environment of your choice to analyze Oracle Eloqua with the CData JDBC Driver for Oracle Eloqua.

• How to Connect the Power BI Service to XML: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Automated Continuous OneNote Replication to Google Cloud SQL

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

• Integrate Live ServiceNow into Amazon SageMaker Canvas with RDS

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

• Visualize Adobe Commerce in Sisense

  Create an ElastiCube in Sisense app with access to Adobe Commerce.

• Extract, Transform, and Load Amazon S3 in Informatica PowerCenter

  Create a simple Workflow for Amazon S3 in Informatica PowerCenter.

• Prepare, Blend, and Analyze Oracle Eloqua in Alteryx Designer

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

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

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

• How to Build Dynamic React Apps with Google Calendar

  Use the CData Connect and React to Build Dynamic Web Apps with Live Google Calendar .

• Connect to SAS xpt as a Linked Server

  Use CData Connect to set up a linked server for SAS XPORT.

• Connect to Reckon from a Connection Pool in JBoss

  Integrate Reckon into Java servlets: Use the Management Console in JBoss to install the Reckon JDBC Driver.

• Automate Snapchat Ads Integration Tasks from PowerShell

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

• Visualize SQL Analysis Services in Sisense

  Create an ElastiCube in Sisense app with access to SQL Analysis Services.

• Visualize Live Salesforce Marketing in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Salesforce Marketing Cloud.

• Feed Coinbase into FineReport

  How to set Coinbase as a JDBC data source in FineReport.

• Using the CData Software ODBC Driver for SQL Server in PyCharm

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

• Analyze Avalara AvaTax with Power Pivot

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

• Integrate Blackbaud FE NXT in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Blackbaud FE NXT from Informatica Cloud.

• Create JotForm-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to JotForm from AppSheet and build custom business apps using live JotForm.

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

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

• How to pipe Sugar CRM to CSV in PowerShell

  Use standard PowerShell cmdlets to access Sugar CRM tables.

• Query Aha as a SQL Server in Node.js

  Execute SQL Server queries against Aha! from Node.js.

• Connect to PostgreSQL from PowerBuilder

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

• Automated Continuous Zenefits Replication to Azure SQL

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

• Access Twilio from MySQL in PHP

  Connect to Twilio through the standard MySQL libraries in PHP.

• Connect to Couchbase in SpagoBI

  Create reports featuring live Couchbase in SpagoBI Studio. Host Couchbase reports on SpagoBI Server.

• Automated Continuous Bing Ads Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Bing Ads replication to SQL Server.

• Using the CData Software ODBC Driver for MongoDB in PyCharm

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

• Stream Azure Synapse into Apache Kafka Topics

  Access and stream Azure Synapse in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Create a Data Access Object for Sage 200 using JDBI

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

• DataBind Azure Synapse to the DevExpress Data Grid

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

• Automated Sage 200 Replication to Teradata

  Use CData Sync to Customize and automate Sage 200 replication to Teradata.

• Replicate Azure Active Directory from PowerShell

  Write a quick PowerShell script to query Azure Active Directory. Use connectivity to the live data to replicate Azure Active Directory to SQL Server.

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

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

• Analyze ClickUp in R

  Create data visualizations and use high-performance statistical functions to analyze ClickUp in Microsoft R Open.

• Connect to Workday from a Connection Pool in WebLogic

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

• Automate Calendly Integration Tasks from PowerShell

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

• Connect to Monday.com from PowerBuilder

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

• Automate Asana Integration Tasks from PowerShell

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

• Create Apps from Excel Online in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Excel Online and build apps from live Microsoft Excel Online in Qlik Sense Cloud.

• Build Visualizations of SharePoint in Birst

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

• Integrate Instagram with External Services using SnapLogic

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

• Automated Continuous IBM Cloud Data Engine Replication to Databricks

  Use CData Sync for automated, continuous, customizable IBM Cloud Data Engine replication to Databricks.

• Author and Share Power BI Reports on Real-Time Sybase

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

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

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

• Replicate Multiple Sybase IQ Accounts

  Replicate multiple Sybase IQ accounts to one or many databases.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Analyze Dropbox in R

  Create data visualizations and use high-performance statistical functions to analyze Dropbox in Microsoft R Open.

• Visualize SAS Data Sets in TIBCO Spotfire through ADO.NET

  Integrate SAS Data Sets into dashboards in TIBCO Spotfire.

• Connect to Epicor Kinetic in RazorSQL

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

• Use the CData Software ODBC Driver for Jira Assets in MicroStrategy

  Connect to Jira Assets in MicroStrategy Developer using the CData Software ODBC Driver for Jira Assets.

• Access Parquet from MySQL in Amazon QuickSight

  Connect to Parquet and build visualizations of Apache Parquet using a MySQL Connection in Amazon QuickSight.

• Connect to Live NetSuite in MicroStrategy through CData Connect Cloud

  Create a live connection to NetSuite in CData Connect Cloud and connect to your NetSuite CRM & ERP from MicroStrategy.

• Author and Share Power BI Reports on Real-Time Salesforce Marketing

  Use the CData ODBC Driver for Salesforce Marketing to visualize Salesforce Marketing Cloud in Power BI Desktop and then upload to the Power BI service.

• Import Real-Time HarperDB in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use HarperDB in ColdFusion.

• How to load Azure Data Catalog data into Elasticsearch via Logstash

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

• Build Automated Workflows with Live Google Contacts in Workato

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

• Connect to MailChimp from a Connection Pool in JBoss

  Integrate MailChimp into Java servlets: Use the Management Console in JBoss to install the MailChimp JDBC Driver.

• Visualize Live Acumatica in the Power BI Service

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

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

  Provide connectivity to eBay Analytics through an SAP BusinessObjects universe.

• Publish Crystal Reports on Pipedrive

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

• DataBind Charts to EnterpriseDB

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

• Microsoft Project Reporting in OBIEE with the Microsoft Project JDBC Driver

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

• Integrate Google Campaign Manager 360 with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Google Campaign Manager 360 with External Services.

• Use the CData Software ODBC Driver for IBM Cloud Data Engine in MicroStrategy Web

  Connect to IBM Cloud Data Engine in MicroStrategy Web using the CData Software ODBC Driver for IBM Cloud Data Engine.

• How to pipe Microsoft OneDrive to CSV in PowerShell

  Use standard PowerShell cmdlets to access Microsoft OneDrive tables.

• Create a Data Access Object for PostgreSQL using JDBI

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

• Rapidly Develop Confluence-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.

• Connect to Outreach.io in Google Apps Script

  Use CData Connect Cloud to access Outreach.io in Google Apps Script.

• Automated Continuous Oracle Service Cloud Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to Amazon S3.

• Connect to Square through External Services in Salesforce

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

• A PostgreSQL Interface for Azure Analysis Services

  Use the Remoting features of the Azure Analysis Services ODBC Driver to create a PostgreSQL entry-point for data access.

• Natively Connect to Workday in PHP

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

• How to connect to SAS xpt in DBVisualizer

  Integrate SAS XPORT with visual data analysis tools and data connection wizards in DBVisualizer

• Automate Google Sheets Replication to Couchbase

  Use CData Sync to Customize and automate Google Sheets replication to Couchbase.

• LINQ to Outreach.io

  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 Outreach.io Data Provider.

• DataBind Charts to Oracle Sales

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

• Integrate Amazon S3 into Power Automate Desktop using CData Connect

  CData Connect for Amazon S3 enables you to integrate Amazon S3 into workflows built using Microsoft Power Automate Desktop.

• Import Real-Time Amazon DynamoDB in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Amazon DynamoDB in ColdFusion.

• How to connect to Snapchat Ads in DBVisualizer

  Integrate Snapchat Ads with visual data analysis tools and data connection wizards in DBVisualizer

• Back Up SAP SuccessFactors to SQL Server through SSIS

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

• Create SSAS Tabular Models from Trello

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

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

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

• Edit and Search External Microsoft OneDrive Objects in Salesforce Connect

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

• Natively Connect to MYOB AccountRight in PHP

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

• Author and Share Power BI Reports on Real-Time Azure Data Lake Storage

  Use the CData ODBC Driver for Azure Data Lake Storage to visualize Azure Data Lake Storage in Power BI Desktop and then upload to the Power BI service.

• Connect to Oracle Service Cloud in RazorSQL

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

• Integrate with Greenhouse using Apache Camel2

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

• How to connect PolyBase to Zoho Inventory

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

• Visualize Okta from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Okta.

• Connect to JSON Services from PowerBuilder

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

• Import Real-Time Amazon Marketplace in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Amazon Marketplace in ColdFusion.

• Use CData Connect Cloud to Access Xero in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Xero Accounting in the Power Pivot business intelligence tool.

• Integrate SAP Hybris C4C in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Hybris C4C from Informatica Cloud.

• Use Dash to Build to Web Apps on SAP Ariba Procurement

  Create Python applications that use pandas and Dash to build SAP Ariba Procurement-connected web apps.

• Automated Continuous SQL Server Replication to Databricks

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

• «
• 189
• 190
• 191
• 192
• 193
• 194
• 195
• 196
• 197
• 198
• »