CData Software - Knowledge Base

Recent Articles

• «
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• »

• Create Datasets from Office 365 in Domo Workbench and Build Visualizations of Office 365 in Domo

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

• Natively Connect to EventBrite in PHP

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

• Build Dynamics 365-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Dynamics 365.

• How to integrate Hive with Apache Airflow

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

• Connect to ShipStation in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Publish JotForm-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live JotForm.

• Build Azure Synapse-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Azure Synapse and create custom apps in Bubble.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Use the CData Software JDBC Driver for ClickUp in MicroStrategy

  Connect to ClickUp in MicroStrategy Developer using the CData Software JDBC Driver for ClickUp.

• How to Build Dynamic React Apps with AlloyDB

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

• Replicate Multiple Monday.com Accounts

  Replicate multiple Monday.com accounts to one or many databases.

• Jira Service Management Reporting in OBIEE with the Jira Service Management JDBC Driver

  Deploy the Jira Service Management JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• How to integrate Basecamp with Apache Airflow

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

• Create FHIR-Connected Business Apps in AppSheet

  Connect to FHIR via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to FHIR.

• Connect to Instagram in CloverDX (formerly CloverETL)

  Transfer Instagram using the visual workflow in the CloverDX data integration tool.

• Automated Continuous HubSpot Replication to Azure SQL

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

• Automate Dropbox Integration Tasks from PowerShell

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

• Analyze Oracle Eloqua in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of Oracle Eloqua and visualize live Oracle Eloqua in Infragistics Reveal.

• Import and Visualize SuiteCRM in Power View

  Create data visualizations based on SuiteCRM in Excel.

• Access Airtable from MySQL in PHP

  Connect to Airtable through the standard MySQL libraries in PHP.

• PowerShell Scripting to Replicate Google Data Catalog to MySQL

  Write a simple PowerShell script to replicate Google Data Catalog to a MySQL database.

• Establish a Live Connection with Facebook using Tableau Bridge

  The CData ODBC Driver for Facebook enables you to integrate live Facebook into Tableau Cloud dashboards using the Tableau Bridge.

• Connect to Gmail in Google Apps Script

  Use the ODBC Driver for Gmail and the SQL Gateway to access Gmail from Google Apps Script.

• Access Live Procore in AWS Lambda (with IntelliJ IDEA)

  Connect to live Procore in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• How to import WooCommerce into Apache Solr

  Use the CData Software JDBC Driver for WooCommerce in Data Import Handler and create an automated import of WooCommerce to Apache Solr Enterprise Search platform.

• Viewing Coinbase in RAD Studio Data Explorer

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

• How to use SQLAlchemy ORM to access Sage Cloud Accounting in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sage Business Cloud Accounting.

• Connect to Pinterest in Jaspersoft Studio

  Execute SQL to remote Pinterest in Jaspersoft Studio.

• LINQ to Invoiced

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

• Use the CData Software ODBC Driver for Salesloft in MicroStrategy Web

  Connect to Salesloft in MicroStrategy Web using the CData Software ODBC Driver for Salesloft.

• Connect to Marketo in CloverDX (formerly CloverETL)

  Transfer Marketo using the visual workflow in the CloverDX data integration tool.

• Integrate Live Veeva into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Veeva Vault and integrate live Veeva Vault into apps built in Microsoft Power Apps.

• How to update SAP Hybris C4C from Excel

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

• Work with SendGrid in FoxPro

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

• How to connect to Workday from Spring Boot

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

• Visualize Live Square in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Square into custom reports in Power BI.

• Automated Continuous Zenefits Replication to Databricks

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

• Automate Sage Intacct Replication to Azure Data Lake

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

• Replicate Multiple Printify Accounts

  Replicate multiple Printify accounts to one or many databases.

• How to connect and process Amazon Marketplace from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Amazon Marketplace

• How to Build an ETL App for SAS Data Sets in Python with CData

  Create ETL applications and real-time data pipelines for SAS Data Sets in Python with petl.

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

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

• Connect to Oracle Eloqua through External Services in Salesforce

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

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

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

• Automated Continuous Procore Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Procore replication to Snowflake.

