CData Software - Knowledge Base

Recent Articles

• «
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• »

• How to connect PolyBase to LinkedIn Ads

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

• Automated Continuous Act-On Replication to Vertica

  Use CData Sync for automated, continuous, customizable Act-On replication to Vertica.

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

• Automated Continuous WooCommerce Replication to Databricks

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

• Publish OneNote-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Microsoft OneNote.

• Add Active Directory to Informatica Enterprise Data Catalog

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

• Automated Continuous ADP Replication to Vertica

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

• Build Pipelines with Live Avalara AvaTax in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Avalara AvaTax from Google Cloud Data Fusion, enabling the integration of live Avalara AvaTax into the building and management of effective data pipelines.

• Visualize Azure Analysis Services in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Azure Analysis Services into TIBCO Spotfire.

• Connect to Google Search Results from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Google Search using standard SQL.

• Connect to SharePoint from a Connection Pool in Jetty

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

• Enable the Facebook JDBC Driver in KNIME

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

• Use the CData ODBC Driver for Salesforce Data Cloud from SharePoint Excel Services

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

• Automated Continuous Airtable Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Airtable replication to SingleStore.

• Perform Batch Operations with Sugar CRM in Apache NiFi

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

• How to connect Amazon QuickSight to Azure Synapse

  Create a connection to Azure Synapse in CData Connect Cloud and insert Azure Synapse into Amazon QuickSight SPICE to build interactive dashboards.

• Connect to and Visualize Live Klaviyo in Tableau Prep

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

• Extract, Transform, and Load Adobe Analytics in Informatica PowerCenter

  Create a simple Workflow for Adobe Analytics in Informatica PowerCenter.

• Create Reports with Twitter in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Twitter.

• Analyze MongoDB in Looker

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

• Validate Salesforce Marketing with QuerySurge

  Access and validate Salesforce Marketing Cloud in QuerySurge using the CData JDBC Driver.

• Visualize Oracle Service Cloud in TIBCO Spotfire through OData

  Integrate Oracle Service Cloud into dashboards in TIBCO Spotfire.

• Automate Google Drive Tasks in Power Automate Using CData API Server

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

• Use the CData Software JDBC Driver for Google Ad Manager in MicroStrategy Web

  Connect to Google Ad Manager in MicroStrategy Web using the CData Software JDBC Driver for Google Ad Manager.

• Automated Continuous Azure Data Lake Storage Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to delimited files (CSV/TSV).

• Replicate Bullhorn CRM to Multiple Databases

  Replicate Bullhorn CRM to disparate databases with a point-and-click configuration.

• Automate SAP Business One Replication to SAP HANA

  Use CData Sync to customize and automate SAP Business One replication to SAP HANA.

• How to Work with Acumatica in ETL Validator JDBC

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

• SAP Hybris C4C Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Hybris C4C through CData Connect Cloud using different applications and tools.

• Access NetSuite as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access NetSuite CRM & ERP from your Oracle system.

• Connect to Klipfolio in DBeaver

  Use the CData ODBC Driver to connect to Klipfolio in DBeaver.

• Integrate with Live Azure Analysis Services in MuleSoft (via CData Connect Cloud)

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

• Provide OData Services of Xero from a WCF Application

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

• Connect to Oracle Sales from a Connection Pool in JBoss

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

• Provide OData Services of PingOne from a WCF Application

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

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

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

• Process & Analyze Cvent in Databricks (AWS)

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

• Create Data Visualizations Based On Asana in Mode

  Use CData Connect Cloud to connect to Asana from Mode and build visualizations using live

• Automated Continuous CSV Replication to AlloyDB

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

• Validate Sage Intacct with QuerySurge

  Access and validate Sage Intacct in QuerySurge using the CData JDBC Driver.

• Connect to Azure Data Catalog in NetBeans

  Connect to Azure Data Catalog in NetBeans with the data source configuration wizard.

• Integrate with Quickbase in SnapLogic

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

• Build Data Flows from Zuora to SQL Server using SSIS

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

• Create Twitter Ads-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Twitter Ads from Klipfolio and build custom visualizations using live Twitter Ads.

• Create Jira Service Management-Connected Dashboards in Grafana

  Connect to Jira Service Management via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Atlassian Jira Service Management.

• How to connect Amazon QuickSight to Oracle Service Cloud

  Create a connection to Oracle Service Cloud in CData Connect Cloud and insert Oracle Service Cloud into Amazon QuickSight SPICE to build interactive dashboards.

• How to create an RPA flow for SharePoint Excel Services in UiPath Studio

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

• Replicate Multiple Spark Accounts via the CData Sync CLI

  Replicate multiple Spark accounts to one or many databases.

