CData Software - Knowledge Base

Recent Articles

• «
• 346
• 347
• 348
• 349
• 350
• 351
• 352
• 353
• 354
• 355
• »

• Using SQL to Query Gmail

  The CData Gmail Data Providers provide access to the full search capabilities of IMAP using standard SQL. This article will explore some examples to demonstrate the ease of creating powerful custom queries to search your Gmail account.

• DataBind Salesforce to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Salesforce with the DevExpress Windows Forms and Web controls to provide Salesforce & Force.com to a chart.

• Use Biml to Build SSIS Tasks to Replicate Oracle Sales to SQL Server

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

• Automated Continuous Exact Online Replication to Azure SQL

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

• How to Connect DBeaver to LinkedIn Ads via a JDBC Driver

  Manage LinkedIn Ads with visual tools in DBeaver like the query browser.

• Viewing Odoo in RAD Studio Data Explorer

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

• Automated Continuous OData Replication to MySQL

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

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

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

• Automated Continuous SAP Ariba Source Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Amazon S3.

• How to publish and share SAP Concur dashboards with Tableau Server

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

• Extract, Transform, and Load Airtable in Informatica PowerCenter

  Create a simple Workflow for Airtable in Informatica PowerCenter.

• Connect to QuickBooks Time in Ruby

  Connect to QuickBooks Time in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• DataBind Charts to Facebook

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Facebook from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Integrate LinkedIn Ads in Your Informatica Cloud Instance

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

• Load Exact Online to a Database Using Embulk

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

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

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

• PowerShell Scripting to Replicate PayPal to MySQL

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

• Automated Continuous Redis Replication to Vertica

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

• Analyze Monday.com in R via ODBC

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

• Build Data Flows from BambooHR to SQL Server using SSIS

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

• How to Connect to & Open Oracle Sales in Microsoft Excel

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

• Connect to Google Search from Excel & GoogleSheets!

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

• Connect to OneNote in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automated Continuous Dynamics CRM Replication to AlloyDB

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

• Analyze SAS Data Sets in Infragistics Reveal

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

• Create Data Visualizations Based On Acumatica in Mode

  Use CData Connect Cloud to connect to Acumatica from Mode and build visualizations using live

• Automated Continuous Elasticsearch Replication to Vertica

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

• Access Live Adobe Analytics in TIBCO Data Virtualization

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

• Connect to Google Ad Manager from PowerBuilder via JDBC

  This article demonstrates how to access Google Ad Manager from PowerBuilder using the Google Ad Manager JDBC Driver.

• DataBind Controls to Twitter in C++Builder

  DataBind to Twitter in C++Builder with standard components and controls.

• Publish Google Directory-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Google Directory.

• Automate Procore Replication to Couchbase

  Use CData Sync to Customize and automate Procore replication to Couchbase.

• How to Connect to Raisers Edge NXT in Using Python: 6 Steps

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

• Connect to Oracle SCM from Asprova with CData Software ODBC Driver for Oracle SCM

  This article shows how to connect faster to Oracle SCM data from Asprova.

• Import Real-Time Clio via JDBC in ColdFusion to Build Applications

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

• Use Dash to Build to Web Apps on PayPal

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

• Create eBay Analytics-Connected Nintex Workflows

  Use CData Software Connect Server to connect to eBay Analytics from Nintex Workflow Cloud and build custom workflows using live eBay Analytics.

• Operational Reporting on Klaviyo from Spotfire Server

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

• Connect to Amazon Athena from Blazor Apps

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

• How to Connect to & Open Sybase IQ in Microsoft Excel

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

• Analyze Zoho Books in Infragistics Reveal

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

• Build Microsoft Dataverse-Connected Apps in Mendix

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

• Enable the Sybase IQ JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Sybase IQ.

• Operational Reporting on Act CRM from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Act CRM.

• Connect to Aha in Aqua Data Studio

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

• CData SAP Driver Deep Dive: Access SAP S/4HANA CDS Views as OData Services

  A simple guide for exposing SAP S/4HANA CDS Views to access them as OData Services using the CData SAP Driver.

• Publish Twitter-Connected Dashboards in Tableau Server via JDBC

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

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

  Provide connectivity to Sage 300 through an SAP BusinessObjects universe.

• Access Azure Synapse from MySQL in Amazon QuickSight

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

• Use CData Connect Cloud to Access Zoho Creator in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Zoho Creator in the Power Pivot business intelligence tool.

