CData Software - Knowledge Base

Recent Articles

• «
• 86
• 87
• 88
• 89
• 90
• 91
• 92
• 93
• 94
• 95
• »

• Automated Continuous EventBrite Replication to Vertica

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

• Use the CData Software ODBC Driver for Todoist in MicroStrategy

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

• Feed Salesforce Marketing into FineReport

  How to set Salesforce Marketing Cloud as a JDBC data source in FineReport.

• Build DocuSign-Connected Web Apps in Servoy

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

• How to publish and share WooCommerce dashboards with Tableau Server

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

• Connect to Avro in SpagoBI

  Create reports featuring live Apache Avro in SpagoBI Studio. Host Avro reports on SpagoBI Server.

• Use JayDeBeApi to access Impala in Python

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

• Bidirectional Access to Elasticsearch from FileMaker Pro

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

• How to connect to Azure Data Catalog from Spring Boot

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

• Query IBM Cloud Data Engine as a SQL Server in Node.js

  Execute SQL Server queries against IBM Cloud Data Engine from Node.js.

• DataBind XML to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for XML with the DevExpress Windows Forms and Web controls to provide XML Files to a chart.

• Replicate Multiple JSON Accounts

  Replicate multiple JSON accounts to one or many databases.

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

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

• Create SQL Analysis Services-Connected Nintex Workflows

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

• Analyze Shippo in Infragistics Reveal

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

• Connect to Live ShipStation in MicroStrategy through CData Connect Cloud

  Create a live connection to ShipStation in CData Connect Cloud and connect to your ShipStation from MicroStrategy.

• Access Live Dynamics 365 in AWS Lambda (with IntelliJ IDEA)

  Connect to live Microsoft Dynamics 365 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Automated Continuous LinkedIn Ads Replication to Amazon S3

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

• How to work with Twitter in Apache Spark using SQL

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

• Automate XML Replication to Couchbase

  Use CData Sync to Customize and automate XML Files replication to Couchbase.

• Build MVC Applications with Connectivity to EventBrite

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

• Build Visualizations of OneNote in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft OneNote in Birst.

• Automated Continuous Asana Replication to Microsoft Access

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

• Automated Continuous SAP ByDesign Replication to Apache Cassandra

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

• Connect to Couchbase in Google Apps Script

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

• Visualize Amazon DynamoDB in Sisense

  Create an ElastiCube in Sisense app with access to Amazon DynamoDB.

• Excel Spreadsheet Automation with the QUERY Formula

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

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

• Query Redshift in DataGrip

  Create a Data Source for Redshift in DataGrip and use SQL to query live Amazon Redshift.

• Publish Trello-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Trello.

• Add eBay to Informatica Enterprise Data Catalog

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

• Query Procore as a SQL Server in Node.js

  Execute SQL Server queries against Procore from Node.js.

• Work with Live Quickbase in Power Query

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

• Automated Continuous Zuora Replication to Microsoft Access

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

• Connect to Invoiced as a Linked Server

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

• Connect to Snapchat Ads from Asprova with CData Software ODBC Driver for Snapchat Ads

  This article shows how to connect faster to Snapchat Ads data from Asprova.

• How to connect to Presto in DBVisualizer

  Integrate Presto with visual data analysis tools and data connection wizards in DBVisualizer

• Extract, Transform, and Load Adobe Analytics in Informatica PowerCenter

  Create a simple Workflow for Adobe Analytics in Informatica PowerCenter.

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

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

• Connect to xBase in Aqua Data Studio

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

• How to create GraphQL federated tables in MySQL

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

• Visualize SFTP in Sisense

  Create an ElastiCube in Sisense app with access to SFTP.

• Replicate Twitter Ads to Multiple Databases

  Replicate Twitter Ads to disparate databases with a point-and-click configuration.

• How to update Odoo from Excel

  This article explains how to transfer data from Excel to Odoo using the Excel Add-In for Odoo.

• How to connect to AlloyDB in DBVisualizer

  Integrate Google AlloyDB with visual data analysis tools and data connection wizards in DBVisualizer

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

  Connect to Zoho Books from a connection pool in Tomcat.

• Query, Visualize, and Share live Microsoft Project in Redash

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

• Connect to MySQL from Blazor Apps

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

• Connect to QuickBooks from a Connection Pool in Jetty

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

• Natively Connect to CSV in PHP

  The CData ODBC driver for CSV enables you to create PHP applications with connectivity to CSV/TSV Files. Leverage the native support for ODBC in PHP.

• Replicate Authorize.Net to Multiple Databases

  Replicate Authorize.Net to disparate databases with a point-and-click configuration.

• Build Confluence-Connected Apps in Choreo

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

• Automated Continuous IBM Cloud Data Engine Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable IBM Cloud Data Engine replication to PostgreSQL.

