CData Software - Knowledge Base

Recent Articles

• «
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• 123
• 124
• 125
• »

• Connect to Airtable from a Connection Pool in JBoss

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

• Connect to BigCommerce from PowerBuilder

  This article demonstrates how to access BigCommerce from Appeon PowerBuilder using the CData ADO.NET Provider for BigCommerce.

• DataBind EventBrite to the DevExpress Data Grid

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

• Analyze PayPal in R

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

• Prepare, Blend, and Analyze Neo4J in Alteryx Designer

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

• Analyze Veeva in Looker

  Use CData Connect Cloud to connect to Veeva from Looker and build custom apps using live Veeva Vault.

• How to connect to IBM Informix in DBVisualizer

  Integrate IBM Informix with visual data analysis tools and data connection wizards in DBVisualizer

• Write a Simple Go Application to work with Avalara AvaTax on Linux

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

• How to pipe Sage Intacct to CSV in PowerShell

  Use standard PowerShell cmdlets to access Sage Intacct tables.

• A PostgreSQL Interface for Klipfolio

  Use the Remoting features of the Klipfolio ODBC Driver to create a PostgreSQL entry-point for data access.

• Automated Continuous Slack Replication to Apache Cassandra

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

• Connect to Veeva from a Connection Pool in JBoss

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

• Connect to and Query ServiceNow in QlikView over ODBC

  Create data visualizations with ServiceNow in QlikView.

• Excel Spreadsheet Automation with the QUERY Formula

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

• How to Work with QuickBooks Time in AWS Glue Jobs Using JDBC

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

• Using AngularJS to Build Dynamic Web Pages with Google Ads

  Use the CData Connect Server to create Google Ads OData feeds and build single-page applications with live Google Ads.

• Access Live Quickbase in AWS Lambda

  Connect to live Quickbase in AWS Lambda using the CData JDBC Driver.

• Connect to Adobe Analytics from Asprova with CData Software ODBC Driver for Adobe Analytics

  This article shows how to connect faster to Adobe Analytics data from Asprova.

• Access Parquet from MySQL in PHP

  Connect to Parquet through the standard MySQL libraries in PHP.

• Connect to SAS Data Sets from a Connection Pool in JBoss

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

• Query Azure Data Catalog as a SQL Server in Node.js

  Execute SQL Server queries against Azure Data Catalog from Node.js.

• Using AngularJS to Build Dynamic Web Pages with Kintone

  Use the CData Connect Server to create Kintone OData feeds and build single-page applications with live Kintone.

• Integrate EnterpriseDB in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live EnterpriseDB from Informatica Cloud.

• Feed CouchDB into FineReport

  How to set Apache CouchDB as a JDBC data source in FineReport.

• Design BIRT Reports on Kintone

  Provide current Kintone to your embedded analytics.

• Visualize QuickBooks Online from Tableau

  Use the Tableau Desktop business intelligence tool to connect to QuickBooks Online.

• Replicate Multiple Calendly Accounts

  Replicate multiple Calendly accounts to one or many databases.

• A PostgreSQL Interface for Avro

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

• How to Connect to Salesforce Pardot in Using Python: 6 Steps

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

• Automated Continuous Raisers Edge NXT Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Google Cloud SQL.

• Automated Continuous Avro Replication to Databricks

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

• Create ClickUp Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Write a Simple Go Application to work with Azure Synapse on Linux

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

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

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

• Bidirectional Access to CSV from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate CSV/TSV Files in Filemaker Pro for Mac or Windows.

• Use the CData Software ODBC Driver for Raisers Edge NXT in MicroStrategy

  Connect to Raisers Edge NXT in MicroStrategy Developer using the CData Software ODBC Driver for Raisers Edge NXT.

• Integrate with live Oracle Service Cloud in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Oracle Service Cloud in Jitterbit.

• Build Microsoft Dataverse Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Microsoft Dataverse (CDS) and build visualizations in Tableau.

• Connect to Unbounce from PowerBuilder

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Connect to and Query Bing Ads in QlikView over ODBC

  Create data visualizations with Bing Ads in QlikView.

• Import Real-Time DocuSign in ColdFusion to Build Applications

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

• Manage SurveyMonkey in DBArtisan as a JDBC Source

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

• Query Bullhorn CRM as a MySQL Database in Node.js

  Execute MySQL queries against Bullhorn CRM from Node.js.

