CData Software - Knowledge Base

Recent Articles

• «
• 268
• 269
• 270
• 271
• 272
• 273
• 274
• 275
• 276
• 277
• »

• Replicate LinkedIn Ads to Multiple Databases

  Replicate LinkedIn Ads to disparate databases with a single configuration.

• Analyze Live Veeva in SAS Viya

  Use CData Connect Cloud to connect to Veeva Vault from SAS Viya and deploy self-service analytics using live Veeva Vault.

• Automated Continuous MYOB AccountRight Replication to MySQL

  Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to MySQL.

• Build Semantic Layer Views for Microsoft Dataverse in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Dataverse (CDS).

• Automate Typeform Replication to Couchbase

  Use CData Sync to Customize and automate Typeform replication to Couchbase.

• Publish Redshift-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Amazon Redshift.

• PowerShell Scripting to Replicate Asana to MySQL

  Write a simple PowerShell script to replicate Asana to a MySQL database.

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

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

• DataBind Controls to Hive in C++Builder

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

• Connect to Raisers Edge NXT from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Raisers Edge NXT from Crystal Reports.

• How to create Visio diagrams from Salesforce

  Automatically update Salesforce & Force.com with the changes you make to Visio master shapes.

• Connect to Office 365 from PowerBuilder

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

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

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

• Prepare, Blend, and Analyze ShipStation in Alteryx Designer

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

• Bidirectional Access to QuickBooks from FileMaker Pro

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

• Visualize Epicor Kinetic in TIBCO Spotfire through ODBC

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

• Use the CData Software ODBC Driver for SurveyMonkey in MicroStrategy

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

• Operational Reporting on SendGrid from Spotfire Server

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

• Connect to REST from PowerBuilder

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

• Build Semantic Layer Views for Dynamics 365 in APOS Live Data Gateway

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

• Prepare, Blend, and Analyze Hive in Alteryx Designer

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

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

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

• Create a Data Access Object for Reckon Accounts Hosted using JDBI

  A brief overview of creating a SQL Object API for Reckon Accounts Hosted in JDBI.

• Analyze Live SingleStore in SAS Viya

  Use CData Connect Cloud to connect to SingleStore from SAS Viya and deploy self-service analytics using live SingleStore.

• Validate Impala with QuerySurge

  Access and validate Apache Impala in QuerySurge using the CData JDBC Driver.

• Connect to Act CRM in as an External Source in Dremio

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

• Integrate Zenefits in Your Informatica Cloud Instance

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

• Prepare, Blend, and Analyze Redshift in Alteryx Designer

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

• Create Apps from Azure Table in Qlik Sense Cloud

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

• LINQ to Databricks

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

• Connect to Reckon in the Denodo Platform

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

• Connect to EnterpriseDB in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for EnterpriseDB and connect to EnterpriseDB in Akorbi Digital RunMyProcess.

• Access Live Sage Intacct in AWS Lambda

  Connect to live Sage Intacct in AWS Lambda using the CData JDBC Driver.

• Automated Continuous Shopify Replication to Google Cloud SQL

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

• Connect to Salesforce Pardot in HULFT Integrate

  Connect to Salesforce Pardot as a JDBC data source in HULFT Integrate

• Build Visualizations of Paylocity in Birst

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

• Integrate Dynamics GP with External Services using SnapLogic

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

• Connect to Dynamics CRM in RapidMiner

  Integrate Microsoft Dynamics CRM with standard components and data source configuration wizards in RapidMiner Studio.

• Using AngularJS to Build Dynamic Web Pages with CouchDB

  Use the CData Connect Server to create CouchDB OData feeds and build single-page applications with live Apache CouchDB.

• Access Reporting in OBIEE with the Access JDBC Driver

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

• Use the CData ODBC Driver for LinkedIn in SAS JMP

  You can use the CData ODBC Driver to integrate LinkedIn into the statistical analysis tools available in SAS JMP. This article shows how to use LinkedIn in the Graph Builder and Query Builder.

• Query Jira Assets in ColdFusion

  Write standard ColdFusion data access code to connect to Jira Assets.

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

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

• Connect to eBay as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live eBay.

• Import Oracle HCM Cloud into FileMaker Pro

  Create reports that integrate Oracle HCM Cloud in Filemaker Pro.

• Connect to Trello in RunMyProcess through Connect Cloud

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

• Build Charts with Access in Clear Analytics

  Create dynamic charts and perform analytics based on Microsoft Access in Clear Analytics.

• Back Up WooCommerce to SQL Server through SSIS

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

• How to publish and share Zoho CRM dashboards with Tableau Server

  The CData ODBC driver for Zoho CRM enables you integrate Zoho CRM into Tableau dashboards.

• Connect to Live CouchDB in MicroStrategy through CData Software Connect Server

  Create a virtual database for CouchDB in CData Software Connect Server and connect to it from MicroStrategy.

• Create Clio-Connected Business Apps in AppSheet

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

• Create Splunk Dashboards in Bold BI

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

• Build AlloyDB-Connected Apps in Choreo

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

• Connect to Klaviyo in Ruby

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

• How to integrate Metabase with Shopify

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

• How to integrate Asana with Apache Airflow

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

• Automated Continuous Oracle Financials Cloud Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to Microsoft Access.

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

  Provide connectivity to Tableau CRM Analytics through an SAP BusinessObjects universe.

• Build Semantic Layer Views for Zoho CRM in APOS Live Data Gateway

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

• Model Google Search Results Using Azure Analysis Services

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

• Validate Outreach.io with QuerySurge

  Access and validate Outreach.io in QuerySurge using the CData JDBC Driver.

• Automated Continuous Quickbase Replication to Apache Kafka

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

• How to Import Oracle into SQL Server using SSIS

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

• Build Smartsheet-Connected Apps in Bubble

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

• Bidirectional Access to Coinbase from FileMaker Pro

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

• Create Data Visualizations in Cognos BI with Jira Assets

  Access Jira Assets as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Feed Azure DevOps into FineReport

  How to set Azure DevOps as a JDBC data source in FineReport.

• Replicate MYOB AccountRight to Multiple Databases

  Replicate MYOB AccountRight to disparate databases with a single configuration.

• How to connect to BigCommerce from Spring Boot

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

• How to connect Amazon QuickSight to MongoDB

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

• Integrate LinkedIn into Automated Tasks with Power Automate

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

• Automated Continuous MailChimp Replication to Amazon S3

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

• Work with Access in FoxPro

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

• Use the CData Software ODBC Driver for SharePoint Excel Services in SAS for Real-Time Reporting and Analytics

  Connect to real-time SharePoint Excel Services in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SharePoint Excel Services.

• Create OneNote-Connected Nintex Workflows

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

• Integrate Blackbaud FE NXT into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Blackbaud FE NXT and integrate live Blackbaud FE NXT into your Power Automate tasks.

• Replicate Multiple Blackbaud FE NXT Accounts

  Replicate multiple Blackbaud FE NXT accounts to one or many databases.

• Access Live HubSpot in AWS Lambda

  Connect to live HubSpot in AWS Lambda using the CData JDBC Driver.

• Create SSAS Tabular Models from Zoho Inventory

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

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

  Connect to FTP Servers 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.

• Xero Cloud Connectivity

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

• Use the CData ODBC Driver for Amazon DynamoDB from SharePoint Excel Services

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

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

• «
• 268
• 269
• 270
• 271
• 272
• 273
• 274
• 275
• 276
• 277
• »