CData Software - Knowledge Base

Recent Articles

• «
• 146
• 147
• 148
• 149
• 150
• 151
• 152
• 153
• 154
• 155
• »

• How to connect and process Facebook Ads from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Facebook Ads

• How to create AlloyDB federated tables in MySQL

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

• Create Azure Analysis Services-Connected Business Apps in AppSheet

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

• Integrate PayPal in the Pentaho Report Designer

  Publish reports based on PayPal in the Pentaho BI tool.

• Query Avalara AvaTax in ColdFusion

  Write standard ColdFusion data access code to connect to Avalara AvaTax.

• How to use SQLAlchemy ORM to access Google Ads in Python

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

• Feed XML into FineReport

  How to set XML Files as a JDBC data source in FineReport.

• Work with Live Dynamics CRM in Power Query

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

• Automated Continuous IBM Informix Replication to Snowflake

  Use CData Sync for automated, continuous, customizable IBM Informix replication to Snowflake.

• Automate Sybase Replication to Azure Data Lake

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

• How to pipe Excel Online to CSV in PowerShell

  Use standard PowerShell cmdlets to access Excel Online tables.

• How to create Visio diagrams from Elasticsearch

  Automatically update Elasticsearch with the changes you make to Visio master shapes.

• Create FTP Reports on JasperReports Server

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

• Build an OLAP Cube in SSAS from SharePoint Excel Services

  Establish a connection to SharePoint Excel Services data from SQL Server Analysis Services, and use the SharePoint Excel Services Data Provider to build OLAP cubes for use in analytics and reporting.

• Use the CData ODBC Driver for NetSuite in MicroStrategy

  Connect to NetSuite data in MicroStrategy Developer using the CData ODBC Driver for NetSuite.

• Automated Continuous Bing Search Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Bing Search replication to IBM DB2.

• Replicate Multiple Act CRM Accounts

  Replicate multiple Act CRM accounts to one or many databases.

• Automated Continuous PayPal Replication to Apache Cassandra

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

• Replicate IBM Cloud Data Engine for Use in Salesforce Connect

  Replicate IBM Cloud Data Engine to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Model, Search, and Visualize Live Facebook Ads in ThoughtSpot

  Use CData Connect Cloud to connect to live Facebook Ads for modeling, searching, and visualizing.

• Automated Continuous Marketo Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Marketo replication to Azure SQL.

• Create Microsoft Planner-Connected Visualizations in Klipfolio

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

• DataBind Controls to MYOB AccountRight in Delphi

  DataBind to MYOB AccountRight in Delphi with standard data access components and controls.

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

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

• Automated Continuous Sage 50 UK Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Sage 50 UK replication to Google Cloud SQL.

• Create Oracle SCM-Connected Business Apps in AppSheet

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

• Creating Bing Search-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Bing Search to Unqork and build custom business apps.

• Connect to Bullhorn CRM in RazorSQL

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

• Analyze Live Zuora in SAS Viya

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

• Validate Microsoft Teams with QuerySurge

  Access and validate Microsoft Teams in QuerySurge using the CData JDBC Driver.

• How to connect to Act-On from IntelliJ

  Integrate connectivity to Act-On with wizards in IntelliJ.

• Viewing MySQL in RAD Studio Data Explorer

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

• Build Visualizations of Google Directory in Birst

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

• Visualize Freshdesk in Tableau

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

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

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

• How to create Marketo federated tables in MySQL

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

• How to connect to MongoDB from Spring Boot

  Connect to MongoDB in a Spring Boot Application using CData JDBC MongoDB Driver

• Analyze QuickBooks Online in R

  Use standard R functions and the development environment of your choice to analyze QuickBooks Online with the CData JDBC Driver for QuickBooks Online.

• Replicate Data from Multiple Files in an Amazon S3 Bucket Using CData Sync

  Use CData Sync to replicate multiple files from an Amazon S3 bucket to a data warehouse

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

  The CData ODBC Driver for Salesforce enables you to integrate Salesforce & Force.com into workflows built using Microsoft Power Automate Desktop.

• Replicate Stripe to Multiple Databases

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

• Using AngularJS to Build Dynamic Web Pages with SAP HANA

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

• Connect to Sage Intacct from a Connection Pool in WebLogic

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

• Create a Data Access Object for ADP using JDBI

  A brief overview of creating a SQL Object API for ADP in JDBI.

• Connect to Jira Assets in NetBeans

  Connect to Jira Assets in NetBeans with the data source configuration wizard.

• Query Microsoft OneDrive as a SQL Server in Node.js

  Execute SQL Server queries against Microsoft OneDrive from Node.js.

• Build Smartsheet-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Smartsheet and create custom apps in Mendix.

• Choosing the Best Method to Connect Kafka to SQL Server: 5 Options Explained

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

• Edit and Search External PostgreSQL Objects in Salesforce Connect

  Use CData Connect Cloud to securely provide OData feeds of PostgreSQL to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create PostgreSQL objects that you can access from apps and the dashboard.

• Back Up ServiceNow to SQL Server through SSIS

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

