CData Software - Knowledge Base

Recent Articles

• «
• 71
• 72
• 73
• 74
• 75
• 76
• 77
• 78
• 79
• 80
• »

• Automated Continuous Microsoft Dataverse Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to SingleStore.

• Connect to SharePoint Excel Services in Jaspersoft Studio

  Execute SQL to remote SharePoint Excel Services in Jaspersoft Studio.

• Feed eBay Analytics into FineReport

  How to set eBay Analytics as a JDBC data source in FineReport.

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

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

• A PostgreSQL Interface for NetSuite

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

• How to integrate Amazon Athena with Apache Airflow

  Access and process Amazon Athena in Apache Airflow using the CData JDBC Driver.

• Connect to SAS xpt in as an External Source in Dremio

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

• Visualize Bing Ads in TIBCO Spotfire through OData

  Integrate Bing Ads into dashboards in TIBCO Spotfire.

• Integrate with Live Microsoft Project in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Microsoft Project from the MuleSoft Anypoint Platform to integrate live Microsoft Project into custom reports and dashboards.

• Create MYOB AccountRight Reports on JasperReports Server

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

• Build Pipelines with Live Zoho CRM in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Zoho CRM from Google Cloud Data Fusion, enabling the integration of live Zoho CRM into the building and management of effective data pipelines.

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

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

• Use the Connect Server to Access Sage 50 UK in Microsoft Power Pivot

  Use the Connect Server to connect to live Sage 50 UK in the Power Pivot business intelligence tool.

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

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

• Automate Facebook Integration Tasks from PowerShell

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

• Publish Reports with XML in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date XML Files.

• Use the CData Software ODBC Driver for CSV in MicroStrategy

  Connect to CSV/TSV Files in MicroStrategy Developer using the CData Software ODBC Driver for CSV.

• How to connect to Tally from MS Excel on Mac OS X

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

• Load Oracle Eloqua to a Database Using Embulk

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

• Build Bing Ads Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Bing Ads and build visualizations in Tableau Cloud.

• Model, Search, and Visualize Live BigQuery in ThoughtSpot

  Use CData Connect Cloud to connect to live Google BigQuery for modeling, searching, and visualizing.

• Create SSAS Tabular Models from Hive

  How to build a SQL Server Analysis Service Tabular Model from Apache Hive using CData drivers.

• Import Real-Time Google Drive in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Google Drive in ColdFusion.

• Connect to Google Campaign Manager 360 in HULFT Integrate

  Connect to Google Campaign Manager 360 as a JDBC data source in HULFT Integrate

• How to connect and process Adobe Analytics from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Adobe Analytics

• A PostgreSQL Interface for Harvest

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

• A PostgreSQL Interface for Raisers Edge NXT

  Use the SQL Gateway and Raisers Edge NXT ODBC Driver to create a PostgreSQL entry-point for data access.

• Integrate Live SAP SuccessFactors into Custom Business Apps Built in Power Apps

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

• Use the CData ODBC Driver for Microsoft Exchange in Microsoft Power Query

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

• Build BigCommerce-Connected Apps in Choreo

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

• Query Shopify as a MySQL Database in Node.js

  Execute MySQL queries against Shopify from Node.js.

• Connect to GitHub in HULFT Integrate

  Connect to GitHub as a JDBC data source in HULFT Integrate

• Access Live Twilio in AWS Lambda

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

• Visualize Live Tableau CRM Analytics of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Tableau CRM Analytics using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to Unbounce from a Connection Pool in WebLogic

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

• Use the CData Software ODBC Driver for Snowflake in MicroStrategy

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

• Model Amazon Marketplace Using Azure Analysis Services

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

• Access Oracle SCM from MySQL in Amazon QuickSight

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

• Connect to Klipfolio from PowerBuilder

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

• CSV: Unable to Retrieve Columns for Table "csv"

  In this entry you will find the resolution for the error: unable to retrieve columns for table "csv".

• How to Connect DBeaver to PostgreSQL via a JDBC Driver

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

• Enable the Dynamics GP JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Microsoft Dynamics GP.

• Connect to ActiveCampaign in NetBeans

  Connect to ActiveCampaign in NetBeans with the data source configuration wizard.

• Query Office 365 in ColdFusion

  Write standard ColdFusion data access code to connect to Microsoft Office 365.

