CData Software - Knowledge Base

Recent Articles

• «
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• 316
• »

• How to connect to MYOB AccountRight in DBVisualizer

  Integrate MYOB AccountRight with visual data analysis tools and data connection wizards in DBVisualizer

• Connect to ActiveCampaign from AWS Glue

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

• Replicate Microsoft Dataverse in Heroku for Use in Salesforce Connect

  Replicate Microsoft Dataverse (CDS) to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Access Live OneNote in Coginiti Pro

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

• Integrate with SharePoint Excel Services using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SharePoint Excel Services to a JSON file on disk.

• Excel Spreadsheet Automation on Dynamics NAV with the QUERY Formula

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

• How to Connect to & Open Zuora in Microsoft Excel

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

• Replicate ShipStation in Heroku for Use in Salesforce Connect

  Replicate ShipStation to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Access Teradata from MySQL in Amazon QuickSight

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

• Provide OData Services of HBase from a WCF Application

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

• Bidirectional Access to Salesforce from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce & Force.com in Filemaker Pro for Mac or Windows.

• Prepare, Blend, and Analyze PayPal in Alteryx Designer (ODBC)

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

• Visualize Live Oracle Sales in the Power BI Service

  Use CData Connect Cloud to connect to live Oracle Sales and create custom reports in the Power BI Service through the On-Premises Gateway.

• Extract, Transform, and Load IBM Informix in Informatica PowerCenter

  Create a simple Workflow for IBM Informix in Informatica PowerCenter.

• Access Facebook Ads 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 Facebook Ads.

• Automate Snowflake Replication to Azure Synapse

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

• Analyze Odoo in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Odoo ERP in Microsoft R Open.

• Visualize Certinia in Tableau

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

• Model Instagram Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Instagram, enabling the direct import of real-time Instagram.

• Automated Continuous Shippo Replication to Databricks

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

• How to Seamlessly Import Dynamics 365 Data into IBM SPSS Modeler

  Integrate Dynamics 365 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

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

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

• LINQ to Greenhouse

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

• Perform Batch Operations with Facebook Ads in Apache NiFi

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

• How to Work with Asana in AWS Glue Jobs Using JDBC

  Connect to Asana from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Visualize Excel Online in TIBCO Spotfire through ADO.NET

  Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.

• Access Live Microsoft OneDrive Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Microsoft OneDrive data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

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

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

• PowerShell Scripting to Replicate Zoho Creator to MySQL

  Write a simple PowerShell script to replicate Zoho Creator to a MySQL database.

• Connect to Zoho Inventory from a Connection Pool in Jetty

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

• Build Dashboards with Microsoft Teams in Dundas BI

  Create dynamic dashboards and perform analytics based on Microsoft Teams in Dundas BI.

• Access Live Cosmos DB in AWS Lambda

  Connect to live Azure Cosmos DB in AWS Lambda using the CData JDBC Driver.

• Integrate HarperDB in the Pentaho Report Designer

  Publish reports based on HarperDB in the Pentaho BI tool.

• Automated Continuous Google Sheets Replication to Oracle

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

• Integrate with Unbounce using Apache Camel2

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

• Connect to Microsoft Planner from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Planner, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Prepare, Blend, and Analyze Sage Intacct in Alteryx Designer (Connect Cloud)

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

• How to create Authorize.Net federated tables in MySQL

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

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

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

• How to connect to Greenhouse with Squirrel SQL client

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

• Access BigCommerce 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 BigCommerce.

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

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

• Automated Continuous Bullhorn CRM Replication to Amazon S3

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

• Build a Simple VCL Application for GraphQL

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

• Back Up Harvest to SQL Server through SSIS

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Amazon Athena

  Provide connectivity to Amazon Athena through an SAP BusinessObjects universe.

• Use the CData API Server to Access Facebook in Microsoft PowerPivot

  Use the CData API Server to connect to live Facebook in the Power Pivot business intelligence tool.

• Bidirectional Access to Clio from FileMaker Pro

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

• Connect to Microsoft Teams from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Teams using standard SQL.

