CData Software - Knowledge Base

Recent Articles

• «
• 104
• 105
• 106
• 107
• 108
• 109
• 110
• 111
• 112
• 113
• »

• Automated Continuous Microsoft Project Replication to Oracle

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

• Connect to WooCommerce in Google Apps Script via SQL Gateway

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

• Automated Continuous Quickbase Replication to Google BigQuery

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

• Automated Continuous Salesloft Replication to Google BigQuery

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

• Publish BigQuery-Connected Dashboards in Tableau Server via JDBC

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

• Build Dashboards with Bullhorn CRM in DBxtra

  Create dynamic dashboards and perform analytics based on Bullhorn CRM in DBxtra.

• Connect to Jira Assets in NetBeans

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

• Extract, Transform, and Load Redshift in Informatica PowerCenter

  Create a simple Workflow for Amazon Redshift in Informatica PowerCenter.

• Integrate with Jira in JReport Designer

  Create charts and reports based on Atlassian Jira in JReport Designer.

• Analyze Live Google Drive in SAS Viya

  Use CData Connect AI to connect to Google Drive from SAS Viya and deploy self-service analytics using live Google Drive.

• Automated Continuous Todoist Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Todoist replication to delimited files (CSV/TSV).

• Replicate Multiple Excel Accounts

  Replicate multiple Excel accounts to one or many databases.

