CData Software - Knowledge Base

Recent Articles

• «
• 118
• 119
• 120
• 121
• 122
• 123
• 124
• 125
• 126
• 127
• »

• How to connect and process Kintone from Azure Databricks

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

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

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

• Automated Continuous Google Directory Replication to SQLite

  Use CData Sync for automated, continuous, customizable Google Directory replication to SQLite.

• Build MVC Applications with Connectivity to PostgreSQL

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access PostgreSQL from an ASP.NET MVC application.

• Connect and Query Live Snowflake Data in Databricks with CData Connect Cloud

  Use CData Connect Cloud to integrate live Snowflake into Databricks

• Access Invoiced from MySQL in Amazon QuickSight

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

• Extract, Transform, and Load Google Cloud Storage in Informatica PowerCenter

  Create a simple Workflow for Google Cloud Storage in Informatica PowerCenter.

• How to Access HDFS Using Entity Framework

  This article shows how to access Apache HDFS using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Provide OData Services of Azure Data Catalog from a WCF Application

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

• Excel Spreadsheet Automation on Zoho Books with the QUERY Formula

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

• Connect to Live Azure Data Lake Storage in MicroStrategy through CData Connect Cloud

  Create a live connection to Azure Data Lake Storage in CData Connect Cloud and connect to your Azure Data Lake Storage from MicroStrategy.

• Validate Freshdesk with QuerySurge

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

• Access Live Coinbase Data in Tableau with CData API Server

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

• Viewing ActiveCampaign in RAD Studio Data Explorer

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

• Automate eBay Replication to Couchbase

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

• Integrate Airtable into Power Automate Desktop using CData Connect

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

• Connect to Asana in the Denodo Platform

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

• Replicate Multiple SAP Hybris C4C Accounts

  Replicate multiple SAP Hybris C4C accounts to one or many databases.

• Create Dynamic QuickBooks Time Grids Using the Infragistics XamDataGrid

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

• Connect to WordPress through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with WordPress using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Use the CData Software JDBC Driver for Printify in MicroStrategy Desktop

  Connect to Printify in MicroStrategy Desktop using the CData Software JDBC Driver for Printify.

• Visualize Zoho Creator in Sisense

  Create an ElastiCube in Sisense app with access to Zoho Creator.

• Visualize Amazon S3 in TIBCO Spotfire through ADO.NET

  Integrate Amazon S3 into dashboards in TIBCO Spotfire.

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

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

• Connect to Yahoo! Japan Data Solution as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Yahoo! Japan Data Solution.

• Visualize Elasticsearch in TIBCO Spotfire through ODBC

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

• Integrate PayPal in Pentaho Data Integration

  Build ETL pipelines based on PayPal in the Pentaho Data Integration tool.

• Build MVC Applications with Connectivity to Zoho Creator

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho Creator from an ASP.NET MVC application.

• Prepare, Blend, and Analyze Dynamics CRM in Alteryx Designer (Connect Cloud)

  Build workflows to access live Microsoft Dynamics CRM for self-service data analytics.

• How to Work with Oracle Sales in AWS Glue Jobs Using JDBC

  Connect to Oracle Sales from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Bidirectional Access to Quickbase from FileMaker Pro

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

• Query QuickBooks Online using the OData SDK for PHP

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

• Automated Continuous HBase Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Apache HBase replication to OneLake in Microsoft Fabric.

• Connect to CSV in the Denodo Platform

  Use CData driver technologies to create a virtual data source for CSV/TSV Files in the Denodo Virtual DataPort Administrator.

• Analyze Cvent in R via JDBC

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

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

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

• Automated Continuous Azure DevOps Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Azure DevOps replication to MongoDB.

• Automated Continuous Google Campaign Manager 360 Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Amazon S3.

• Analyze Snapchat Ads in Slingshot with CData API Server

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

• Visualize Live Zoho Books in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Books.

• Design BIRT Reports on ActiveCampaign

  Provide current ActiveCampaign to your embedded analytics.

• Automated Continuous Access Replication to SQL Server

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

• Analyze BigCommerce in Looker

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

• Automated Continuous Oracle HCM Cloud Replication to Google Cloud SQL

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

• Automated Continuous Aha Replication to Oracle

  Use CData Sync for automated, continuous, customizable Aha replication to Oracle.

• Automated Continuous Microsoft OneLake Replication to Apache Cassandra

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

• Create Dynamic Sage Intacct Grids Using the Infragistics XamDataGrid

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

• How to Access HCL Domino Using Entity Framework

  This article shows how to access HCL Domino using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Query, Visualize, and Share live Salesforce in Redash

  Use CData Connect Cloud to connect to live Salesforce & Force.com in Redash for querying, visualizing, and sharing.

• Automated Continuous Sugar CRM Replication to Snowflake

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

