CData Software - Knowledge Base

Recent Articles

• «
• 182
• 183
• 184
• 185
• 186
• 187
• 188
• 189
• 190
• 191
• »

• Build Elasticsearch-Connected Web Apps in Servoy

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

• Use the CData ODBC Driver for BigCommerce from SharePoint Excel Services

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

• Automated Continuous Trello Replication to Microsoft Access

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

• Create Informatica Mappings From/To a JDBC Data Source for OData

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

• Visualize Live Freshdesk in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Freshdesk into custom reports in Power BI.

• Connect to Shippo in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automate SAP HANA XS Advanced Replication to Azure Synapse

  Use CData Sync to customize and automate SAP HANA XS Advanced replication to Azure Synapse.

• How to integrate Metabase with BigQuery

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

• Automated Continuous Square Replication to Oracle

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

• Automated Continuous Confluence Replication to Google Cloud SQL

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

• Create Apps from Google Ads in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Google Ads and build apps from live Google Ads in Qlik Sense Cloud.

• Access IBM Informix as a Remote Oracle Database

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

• Edit and Search External Tally Objects in Salesforce Connect

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

• Working with Zoho Projects in LINQPad

  Execute LINQ queries to Zoho Projects in LINQPad.

• Creating Salesforce Pardot-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Salesforce Pardot to Unqork and build custom business apps.

• How to connect to SQL Analysis Services in DBVisualizer

  Integrate SQL Analysis Services with visual data analysis tools and data connection wizards in DBVisualizer

• Design BIRT Reports on Microsoft OneDrive

  Provide current Microsoft OneDrive to your embedded analytics.

• Work with Live Couchbase in Power Query

  Use CData Connect Cloud to connect to Couchbase and work with live Couchbase in Microsoft Power Query.

• Access Live JotForm in Coginiti Pro

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

• ETL QuickBooks Time in Oracle Data Integrator

  This article shows how to transfer QuickBooks Time into a data warehouse using Oracle Data Integrator.

• Connect to Office 365 in JRuby

  Create a simple JRuby app with access to live Microsoft Office 365.

• Connect to Quickbase from AWS Glue

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

• Automated Continuous Aha Replication to Google Cloud SQL

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

• Use the CData ODBC Driver for Zoho Books in SAS JMP

  You can use the CData ODBC Driver to integrate Zoho Books into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Books in the Graph Builder and Query Builder.

• Rapidly Develop SAP Ariba Procurement-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.

• Extract, Transform, and Load Avalara AvaTax in Informatica PowerCenter

  Create a simple Workflow for Avalara AvaTax in Informatica PowerCenter.

• Integrate Real-Time Access to Wave Financial in SAPUI5 MVC Apps

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

• Process & Analyze DocuSign in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live DocuSign .

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

  Connect to Amazon Marketplace from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Create Wave Financial Dashboards in Bold BI

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

• Import Workday into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Workday and provide access to live Workday for custom reports in the Power BI Service.

• Viewing Todoist in RAD Studio Data Explorer

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

• Connect to Aha from a Connection Pool in Jetty

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

• Connect to Dynamics CRM in SpagoBI

  Create reports featuring live Microsoft Dynamics CRM in SpagoBI Studio. Host Dynamics CRM reports on SpagoBI Server.

• Automate Authorize.Net Replication to SAP HANA

  Use CData Sync to customize and automate Authorize.Net replication to SAP HANA.

• Access Live xBase in TIBCO Data Virtualization

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

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

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

• Natively Connect to Amazon Athena in PHP

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

• Import Real-Time SAS Data Sets in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use SAS Data Sets in ColdFusion.

• Create Data Visualizations in Cognos BI with Xero

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

• Publish Crystal Reports on SAP HANA

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

• LINQ to Azure Data Lake Storage

  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 Azure Data Lake Storage Data Provider.

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

  Use the Connect Server to connect to live Tally ERP in the Power Pivot business intelligence tool.

• Build a Simple VCL Application for Teradata

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

• Automated Zoho Books Replication to Teradata

  Use CData Sync to Customize and automate Zoho Books replication to Teradata.

• How to integrate Tally with Apache Airflow

  Access and process Tally ERP in Apache Airflow using the CData JDBC Driver.

• Act CRM Reporting and Star Schemas in OBIEE

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

• Visualize Bing Ads from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Bing Ads.

• Connect to Odoo in NetBeans

  Connect to Odoo ERP in NetBeans with the data source configuration wizard.