• Replicate Multiple Azure Active Directory Accounts

  Replicate multiple Azure Active Directory accounts to one or many databases.

• Access Sage Cloud Accounting as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage Business Cloud Accounting from your Oracle system.

• Natively Connect to Google Directory in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to Google Directory. Leverage the native support for ODBC in PHP.

• Automated Continuous SAP HANA Replication to Snowflake

  Use CData Sync for automated, continuous, customizable SAP HANA replication to Snowflake.

• Automate EnterpriseDB Integration Tasks from PowerShell

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

• Integrate with live Facebook Ads in Jitterbit

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

• Integrate Aha with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Aha with External Services.

• Create SSAS Tabular Models from Smartsheet

  How to build a SQL Server Analysis Service Tabular Model from Smartsheet using CData drivers.

• Use Dash to Build to Web Apps on Dynamics 365

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

• Access Live IBM Informix in Coginiti Pro

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

• Extract, Transform, and Load Acumatica in Informatica PowerCenter

  Create a simple Workflow for Acumatica ERP in Informatica PowerCenter.

• Create Shopify Reports on JasperReports Server

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

• Connect to ActiveCampaign from Crystal Reports

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

• Integrate with Paylocity using Apache Camel2

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

• Publish Microsoft Exchange-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Microsoft Exchange.

• Build ADP-Connected Apps in Bubble

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

• Query Klipfolio in MySQL Workbench

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Analyze Active Directory in SAP Analytics Cloud

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

• Query Aha in MySQL Workbench

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

• Viewing Jira Assets in RAD Studio Data Explorer

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

• Import Real-Time Access in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Microsoft Access in ColdFusion.

• Stream TigerGraph into Apache Kafka Topics

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

• A PostgreSQL Interface for Twitter

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

• Build a Simple VCL Application for Zoho Books

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

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

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

• Add Sage 200 to Informatica Enterprise Data Catalog

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

• Create Oracle Eloqua-Connected Enterprise Applications in OutSystems

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

• Automate Twilio Replication to Azure Data Lake

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

• Access Google Search Results 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 Google Search.

• Stream Zoho CRM into Apache Kafka Topics

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

• Automated Continuous WooCommerce Replication to AlloyDB

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

• Create Data Visualizations in Cognos BI with Microsoft OneDrive

  Access Microsoft OneDrive as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Integrate Real-Time Access to Facebook in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Facebook in real time.

• Integrate with live Google Sheets in Jitterbit

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

• Publish Reports with MYOB AccountRight in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date MYOB AccountRight.

• How to work with Basecamp in Apache Spark using SQL

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

• How to connect to MySQL from MS Excel on Mac OS X

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

• Automated Continuous SendGrid Replication to Amazon S3

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

• Automated Continuous Zoho CRM Replication to SQL Server

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

• Visualize Presto in TIBCO Spotfire through ODBC

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

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

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

• Connect to Basecamp from a Connection Pool in JBoss

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

• Connect to Dynamics 365 Business Central as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Dynamics 365 Business Central.

• Use the CData ODBC Driver for Acumatica in SAS JMP

  You can use the CData ODBC Driver to integrate Acumatica ERP into the statistical analysis tools available in SAS JMP. This article shows how to use Acumatica ERP in the Graph Builder and Query Builder.

• Query Databricks through ODBC in Node.js

  Use node-odbc to execute SQL queries against Databricks from Node.js.

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

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

• How to Connect the Power BI Service to SAP Ariba Source: Complete Guide

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

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

  Provide connectivity to Amazon DynamoDB through an SAP BusinessObjects universe.

• Connect to Reckon Accounts Hosted in Jaspersoft Studio

  Execute SQL to remote Reckon Accounts Hosted in Jaspersoft Studio.

• Build QuickBooks Time-Connected Web Apps with Axios and CData Connect Cloud

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

• Analyze Microsoft OneDrive in R

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

• How to Connect DBeaver to MariaDB via a JDBC Driver

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

• Create FTP Dataflows on PowerBI.com

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

• Natively Connect to Active Directory in PHP

  The CData ODBC driver for Active Directory enables you to create PHP applications with connectivity to Active Directory. Leverage the native support for ODBC in PHP.

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

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

• «
• 71
• 72
• 73
• 74
• 75
• 76
• 77
• 78
• 79
• 80
• »