• Automated Continuous Google Campaign Manager 360 Replication to SQLite

  Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to SQLite.

• How to Access Reckon Accounts Hosted Using Entity Framework

  This article shows how to access Reckon Accounts Hosted using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Visualize Coinbase in Tableau

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

• Use the CData Software JDBC Driver for SAP Ariba Procurement in MicroStrategy Web

  Connect to SAP Ariba Procurement in MicroStrategy Web using the CData Software JDBC Driver for SAP Ariba Procurement.

• Create Informatica Mappings From/To an ODBC Data Source for AlloyDB

  Create an ODBC connection to AlloyDB in Informatica and browse and transfer Google AlloyDB.

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

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

• Access Live Pipedrive in Coginiti Pro

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

• Connect to Zoho Books in Jaspersoft Studio

  Execute SQL to remote Zoho Books in Jaspersoft Studio.

• Analyze Google Cloud Storage with Power Pivot

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

• How to import Splunk into Apache Solr

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

• Migrating data from Snapchat Ads to Snowflake using CData SSIS Components.

  Easily push Snapchat Ads to Snowflake using the CData SSIS Tasks for Snapchat Ads and Snowflake.

• Connect to ActiveCampaign in Aqua Data Studio

  Access ActiveCampaign from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• How to Connect to & Open Salesforce Data Cloud in Microsoft Excel

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

• Analyze Live Zoho Books in SAS Viya

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

• Replicate Multiple Google Campaign Manager 360 Accounts

  Replicate multiple Google Campaign Manager 360 accounts to one or many databases.

• DataBind Charts to YouTube Analytics

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

• Automate Splunk Replication to SAP HANA

  Use CData Sync to customize and automate Splunk replication to SAP HANA.

• Manage Excel in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Excel.

• Connect to ActiveCampaign in ACL Analytics

  Connect to ActiveCampaign via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to ActiveCampaign.

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

  Provide connectivity to Twitter Ads through an SAP BusinessObjects universe.

• Connect to NetSuite from PowerBuilder via ADO.NET

  This article demonstrates how to access NetSuite CRM & ERP from Appeon PowerBuilder using the CData ADO.NET Provider for NetSuite.

• Access Live BigCommerce in Coginiti Pro

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

• Publish Crystal Reports on ServiceNow

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

• Connect to Oracle from AWS Glue

  Use CData Connect Cloud to gain access to live Oracle Database from your AWS Glue jobs.

• Connect to Trello in Ruby

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

• Use JayDeBeApi to access PostgreSQL in Python

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

• Automated Continuous Workday Replication to Amazon Redshift

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

• Analyze Live Azure Synapse in SAS Viya

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

• Automated Continuous Sage 50 UK Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Sage 50 UK replication to IBM DB2.

• Create SSAS Tabular Models from Wave Financial

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

• Automate SurveyMonkey Integration Tasks from PowerShell

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

• Use the CData Software ODBC Driver for Box in MicroStrategy Desktop

  Connect to Box in MicroStrategy Desktop using the CData Software ODBC Driver for Box.

• Integrate with live Facebook Ads in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Facebook Ads in Jitterbit.

• Build Automated Workflows with Live ServiceNow in Workato

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

• Provide OData Services of Invoiced from a WCF Application

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

• How to Access GitHub Using Entity Framework

  This article shows how to access GitHub using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Model Hive Using Azure Analysis Services

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

• Connect to and Query SAP Netweaver Gateway in QlikView over ODBC

  Create data visualizations with SAP Netweaver Gateway in QlikView.

• Consume SAS xpt OData Feeds in PowerBuilder

  This article demonstrates how to consume SAS XPORT as OData feeds from PowerBuilder using the API Server.

• Connect to Zoho Inventory in HULFT Integrate

  Connect to Zoho Inventory as a JDBC data source in HULFT Integrate

• Integrate Real-Time Access to EventBrite in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Eventbrite in real time.

• Analyze Adobe Commerce in Infragistics Reveal

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

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

  Use CData Power BI Connectors to visualize Microsoft Excel in Power BI.

• Viewing SQL Server in RAD Studio Data Explorer

  How to view Microsoft SQL Server in RAD Studio Data Explorer using the CData ODBC Driver for SQL Server.

• Connect to ServiceNow in Ruby

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

• Access Wave Financial in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Wave Financial.

• Connect to Microsoft Project in DBeaver

  Use the CData ODBC Driver to connect to Microsoft Project in DBeaver.

• Edit and Search External Smaregi Objects in Salesforce Connect

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

• Integrate Live ShipStation into Blue Prism for Intelligent Robotic Process Automation (RPA)

• «
• 118
• 119
• 120
• 121
• 122
• 123
• 124
• 125
• 126
• 127
• »