• Connect to Invoiced from a Connection Pool in WebLogic

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

• Connect to ClickUp from a Connection Pool in WebLogic

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

• Automated Continuous JotForm Replication to MongoDB

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

• Using the CData Software ODBC Driver for MongoDB in PyCharm

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

• Automate Bing Search Results Replication to Couchbase

  Use CData Sync to Customize and automate Bing Search replication to Couchbase.

• Automated Continuous Smartsheet Replication to Vertica

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

• Access Exact Online in PHP through Connect Server

  Connect to Exact Online through the standard SQL Server libraries in PHP.

• Bridge Zenefits Connectivity with Apache NiFi

  Access and process Zenefits in Apache NiFi using the CData JDBC Driver.

• Integrate Google Drive with External Services using SnapLogic

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

• How to integrate Metabase with Airtable

  Use CData Connect Cloud to connect to live Airtable and create an interactive dashboard in Metabase from Airtable.

• Visualize Drip in Tableau

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

• PowerShell Scripting to Replicate SingleStore to MySQL

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

• How to Connect to & Open Zoho Inventory in Microsoft Excel

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

• Automated Continuous SAS xpt Replication to SingleStore

  Use CData Sync for automated, continuous, customizable SAS xpt replication to SingleStore.

• Build a PostgreSQL Interface for SurveyMonkey using the CData JDBC Driver

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

• How to connect and process HCL Domino from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live HCL Domino

• Object-Relational Mapping (ORM) with SingleStore Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SingleStore into a Java-based ORM framework, Hibernate.

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

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

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

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

• Connect to Bing Ads from PowerBuilder via JDBC

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

• Connect to ShipStation as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live ShipStation.

• Connect to Reckon in DBeaver

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

• Use Dash to Build to Web Apps on RSS Feeds

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

• View Reports on Real-Time Shopify in Power BI Report Server

  Use the CData ODBC Driver for Shopify to visualize Shopify in Power BI Desktop and then publish them to Power BI Report Server.

• Working with LDAP Objects in LINQPad

  Execute LINQ queries to LDAP in LINQPad.

• Create Drip-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Drip from AppSheet and build custom business apps using live Drip.

• Create a Data Access Object for Box using JDBI

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

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

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

• Replicate Multiple Azure Data Lake Storage Accounts via the CData Sync CLI

  Replicate multiple Azure Data Lake Storage accounts to one or many databases.

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

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

• Build Data Flows from Stripe to SQL Server using SSIS

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

• Build an OLAP Cube in SSAS from Gmail

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

• Import Real-Time LinkedIn Ads via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use LinkedIn Ads in ColdFusion.

• Manage CouchDB in DBArtisan as a JDBC Source

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

• Visualize SAP Fieldglass in TIBCO Spotfire through OData

  Integrate SAP Fieldglass into dashboards in TIBCO Spotfire.

• Create Apps from SurveyMonkey in Qlik Sense Cloud

  Use CData Connect Cloud to connect to SurveyMonkey and build apps from live SurveyMonkey in Qlik Sense Cloud.

• Access Live Salesforce in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Salesforce & Force.com from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• How to connect and process Greenplum from Azure Databricks

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

• Write a Simple Go Application to work with Wave Financial on Linux

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

• Analyze Google Spanner in R via ODBC

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

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

• Automate PostgreSQL Replication to SAP HANA

  Use CData Sync to customize and automate PostgreSQL replication to SAP HANA.

• Back Up SAP Hybris C4C to SQL Server through SSIS

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

• Connect to OneNote in Jaspersoft Studio

  Execute SQL to remote Microsoft OneNote in Jaspersoft Studio.

• Create Apps from MYOB AccountRight in Qlik Sense Cloud

  Use CData Connect Cloud to connect to MYOB AccountRight and build apps from live MYOB AccountRight in Qlik Sense Cloud.

• Build Dashboards with WordPress in DBxtra

  Create dynamic dashboards and perform analytics based on WordPress in DBxtra.

• Integrate Sybase IQ in Your Informatica Cloud Instance

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

• Replicate ADP to Multiple Databases

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

• Access Live Zendesk in AWS Lambda

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

• Automated Continuous Snapchat Ads Replication to Oracle

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

• «
• 346
• 347
• 348
• 349
• 350
• 351
• 352
• 353
• 354
• 355
• »