CData Software - Knowledge Base

Recent Articles

• «
• 210
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• 218
• 219
• »

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

  Use LlamaIndex to query live Apache Spark SQL data in natural language using Python.

• Connect to ConstantContact in NetBeans

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

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

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

• Analyze Quickbase in Infragistics Reveal

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

• Visualize Klipfolio in Sisense

  Create an ElastiCube in Sisense app with access to Klipfolio.

• Create Reports with Outreach.io in SAP Crystal Reports

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

• Query, Visualize, and Share live Twitter in Redash

  Use CData Connect Cloud to connect to live Twitter in Redash for querying, visualizing, and sharing.

• Create SSAS Tabular Models from Google Drive

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

• Connect to Freshdesk 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 Freshdesk.

• Automated Continuous Amazon Marketplace Replication to Oracle

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

• Write a Simple Go Application to work with TigerGraph on Linux

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

• Import Hive Using Azure Data Factory

  Use CData Connect Cloud to connect to Hive from Azure Data Factory and import live Apache Hive.

• Deploy the ADO.NET Provider for Square on an SSRS Report Server

  Connect to Square from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Create Data Visualizations in Cognos BI with WooCommerce

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

• Automated Continuous Quickbase Replication to Google Cloud SQL

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

• Import MarkLogic into FileMaker Pro

  Create reports that integrate MarkLogic in Filemaker Pro.

• Create Dynamic SAP Business One Grids Using the Infragistics XamDataGrid

  Learn how you can connect SAP Business One to Infragistics XamDataGrid to build dynamic grids.

• Analyze Live Excel Online in SAS Viya

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

• Back Up Procore to SQL Server through SSIS

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

• Replicate Tally for Use in Salesforce Connect

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

• Access Highrise in PHP through Connect Server

  Connect to Highrise through the standard SQL Server libraries in PHP.

• Create Reports from FHIR in Looker Studio

  Use CData Connect Cloud to gain access to live FHIR and create custom reports in Looker Studio.

• Query AlloyDB as a SQL Server Database in Node.js

  Execute SQL Server queries against Google AlloyDB from Node.js.

• Connect and Visualize Live Stripe Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Stripe into the Databricks platform and create visualization dashboards with real-time Stripe.

• Connect to and Visualize Live Dynamics GP in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dynamics GP.

• Analyze xBase in R via JDBC

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

• Design BIRT Reports on PostgreSQL

  Provide current PostgreSQL to your embedded analytics.

• Connect to Live IBM Informix in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to IBM Informix in CData Connect Cloud and connect to your IBM Informix from PostgreSQL.

• Build a Simple VCL Application for Google Sheets

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

• Replicate SAP SuccessFactors for Use in Salesforce Connect

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

• Connect to Databricks from a Connection Pool in WebLogic

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

• Connect to Epicor Kinetic from a Connection Pool in JBoss

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

• Automate Aha Integration Tasks from PowerShell

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

• Create Raisers Edge NXT Dataflows on PowerBI.com

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

• Connect to Facebook as a Linked Server via SQL Gateway

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

• How to create Box federated tables in MySQL

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

• Analyze OneNote with Power Pivot

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

• How to create Spark federated tables in MySQL

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

• Create Stripe-Connected Business Apps in AppSheet

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

• How to Use CData Connect to Access Live Coinbase in Power Automate

  CData Connect for Coinbase enables you to integrate Coinbase into workflows built using Microsoft Power Automate Desktop.

• Create Twilio-Connected Business Apps in AppSheet

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

• Connect to and Query DocuSign in QlikView over ODBC

  Create data visualizations with DocuSign in QlikView.

• Automated Continuous Twitter Replication to SingleStore

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

• How to Work with Power BI XMLA in AWS Glue Jobs Using JDBC

  Connect to Power BI XMLA from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Access Zoho Books in PHP through Connect Server

  Connect to Zoho Books through the standard SQL Server libraries in PHP.

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

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

• Build Stripe-Connected ETL Processes in Google Data Fusion

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

• Connect to Live Amazon DynamoDB in MicroStrategy through CData Connect Cloud

  Create a live connection to Amazon DynamoDB in CData Connect Cloud and connect to your Amazon DynamoDB from MicroStrategy.

• Query PayPal in DataGrip

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

• How to Visualize Outreach.io Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Outreach.io in Python.

• Analyze Invoiced in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of Invoiced and visualize Invoiced in SAP Analytics Cloud.

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

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

• Connect to Highrise in NetBeans

  Connect to Highrise CRM in NetBeans with the data source configuration wizard.

• Build Tableau CRM Analytics-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Tableau CRM Analytics.

• How to create MongoDB federated tables in MySQL

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

