CData Software - Knowledge Base

Recent Articles

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »

• Process & Analyze Amazon S3 in Databricks (AWS)

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

• Rapidly Develop IBM Cloud Object Storage-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 Jira Service Management in Informatica PowerCenter

  Create a simple Workflow for Atlassian Jira Service Management in Informatica PowerCenter.

• Import Real-Time WordPress in ColdFusion to Build Applications

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

• Build Pipelines with Live Google Directory in Google Cloud Data Fusion (via CData Connect Cloud)

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

• LINQ to HBase

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

• ADP Reporting in OBIEE with the ADP JDBC Driver

  Deploy the ADP JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Integrate Cosmos DB into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Azure Cosmos DB and integrate live Azure Cosmos DB into your Power Automate tasks.

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

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

• Replicate Hive from PowerShell

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

• Automate YouTube Analytics Replication to Azure Data Lake

  Use CData Sync to customize and automate YouTube Analytics replication to Azure Data Lake.

• Connect to JDBC-ODBC Bridge in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automated Continuous XML Replication to Apache Kafka

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

• Build Pipelines with Live API in Google Cloud Data Fusion (via CData Connect Cloud)

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

• Edit and Search External EventBrite Objects in Salesforce Connect

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

• Visualize OneNote in Tableau

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

• Use the CData ODBC Driver for Xero in Microsoft Power Query

  You can use the CData Xero ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Xero Accounting into Microsoft Power Query.

• Automate Google Campaign Manager 360 Replication to SAP HANA

  Use CData Sync to customize and automate Google Campaign Manager 360 replication to SAP HANA.

• A PostgreSQL Interface for Amazon S3

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

• Integrate SAP Netweaver Gateway in the Pentaho Report Designer

  Publish reports based on SAP Netweaver Gateway in the Pentaho BI tool.

• Integrate Live Sage 50 UK into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for Sage 50 UK and integrate live Sage 50 UK into apps built in Microsoft Power Apps.

• Access ADP from MySQL in HeidiSQL

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

• How to Query LinkedIn in MySQL Workbench

  Execute MySQL queries against live LinkedIn from MySQL Workbench.

• Automate Google Campaign Manager 360 Integration Tasks from PowerShell

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

• Natively Connect to CockroachDB in PHP

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

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

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

• Using the CData Software ODBC Driver for Adobe Analytics in PyCharm

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

• How to Connect DBeaver to Tableau CRM Analytics via a JDBC Driver

  Manage Tableau CRM Analytics with visual tools in DBeaver like the query browser.

• Build Tableau CRM Analytics-Connected Apps in Bubble

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

• Automated Continuous CouchDB Replication to Amazon S3

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

• Automated Continuous Phoenix Replication to MySQL

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

• How to Access Live LinkedIn Ads in Power Automate Desktop via ODBC

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

• Access Live OData Services in Excel (Desktop)

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

• Replicate Multiple Sage Cloud Accounting Accounts

  Replicate multiple Sage Cloud Accounting accounts to one or many databases.

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

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

• Prepare, Blend, and Analyze Paylocity in Alteryx Designer

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

• Export Data from SQL Server to TaxJar through SSIS

  Easily push SQL Server data to TaxJar using the CData SSIS Tasks for TaxJar.

• Bidirectional Access to Teradata from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Teradata in Filemaker Pro for Mac or Windows.

• How to integrate Paylocity with Apache Airflow

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

• Connect to Act CRM as a SQL Server Linked Server

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

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

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

• Create Data Visualizations Based On AlloyDB in Mode

  Use CData Connect Cloud to connect to AlloyDB from Mode and build visualizations using live

• Use the CData Software ODBC Driver for Google Contacts in MicroStrategy Web

  Connect to Google Contacts in MicroStrategy Web using the CData Software ODBC Driver for Google Contacts.

• How to create Invoiced federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Invoiced in MySQL .

• Automate Aha Integration Tasks from PowerShell

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

• Using AngularJS to Build Dynamic Web Pages with Jira Service Management

  Use the CData Connect Server to create Jira Service Management OData feeds and build single-page applications with live Atlassian Jira Service Management.

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

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

• ETL Avro in Oracle Data Integrator

  This article shows how to transfer Apache Avro into a data warehouse using Oracle Data Integrator.

• Connect to Neo4J in Google Apps Script

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

• Automated Continuous Sage Cloud Accounting Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Amazon Redshift.

• How to create Trello federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Trello in MySQL .

• Automated Continuous Exact Online Replication to Apache Cassandra

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

• Connect to Twitter from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Twitter from Filemaker Pro on Mac.

• Operational Reporting on PayPal from Spotfire Server

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

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

  Use CData Power BI Connectors to visualize Apache HBase in Power BI.

• Connect to QuickBooks Time in HULFT Integrate

  Connect to QuickBooks Time as a JDBC data source in HULFT Integrate

• Automated Continuous CSV Replication to Microsoft Access

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

• Integrating Active Directory in Talend Cloud Data Management Platform

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »