CData Software - Knowledge Base

Recent Articles

• «
• 294
• 295
• 296
• 297
• 298
• 299
• 300
• 301
• 302
• 303
• »

• Create Reports with Phoenix in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Apache Phoenix.

• Integrate Drip in the Pentaho Report Designer

  Publish reports based on Drip in the Pentaho BI tool.

• Connect to Google Ad Manager from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Google Ad Manager to connect to Google Ad Manager from Web applications running on WebLogic.

• Analyze Google Data Catalog in R

  Create data visualizations and use high-performance statistical functions to analyze Google Data Catalog in Microsoft R Open.

• Integrate Zuora in the Pentaho Report Designer

  Publish reports based on Zuora in the Pentaho BI tool.

• Connect to Dynamics GP in DBeaver

  Use the CData ODBC Driver to connect to Microsoft Dynamics GP in DBeaver.

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

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

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

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

• Integrate ActiveCampaign in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ActiveCampaign from Informatica Cloud.

• Analyze Live LinkedIn Ads in SAS Viya

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

• Build Cosmos DB-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Azure Cosmos DB and build Cosmos DB-connected web apps with Axios.

• Connect to Greenplum in JRuby

  Create a simple JRuby app with access to live Pivotal GreenPlum.

• Analyze Twitter in R

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

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

  Use LlamaIndex to query live Atlassian Confluence data in natural language using Python.

• Back Up Apache Phoenix to SQL Server through SSIS

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

• Publish Reports with Azure Active Directory in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Azure Active Directory.

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

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

• Access Presto from MySQL in Amazon QuickSight

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

• Using AngularJS to Build Dynamic Web Pages with Amazon S3

  Use the CData Connect Server to create Amazon S3 OData feeds and build single-page applications with live Amazon S3.

• How to Import Access into SQL Server using SSIS

  Easily back up Microsoft Access to SQL Server using the SSIS components for Access.

• Automated CouchDB Replication to Teradata

  Use CData Sync to Customize and automate Apache CouchDB replication to Teradata.

• Integrate Real-Time Access to SAP Business One in SAPUI5 MVC Apps

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

• Back Up Adobe Commerce to SQL Server through SSIS

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

• How to Access Live Drip in Power Automate Desktop via ODBC

  The CData ODBC Driver for Drip enables you to integrate Drip into workflows built using Microsoft Power Automate Desktop.

• Build Dashboards with Oracle Service Cloud in Dundas BI

  Create dynamic dashboards and perform analytics based on Oracle Service Cloud in Dundas BI.

• Bridge Teradata Connectivity with Apache NiFi

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

• Create Zoom-Connected Nintex Workflows

  Use CData Software Connect Server to connect to Zoom from Nintex Workflow Cloud and build custom workflows using live Zoom.

• Automated Continuous Phoenix Replication to SingleStore

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

• Automate SharePoint Excel Services Replication to Azure Synapse

  Use CData Sync to customize and automate SharePoint Excel Services replication to Azure Synapse.

• Automated Continuous Avro Replication to Apache Cassandra

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

• Creating Avro-Connected Applications in Unqork

  You can use CData Connect to feed Apache Avro to Unqork and build custom business apps.

• Build SAP Business One-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live SAP Business One and build SAP Business One-connected web apps with Axios.

• Use the CData Software JDBC Driver for SAP Business One in MicroStrategy Desktop

  Connect to SAP Business One in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Business One.

• Create Apps from JotForm in Qlik Sense Cloud

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

• Replicate MariaDB to Multiple Databases

  Replicate MariaDB to disparate databases with a single configuration.

• How to connect to Exact Online from MS Excel on Mac OS X

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

• Connect to Salesloft from PowerBuilder

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

• DataBind Wijmo Grid to Printify

  Provide real-time Printify to interactive controls.

• How to Import TaxJar into SQL Server using SSIS

  Easily back up TaxJar to SQL Server using the SSIS components for TaxJar.

• Work with Live Snowflake in Power Query

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

• Connect to Azure Data Lake Storage in DBeaver

  Use the CData ODBC Driver to connect to Azure Data Lake Storage in DBeaver.

• Integrate Real-Time Access to Bing Search in SAPUI5 MVC Apps

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

• Access Bitbucket as a Remote Oracle Database

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

