CData Software - Knowledge Base

Recent Articles

• «
• 238
• 239
• 240
• 241
• 242
• 243
• 244
• 245
• 246
• 247
• »

• Operational Reporting on Coinbase from Spotfire Server

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

• Process & Analyze eBay in Databricks (AWS)

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

• Access HubDB from MySQL in Amazon QuickSight

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

• Use the CData SSIS Components to Insert New or Update Existing Presto Records from SQL Server

  Easily push SQL Server data to Presto using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Presto or update existing records with data from a SQL Server database.

• Prepare, Blend, and Analyze Microsoft Project in Alteryx Designer

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

• Visualize Facebook in Tableau

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

• How to use SQLAlchemy ORM to access Cloudant in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of IBM Cloudant.

• Create Apps from SAP Concur in Qlik Sense Cloud

  Use CData Connect Cloud to connect to SAP Concur and build apps from live SAP Concur in Qlik Sense Cloud.

• Perform Batch Operations with Certinia in Apache NiFi

  Connect to Certinia and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Import Real-Time Bing Search Results in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Bing Search in ColdFusion.

• Automate Drip Integration Tasks from PowerShell

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

• Automate QuickBooks Time Replication to Couchbase

  Use CData Sync to Customize and automate QuickBooks Time replication to Couchbase.

• Manage HCL Domino in DBArtisan as a JDBC Source

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

• How to Use a Microsoft Access Database to Update MariaDB in Real Time

  Update MariaDB data by creating a linked table in Microsoft Access with the CData MariaDB ODBC Driver.

• Automated Continuous SAP Concur Replication to Oracle

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

• Import and Visualize Teradata in Power View

  Create data visualizations based on Teradata in Excel.

• Build Stripe-Connected Apps in Choreo

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

• Connect to MailChimp in Aqua Data Studio

  Access MailChimp from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Automate XML Integration Tasks from PowerShell

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

• Access Act-On from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Act-On from HeidiSQL.

• Connect to SAP Fieldglass in DBeaver

  Use the CData ODBC Driver to connect to SAP Fieldglass in DBeaver.

• Create Microsoft Teams-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Microsoft Teams from Klipfolio and build custom visualizations using live Microsoft Teams.

• Connect to HubSpot in JRuby

  Create a simple JRuby app with access to live HubSpot.

• Import Google Search Results into FileMaker Pro

  Create reports that integrate Google Search in Filemaker Pro.

• Connect to ADP in DBeaver

  Use the CData ODBC Driver to connect to ADP in DBeaver.

• How to load SAP Ariba Procurement data into Elasticsearch via Logstash

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

• Add Klaviyo to Informatica Enterprise Data Catalog

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

• Stream HBase into Apache Kafka Topics

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

• Marketo Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Marketo through CData Connect Cloud using different applications and tools.

• A PostgreSQL Interface for SAP HANA XS Advanced

  Use the Remoting features of the SAP HANA XS Advanced JDBC Driver to create a PostgreSQL entry-point for data access.

• Automated Continuous Cosmos DB Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Cosmos DB replication to MongoDB.

• Visualize SingleStore in TIBCO Spotfire through ODBC

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

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

  Provide connectivity to Klipfolio through an SAP BusinessObjects universe.

• Working with FHIR in LINQPad

  Execute LINQ queries to FHIR in LINQPad.

• Connect to OData Services in DBArtisan

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

• Create Zoho Projects-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Zoho Projects from Klipfolio and build custom visualizations using live Zoho Projects.

• Connect to MariaDB in Google Apps Script

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

• Feed Jira into FineReport

  How to set Atlassian Jira as a JDBC data source in FineReport.

• Connect to Sage 50 UK in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automated Continuous Google Ad Manager Replication to Amazon Redshift

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

• Automated Continuous Epicor Kinetic Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to PostgreSQL.

• How to Import Shopify into SQL Server using SSIS

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

• Connect to PayPal from PowerBuilder

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

• Extract, Transform, and Load Databricks in Informatica PowerCenter

  Create a simple Workflow for Databricks in Informatica PowerCenter.

• Visualize SAS xpt in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for SAS XPORT in CData Software Connect (or Connect Server) and build visualizations from live SAS XPORT in Tableau Desktop.

• Build Exact Online Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Exact Online and build visualizations in Tableau Cloud.

• Build Interactive Dashboards from SAP in Amazon QuickSight

  Create a virtual SQL Server database for SAP ERP/NetWeaver in CData Software Connect Server and import SAP ERP/NetWeaver into Amazon QuickSight SPICE to build interactive dashboards.

• Create Blackbaud FE NXT-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Blackbaud FE NXT from Nintex Workflow Cloud and build custom workflows using live Blackbaud FE NXT.

• Connect to Stripe in DBeaver

  Use the CData ODBC Driver to connect to Stripe in DBeaver.