• Connect to xBase in DBArtisan

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

• PowerShell Scripting to Replicate Bullhorn CRM to MySQL

  Write a simple PowerShell script to replicate Bullhorn CRM to a MySQL database.

• Edit and Search External MYOB AccountRight Objects in Salesforce Connect

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

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

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

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

  Connect to SAP Concur from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• A PostgreSQL Interface for SAP Fieldglass

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

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

  Use LlamaIndex to query live Amazon Redshift data in natural language using Python.

• Build Automated Workflows with Live QuickBooks Online in Workato

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

• Access Sage 50 UK as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage 50 UK from your Oracle system.

• How to publish and share eBay Analytics dashboards with Tableau Server

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

• Connect to HBase in Ruby

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

• Process & Analyze Stripe in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Stripe .

• Create a Data Access Object for Greenplum using JDBI

  A brief overview of creating a SQL Object API for Pivotal GreenPlum in JDBI.

• Automated Continuous IBM Cloud Data Engine Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable IBM Cloud Data Engine replication to Google Cloud SQL.

• How to work with CSV in Apache Spark using SQL

  Access and process CSV in Apache Spark using the CData Software JDBC Driver.

• Build a Simple VCL Application for LinkedIn Ads

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

• Automated Continuous Google Sheets Replication to Oracle

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

• How to connect to Teradata from Spring Boot

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

• Build an OLAP Cube in SSAS from Azure Synapse

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

• LINQ to Pinterest

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

• DataBind Controls to Presto in C++Builder

  DataBind to Presto in C++Builder with standard components and controls.

• PowerShell Scripting to Replicate Oracle Financials Cloud to MySQL

  Write a simple PowerShell script to replicate Oracle Financials Cloud to a MySQL database.

• Build YouTube Analytics Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live YouTube Analytics and build visualizations in Tableau.

• Access Klaviyo from MySQL in HeidiSQL

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

• Build an OLAP Cube in SSAS from Unbounce

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

• PowerShell Scripting to Replicate BigQuery to MySQL

  Write a simple PowerShell script to replicate Google BigQuery to a MySQL database.

• Build Visualizations of Live Sybase in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for Sybase and build custom reports in Power BI.

• Automated Continuous Aha Replication to Microsoft Access

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

• Use JayDeBeApi to access OData Services in Python

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

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

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

• Provide OData Services of OneNote from a WCF Application

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

• Automate Amazon Athena Integration Tasks from PowerShell

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

• Use the CData Software JDBC Driver for MongoDB in MicroStrategy

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

• Build Automated Workflows with Live Active Directory in Workato

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

• How to Query Sage 50 UK in MySQL Workbench

  Execute MySQL queries against live Sage 50 UK from MySQL Workbench.

• Connect to Google Analytics in DBArtisan

  Use wizards in DBArtisan to configure Google Analytics as a data source.

• Query Bing Search Results as a MySQL Database in Node.js

  Execute MySQL queries against Bing Search from Node.js.

• Create LinkedIn Ads Reports on JasperReports Server

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

• Configure the CData JDBC Driver for Stripe in a Connection Pool in Tomcat

  Connect to Stripe from a connection pool in Tomcat.

• Automated Continuous Google Sheets Replication to Amazon Redshift

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

• Build Charts with Veeva in Clear Analytics

  Create dynamic charts and perform analytics based on Veeva Vault in Clear Analytics.

• Back Up SAP Business One to SQL Server through SSIS

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

• Build a Simple VCL Application for Exact Online

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

• How to Build Dynamic React Apps with SAP SuccessFactors

  Use the CData Connect and React to Build Dynamic Web Apps with Live SAP SuccessFactors .

• Connect to SAS xpt in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for SAS xpt and connect to SAS XPORT in Akorbi Digital RunMyProcess.

• Visualize LinkedIn Ads in TIBCO Spotfire through ADO.NET

  Integrate LinkedIn Ads into dashboards in TIBCO Spotfire.

• Bridge Odoo Connectivity with Apache NiFi

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

• PowerShell Scripting to Replicate DocuSign to MySQL

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

• Build Dynamics CRM-Connected Apps in Bubble

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

• Create SAP ByDesign Reports on JasperReports Server

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

• Connect to SAP Fieldglass from Asprova with CData Software ODBC Driver for SAP Fieldglass

  This article shows how to connect faster to SAP Fieldglass data from Asprova.

• «
• 182
• 183
• 184
• 185
• 186
• 187
• 188
• 189
• 190
• 191
• »