CData Software - Knowledge Base

Recent Articles

• «
• 149
• 150
• 151
• 152
• 153
• 154
• 155
• 156
• 157
• 158
• »

• Build ADP-Connected Apps in Bubble

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

• Feed Veeva into FineReport

  How to set Veeva Vault as a JDBC data source in FineReport.

• Analyze HBase in R

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

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

• Use the Connect Server to Access Aha in Microsoft Power Pivot

  Use the Connect Server to connect to live Aha! in the Power Pivot business intelligence tool.

• Back Up Google Directory to SQL Server through SSIS

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

• Access Live Microsoft Planner in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Microsoft Planner to create a Microsoft Planner source in TIBCO Data Virtualization Studio and gain access to live Microsoft Planner from your TDV Server.

• Create Reports with SAP in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP ERP/NetWeaver.

• Create Reports with Avalara AvaTax in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Avalara AvaTax.

• Explore Geographical Relationships in Bitbucket with Power Map

  Create data visualizations with Bitbucket in Power Map.

• How to import Salesforce Pardot into Apache Solr

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

• Build Semantic Layer Views for BigQuery in APOS Live Data Gateway

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

• Connect to CouchDB in DBeaver

  Use the CData ODBC Driver to connect to Apache CouchDB in DBeaver.

• Connect to EventBrite in Google Apps Script

  Use the ODBC Driver for EventBrite and the SQL Gateway to access Eventbrite from Google Apps Script.

• Analyze SAP Hybris C4C in R

  Create data visualizations and use high-performance statistical functions to analyze SAP Hybris C4C in Microsoft R Open.

• Connect to SendGrid in Airbyte ELT Pipelines

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

• Acumatica Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Acumatica facts in real time.

• Use the CData Software JDBC Driver for Microsoft OneDrive in MicroStrategy Desktop

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

• Visualize Live Parquet in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Parquet.

• Visualize Salesforce Marketing from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Salesforce Marketing Cloud.

• A PostgreSQL Interface for Drip

  Use the SQL Gateway and Drip ODBC Driver to create a PostgreSQL entry-point for data access.

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

  Create an ODBC connection to Sybase in Informatica and browse and transfer Sybase.

• Build Procore-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Procore and build web apps with connectivity to live Procore.

• PowerShell Scripting to Replicate Dynamics CRM to MySQL

  Write a simple PowerShell script to replicate Microsoft Dynamics CRM to a MySQL database.

• Query, Visualize, and Share live AlloyDB in Redash

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

• Create JSON Dashboards in Bold BI

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

• Import HarperDB into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for HarperDB and create custom reports in the Power BI Service.

• Bridge LDAP Connectivity with Apache NiFi

  Access and process LDAP in Apache NiFi using the CData JDBC Driver.

• Connect to Active Directory in DBeaver

  Use the CData ODBC Driver to connect to Active Directory in DBeaver.

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

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

• Build Dashboards with QuickBooks Time in DBxtra

  Create dynamic dashboards and perform analytics based on QuickBooks Time in DBxtra.

• Integrate Oracle Sales with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Oracle Sales with External Services.

• Build Pipelines with Live SAP Hybris C4C in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to SAP Hybris C4C from Google Cloud Data Fusion, enabling the integration of live SAP Hybris C4C into the building and management of effective data pipelines.

• How to connect PolyBase to Phoenix

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

• Connect to Microsoft Teams from HeidiSQL

  Use CData Connect Cloud to connect to and query live Microsoft Teams from HeidiSQL.

• Create SFTP Dataflows on PowerBI.com

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

• Automated Oracle Financials Cloud Replication to Teradata

  Use CData Sync to Customize and automate Oracle Financials Cloud replication to Teradata.

• Import Real-Time BigCommerce in ColdFusion to Build Applications

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

• Create DocuSign Dataflows on PowerBI.com

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

• Bridge Bing Ads Connectivity with Apache NiFi

  Access and process Bing Ads in Apache NiFi using the CData JDBC Driver.

• Connect to Live Office 365 in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Office 365 in CData Connect Cloud and connect to your Microsoft Office 365 from PostgreSQL.

• Import and Visualize CockroachDB in Power View

  Create data visualizations based on CockroachDB in Excel.

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

  Provide connectivity to Printify through an SAP BusinessObjects universe.

• Access Live Facebook Ads in Excel (Desktop)

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

• Query HDFS as a SQL Server in Node.js

  Execute SQL Server queries against Apache HDFS from Node.js.

• How to connect to BigQuery from IntelliJ

  Integrate connectivity to Google BigQuery with wizards in IntelliJ.

• Connect to Xero from PowerBuilder

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

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

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

• Build Kafka-Connected ETL Processes in Google Data Fusion

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

• Create Data Visualizations in Cognos BI with Presto

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

• Connect to Instagram as a SQL Server Linked Server

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