• Connect to SAP ByDesign in JRuby

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

• Databricks Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Databricks through CData Connect Cloud using different applications and tools.

• Automated Continuous Microsoft Exchange Replication to Amazon S3

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

• Design BIRT Reports on Sybase IQ

  Provide current Sybase IQ to your embedded analytics.

• Create Informatica Mappings From/To an ODBC Data Source for Oracle HCM Cloud

  Create an ODBC connection to Oracle HCM Cloud in Informatica and browse and transfer Oracle HCM Cloud.

• Use JayDeBeApi to access SendGrid in Python

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

• Enable the HBase JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Apache HBase.

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

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

• Access Live ServiceNow in Excel (Desktop)

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

• Connect to Live Acumatica in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Acumatica in CData Connect Cloud and connect to your Acumatica ERP from PostgreSQL.

• Connect to Google Campaign Manager 360 from a Connection Pool in Jetty

  The Google Campaign Manager 360 JDBC Driver supports connection pooling: This article shows how to connect faster to Google Campaign Manager 360 from Web apps in Jetty.

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

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

• Automate Box Replication to Azure Synapse

  Use CData Sync to customize and automate Box replication to Azure Synapse.

• Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy Desktop

  Connect to SAP Netweaver Gateway in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Netweaver Gateway.

• Use the CData SSIS Components to Insert New or Update Existing Workday Records from SQL Server

  Easily push SQL Server data to Workday using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Workday or update existing records with data from a SQL Server database.

• Automated Continuous QuickBooks Time Replication to Vertica

  Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Vertica.

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

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

• Integrate Live MailChimp into Custom Business Apps Built in Power Apps

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

• Visualize PayPal in TIBCO Spotfire through ODBC

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

• Connect to Gmail in Ruby

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

• Hive Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache Hive through CData Connect Cloud using different applications and tools.

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

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

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

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

• Manage Microsoft OneDrive in DBArtisan as a JDBC Source

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

• How to connect to Azure DevOps from Spring Boot

  Connect to Azure DevOps in a Spring Boot Application using CData JDBC Azure DevOps Driver

• How to work with IBM Cloud Object Storage in Apache Spark using SQL

  Access and process IBM Cloud Object Storage in Apache Spark using the CData Software JDBC Driver.

• Viewing Drip in RAD Studio Data Explorer

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

• Connect to SAP Business One in Jaspersoft Studio

  Execute SQL to remote SAP Business One in Jaspersoft Studio.

• Replicate Multiple Amazon DynamoDB Accounts

  Replicate multiple Amazon DynamoDB accounts to one or many databases.

• Connect to Shopify in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to FHIR from Crystal Reports

  Use CData Connect Cloud to connect to and report on live FHIR from Crystal Reports.

• Use the CData Software ODBC Driver for Couchbase in MicroStrategy

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

• Build Oracle-Connected Apps in Bubble

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

• Create Email-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Email from Klipfolio and build custom visualizations using live Email.

• How to create SFTP federated tables in MySQL

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

• Replicate Multiple Raisers Edge NXT Accounts

  Replicate multiple Raisers Edge NXT accounts to one or many databases.

• Connect to Access from a Connection Pool in WebLogic

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

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

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

• Integrate Microsoft Teams into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Microsoft Teams and integrate live Microsoft Teams into your Power Automate tasks.

• Use the CData Software JDBC Driver for Excel Online in MicroStrategy Web

  Connect to Microsoft Excel Online in MicroStrategy Web using the CData Software JDBC Driver for Excel Online.

• Build Azure Synapse-Connected Web Apps with Axios and CData Connect Cloud

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

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

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

• Integrate with BigCommerce in JReport Designer

  Create charts and reports based on BigCommerce in JReport Designer.

• How to connect Amazon QuickSight to Dynamics 365 Business Central

  Create a connection to Dynamics 365 Business Central in CData Connect Cloud and insert Dynamics 365 Business Central into Amazon QuickSight SPICE to build interactive dashboards.

• Integrate with SAP using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP ERP/NetWeaver to a JSON file on disk.

• Viewing Act CRM in RAD Studio Data Explorer

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

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

  Use the Connect Server to connect to live Apache HDFS in the Power Pivot business intelligence tool.

• PowerShell Scripting to Replicate BambooHR to MySQL

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

• Use the CData Software ODBC Driver for HBase in MicroStrategy Web

  Connect to Apache HBase in MicroStrategy Web using the CData Software ODBC Driver for HBase.

• Work with WordPress in FoxPro

  Load WordPress into a FoxPro database. This article includes full code and a walk-through of the process.

• Automated Continuous Google Campaign Manager 360 Replication to Vertica

  Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Vertica.

• «
• 238
• 239
• 240
• 241
• 242
• 243
• 244
• 245
• 246
• 247
• »