CData Software - Knowledge Base

Recent Articles

• «
• 146
• 147
• 148
• 149
• 150
• 151
• 152
• 153
• 154
• 155
• »

• Connect to Oracle Financials Cloud from AWS Glue

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

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

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

• Connect to SAP ByDesign in JRuby

  Create a simple JRuby app with access to live SAP Business ByDesign.

• How to load OData data into Elasticsearch via Logstash

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

• How to load Azure Data Lake Storage data into Elasticsearch via Logstash

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

• Automated Continuous Cloudant Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Cloudant replication to Azure SQL.

• Import Monday.com Using Azure Data Factory

  Use CData Connect Cloud to connect to Monday.com from Azure Data Factory and import live Monday.com.

• Manage Access in DBArtisan as a JDBC Source

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

• Rapidly Develop Dynamics 365 Business Central-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.

• View Reports on Real-Time Smartsheet in Power BI Report Server

  Use the CData ODBC Driver for Smartsheet to visualize Smartsheet in Power BI Desktop and then publish them to Power BI Report Server.

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

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

• Create Reports with Azure DevOps in SAP Crystal Reports

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

• Validate Azure Data Lake Storage with QuerySurge

  Access and validate Azure Data Lake Storage in QuerySurge using the CData JDBC Driver.

• DataBind Wijmo Grid to Sybase IQ

  Provide real-time Sybase IQ to interactive controls.

• How to create an RPA flow for IBM Cloud Object Storage in UiPath Studio

  Use the IBM Cloud Object Storage ODBC Driver to create workflows that access real-time IBM Cloud Object Storage without any coding.

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

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

• Build Semantic Layer Views for Dynamics CRM in APOS Live Data Gateway

  Use the CData Connector for Dynamics CRM in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Dynamics CRM.

• Access Live Oracle Sales in Excel (Desktop)

  Use Connect Spreadsheets by CData to gain access to live Oracle Sales from your Excel spreadsheets.

• Automated Continuous Azure DevOps Replication to MySQL

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

• How to create Printful federated tables in MySQL

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

• Add Shippo to Informatica Enterprise Data Catalog

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

• Automated Continuous Bing Ads Replication to Apache Cassandra

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

• How to connect to xBase with Squirrel SQL client

  Connect to xBase and execute queries in the Squirrel SQL Client.

• Query, Visualize, and Share live Dynamics CRM in Redash

  Use CData Connect Cloud to connect to live Microsoft Dynamics CRM in Redash for querying, visualizing, and sharing.

• Analyze SQL Server in R

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

• Prepare, Blend, and Analyze Oracle Eloqua in Alteryx Designer

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

• Work with Live Amazon Athena in Power Query

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

• How to connect to Sybase from IntelliJ

  Integrate connectivity to Sybase with wizards in IntelliJ.

• Certinia Reporting in OBIEE with the Certinia JDBC Driver

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

• How to Work with HDFS in ETL Validator JDBC

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

• Write a Simple Go Application to work with MailChimp on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MailChimp.

• Automated Continuous Salesloft Replication to Databricks

  Use CData Sync for automated, continuous, customizable Salesloft replication to Databricks.

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

  Provide connectivity to Kintone through an SAP BusinessObjects universe.

• View Reports on Real-Time Unbounce in Power BI Report Server

  Use the CData ODBC Driver for Unbounce to visualize Unbounce in Power BI Desktop and then publish them to Power BI Report Server.

• Google Drive Reporting and Star Schemas in OBIEE

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

• Analyze SharePoint with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for SharePoint from Power Pivot. You will use the Table Import Wizard to load Microsoft SharePoint. You can visually build the import query or use any SQL supported by the driver.

• Build HubSpot-Connected Apps in Choreo

  Use CData Connect Cloud to connect to HubSpot from Choreo and build custom apps using live HubSpot.

• Visualize Jira from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Atlassian Jira.

• Connect to SAP HANA XS Advanced in JRuby

  Create a simple JRuby app with access to live SAP HANA XS Advanced.

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

  Connect to Microsoft Dataverse (CDS) from a connection pool in Tomcat.

• Access Shopify in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Shopify.

• Use the CData ODBC Driver for HCL Domino in Microsoft Power Query

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

• Connect to SQL Server as an External Source in Dremio

  Use the CData JDBC Driver to connect to SQL Server as an External Source in Dremio.

• Extract, Transform, and Load MailChimp in Informatica PowerCenter

  Create a simple Workflow for MailChimp in Informatica PowerCenter.

• Replicate Redshift from PowerShell

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

• Use JayDeBeApi to access BigQuery in Python

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

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

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

