CData Software - Knowledge Base

Recent Articles

• «
• 389
• 390
• 391
• 392
• 393
• 394
• 395
• 396
• 397
• 398
• »

• Replicate SAS Data Sets from PowerShell

  Write a quick PowerShell script to query SAS Data Sets. Use connectivity to the live data to replicate SAS Data Sets to SQL Server.

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

• Access ShipStation from MySQL in PHP

  Connect to ShipStation through the standard MySQL libraries in PHP.

• How to connect to Dynamics 365 Business Central from IntelliJ

  Integrate connectivity to Dynamics 365 Business Central with wizards in IntelliJ.

• Extract, Transform, and Load Act CRM in Informatica PowerCenter

  Create a simple Workflow for Act CRM in Informatica PowerCenter.

• Load Coinbase to a Database Using Embulk

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

• Getting Started with OAuth in CData Connectivity Solutions

  Configuring OAuth with CData Connectivity Solutions for Desktop, Web Application and Headless Machines

• Automated Continuous Microsoft OneLake Replication to AlloyDB

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

• Building Dynamic Web Pages with Jira Using AngularJS

  Create single-page applications with live connectivity to Jira using the CData API Server.

• Automated Continuous Quickbase Replication to Databricks

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

• Automate Splunk Replication to Azure Data Lake

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

• Establish a Live Connection with Microsoft Project using Tableau Bridge

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

• Build Act-On-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Act-On from Choreo and build custom apps using live Act-On.

• How to use SQLAlchemy ORM to access EventBrite in Python

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

• Extract, Transform, and Load SAP HANA in Informatica PowerCenter

  Create a simple Workflow for SAP HANA in Informatica PowerCenter.

• Access Live OData Services in Excel (Desktop) via Connect Cloud

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

• Analyze Salesloft in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Salesloft and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

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

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

• How to Use a Microsoft Access Database to Update Tableau CRM Analytics in Real Time

  Update Tableau CRM Analytics data by creating a linked table in Microsoft Access with the CData Tableau CRM Analytics ODBC Driver.

• Build a PostgreSQL Interface for Tally using the CData JDBC Driver

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

• Build PostgreSQL-Connected Apps in Choreo

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

• Use the CData Software JDBC Driver for CockroachDB in MicroStrategy

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

• Connect to Printful as a Linked Server via SQL Gateway

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

• Publish QuickBooks-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live QuickBooks Desktop.

• How to Connect DBeaver to SAP Ariba Source via a JDBC Driver

  Manage SAP Ariba Source with visual tools in DBeaver like the query browser.

• Analyze DB2 with Power Pivot

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

• Query QuickBooks Time as a SQL Server Database in Node.js

  Execute SQL Server queries against QuickBooks Time from Node.js.

• Model, Search, and Visualize Live Monday.com in ThoughtSpot

  Use CData Connect Cloud to connect to live Monday.com for modeling, searching, and visualizing.

• Connect to Sugar CRM from PowerBuilder via JDBC

  This article demonstrates how to access Sugar CRM from PowerBuilder using the Sugar CRM JDBC Driver.

• Access Live Office 365 in Excel 365 Online (Excel for the web)

  Connect to Microsoft Office 365 from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• How to Connect to & Open Outreach.io in Microsoft Excel

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

• Automated Continuous Sybase IQ Replication to Amazon Redshift

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

• Analyze Spark in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Apache Spark SQL with the CData JDBC Driver for Spark.

• Automated Continuous HBase Replication to AlloyDB

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

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

  Provide connectivity to Atlassian Confluence through an SAP BusinessObjects universe.

• Build Automated Blackbaud FE NXT-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Blackbaud FE NXT and build automated workflows in Zapier.

• Build Paylocity-Connected Apps in Mendix

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

• Visualize ADP in TIBCO Spotfire through ADO.NET

  Integrate ADP into dashboards in TIBCO Spotfire.

• Build Typeform-Connected ETL Processes in Google Data Fusion

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

• Visualize Drift from Tableau

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

• Create Smartsheet-Connected Enterprise Applications in OutSystems

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

• Easily Integrate Acumatica in Lazarus Pascal IDE

  Learn how to easily integrate live Acumatica ERP in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Access Live SAP Concur in AWS Lambda (with IntelliJ IDEA)

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

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

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

• How to Work with Microsoft OneDrive in ETL Validator JDBC

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

• Use the CData ODBC Driver for Twitter in Microsoft Power Query

  You can use the CData Twitter ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Twitter into Microsoft Power Query.

• Access SAP BusinessObjects BI as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP BusinessObjects BI from your Oracle system.

• Connect to Redshift from a Connection Pool in Jetty

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

• Create Dynamic EventBrite Grids Using the Infragistics XamDataGrid

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

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

  Execute SQL Server queries against WooCommerce from Node.js.

• Analyze SharePoint in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Microsoft SharePoint and visualize Microsoft SharePoint in SAP Analytics Cloud.

• Create Datasets from SAP HANA in Domo Workbench and Build Visualizations of SAP HANA in Domo

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

• Query Amazon Athena using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Amazon Athena entities in PHP by modeling them as objects.

• Build an OLAP Cube in SSAS from Typeform

  Establish a connection to Typeform data from SQL Server Analysis Services, and use the Typeform Data Provider to build OLAP cubes for use in analytics and reporting.

• How to Connect the Power BI Service to Blackbaud FE NXT: Complete Guide

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

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

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

• Replicate Multiple Instagram Accounts

  Replicate multiple Instagram accounts to one or many databases.

• Replicate Multiple RSS Accounts via the CData Sync CLI

  Replicate multiple RSS accounts to one or many databases.

• Connect to Jira Using the Script Function in Claris FileMaker Pro

• «
• 389
• 390
• 391
• 392
• 393
• 394
• 395
• 396
• 397
• 398
• »