• How to use SQLAlchemy ORM to access ShipStation in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ShipStation.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Connect to Asana in RapidMiner

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

• Use JayDeBeApi to access Square in Python

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

• How to Work with BigQuery in ETL Validator JDBC

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

• Automated Marketo Replication to Teradata

  Use CData Sync to Customize and automate Marketo replication to Teradata.

• Access Live Google Analytics in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Google Analytics from your Excel spreadsheets.

• Automated Continuous TaxJar Replication to Google Cloud SQL

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

• Build Semantic Layer Views for QuickBooks Online in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for QuickBooks Online.

• Automated Continuous SQL Server Replication to Amazon S3

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

• Build Visualizations of SQL Server in Birst

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

• Import Real-Time Printify in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Printify in ColdFusion.

• Connect to EventBrite from a Connection Pool in Jetty

  The EventBrite JDBC Driver supports connection pooling: This article shows how to connect faster to Eventbrite from Web apps in Jetty.

• Build a Simple VCL Application for IBM Informix

  How to build a simple VCL Application to view IBM Informix in RAD Studio using the CData ODBC Driver for IBM Informix.

• Connect to Live Sage Cloud Accounting in MicroStrategy through CData Connect Cloud

  Create a live connection to Sage Cloud Accounting in CData Connect Cloud and connect to your Sage Business Cloud Accounting from MicroStrategy.

• Edit and Search External Invoiced Objects in Salesforce Connect

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

• Visualize Live Tableau CRM Analytics in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Tableau CRM Analytics.

• Publish Freshdesk-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Freshdesk.

• Use the CData Software ODBC Driver for HCL Domino in MicroStrategy Web

  Connect to HCL Domino in MicroStrategy Web using the CData Software ODBC Driver for HCL Domino.

• Access Live IBM Informix in Coginiti Pro

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

• Access Google Ads as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Ads from your Oracle system.

• Create Oracle Financials Cloud-Connected Enterprise Applications in OutSystems

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

• Build Oracle Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Oracle Database and build visualizations in Tableau.

• Connect to Salesforce from AWS Glue

  Use CData Connect Cloud to gain access to live Salesforce & Force.com from your AWS Glue jobs.

• LINQ to Reckon

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

• Back Up CSV/TSV Files to SQL Server through SSIS

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Automated Continuous Databricks Replication to Local Delimited Files

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

• Visualize Live Zoho CRM in the Power BI Service

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

• Create Excel Online Dataflows on PowerBI.com

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

• Connect to Invoiced in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Invoiced in the Denodo Virtual DataPort Administrator.

• Automate QuickBooks Online Replication to Azure Data Lake

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

• Create Apps from Azure DevOps in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Azure DevOps and build apps from live Azure DevOps in Qlik Sense Cloud.

• Automated Continuous Impala Replication to PostgreSQL

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

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

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

• How to import Salesforce Marketing into Apache Solr

  Use the CData Software JDBC Driver for Salesforce Marketing in Data Import Handler and create an automated import of Salesforce Marketing Cloud to Apache Solr Enterprise Search platform.

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

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

• Analyze LDAP Objects in R

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

• Connect to Tableau CRM Analytics from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Tableau CRM Analytics from Filemaker Pro on Mac.

• Connect to Sage Cloud Accounting in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Sage Cloud Accounting and connect to Sage Business Cloud Accounting in Akorbi Digital RunMyProcess.

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

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

• A PostgreSQL Interface for Xero

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

• How to Work with HubSpot in ETL Validator JDBC

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

• Build Visualizations of Live Phoenix in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for Apache Phoenix and build custom reports in Power BI.

• Publish Oracle SCM-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Oracle SCM.

• How to Build Dynamic React Apps with Excel Online

  Use the CData Connect and React to Build Dynamic Web Apps with Live Excel Online .

• Natively Connect to OData Services in PHP

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

• Create Oracle Financials Cloud-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Oracle Financials Cloud from Nintex Workflow Cloud and build custom workflows using live Oracle Financials Cloud.

• Connect to QuickBooks Time in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for QuickBooks Time and connect to QuickBooks Time in Akorbi Digital RunMyProcess.

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

• «
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• »