• Build EventBrite-Connected Web Apps in Servoy

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

• Build a Simple VCL Application for Access

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

• Automated Continuous Office 365 Replication to SQL Server

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

• How to Build Dynamic React Apps with Parquet

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

• How to connect Amazon QuickSight to Google Search Results

  Create a connection to Google Search in CData Connect Cloud and insert Google Search into Amazon QuickSight SPICE to build interactive dashboards.

• Operational Reporting on GraphQL from Spotfire Server

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

• Access Live TaxJar in TIBCO Data Virtualization

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

• Visualize Veeva from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Veeva Vault.

• Build Odoo-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Odoo from Zoho Analytics and import live Odoo ERP.

• Import Real-Time Klipfolio in ColdFusion to Build Applications

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

• Visualize Bing Ads in TIBCO Spotfire through ODBC

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

• Create a Data Access Object for Epicor Kinetic using JDBI

  A brief overview of creating a SQL Object API for Epicor Kinetic in JDBI.

• Use the CData Software ODBC Driver for Sugar CRM in MicroStrategy

  Connect to Sugar CRM in MicroStrategy Developer using the CData Software ODBC Driver for Sugar CRM.

• How to connect to Salesforce from Spring Boot

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

• Create Data Visualizations Based On Azure Analysis Services in Mode

  Use CData Connect Cloud to connect to Azure Analysis Services from Mode and build visualizations using live

• Connect to Aha in RunMyProcess through Connect Server

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

• How to Connect DBeaver to Shopify via a JDBC Driver

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

• Object-Relational Mapping (ORM) with SAP ByDesign 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 Business ByDesign into a Java-based ORM framework, Hibernate.

• Build Automated Snapchat Ads-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Snapchat Ads and build automated workflows in Zapier.

• Build an OLAP Cube in SSAS from Google Campaign Manager 360

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

• Establish a Live Connection with Google Drive using Tableau Bridge

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

• How to connect and process SAS Data Sets from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live SAS Data Sets

• Connect to Greenhouse in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

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

• Connect to Salesloft in RapidMiner

  Integrate Salesloft with standard components and data source configuration wizards in RapidMiner Studio.

• Access EventBrite as a Remote Oracle Database

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

• Connect to YouTube Analytics as a SQL Server Linked Server

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

• Manage Blackbaud FE NXT in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Blackbaud FE NXT.

• Connect to Zoho Books in Airbyte ELT Pipelines

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

• Automate CSV Replication to Azure Data Lake

  Use CData Sync to customize and automate CSV/TSV Files replication to Azure Data Lake.

• Connect to Google Contacts from AWS Glue

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

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

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

• Access Elasticsearch in PHP through Connect Server

  Connect to Elasticsearch through the standard SQL Server libraries in PHP.

• Write a Simple Go Application to work with JSON Services on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to JSON.

• Stream TaxJar into Apache Kafka Topics

  Access and stream TaxJar in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Automated Continuous Zenefits Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Zenefits replication to SQL Server.

• Connect to Salesforce in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Access FTP in PHP through Connect Server

  Connect to FTP through the standard SQL Server libraries in PHP.

• Using the CData Software ODBC Driver for MySQL in PyCharm

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

• Object-Relational Mapping (ORM) with Google Calendar 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 Google Calendar into a Java-based ORM framework, Hibernate.

• Automated Continuous SAP SuccessFactors Replication to Apache Kafka

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

• Access Salesforce Pardot in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Salesforce Pardot.

• Replicate Oracle Financials Cloud to Multiple Databases

  Replicate Oracle Financials Cloud to disparate databases with a point-and-click configuration.

• Use JayDeBeApi to access Avro in Python

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

• ETL Azure Data Lake Storage in Oracle Data Integrator

  This article shows how to transfer Azure Data Lake Storage into a data warehouse using Oracle Data Integrator.

• Automated Continuous Stripe Replication to Google Cloud SQL

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

• How to connect PolyBase to Freshdesk

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

• How to Connect to & Open NetSuite in Microsoft Excel

  This article uses the CData ODBC driver for NetSuite to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

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

  Use CData Power BI Connectors to visualize Aha! in Power BI.

• Analyze SQL Analysis Services in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of SQL Analysis Services and visualize SQL Analysis Services in SAP Analytics Cloud.

• Automated Continuous Acumatica Replication to AlloyDB

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

• Analyze ClickUp in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of ClickUp and visualize live ClickUp in Ingragistics Reveal.

• How to work with SAS xpt in Apache Spark using SQL

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

• «
• 146
• 147
• 148
• 149
• 150
• 151
• 152
• 153
• 154
• 155
• »