CData Software - Knowledge Base

Recent Articles

• «
• 326
• 327
• 328
• 329
• 330
• 331
• 332
• 333
• 334
• 335
• »

• Integrate Zoho Projects into Power Automate Desktop using CData Connect

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

• How to connect and process Cvent from Azure Databricks

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

• Automated Continuous Oracle Sales Replication to SingleStore

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

• Create Informatica Mappings From/To a JDBC Data Source for Google Cloud Storage

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

• Automate Oracle Sales Replication to Couchbase

  Use CData Sync to Customize and automate Oracle Sales replication to Couchbase.

• Connect to Live Amazon Marketplace in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Amazon Marketplace in CData Connect Cloud and connect to your Amazon Marketplace from PostgreSQL.

• Connect to Elasticsearch in NetBeans

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

• Integrate Real-Time Access to SharePoint Excel Services in SAPUI5 MVC Apps

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

• Query, Visualize, and Share live Sugar CRM in Redash

  Use CData Connect Cloud to connect to live Sugar CRM in Redash for querying, visualizing, and sharing.

• Build a Simple VCL Application for Parquet

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

• Establish a Live Connection with Excel Online using Tableau Bridge

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

• Build Dashboards with Epicor Kinetic in DBxtra

  Create dynamic dashboards and perform analytics based on Epicor Kinetic in DBxtra.

• Create Informatica Mappings From/To an ODBC Data Source for Azure Data Lake Storage

  Create an ODBC connection to Azure Data Lake Storage in Informatica and browse and transfer Azure Data Lake Storage.

• Connect to GraphQL in SpagoBI

  Create reports featuring live GraphQL in SpagoBI Studio. Host GraphQL reports on SpagoBI Server.

• Query Power BI XMLA in ColdFusion

  Write standard ColdFusion data access code to connect to Power BI XMLA.

• Automated Continuous SAP Ariba Procurement Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Amazon Redshift.

• Automated Continuous Oracle Eloqua Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to IBM DB2.

• How to use SQLAlchemy ORM to access Google Ad Manager in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Ad Manager.

• Explore Geographical Relationships in Reckon with Power Map

  Create data visualizations with Reckon in Power Map.

• Model, Search, and Visualize Live Zuora in ThoughtSpot

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

• Natively Connect to Oracle Eloqua in PHP

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

• Connect to FHIR in Jaspersoft Studio

  Execute SQL to remote FHIR in Jaspersoft Studio.

• Automated Continuous SAP Ariba Source Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to AlloyDB.

• Add Google Drive to Informatica Enterprise Data Catalog

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

• Work with SharePoint in FoxPro

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

• Analyze Adobe Commerce in R

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

• Connect to JotForm in SpagoBI

  Create reports featuring live JotForm in SpagoBI Studio. Host JotForm reports on SpagoBI Server.

• Perform Batch Operations with Gmail in Apache NiFi

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

• Connect to Power BI XMLA in Google Apps Script

  Use CData Connect Cloud to access Power BI XMLA in Google Apps Script.

• Build MVC Applications with Connectivity to NetSuite

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

• Automate Highrise Replication to Couchbase

  Use CData Sync to Customize and automate Highrise CRM replication to Couchbase.

• Access MySQL as a Remote Oracle Database

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

• Query Paylocity as a MySQL Database in Node.js

  Execute MySQL queries against Paylocity from Node.js.

• Access Google Data Catalog from MySQL in Amazon QuickSight

  Connect to Google Data Catalog and build visualizations of Google Data Catalog using a MySQL Connection in Amazon QuickSight.

• Bridge SAP Connectivity with Apache NiFi

  Access and process SAP ERP/NetWeaver in Apache NiFi using the CData JDBC Driver.

• Work with Google Calendar in FoxPro

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

• Import Real-Time BigCommerce in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use BigCommerce in ColdFusion.

• Use the CData Software ODBC Driver for Google Directory in MicroStrategy

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

• Prepare, Blend, and Analyze SAP Ariba Source in Alteryx Designer

  Build workflows to access live SAP Ariba Source for self-service data analytics.

• Visualize Neo4J in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Neo4J in CData Software Connect (or Connect Server) and build visualizations from live Neo4J in Tableau Desktop.

• Create Reports with IBM Cloud Object Storage in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date IBM Cloud Object Storage.

• Add SAS Data Sets to Informatica Enterprise Data Catalog

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

• Visualize Salesforce in TIBCO Spotfire through OData

  Integrate Salesforce & Force.com into dashboards in TIBCO Spotfire.

• Visualize Amazon DynamoDB in Sisense

  Create an ElastiCube in Sisense app with access to Amazon DynamoDB.

• Replicate Multiple MYOB AccountRight Accounts

  Replicate multiple MYOB AccountRight accounts to one or many databases.

• Establish a Live Connection with Microsoft Exchange using Tableau Bridge

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