• Connect to Bing Search Results from PowerBuilder

  This article demonstrates how to access Bing Search from PowerBuilder using the Bing Search JDBC Driver.

• Automate Tableau CRM Analytics Replication to Azure Synapse

  Use CData Sync to customize and automate Tableau CRM Analytics replication to Azure Synapse.

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

  Connect to CSV/TSV Files 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.

• Build Dashboards with Amazon S3 in Dundas BI

  Create dynamic dashboards and perform analytics based on Amazon S3 in Dundas BI.

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

  Provide connectivity to ActiveCampaign through an SAP BusinessObjects universe.

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

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

• Publish xBase-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live xBase.

• Automated Continuous YouTube Analytics Replication to Vertica

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

• How to connect to AlloyDB from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for AlloyDB and work with Google AlloyDB in Microsoft Excel on Mac OS X.

• Build SuiteCRM-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for SuiteCRM and build visualizations and dashbaords from SuiteCRM in Redash.

• How to use SQLAlchemy ORM to access Sage 300 in Python

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

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

  Connect to OData 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.

• Feed Cvent into FineReport

  How to set Cvent as a JDBC data source in FineReport.

• Analyze SFTP in R

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

• Connect to Facebook in RazorSQL

  Connect to Facebook from wizards and query Facebook from the GUI in the RazorSQL database management tool.

• Integrate Live SAP Concur into Custom Business Apps Built in Power Apps

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

• Replicate Cosmos DB to Multiple Databases

  Replicate Azure Cosmos DB to disparate databases with a point-and-click configuration.

• Analyze Veeva in Cognos Analytics

  Use CData Connect Cloud to connect to Veeva from Cognos Analytics and analyze live Veeva Vault.

• Object-Relational Mapping (ORM) with SAP Hybris C4C Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP Hybris C4C into a Java-based ORM framework, Hibernate.

• Connect to Smartsheet from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Smartsheet to connect to Smartsheet from Web applications running on WebLogic.

• LINQ to Sage 50 UK

  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 Sage 50 UK Data Provider.

• Use the Connect Server to Access Azure Data Catalog in Microsoft Power Pivot

  Use the Connect Server to connect to live Azure Data Catalog in the Power Pivot business intelligence tool.

• Automated Continuous Clio Replication to AlloyDB

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

• Automated Continuous Salesforce Pardot Replication to AlloyDB

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

• Query SuiteCRM in ColdFusion

  Write standard ColdFusion data access code to connect to SuiteCRM.

• Query Avro as a SQL Server in Node.js

  Execute SQL Server queries against Apache Avro from Node.js.

• Automated Continuous Pipedrive Replication to Google Cloud SQL

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

• Create Oracle Service Cloud-Connected Enterprise Applications in OutSystems

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

• Use the CData Software ODBC Driver for Zoho CRM in MicroStrategy Desktop

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

• Integrate Printify into Automated Tasks with Power Automate

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

• Use the CData Software ODBC Driver for SharePoint Excel Services in MicroStrategy Web

  Connect to SharePoint Excel Services in MicroStrategy Web using the CData Software ODBC Driver for SharePoint Excel Services.

• Integrate Google Calendar with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Google Calendar with External Services.

• Connect to Bullhorn CRM as a Linked Server

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

• Analyze Google Contacts in Infragistics Reveal

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

• Visualize MongoDB in TIBCO Spotfire through ODBC

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

• Access ConstantContact from MySQL in PHP

  Connect to ConstantContact through the standard MySQL libraries in PHP.

• Replicate Drip to Multiple Databases

  Replicate Drip to disparate databases with a point-and-click configuration.

• Use the CData Software JDBC Driver for Zoho Creator in MicroStrategy Desktop

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

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

  Create an ODBC connection to Sage 200 in Informatica and browse and transfer Sage 200.

• Connect to Microsoft Dataverse in SpagoBI

  Create reports featuring live Microsoft Dataverse (CDS) in SpagoBI Studio. Host Microsoft Dataverse reports on SpagoBI Server.

• Visualize Live Zuora in the Power BI Service

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

• Manage Amazon Marketplace in DBArtisan as a JDBC Source

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

• Connect to Facebook from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Facebook to connect to Facebook from Web applications running on WebLogic.

• How to Connect the Power BI Service to Excel Online: Complete Guide

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

• Connect to Reckon from PowerBuilder

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

• Query Adobe Commerce in MySQL Workbench

  Create a virtual MySQL database for Adobe Commerce in CData Software Connect (or Connect Server) and work with live Adobe Commerce in MySQL Workbench.

• Integrate with Amazon Athena using Apache Camel2

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

• How to Work with HCL Domino in ETL Validator JDBC

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

• Build a Simple VCL Application for FHIR

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

• «
• 149
• 150
• 151
• 152
• 153
• 154
• 155
• 156
• 157
• 158
• »