CData Software - Knowledge Base

Recent Articles

• «
• 377
• 378
• 379
• 380
• 381
• 382
• 383
• 384
• 385
• 386
• »

• Automated Continuous OneNote Replication to MongoDB

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

• Connect to Azure Active Directory as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Active Directory.

• Create Google Contacts-Connected Business Apps in AppSheet

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

• Create SSAS Tabular Models from Impala

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

• How to Query Live Impala in Claude Desktop

  Connect to and query live Impala in Claude Desktop using the CData MCP Server.

• Visualize Live Kintone in the Power BI Service

  Use CData Connect Cloud to connect to live Kintone and create custom reports in the Power BI Service through the On-Premises Gateway.

• Access Live Splunk in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Splunk from your Excel spreadsheets.

• Automated Continuous Salesforce Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Salesforce & Force.com replication to OneLake in Microsoft Fabric.

• Automate Twitter Ads Integration Tasks from PowerShell

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

• How to connect Amazon QuickSight to Google Campaign Manager 360

  Create a connection to Google Campaign Manager 360 in CData Connect Cloud and insert Google Campaign Manager 360 into Amazon QuickSight SPICE to build interactive dashboards.

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

• Publish Reports with Amazon Athena in SAP Crystal Reports

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

• Consume SAP SuccessFactors OData Feeds in PowerBuilder

  This article demonstrates how to consume SAP SuccessFactors as OData feeds from PowerBuilder using the API Server.

• Connect to Live NetSuite in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to NetSuite in CData Connect Cloud and connect to your NetSuite CRM & ERP from PostgreSQL.

• Connect to Twitter Ads in CloverDX (formerly CloverETL)

  Transfer Twitter Ads using the visual workflow in the CloverDX data integration tool.

• How to Connect to & Open Reckon in Microsoft Excel

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

• Creating Adobe Commerce-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Adobe Commerce to Unqork and build custom business apps.

• Analyze Smartsheet in R via ODBC

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

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

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

• Enable the Redis JDBC Driver in KNIME

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

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

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

• Access Live Aha in TIBCO Data Virtualization

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

• Visualize Live Act-On in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Act-On.

• Extending QuickBooks Online Reporting

  The CData Data Providers for QuickBooks Online make it easy for you to create new reports and customize existing ones. This article demonstrates how to create a new Item Profitability Report. Using the ADO.NET provider, you can then retrieve it directly from Server Explorer in Visual Studio.

• Access Live Tally in Coginiti Pro

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

• PowerShell Scripting to Replicate Snowflake to MySQL

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

• Use the CData API Server to Access SQL Analysis Services in Microsoft PowerPivot

  Use the CData API Server to connect to live SQL Analysis Services in the Power Pivot business intelligence tool.

• Visualize Live WordPress of Power BI Report Builder in Power BI Service

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

• Query Google Cloud Storage in DataGrip

  Create a Data Source for Google Cloud Storage in DataGrip and use SQL to query live Google Cloud Storage.

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

  Use CData JDBC drivers to import and use Google Spanner in ColdFusion.

• Connect to Azure Data Catalog from Asprova with CData Software ODBC Driver for Azure Data Catalog

  This article shows how to connect faster to Azure Data Catalog data from Asprova.

• Raisers Edge NXT Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Raisers Edge NXT facts in real time.

• Working with ActiveCampaign in LINQPad

  Execute LINQ queries to ActiveCampaign in LINQPad.

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

  Connect to Apache Cassandra 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.

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

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

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

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

• Use the CData Software JDBC Driver for SAP in MicroStrategy

  Connect to SAP ERP/NetWeaver in MicroStrategy Developer using the CData Software JDBC Driver for SAP.

• Visualize SendGrid from Tableau

  Use the Tableau Desktop business intelligence tool to connect to SendGrid.

• Connect to Excel from PowerBuilder via JDBC

  This article demonstrates how to access Microsoft Excel from PowerBuilder using the Excel JDBC Driver.

• How to publish and share Paylocity dashboards with Tableau Server

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

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

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

• Configure the CData JDBC Driver for SAS xpt in a Connection Pool in Tomcat

  Connect to SAS XPORT from a connection pool in Tomcat.

• Automate SAP HANA XS Advanced Replication to Azure Data Lake

  Use CData Sync to customize and automate SAP HANA XS Advanced replication to Azure Data Lake.

• Automated Continuous SAP Ariba Source Replication to MySQL

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

• Access Live Salesforce Pardot in AWS Lambda

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

• Migrating data from CockroachDB to Google BigQuery using CData SSIS Components.

  Easily push CockroachDB to Google BigQuery using the CData SSIS Tasks for CockroachDB and Google BigQuery.

• Create Zuora-Connected Visualizations in Klipfolio

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