• How to Connect to Live Google Ads from Gemini CLI (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Google Ads for you.

• Automated Continuous BambooHR Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable BambooHR replication to OneLake in Microsoft Fabric.

• Query Azure Synapse in DataGrip

  Create a Data Source for Azure Synapse in DataGrip and use SQL to query live Azure Synapse.

• Build an OLAP Cube in SSAS from Oracle Eloqua Reporting

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

• How to Connect to Live MySQL from Google ADK Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your MySQL for you.

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

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

• Working with Greenhouse in LINQPad

  Execute LINQ queries to Greenhouse in LINQPad.

• How to connect to Google Campaign Manager 360 in DBVisualizer

  Integrate Google Campaign Manager 360 with visual data analysis tools and data connection wizards in DBVisualizer

• Replicate REST in Heroku for Use in Salesforce Connect

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

• Create Informatica Mappings From/To a JDBC Data Source for Redis

  Create Redis data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Manage Smartsheet in DBArtisan as a JDBC Source

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

• How to connect to Stripe from Spring Boot

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

• Replicate IBM Informix to Multiple Databases via the CData Sync CLI

  Replicate IBM Informix to disparate databases with a single configuration.

• Connect to SAP Hybris C4C from Blazor Apps

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

• Access Cosmos DB 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 Azure Cosmos DB.

• Build Data Flows from SQL Server to Elasticsearch through SSIS

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

• A PostgreSQL Interface for Phoenix (MySQL Remoting via JDBC)

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

• Connect to Blackbaud FE NXT through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Blackbaud FE NXT using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Access Square from MySQL in Amazon QuickSight

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

• Working with eBay Analytics in LINQPad

  Execute LINQ queries to eBay Analytics in LINQPad.

• Access PayPal from MySQL in Amazon QuickSight

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

• Publish Crystal Reports on Salesforce Data Cloud

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Salesforce Data Cloud.

• Access Shopify from MySQL in Amazon QuickSight

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

• Choosing the Best Method to Connect Google Cloud Storage to SQL Server: 5 Options Explained

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

• Publish Reports with Databricks in SAP Crystal Reports

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

• Connect to Procore in Aqua Data Studio

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

• LINQ to FHIR

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

• Edit and Search Sybase IQ External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Sybase IQ to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Sybase IQ objects that you can access from apps and the dashboard.

• How to Query Live Oracle Service Cloud Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Oracle Service Cloud data in natural language using Python.

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

  Create an ODBC connection to Microsoft Project in Informatica and browse and transfer Microsoft Project.

• Connect to LinkedIn Ads in SpagoBI

  Create reports featuring live LinkedIn Ads in SpagoBI Studio. Host LinkedIn Ads reports on SpagoBI Server.

• LINQ to Spark

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

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

  Use LlamaIndex to query live Salesforce Marketing Cloud data in natural language using Python.

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

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

• Natively Connect to ADP in PHP via ODBC (Linux)

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

• Use the CData API Server to Access Google Spanner in Microsoft PowerPivot

  Use the CData API Server to connect to live Google Spanner in the Power Pivot business intelligence tool.

• Connect to Raisers Edge NXT as an External Data Source using PolyBase

  Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Raisers Edge NXT.

• Use the CData SSIS Components to Insert New or Update Existing HBase Records from SQL Server

  Easily push SQL Server data to HBase using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into HBase or update existing records with data from a SQL Server database.

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

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

• Build Google Ad Manager-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Google Ad Manager and build web apps with connectivity to live Google Ad Manager.

• Connect to Snapchat Ads in ACL Analytics

  Connect to Snapchat Ads via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Snapchat Ads.

• Build Dashboards with Microsoft OneDrive in DBxtra

  Create dynamic dashboards and perform analytics based on Microsoft OneDrive in DBxtra.

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

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

• MongoDB Reporting and Star Schemas in OBIEE

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

• Integrating Boomi Agentstudio with Oracle SCM via CData Connect AI

  Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle SCM, enabling AI agents to act on live enterprise data within your integration and automation workflows.

• Validate Oracle Service Cloud with QuerySurge

  Access and validate Oracle Service Cloud in QuerySurge using the CData JDBC Driver.

• Connect to Outreach.io as a Linked Server via SQL Gateway

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

• How to Access Sage 50 UK Using Entity Framework

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

• Create Apps from MYOB AccountRight in Qlik Sense Cloud

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

• Build a Simple VCL Application for Printify

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

• Design BIRT Reports on Coinbase

  Provide current Coinbase to your embedded analytics.

• Automated Continuous Parquet Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Parquet replication to delimited files (CSV/TSV).

• Connect to TigerGraph in Ruby

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

• Create Google Contacts-Connected Enterprise Applications in OutSystems

  Use CData Connect AI to connect to Google Contacts from OutSystems and build custom enterprise apps using live Google Contacts.

• Connect to BigCommerce from Asprova with CData Software ODBC Driver for BigCommerce

  This article shows how to connect faster to BigCommerce data from Asprova.

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

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

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

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

• Analyze MYOB AccountRight with Power Pivot

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

• Build Semantic Layer Views for Epicor Kinetic in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Epicor Kinetic.

• Integrate WooCommerce into Automated Tasks with Power Automate

  Use CData Connect AI to connect to WooCommerce and integrate live WooCommerce into your Power Automate tasks.

• Use the CData API Server to Access Google Ads in Microsoft PowerPivot

  Use the CData API Server to connect to live Google Ads in the Power Pivot business intelligence tool.

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

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

• Connect to Amazon Marketplace in RapidMiner

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

• Visualize Live Cassandra in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live Apache Cassandra into custom reports in Power BI.

• Perform Batch Operations with Amazon DynamoDB in Apache NiFi

  Connect to Amazon DynamoDB and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Automated Continuous Avro Replication to Amazon S3

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

• Integrate with Gmail in JReport Designer

  Create charts and reports based on Gmail in JReport Designer.

• Use the CData Software JDBC Driver for Neo4J in MicroStrategy Desktop

  Connect to Neo4J in MicroStrategy Desktop using the CData Software JDBC Driver for Neo4J.

• How to use SQLAlchemy ORM to access HDFS in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache HDFS.

• Connect to Adobe Target in RazorSQL

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

• How to create Twilio federated tables in MySQL

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

• Enable the SQL Server JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Microsoft SQL Server.

• Connect to Google Directory in DBArtisan

  Use wizards in DBArtisan to configure Google Directory as a data source.

• Connect to WordPress in RazorSQL

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

• Visualize Confluence in TIBCO Spotfire through OData

  Integrate Atlassian Confluence into dashboards in TIBCO Spotfire.

• Replicate Confluence in Heroku for Use in Salesforce Connect

  Replicate Atlassian Confluence to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• How to create HBase federated tables in MySQL

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

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

• How to Connect to & Open SQL Server in Microsoft Excel

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

• How to import Splunk into Apache Solr

  Use the CData Software JDBC Driver for Splunk in Data Import Handler and create an automated import of Splunk to Apache Solr Enterprise Search platform.

• Natively Connect to PayPal in PHP

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

• Building Dynamic Web Pages with CSV Using AngularJS

  Create single-page applications with live connectivity to CSV using the CData API Server.

• Connect to Trello in RapidMiner

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

• Connect to Cloudant from Asprova with CData Software ODBC Driver for Cloudant

  This article shows how to connect faster to Cloudant data from Asprova.

• Connect to and Query Dynamics 365 in QlikView over ODBC

  Create data visualizations with Microsoft Dynamics 365 in QlikView.

• Getting Started with the CData PowerShell Cmdlets for HDFS

• «
• 104
• 105
• 106
• 107
• 108
• 109
• 110
• 111
• 112
• 113
• »