• Import EnterpriseDB into Microsoft Power Query

  The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access EnterpriseDB. In this article, you will use the OData format to import EnterpriseDB into Microsoft Power Query.

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

  Provide connectivity to Acumatica ERP through an SAP BusinessObjects universe.

• Visualize Google Ad Manager in TIBCO Spotfire through OData

  Integrate Google Ad Manager into dashboards in TIBCO Spotfire.

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

  Provide connectivity to Apache CouchDB through an SAP BusinessObjects universe.

• Connect to Tally from PowerBuilder

  This article demonstrates how to access Tally ERP from PowerBuilder using the Tally JDBC Driver.

• Publish Crystal Reports on DocuSign

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

• How to pipe Unbounce to CSV in PowerShell

  Use standard PowerShell cmdlets to access Unbounce tables.

• Author and Share Power BI Reports on Real-Time Clio

  Use the CData ODBC Driver for Clio to visualize Clio in Power BI Desktop and then upload to the Power BI service.

• How to connect to Google Cloud Storage from Google Apps Script

  Use CData Software Connect Server to access Google Cloud Storage in Google Apps Script.

• Automated Continuous eBay Replication to SQLite

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

• Create Dynamic Unbounce Grids Using the Infragistics XamDataGrid

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

• Operational Reporting on Paylocity from Spotfire Server

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

• Analyze Azure Analysis Services with Power Pivot

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

• A PostgreSQL Interface for IBM Cloud Object Storage

  Use the Remoting features of the IBM Cloud Object Storage JDBC Driver to create a PostgreSQL entry-point for data access.

• How to Use a Microsoft Access Database to Update Freshdesk in Real Time

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

• Automated Continuous Acumatica Replication to SingleStore

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

• Connect Cloud Quickstart

  Everything you need to get started with data connectivity as a service.

• Access Live JSON Services in AWS Lambda (with IntelliJ IDEA)

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

• A PostgreSQL Interface for Avalara AvaTax

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

• 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.

• A PostgreSQL Interface for Microsoft Dataverse

  Use the Remoting features of the Microsoft Dataverse ODBC Driver to create a PostgreSQL entry-point for data access.

• Natively Connect to Databricks in PHP

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

• Connect to Hive in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Apache Hive in Airbyte.

• Access Google Analytics from MySQL in PHP

  Connect to Google Analytics through the standard MySQL libraries in PHP.

• Automated Continuous Highrise Replication to MongoDB

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

• Build Act-On-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Act-On.

• Query, Visualize, and Share live SAP Hybris C4C in Redash

  Use CData Connect Cloud to connect to live SAP Hybris C4C in Redash for querying, visualizing, and sharing.

• Build Semantic Layer Views for RSS Feeds in APOS Live Data Gateway

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

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

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

• Build MVC Applications with Connectivity to SAP Ariba Source

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

• Edit and Search External Zoho CRM Objects in Salesforce Connect

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

• LINQ to ServiceNow

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

• Query FHIR in ColdFusion

  Write standard ColdFusion data access code to connect to FHIR.

• Automated Continuous Sugar CRM Replication to MongoDB

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

• Build a Simple VCL Application for Excel Online

  How to build a simple VCL Application to view Microsoft Excel Online in RAD Studio using the CData ODBC Driver for Excel Online.

• Build a Simple VCL Application for Basecamp

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

• Create Pinterest Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pinterest data access from reports, embedded analytics, and more.

• Access Exact Online from MySQL in Amazon QuickSight

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

• Connect to Sugar CRM as a Linked Server

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

• Perform Batch Operations with Microsoft Exchange in Apache NiFi

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

• DataBind Controls to SFTP in Delphi

  DataBind to SFTP in Delphi with standard data access components and controls.

• How to Connect to & Open Avalara AvaTax in Microsoft Excel

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

• How to load YouTube Analytics data into Elasticsearch via Logstash

  Introducing a simple method to load YouTube Analytics data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• How to Visualize Parquet Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Apache Parquet in Python.

• Visualize Basecamp in Sisense

  Create an ElastiCube in Sisense app with access to Basecamp.

• How to integrate Google Calendar with Apache Airflow

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

• Design BIRT Reports on eBay

  Provide current eBay to your embedded analytics.

• How to integrate Metabase with Azure Analysis Services

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

• How to import Salesloft into Apache Solr

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

• Create Google Ads-Connected Nintex Workflows

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

• Visualize Reckon Accounts Hosted in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Reckon Accounts Hosted in CData Software Connect (or Connect Server) and build visualizations from live Reckon Accounts Hosted in Tableau Desktop.

• Connect to QuickBooks in Google Apps Script

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

• Connect to Active Directory in NetBeans

  Connect to Active Directory in NetBeans with the data source configuration wizard.

• Visualize SAP Concur in TIBCO Spotfire through OData

  Integrate SAP Concur into dashboards in TIBCO Spotfire.

• «
• 326
• 327
• 328
• 329
• 330
• 331
• 332
• 333
• 334
• 335
• »