• Automated Continuous Unbounce Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Unbounce replication to delimited files (CSV/TSV).

• Connect to Dynamics NAV in DBArtisan

  Use wizards in DBArtisan to configure Microsoft Dynamics NAV as a data source.

• Automated Continuous Office 365 Replication to SQLite

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

• Creating ShipStation-Connected Applications in Unqork

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

• Connect to IBM Cloud Object Storage in DBeaver

  Use the CData ODBC Driver to connect to IBM Cloud Object Storage in DBeaver.

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

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

• Connect to HBase from PowerBuilder

  This article demonstrates how to access Apache HBase from PowerBuilder using the HBase JDBC Driver.

• Access SharePoint Excel Services from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live SharePoint Excel Services from HeidiSQL.

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

  Connect to Google Analytics 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.

• Access Gmail as a Remote Oracle Database

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

• Build a Simple VCL Application for Salesforce Pardot

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

• Replicate Bitbucket from PowerShell

  Write a quick PowerShell script to query Bitbucket. Use connectivity to the live data to replicate Bitbucket to SQL Server.

• Automated Continuous Reckon Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Reckon replication to Apache Kafka.

• Natively Connect to Azure Table in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to Azure Table Storage. Leverage the native support for ODBC in PHP.

• Manage Instagram in DBArtisan as a JDBC Source

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

• Edit and Search External Authorize.Net Objects in Salesforce Connect

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

• How to integrate MarkLogic with Apache Airflow

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

• How to Access Sage 200 Using Entity Framework

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

• Edit and Search External Google Sheets Objects in Salesforce Connect

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

• Automated Continuous Adobe Commerce Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Amazon S3.

• How to Connect to Access in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Microsoft Access. Leverage the pyodbc module for ODBC in Python.

• Integrate Bing Ads in the Pentaho Report Designer

  Publish reports based on Bing Ads in the Pentaho BI tool.

• How to Query Live Dynamics 365 Business Central Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Dynamics 365 Business Central data in natural language using Python.

• Connect to Oracle Service Cloud in Google Apps Script

  Use the ODBC Driver for Oracle Service Cloud and the SQL Gateway to access Oracle Service Cloud from Google Apps Script.

• Build an OLAP Cube in SSAS from Reckon Accounts Hosted

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

• Use the CData Software ODBC Driver for IBM Cloud Data Engine in MicroStrategy

  Connect to IBM Cloud Data Engine in MicroStrategy Developer using the CData Software ODBC Driver for IBM Cloud Data Engine.

• Automate DB2 Replication to Azure Synapse

  Use CData Sync to customize and automate IBM DB2 replication to Azure Synapse.

• Connect to Facebook Ads through External Services in Salesforce

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

• Automated Continuous MariaDB Replication to Amazon Redshift

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

• How to Connect the Power BI Service to Neo4J: Complete Guide

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

• How to connect to MYOB AccountRight from MS Excel on Mac OS X

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Automated Continuous Aha Replication to Amazon S3

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

• DataBind Wijmo Grid to SharePoint

  Provide real-time Microsoft SharePoint to interactive controls.

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

  Use LlamaIndex to query live Google Contacts data in natural language using Python.

• Working with Salesforce in LINQPad

  Execute LINQ queries to Salesforce & Force.com in LINQPad.

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

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

• Create Google Cloud Storage-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Google Cloud Storage from AppSheet and build custom business apps using live Google Cloud Storage.

• Query Oracle as a MySQL Database in Node.js

  Execute MySQL queries against Oracle Database from Node.js.

• Using the CData Software ODBC Driver for Amazon DynamoDB in PyCharm

  Connect to Amazon DynamoDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon DynamoDB.

• How to load SAS xpt data into Elasticsearch via Logstash

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

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

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

• Connect to HBase as a Linked Server

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

• Build MVC Applications with Connectivity to Highrise

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

• Use Biml to Build SSIS Tasks to Replicate Aha to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Aha! to SQL Server.

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

  Use LlamaIndex to query live Sage Intacct data in natural language using Python.

• Connect to Sage 200 from a Connection Pool in Jetty

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

• Connect to Real-Time Avalara AvaTax Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 294
• 295
• 296
• 297
• 298
• 299
• 300
• 301
• 302
• 303
• »