• Replicate CSV in Heroku for Use in Salesforce Connect

  Replicate CSV/TSV Files to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Build Data Flows from QuickBooks to SQL Server using SSIS

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

• Process & Analyze Google Ad Manager in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Google Ad Manager .

• Analyze Salesforce Marketing in R via ODBC

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

• Automated Continuous Oracle Sales Replication to Amazon Redshift

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

• Connect to GraphQL in JRuby

  Create a simple JRuby app with access to live GraphQL.

• Extend Google Sheets with Shopify

  Make calls to the API Server from Google Apps Script.

• Integrate with live Hive in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Apache Hive in Jitterbit.

• Visualize Live Act-On in Power BI (via CData Connect Cloud)

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

• Natively Connect to ActiveCampaign in PHP

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

• Connect to Outreach.io in DBeaver

  Use the CData ODBC Driver to connect to Outreach.io in DBeaver.

• Easily Integrate Klaviyo in Lazarus Pascal IDE

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

• Analyze Avalara AvaTax in Infragistics Reveal

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

• Build Data Flows from Redshift to SQL Server using SSIS

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

• Validate Cosmos DB with QuerySurge

  Access and validate Azure Cosmos DB in QuerySurge using the CData JDBC Driver.

• Analyze Printful in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Printful and visualize live Printful in Ingragistics Reveal.

• Automate Active Directory Integration Tasks from PowerShell

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

• Access Live Amazon Athena Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Amazon Athena data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Bridge Invoiced Connectivity with Apache NiFi

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

• PowerShell Scripting to Replicate SAP Netweaver Gateway to MySQL

  Write a simple PowerShell script to replicate SAP Netweaver Gateway to a MySQL database.

• Access Act-On as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act-On from your Oracle system.

• Connect to Live Google Contacts in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Google Contacts in CData Connect Cloud and connect to your Google Contacts from PostgreSQL.

• Use the CData Software ODBC Driver for Sage Intacct in MicroStrategy

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

• Manage ActiveCampaign in DBArtisan as a JDBC Source

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

• Analyze Cloudant with Power Pivot

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

• Create Couchbase-Connected Enterprise Applications in OutSystems

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

• PowerShell Scripting to Replicate HBase to MySQL

  Write a simple PowerShell script to replicate Apache HBase to a MySQL database.

• Visualize Live Square in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Square.

• Automated CSV Replication to Teradata

  Use CData Sync to Customize and automate CSV/TSV Files replication to Teradata.

• Analyze Amazon Marketplace in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Amazon Marketplace and visualize live Amazon Marketplace in Ingragistics Reveal.

• How to connect and process QuickBooks Time from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live QuickBooks Time.

• Prepare, Blend, and Analyze Snowflake in Alteryx Designer (ODBC)

  Build workflows to access live Snowflake for self-service data analytics.

• Connect to Redis in RazorSQL

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

• Automated Continuous Google Campaign Manager 360 Replication to MySQL

  Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to MySQL.

• Connect to OneNote in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for OneNote and connect to Microsoft OneNote in Akorbi Digital RunMyProcess.

• Integrate Live Gmail into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Gmail from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Gmail.

• Connect to SAP Hybris C4C in RapidMiner

  Integrate SAP Hybris C4C with standard components and data source configuration wizards in RapidMiner Studio.

• Create Apps from CockroachDB in Qlik Sense Cloud

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

• Visualize Zoho Inventory in TIBCO Spotfire through ODBC

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

• Automate Dropbox Integration Tasks from PowerShell

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

• Design BIRT Reports on SAS xpt

  Provide current SAS XPORT to your embedded analytics.

• Create Dashboards and Visualize Live Oracle SCM in Geckoboard

  Use CData Connect Cloud to connect to live Oracle SCM and create dashboards for real-time monitoring and visualization in Geckoboard.

• DataBind Controls to Google Contacts in Delphi

  DataBind to Google Contacts in Delphi with standard data access components and controls.

• How to connect SharePoint with Greenplum through external lists

  Provide Pivotal GreenPlum to SharePoint users as an external list.

• Use Dash to Build to Web Apps on Klaviyo

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

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

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

• Model Bing Ads Using Azure Analysis Services

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

• Analyze SAP Business One in R via ODBC

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

• How to connect to Marketo in DBVisualizer

  Integrate Marketo with visual data analysis tools and data connection wizards in DBVisualizer

• Connect to ServiceNow as a Linked Server via SQL Gateway

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

• Use the CData Software ODBC Driver for Dynamics 365 in MicroStrategy Web

  Connect to Microsoft Dynamics 365 in MicroStrategy Web using the CData Software ODBC Driver for Dynamics 365.

• Connect to Real-Time Redshift Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 377
• 378
• 379
• 380
• 381
• 382
• 383
• 384
• 385
• 386
• »