• Create Cosmos DB Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• PowerShell Scripting to Replicate Shippo to MySQL

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

• Connect to Google Campaign Manager 360 from HeidiSQL

  Use CData Connect Cloud to connect to and query live Google Campaign Manager 360 from HeidiSQL.

• Use Dash to Build to Web Apps on Snowflake

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

• Natively Connect to SAP BusinessObjects BI in PHP

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

• Build Visualizations of YouTube Analytics in Birst

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

• Import and Visualize Amazon Marketplace in Power View

  Create data visualizations based on Amazon Marketplace in Excel.

• Create MySQL Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for MySQL to build custom dashboards in Bold BI.

• PowerShell Scripting to Replicate WordPress to MySQL

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

• Connect to BambooHR in DBeaver

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

• LINQ to SendGrid

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

• Extract, Transform, and Load Aha in Informatica PowerCenter

  Create a simple Workflow for Aha! in Informatica PowerCenter.

• Automated Continuous DocuSign Replication to Oracle

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

• Automate Cosmos DB Replication to Couchbase

  Use CData Sync to Customize and automate Azure Cosmos DB replication to Couchbase.

• Integrate with Sage Cloud Accounting using Apache Camel2

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

• Replicate Google Calendar to Multiple Databases

  Replicate Google Calendar to disparate databases with a point-and-click configuration.

• Automated Continuous Sybase IQ Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Sybase IQ replication to Google BigQuery.

• Load QuickBooks Online to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load QuickBooks Online to a database.

• How to Query Reckon Accounts Hosted in MySQL Workbench

  Execute MySQL queries against live Reckon Accounts Hosted from MySQL Workbench.

• Model Couchbase Using Azure Analysis Services

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

• Connect to Amazon Marketplace in Google Apps Script

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

• Build Jira Service Management-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Atlassian Jira Service Management and build Jira Service Management-connected web apps with Axios.

• Build Apps with Live Google Spanner in Adalo using CData Connect Cloud

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

• Write a Simple Go Application to work with Outreach.io on Linux

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

• Create Dynamic Microsoft Project Grids Using the Infragistics XamDataGrid

  Learn how you can connect Microsoft Project to Infragistics XamDataGrid to build dynamic grids.

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

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

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

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

• Build HarperDB Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for HarperDB and build visualizations in Tableau Cloud.

• How to Connect the Power BI Service to Typeform: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Replicate Multiple Drip Accounts

  Replicate multiple Drip accounts to one or many databases.

• Create Acumatica-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Acumatica from OutSystems and build custom enterprise apps using live Acumatica ERP.

• Create Snowflake-Connected Business Apps in AppSheet

  Connect to Snowflake via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Snowflake.

• How to Access Neo4J Using Entity Framework

  This article shows how to access Neo4J using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Access SFTP from MySQL in Amazon QuickSight

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

• Export Data from SQL Server to Oracle Eloqua through SSIS

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

• Access Live Facebook Ads in AWS Lambda

  Connect to live Facebook Ads in AWS Lambda using the CData JDBC Driver.

• Integrate with eBay Analytics in JReport Designer

  Create charts and reports based on eBay Analytics in JReport Designer.

• Create Reports with YouTube Analytics in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date YouTube Analytics.

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

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

• JSON Reporting and Star Schemas in OBIEE

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

• Integrate with live Elasticsearch in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Elasticsearch in Jitterbit.

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

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

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

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

• Build Access-Connected Web Apps in Servoy

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

• Connect to Highrise from a Connection Pool in Jetty

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

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

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

• AlloyDB Cloud Connectivity

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

• Build Semantic Layer Views for Amazon Athena in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Amazon Athena.

• Build Azure Data Lake Storage-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Azure Data Lake Storage from Zoho Analytics and import live Azure Data Lake Storage.

• Publish Crystal Reports on Impala

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Impala.

• PowerShell Scripting to Replicate Paylocity to MySQL

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

• Connect to SAP Hybris C4C in JRuby

  Create a simple JRuby app with access to live SAP Hybris C4C.

• Provide OData Services of SendGrid from a WCF Application

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

• Connect to Procore in RapidMiner

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

• Work with Confluence in FoxPro

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

• Build Sage 200-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sage 200.

• «
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• 123
• 124
• 125
• »