• Visualize Hive in TIBCO Spotfire through OData

  Integrate Apache Hive into dashboards in TIBCO Spotfire.

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

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

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

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

• Explore Geographical Relationships in SAP HANA XS Advanced with Power Map

  Create data visualizations with SAP HANA XS Advanced in Power Map.

• Use the CData Software JDBC Driver for PostgreSQL in MicroStrategy

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

• Connect to BigCommerce in RazorSQL

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

• Build Automated Instagram-Connected Workflows in Zapier

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

• Automated Continuous GraphQL Replication to MySQL

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

• Create DocuSign Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time DocuSign data access from reports, embedded analytics, and more.

• Connect to EventBrite as an External Source in Dremio

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

• Use the CData Software JDBC Driver for SQL Server in MicroStrategy Web

  Connect to Microsoft SQL Server in MicroStrategy Web using the CData Software JDBC Driver for SQL Server.

• Use Dash to Build to Web Apps on SAP BusinessObjects BI

  Create Python applications that use pandas and Dash to build SAP BusinessObjects BI-connected web apps.

• Manage SendGrid in DBArtisan as a JDBC Source

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

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

  Connect to Twilio from a connection pool in Tomcat.

• How to connect to eBay Analytics from MS Excel on Mac OS X

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

• Connect to LinkedIn Ads from HeidiSQL

  Use CData Connect Cloud to connect to and query live LinkedIn Ads from HeidiSQL.

• Access GitHub from MySQL in HeidiSQL

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

• Automated Continuous Google Ad Manager Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Azure SQL.

• Use the CData Software ODBC Driver for SFTP in MicroStrategy Desktop

  Connect to SFTP in MicroStrategy Desktop using the CData Software ODBC Driver for SFTP.

• Automated Continuous MySQL Replication to AlloyDB

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

• Integrate with Facebook Ads using Apache Camel2

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

• Query Sybase in MySQL Workbench

  Create a virtual MySQL database for Sybase in CData Software Connect (or Connect Server) and work with live Sybase in MySQL Workbench.

• How to connect to LinkedIn in DBVisualizer

  Integrate LinkedIn with visual data analysis tools and data connection wizards in DBVisualizer

• How to Import Klipfolio into SQL Server using SSIS

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

• PowerShell Scripting to Replicate SendGrid to MySQL

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

• Create Datasets from Dynamics 365 Business Central in Domo Workbench and Build Visualizations of Dynamics 365 Business Central in Domo

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

• Connect to HarperDB from a Connection Pool in JBoss

  Integrate HarperDB into Java servlets: Use the Management Console in JBoss to install the HarperDB JDBC Driver.

• Connect to Sage 50 UK in CloverDX (formerly CloverETL)

  Transfer Sage 50 UK using the visual workflow in the CloverDX data integration tool.

• Connect to JDBC-ODBC Bridge in NetBeans

  Connect to JDBC-ODBC Bridge in NetBeans with the data source configuration wizard.

• How to pipe Invoiced to CSV in PowerShell

  Use standard PowerShell cmdlets to access Invoiced tables.

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

  Connect to Xero Accounting in MicroStrategy Web using the CData Software ODBC Driver for Xero.

• Design BIRT Reports on Paylocity

  Provide current Paylocity to your embedded analytics.

• Build Invoiced-Connected Web Apps in Servoy

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

• Automate Sybase IQ Replication to Couchbase

  Use CData Sync to Customize and automate Sybase IQ replication to Couchbase.

• How to create an RPA flow for Salesforce in UiPath Studio

  Use the Salesforce ODBC Driver to create workflows that access real-time Salesforce & Force.com without any coding.

• Query SAP Concur as a MySQL Database in Node.js

  Execute MySQL queries against SAP Concur from Node.js.

• Analyze Live Databricks in SAS Viya

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

• Use Dash to Build to Web Apps on Greenplum

  Create Python applications that use pandas and Dash to build Greenplum-connected web apps.

• Connect to MariaDB in DBArtisan

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

• Connect to Google Cloud Storage in SpagoBI

  Create reports featuring live Google Cloud Storage in SpagoBI Studio. Host Google Cloud Storage reports on SpagoBI Server.

• Access SAS Data Sets from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live SAS Data Sets from HeidiSQL.

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

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

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

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

• Operational Reporting on Odoo from Spotfire Server

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

• How to Connect DBeaver to Workday via a JDBC Driver

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

• Use the CData ODBC Driver for Parquet from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Parquet to connect to Apache Parquet from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Parquet in Excel.

• Access Live Salesforce in AWS Lambda (with IntelliJ IDEA)

  Connect to live Salesforce & Force.com in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• «
• 86
• 87
• 88
• 89
• 90
• 91
• 92
• 93
• 94
• 95
• »