• Build Sugar CRM Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Sugar CRM and build visualizations in Tableau Cloud.

• Visualize MailChimp in TIBCO Spotfire through ADO.NET

  Integrate MailChimp into dashboards in TIBCO Spotfire.

• Access Live Zenefits in SAS JMP via ODBC

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

• How to publish and share Bullhorn CRM dashboards with Tableau Server

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

• Use Dash to Build to Web Apps on Google Ad Manager

  Create Python applications that use pandas and Dash to build Google Ad Manager-connected web apps.

• Connect to Oracle HCM Cloud in RazorSQL

  Connect to Oracle HCM Cloud from wizards and query Oracle HCM Cloud from the GUI in the RazorSQL database management tool.

• How to Use CData Connect to Access Live SAS xpt in Power Automate

  CData Connect for SAS xpt enables you to integrate SAS XPORT into workflows built using Microsoft Power Automate Desktop.

• Access Google Data Catalog from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Google Data Catalog from HeidiSQL.

• Build Google Calendar-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Google Calendar from Zoho Analytics and import live Google Calendar.

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

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

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

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

• Connect to Live SQL Analysis Services in MicroStrategy through CData Software Connect Server

  Create a virtual database for SQL Analysis Services in CData Software Connect Server and connect to it from MicroStrategy.

• Load Google Campaign Manager 360 to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Campaign Manager 360 to a database.

• Integrate with Facebook Ads in SnapLogic

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

• Provide OData Services of SAP ByDesign from a WCF Application

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

• Build Automated Freshdesk-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Freshdesk and build automated workflows in Zapier.

• How to create Excel Online federated tables in MySQL

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

• Working with Snowflake in LINQPad

  Execute LINQ queries to Snowflake in LINQPad.

• Build Dashboards with SAP Ariba Source in DBxtra

  Create dynamic dashboards and perform analytics based on SAP Ariba Source in DBxtra.

• Query Gmail in DataGrip

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

• Viewing Oracle HCM Cloud in RAD Studio Data Explorer

  How to view Oracle HCM Cloud in RAD Studio Data Explorer using the CData ODBC Driver for Oracle HCM Cloud.

• How to Connect DBeaver to SAP BusinessObjects BI via a JDBC Driver

  Manage SAP BusinessObjects BI with visual tools in DBeaver like the query browser.

• Create SSAS Tabular Models from Redis

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

• Connect to Dropbox in HULFT Integrate

  Connect to Dropbox as a JDBC data source in HULFT Integrate

• Create Dynamic Harvest Grids Using the Infragistics XamDataGrid

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

• How to connect to Sybase IQ from Spring Boot

  Connect to Sybase IQ in a Spring Boot Application using CData JDBC Sybase IQ Driver

• Back Up Azure Data Catalog to SQL Server through SSIS

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

• Build SAP Hybris C4C-Connected Apps in Mendix

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

• Create Pipedrive Reports on JasperReports Server

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

• Easily Integrate Sage Intacct in Lazarus Pascal IDE

  Learn how to easily integrate live Sage Intacct in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• eBay Analytics Reporting in OBIEE with the eBay Analytics JDBC Driver

  Deploy the eBay Analytics JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Viewing Splunk in RAD Studio Data Explorer

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

• How to Work with Wave Financial in ETL Validator JDBC

  Connect to Wave Financial from ETL Validator jobs using the CData Software JDBC Driver.

• Connect to MySQL in SpagoBI

  Create reports featuring live MySQL in SpagoBI Studio. Host MySQL reports on SpagoBI Server.

• Replicate Typeform to Multiple Databases

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

• Create Spark-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Spark from Nintex Workflow Cloud and build custom workflows using live Apache Spark SQL.

• Integrate with Live Twitter Ads in MuleSoft (via CData Connect Cloud)

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

• Build Visualizations of Live SAP Netweaver Gateway in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for SAP Netweaver Gateway and build custom reports in Power BI.

• Connect to Azure Active Directory in DBeaver

  Use the CData ODBC Driver to connect to Azure Active Directory in DBeaver.

• Use the CData SSIS Components to Insert New or Update Existing Google Campaign Manager 360 Records from SQL Server

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

• Connect to SAP Ariba Source from Asprova with CData Software ODBC Driver for SAP Ariba Source

  This article shows how to connect faster to SAP Ariba Source data from Asprova.

• Connect to Acumatica in NetBeans

  Connect to Acumatica ERP in NetBeans with the data source configuration wizard.

• Connect to Asana from a Connection Pool in Jetty

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

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

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

• Connect to and Visualize Live Epicor Kinetic in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Epicor Kinetic.

• «
• 210
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• 218
• 219
• »