CData Software - Knowledge Base

Recent Articles

• «
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• 316
• »

• Connect to Smartsheet as a SQL Server Linked Server

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

• Connect to Phoenix in DBArtisan

  Use wizards in DBArtisan to configure Apache Phoenix as a data source.

• How to Build an ETL App for Highrise in Python with CData

  Create ETL applications and real-time data pipelines for Highrise CRM in Python with petl.

• Connect to Sage 300 in RunMyProcess through Connect Server

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

• Integrate HBase into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for Apache HBase and integrate live Apache HBase into your Power Automate (Microsoft Flow) tasks.

• Access MariaDB from MySQL in PHP

  Connect to MariaDB through the standard MySQL libraries in PHP.

• Integrate Live Amazon DynamoDB into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Amazon DynamoDB and integrate live Amazon DynamoDB into apps built in Microsoft Power Apps.

• Integrate Oracle HCM Cloud into Automated Tasks with Power Automate

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

• How to update Google Sheets from Excel

  This article explains how to transfer data from Excel to Google Sheets using the Excel Add-In for Google Sheets.

• Build Visualizations of Bullhorn CRM in Birst

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

• Create Phoenix Dashboards in Bold BI

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

• Connect to Google Spanner from PowerBuilder

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

• Connect to Teradata in DBArtisan

  Use wizards in DBArtisan to configure Teradata as a data source.

• Visualize Microsoft Project in Tableau

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

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

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

• Create Salesforce Marketing Dataflows on PowerBI.com

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

• Automated Continuous ServiceNow Replication to Snowflake

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

• Viewing QuickBooks in RAD Studio Data Explorer

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

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

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

• Use the CData ODBC Driver for SAP HANA from SharePoint Excel Services

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

• Use JayDeBeApi to access Act CRM in Python

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

• How to Access Authorize.Net Using Entity Framework

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

• How to Access Azure Active Directory Using Entity Framework

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

• Create Apps from Certinia in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for Certinia and build apps from live Certinia in Qlik Sense Cloud.

• Replicate Invoiced for Use in Salesforce Connect

  Replicate Invoiced to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• CData AWS Glue Connector Trial

  You can test and build out Proofs-of-Concept for the CData AWS Glue Connectors using the CData JDBC Drivers.

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

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

• Connect to Google Campaign Manager 360 in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Google Campaign Manager 360 as an External Source in Dremio.

• Connect to Zuora in NetBeans

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Ads

  Provide connectivity to Google Ads through an SAP BusinessObjects universe.

• Build WordPress-Connected Apps in Mendix

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

• Automate YouTube Analytics Replication to Couchbase

  Use CData Sync to Customize and automate YouTube Analytics replication to Couchbase.

• Use the CData Software ODBC Driver for YouTube Analytics in MicroStrategy

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Bullhorn CRM

  Provide connectivity to Bullhorn CRM through an SAP BusinessObjects universe.

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

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

• Create Datasets from QuickBooks in Domo Workbench and Build Visualizations of QuickBooks in Domo

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

• Access AlloyDB from MySQL in HeidiSQL

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

• How to connect to Certinia from Spring Boot

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

• Connect to HubDB in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to integrate Metabase with SharePoint

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

• Prepare, Blend, and Analyze SuiteCRM in Alteryx Designer

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

• Connect to and Visualize Live QuickBooks Time in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live QuickBooks Time.

• Automated Continuous Google Sheets Replication to Microsoft Access

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

• Connect to HubDB from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for HubDB to connect to HubDB and execute queries in PowerBuilder.

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

  Create a simple Workflow for Google Analytics in Informatica PowerCenter.

• Connect to Todoist in DBArtisan

  Use wizards in DBArtisan to configure Todoist as a data source.

• Analyze Amazon Athena in Infragistics Reveal

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

• How to connect to Google Data Catalog from Google Apps Script

  Use CData Software Connect Server to access Google Data Catalog in Google Apps Script.

• Automated Continuous YouTube Analytics Replication to AlloyDB

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

• How to pipe Zendesk to CSV in PowerShell

  Use standard PowerShell cmdlets to access Zendesk tables.

• How to Connect DBeaver to Drip via a JDBC Driver

  Manage Drip with visual tools in DBeaver like the query browser.

• Add Oracle SCM to Informatica Enterprise Data Catalog

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

• Connect to Active Directory through External Services in Salesforce

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