• Build Automated Workflows with Live Oracle in Workato

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

• How to Create Power BI Visual Reports with Real-Time Google Directory

  Use CData Power BI Connectors to visualize Google Directory in Power BI.

• Replicate Vault CRM to Multiple Databases via the CData Sync CLI

  Replicate Veeva Vault & Vault CRM to disparate databases with a single configuration.

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

  Connect to Amazon Athena from a connection pool in Tomcat.

• Replicate Trello to Multiple Databases

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

• Connect to BambooHR in NetBeans

  Connect to BambooHR in NetBeans with the data source configuration wizard.

• Validate Smartsheet with QuerySurge

  Access and validate Smartsheet in QuerySurge using the CData JDBC Driver.

• Automated Continuous Sybase IQ Replication to PostgreSQL

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

• Build Pipelines with Live Presto in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Presto from Google Cloud Data Fusion, enabling the integration of live Presto into the building and management of effective data pipelines.

• Build AlloyDB-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Google AlloyDB.

• Create SAP ByDesign-Connected Nintex Workflows

  Use CData Connect Cloud to connect to SAP ByDesign from Nintex Workflow Cloud and build custom workflows using live SAP Business ByDesign.

• Create Informatica Mappings From/To a JDBC Data Source for Clio

  Create Clio data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• A PostgreSQL Interface for MongoDB (MySQL Remoting via JDBC)

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

• How to Visualize Office 365 Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Microsoft Office 365 in Python.

• How to integrate Excel Online with Apache Airflow

  Access and process Microsoft Excel Online in Apache Airflow using the CData JDBC Driver.

• Connect to Live Oracle Financials Cloud in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Oracle Financials Cloud in CData Connect Cloud and connect to your Oracle Financials Cloud from PostgreSQL.

• Create MySQL Dataflows on PowerBI.com

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

• Visualize NetSuite in Tableau

  The CData ODBC driver for NetSuite enables you integrate NetSuite CRM & ERP into Tableau dashboards.

• Bidirectional Access to SAP Fieldglass from FileMaker Pro

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

• Connect to Printify in CloverDX (formerly CloverETL)

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

• Access Wave Financial from MySQL in HeidiSQL

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

• How to connect to Oracle Sales in DBVisualizer

  Integrate Oracle Sales with visual data analysis tools and data connection wizards in DBVisualizer

• Replicate Multiple Elasticsearch Accounts

  Replicate multiple Elasticsearch accounts to one or many databases.

• Connect to SAP BusinessObjects BI from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live SAP BusinessObjects BI from Filemaker Pro on Mac.

• Automated Continuous Google Search Replication to Databricks

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

• Automated Continuous Impala Replication to Microsoft Access

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

• Integrate CockroachDB in Your Informatica Cloud Instance

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

• Seamlessly Bring Spark into Retool Using CData Connect Cloud

  Integrate Spark data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• Access Live Sybase IQ in AWS Lambda (with IntelliJ IDEA)

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

• Build Semantic Layer Views for Airtable in APOS Live Data Gateway

  Use the CData Connector for Airtable in APOS Live Data Gateway to build Semantic Layer Views for Airtable.

• Build Dashboards with OData Services in Dundas BI

  Create dynamic dashboards and perform analytics based on OData in Dundas BI.

• Automate Snowflake Integration Tasks from PowerShell

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

• Connect to Adobe Analytics as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Adobe Analytics.

• Access Reckon Accounts Hosted as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Reckon Accounts Hosted from your Oracle system.

• How to pipe Spark to CSV in PowerShell

  Use standard PowerShell cmdlets to access Spark tables.

• Publish Xero-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Xero Accounting.

• Access Live BigCommerce Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live BigCommerce data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Connect to OData Services in Ruby

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

• Automated Continuous Sage Intacct Replication to Vertica

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

• How to connect and process DocuSign from Azure Databricks

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

• Automated Continuous Vault CRM Replication to AlloyDB

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

• Prepare, Blend, and Analyze Typeform in Alteryx Designer (ODBC)

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

• Build Semantic Layer Views for LinkedIn in APOS Live Data Gateway

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

• Natively Connect to Okta in PHP

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

• Connect to and Visualize Live Amazon Athena in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon Athena.

• ETL Access in Oracle Data Integrator

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

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

  Connect to Salesforce Pardot from a connection pool in Tomcat.

• Connect to HBase in Google Apps Script via SQL Gateway

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

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

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

• Access SAP Hybris C4C from MySQL in PHP

  Connect to SAP Hybris C4C through the standard MySQL libraries in PHP.

• Access Okta from MySQL in HeidiSQL

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

• Create Dynamic Zoho Projects Grids Using the Infragistics XamDataGrid

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

• «
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• »