• Automated Continuous WooCommerce Replication to MongoDB

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

• Access Live Microsoft OneDrive in TIBCO Data Virtualization

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

• Analyze SAP Hybris C4C in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of SAP Hybris C4C and visualize SAP Hybris C4C in SAP Analytics Cloud.

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

  Connect to Couchbase from a connection pool in Tomcat.

• Visualize Twitter in Sisense

  Create an ElastiCube in Sisense app with access to Twitter.

• Visualize HCL Domino in TIBCO Spotfire through ODBC

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

• Create Power BI Reports on Real-Time SAP HANA

  Use the CData ODBC Driver for SAP HANA to visualize SAP HANA in Power BI Desktop.

• Automated Continuous Printful Replication to Local Delimited Files

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

• Create SSAS Tabular Models from SAP Business One

  How to build a SQL Server Analysis Service Tabular Model from SAP Business One using CData drivers.

• Connect to Parquet in Aqua Data Studio

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

• Connect to Kafka in RapidMiner

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

• Integrate with Google Campaign Manager 360 in JReport Designer

  Create charts and reports based on Google Campaign Manager 360 in JReport Designer.

• Automate Sybase Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Sybase and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Import Real-Time Airtable via ODBC in ColdFusion to Build Applications

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

• Replicate CouchDB to Multiple Databases

  Replicate Apache CouchDB to disparate databases with a point-and-click configuration.

• Visualize Azure DevOps in TIBCO Spotfire through ODBC

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

• Automated Continuous MailChimp Replication to SQL Server

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

• Automated Continuous SAP ByDesign Replication to SingleStore

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

• Create Reports from CockroachDB in Looker Studio

  Use CData Connect Cloud to gain access to live CockroachDB and create custom reports in Looker Studio.

• Build Apps with Live Blackbaud FE NXT in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Blackbaud FE NXT into the Adalo platform and build custom mobile and web applications with real-time Blackbaud FE NXT.

• Automate Sage Intacct Replication to Azure Data Lake

  Use CData Sync to customize and automate Sage Intacct replication to Azure Data Lake.

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

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

• Connect to Google Drive in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Google Drive in Airbyte.

• SAS Data Sets Reporting in OBIEE with the SAS Data Sets JDBC Driver

  Deploy the SAS Data Sets JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• How to use SQLAlchemy ORM to access Square in Python

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

• Connect to AlloyDB in Google Apps Script via SQL Gateway

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

• Automated Continuous Snapchat Ads Replication to Google Cloud SQL

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

• Work with Office 365 in FoxPro

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

• Use the CData Software JDBC Driver for OData in MicroStrategy

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

• Replicate Multiple Todoist Accounts

  Replicate multiple Todoist accounts to one or many databases.

• Choosing the Best Method to Connect SAP Ariba Source to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use SAP Ariba Source from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Process & Analyze Amazon S3 in Databricks (AWS)

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

• Build Excel Online-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Microsoft Excel Online and build web apps with connectivity to live Microsoft Excel Online.

• Extract, Transform, and Load Microsoft Teams in Informatica PowerCenter

  Create a simple Workflow for Microsoft Teams in Informatica PowerCenter.

• Access Live Zoho Inventory in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Zoho Inventory from your Excel spreadsheets.

• Connect to xBase in RazorSQL

  Connect to xBase from wizards and query xBase from the GUI in the RazorSQL database management tool.

• Use JayDeBeApi to access LinkedIn in Python

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

• How to Import Data from Kafka into Google Sheets

  Import Apache Kafka into a Google spreadsheet that is automatically refreshed.

• Analyze Google Sheets in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of Google Sheets and visualize live Google Sheets in Infragistics Reveal.

• Visualize HDFS from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Apache HDFS.

• Replicate Multiple Highrise Accounts via the CData Sync CLI

  Replicate multiple Highrise accounts to one or many databases.

• Integrate Live Zuora into Blue Prism for Intelligent Robotic Process Automation (RPA)

• «
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• 314
• 315
• 316
• »