• Data Privacy And Security

  We understand our drivers are used in applications and provide connectivity to sources that have private and sensitive information. We take security and privacy very seriously. Here we outline some of our relevant policies.

• Query Azure Data Lake Storage in DataGrip

  Create a Data Source for Azure Data Lake Storage in DataGrip and use SQL to query live Azure Data Lake Storage.

• Enable the Phoenix JDBC Driver in KNIME

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

• Automated Continuous ADP Replication to SingleStore

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

• Import and Visualize Microsoft OneDrive in Power View

  Create data visualizations based on Microsoft OneDrive in Excel.

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

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

• Build MVC Applications with Connectivity to Coinbase

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

• Rapidly Develop SAP Netweaver Gateway-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.

• DataBind Controls to Dynamics 365 in C++Builder

  DataBind to Microsoft Dynamics 365 in C++Builder with standard components and controls.

• How to use SQLAlchemy ORM to access Klipfolio in Python

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

• Import Real-Time Outreach.io in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Outreach.io in ColdFusion.

• How to work with Oracle Financials Cloud in Apache Spark using SQL

  Access and process Oracle Financials Cloud in Apache Spark using the CData Software JDBC Driver.

• Visualize Reckon in Sisense

  Create an ElastiCube in Sisense app with access to Reckon.

• Replicate Azure DevOps to Multiple Databases

  Replicate Azure DevOps to disparate databases with a single configuration.

• Automated Exact Online Replication to Teradata

  Use CData Sync to Customize and automate Exact Online replication to Teradata.

• Connect to ServiceNow in SpagoBI

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

• Build an OLAP Cube in SSAS from Pipedrive

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

• Visualize Live Pipedrive in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Pipedrive and create custom reports in the Power BI Service.

• Connect to Azure DevOps in Aqua Data Studio

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

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

  Use CData Power BI Connectors to visualize Atlassian Confluence in Power BI.

• How to Connect the Power BI Service to IBM Cloud Object Storage: Complete Guide

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

• Manage Tableau CRM Analytics in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Tableau CRM Analytics.

• Create Adobe Commerce-Connected Nintex Workflows

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

• Access Splunk as a Remote Oracle Database

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

• Integrate with Odoo using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Odoo ERP to a JSON file on disk.

• Import Sage Intacct into FileMaker Pro

  Create reports that integrate Sage Intacct in Filemaker Pro.

• Create GitHub-Connected Business Apps in AppSheet

  Connect to GitHub via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to GitHub.

• How to Work with Veeva in ETL Validator JDBC

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

• Creating Microsoft Exchange-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Microsoft Exchange to Unqork and build custom business apps.

• Connect to Microsoft Exchange from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Microsoft Exchange to connect to Microsoft Exchange and execute queries in PowerBuilder.

• Connect to Azure Data Lake Storage 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 Azure Data Lake Storage.

• How to Query Live XML Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live XML Files data in natural language using Python.

• Edit and Search External SurveyMonkey Objects in Salesforce Connect

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

• Edit and Search External ServiceNow Objects in Salesforce Connect

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

• Visualize HCL Domino in TIBCO Spotfire through OData

  Integrate HCL Domino into dashboards in TIBCO Spotfire.

• Visualize Live MailChimp in the Power BI Service

  Use CData Connect Cloud to connect to live MailChimp and create custom reports in the Power BI Service through the On-Premises Gateway.

• Integrate PostgreSQL into Automated Tasks with Power Automate

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

• How to connect PolyBase to MailChimp

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

• PowerShell Scripting to Replicate PostgreSQL to MySQL

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

• How to Work with SAP Hybris C4C in AWS Glue Jobs Using JDBC

  Connect to SAP Hybris C4C from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• How to Build an ETL App for Databricks in Python with CData

  Create ETL applications and real-time data pipelines for Databricks in Python with petl.

• Establish a Live Connection with Stripe using Tableau Bridge

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

• A PostgreSQL Interface for Shopify

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

• Connect to Email as a Linked Server

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

• How to create IBM Cloud Object Storage federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for IBM Cloud Object Storage in MySQL .

• Use the CData Software JDBC Driver for SAP HANA XS Advanced in MicroStrategy Desktop

  Connect to SAP HANA XS Advanced in MicroStrategy Desktop using the CData Software JDBC Driver for SAP HANA XS Advanced.

• How to connect to Teradata in DBVisualizer

  Integrate Teradata with visual data analysis tools and data connection wizards in DBVisualizer

• «
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• 316
• »