CData Software - Knowledge Base

Recent Articles

• «
• 48
• 49
• 50
• 51
• 52
• 53
• 54
• 55
• 56
• 57
• »

• Use the CData API Server to Access FTP in Microsoft PowerPivot

  Use the CData API Server to connect to live FTP Servers in the Power Pivot business intelligence tool.

• Automate Twilio Integration Tasks from PowerShell

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

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

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

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

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

• Rapidly Develop Klaviyo-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Build an OLAP Cube in SSAS from Zoho Inventory

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

• LINQ to Azure Data Catalog

  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 Azure Data Catalog Data Provider.

• Automated Continuous Invoiced Replication to Databricks

  Use CData Sync for automated, continuous, customizable Invoiced replication to Databricks.

• PowerShell Scripting to Replicate Kintone to MySQL

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

• Automated Continuous Box Replication to Oracle

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

• Integrate with SQL Server in JReport Designer

  Create charts and reports based on Microsoft SQL Server in JReport Designer.

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

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

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

  Use CData JDBC drivers to import and use Zoho CRM in ColdFusion.

• Query Twitter as a MySQL Database in Node.js

  Execute MySQL queries against Twitter from Node.js.

• Analyze Microsoft Teams in R via JDBC

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

• Consume Google Calendar OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Google Calendar feeds that reflect any changes in SAP Lumira.

• How to Build an ETL App for FTP in Python with CData

  Create ETL applications and real-time data pipelines for FTP Servers in Python with petl.

• Query Google Calendar as a MySQL Database in Node.js

  Execute MySQL queries against Google Calendar from Node.js.

• Publish Typeform-Connected Dashboards in Tableau Server via JDBC

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

• Create Reports with Cvent in SAP Crystal Reports

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

• Connect to SharePoint from Excel & GoogleSheets!

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

• How to Create Power BI Visual Reports with Real-Time WooCommerce

  Use CData Power BI Connectors to visualize WooCommerce in Power BI.

• How to Seamlessly Import SAP HANA XS Advanced Data into IBM SPSS Modeler

  Integrate SAP HANA XS Advanced data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• How to connect and process ActiveCampaign from Azure Databricks

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

• Connect to Presto in NetBeans

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

• Automated Continuous Oracle Replication to Vertica

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

• Create REST Reports on JasperReports Server

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

• How to connect PolyBase to CSV

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CSV/TSV Files.

• Create SSAS Tabular Models from RSS Feeds

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

• Load Sage Cloud Accounting to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sage Business Cloud Accounting to a database.

• Visualize Live Act-On in the Power BI Service

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

• How to Create Power BI Visual Reports with Real-Time MailChimp

  Use CData Power BI Connectors to visualize MailChimp in Power BI.

• Connect to MongoDB from Blazor Apps

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

• Visualize SAS Data Sets in TIBCO Spotfire through OData

  Integrate SAS Data Sets into dashboards in TIBCO Spotfire.

• Import Real-Time Authorize.Net via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Authorize.Net in ColdFusion.

• Automated Continuous Vertica Replication to MongoDB

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

• Connect to and Visualize Live Confluence in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Atlassian Confluence.

• Rapidly Develop Twitter Ads-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Integrate Real-Time Access to Cloudant in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to IBM Cloudant in real time.

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

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

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

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

• Build ShipStation-Connected Apps in Mendix

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

• How to connect to Google Spanner from IntelliJ

  Integrate connectivity to Google Spanner with wizards in IntelliJ.

• Automated Continuous Dynamics NAV Replication to SQLite

  Use CData Sync for automated, continuous, customizable Dynamics NAV replication to SQLite.

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

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

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

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

• Connect to Jira Service Management from PowerBuilder via JDBC

  This article demonstrates how to access Atlassian Jira Service Management from PowerBuilder using the Jira Service Management JDBC Driver.

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

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

• How to Work with Google Data Catalog in AWS Glue Jobs Using JDBC

  Connect to Google Data Catalog from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Manage Amazon DynamoDB in DBArtisan as a JDBC Source

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

• Migrating data from ServiceNow to Databricks using CData SSIS Components.

  Easily push ServiceNow to Databricks using the CData SSIS Tasks for ServiceNow and Databricks.

• Import and Visualize Google Spanner in Power View

  Create data visualizations based on Google Spanner in Excel.

• Create SSAS Tabular Models from SendGrid

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

• Natively Connect to Google Analytics in PHP via ODBC (Linux)

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

• Replicate Multiple WordPress Accounts via the CData Sync CLI

  Replicate multiple WordPress accounts to one or many databases.

• Publish Reports with FTP in SAP Crystal Reports

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

• Create Sage Cloud Accounting Dataflows on PowerBI.com

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

• Visualize ConstantContact from Tableau

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

• Access Live Dynamics NAV in SAS JMP via ODBC

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

• How to connect SharePoint with Dropbox through external lists

  Provide Dropbox to SharePoint users as an external list.

• How to load Printify data into Elasticsearch via Logstash

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

• Extract, Transform, and Load HubSpot in Informatica PowerCenter

  Create a simple Workflow for HubSpot in Informatica PowerCenter.

• Automated Continuous Wave Financial Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Wave Financial replication to Azure SQL Database.

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

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

• Integrating Zoho Creator in Talend Cloud Data Management Platform

• «
• 48
• 49
• 50
• 51
• 52
• 53
• 54
• 55
• 56
• 57
• »