• Access Live SAS xpt in AWS Lambda (with IntelliJ IDEA)

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

• Create Stripe Reports on JasperReports Server

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

• How to create Coinbase federated tables in MySQL

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

• Visualize Printify in TIBCO Spotfire through ADO.NET

  Integrate Printify into dashboards in TIBCO Spotfire.

• Access ActiveCampaign from MySQL in HeidiSQL

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

• Natively Connect to Bing Ads in PHP

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

• Automate Monday.com Replication to Azure Data Lake

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

• Visualize Salesloft in Tableau

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

• Query LinkedIn Ads in ColdFusion

  Write standard ColdFusion data access code to connect to LinkedIn Ads.

• Using AngularJS to Build Dynamic Web Pages with LDAP Objects

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

• Analyze eBay Analytics with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for eBay Analytics from Power Pivot. You will use the Table Import Wizard to load eBay Analytics. You can visually build the import query or use any SQL supported by the driver.

• Create Data Visualizations in Cognos BI with Sage Intacct

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

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

  Create an ODBC connection to Zoho CRM in Informatica and browse and transfer Zoho CRM.

• Replicate DB2 for Use in Salesforce Connect

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

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

  Provide connectivity to Trello through an SAP BusinessObjects universe.

• How to connect to Oracle Sales from IntelliJ

  Integrate connectivity to Oracle Sales with wizards in IntelliJ.

• Connect to JotForm in the Denodo Platform

  Use CData driver technologies to create a virtual data source for JotForm in the Denodo Virtual DataPort Administrator.

• Access Typeform from MySQL in HeidiSQL

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

• Automated Continuous Shippo Replication to MongoDB

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

• How to connect to Office 365 with Squirrel SQL client

  Connect to Microsoft Office 365 and execute queries in the Squirrel SQL Client.

• How to load Klaviyo data into Elasticsearch via Logstash

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

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

  Connect to SQL Analysis Services in MicroStrategy Web using the CData Software JDBC Driver for SQL Analysis Services.

• Using the CData Software ODBC Driver for EnterpriseDB in PyCharm

  Connect to EnterpriseDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for EnterpriseDB.

• Import Bing Search Results into FileMaker Pro

  Create reports that integrate Bing Search in Filemaker Pro.

• Connect to Shopify in Jaspersoft Studio

  Execute SQL to remote Shopify in Jaspersoft Studio.

• Import Snowflake into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Snowflake and provide access to live Snowflake for custom reports in the Power BI Service.

• Export Data from SQL Server to Basecamp through SSIS

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

• Create Dynamic QuickBooks Online Grids Using the Infragistics XamDataGrid

  Learn how you can connect QuickBooks Online to Infragistics XamDataGrid to build dynamic grids.

• Connect to Dynamics 365 Business Central in Google Apps Script

  Use the ODBC Driver for Dynamics 365 Business Central and the SQL Gateway to access Dynamics 365 Business Central from Google Apps Script.

• Create Datasets from xBase in Domo Workbench and Build Visualizations of xBase in Domo

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

• Connect to FTP in DBArtisan

  Use wizards in DBArtisan to configure FTP Servers as a data source.

• Query EnterpriseDB in ColdFusion

  Write standard ColdFusion data access code to connect to EnterpriseDB.

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

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

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

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

• Connect to Asana in RazorSQL

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

• How to connect to Azure Data Lake Storage from IntelliJ

  Integrate connectivity to Azure Data Lake Storage with wizards in IntelliJ.

• Build an OLAP Cube in SSAS from xBase

  Establish a connection to xBase data from SQL Server Analysis Services, and use the xBase Data Provider to build OLAP cubes for use in analytics and reporting.

• Build Azure Data Catalog-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Azure Data Catalog and build web apps with connectivity to live Azure Data Catalog.

• Use the CData ODBC Driver for YouTube Analytics in SAS JMP

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

• How to Build Dynamic React Apps with Kintone

  Use the CData Connect and React to Build Dynamic Web Apps with Live Kintone .

• Automated Continuous Act-On Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Act-On replication to Amazon Redshift.

• Use the CData Software JDBC Driver for Wave Financial in MicroStrategy Web

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

• Connect to Dynamics NAV from a Connection Pool in WebLogic

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

• Viewing Dynamics NAV in RAD Studio Data Explorer

  How to view Microsoft Dynamics NAV in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics NAV.

• Build Semantic Layer Views for SAP Hybris C4C in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for SAP Hybris C4C.

• Replicate Multiple Tally Accounts

  Replicate multiple Tally accounts to one or many databases.

• A PostgreSQL Interface for Drift

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

• Connect to Odoo from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Odoo to connect to Odoo ERP and execute queries in PowerBuilder.

• Automated Continuous Reckon Replication to Amazon S3

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

• Use CData Sync to Replicate Data to Amazon S3

  Use CData Sync to replicate enterprise data from more than 100 data sources to Amazon S3

• «
• 146
• 147
• 148
• 149
• 150
• 151
• 152
• 153
• 154
• 155
• »