CData Software - Knowledge Base

Recent Articles

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

• Work with SAP in FoxPro

  Load SAP ERP/NetWeaver into a FoxPro database. This article includes full code and a walk-through of the process.

• Prepare, Blend, and Analyze Oracle HCM Cloud in Alteryx Designer

  Build workflows to access live Oracle HCM Cloud for self-service data analytics.

• Automate Twitter Replication to Azure Data Lake

  Use CData Sync to customize and automate Twitter replication to Azure Data Lake.

• A PostgreSQL Interface for Splunk

  Use the SQL Gateway and Splunk ODBC Driver to create a PostgreSQL entry-point for data access.

• Use the CData Software JDBC Driver for Google Directory in MicroStrategy Web

  Connect to Google Directory in MicroStrategy Web using the CData Software JDBC Driver for Google Directory.

• How to connect to Veeva from IntelliJ

  Integrate connectivity to Veeva Vault with wizards in IntelliJ.

• Establish a Live Connection with SharePoint using Tableau Bridge

  The CData ODBC Driver for SharePoint enables you to integrate live Microsoft SharePoint into Tableau Cloud dashboards using the Tableau Bridge.

• How to connect PolyBase to Invoiced

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Invoiced.

• Connect to CouchDB in HULFT Integrate

  Connect to CouchDB as a JDBC data source in HULFT Integrate

• Connect to Blackbaud FE NXT from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Blackbaud FE NXT to connect to Blackbaud FE NXT and execute queries in PowerBuilder.

• How to integrate Metabase with Marketo

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

• Prepare, Blend, and Analyze Google Campaign Manager 360 in Alteryx Designer

  Build workflows to access live Google Campaign Manager 360 for self-service data analytics.

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

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

• Access Live SAP Business One in AWS Lambda (with IntelliJ IDEA)

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

• Query SingleStore in ColdFusion

  Write standard ColdFusion data access code to connect to SingleStore.

• Build Semantic Layer Views for OneNote in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Microsoft OneNote.

• Import and Visualize Google Cloud Storage in Power View

  Create data visualizations based on Google Cloud Storage in Excel.

• Stream Zoho Books into Apache Kafka Topics

  Access and stream Zoho Books in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• How to update Google Campaign Manager 360 from Excel

  This article explains how to transfer data from Excel to Google Campaign Manager 360 using the Excel Add-In for Google Campaign Manager 360.

• Build MVC Applications with Connectivity to Google Spanner

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Spanner from an ASP.NET MVC application.

• A PostgreSQL Interface for Snowflake

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

• Import Excel into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Excel and create custom reports in the Power BI Service.

• Build OneNote-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Microsoft OneNote and build web apps with connectivity to live Microsoft OneNote.

• Use the CData Software JDBC Driver for QuickBooks Time in MicroStrategy Web

  Connect to QuickBooks Time in MicroStrategy Web using the CData Software JDBC Driver for QuickBooks Time.

• QuickBooks Online Reporting and Star Schemas in OBIEE

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

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

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

• How to pipe Salesforce Marketing to CSV in PowerShell

  Use standard PowerShell cmdlets to access Salesforce Marketing tables.

• Integrate Azure Analysis Services with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Azure Analysis Services with External Services.

• Creating LinkedIn Ads-Connected Applications in Unqork

  You can use CData Connect Cloud to feed LinkedIn Ads to Unqork and build custom business apps.

• Design BIRT Reports on QuickBooks

  Provide current QuickBooks Desktop to your embedded analytics.

• Manage Adobe Analytics in DBArtisan as a JDBC Source

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

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

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

• Import LinkedIn Ads into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to LinkedIn Ads and provide access to live LinkedIn Ads for custom reports in the Power BI Service.

• Import Dynamics CRM into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Dynamics CRM and provide access to live Microsoft Dynamics CRM for custom reports in the Power BI Service.

• Model, Search, and Visualize Live AlloyDB in ThoughtSpot

  Use CData Connect Cloud to connect to live Google AlloyDB for modeling, searching, and visualizing.

• Create Quickbase-Connected Business Apps in AppSheet

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

• Connect to Harvest in Jaspersoft Studio

  Execute SQL to remote Harvest in Jaspersoft Studio.

• Use Biml to Build SSIS Tasks to Replicate MYOB AccountRight to SQL Server

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

• Configure the CData JDBC Driver for Azure Synapse in a Connection Pool in Tomcat

  Connect to Azure Synapse from a connection pool in Tomcat.

• Model PayPal Using Azure Analysis Services

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

• Rapidly Develop GitHub-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.

• How to connect and process Printful from Azure Databricks

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

• Edit and Search External Epicor Kinetic Objects in Salesforce Connect

  Use CData Connect Cloud to securely provide OData feeds of Epicor Kinetic to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Epicor Kinetic objects that you can access from apps and the dashboard.

• Use the CData ODBC Driver for Azure DevOps in Microsoft Power Query

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

• Prepare, Blend, and Analyze Power BI XMLA in Alteryx Designer

  Build workflows to access live Power BI XMLA for self-service data analytics.

• Build Dashboards with SingleStore in Dundas BI

  Create dynamic dashboards and perform analytics based on SingleStore in Dundas BI.

• Build Automated Workflows with Live Amazon DynamoDB in Workato

  Use CData Connect Cloud to connect to live Amazon DynamoDB and build automated workflows in Workato.

• Manage Azure Data Catalog in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Azure Data Catalog.

• Visualize ADP in Sisense

  Create an ElastiCube in Sisense app with access to ADP.

• How to Build Dynamic React Apps with QuickBooks Time

  Use the CData Connect and React to Build Dynamic Web Apps with Live QuickBooks Time .

• Author and Share Power BI Reports on Real-Time Zoho Books

  Use the CData ODBC Driver for Zoho Books to visualize Zoho Books in Power BI Desktop and then upload to the Power BI service.

• Natively Connect to Outreach.io in PHP

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

• Create Zenefits Reports on JasperReports Server

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

• Automated Continuous eBay Replication to Oracle

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

• Query eBay Analytics as a SQL Server in Node.js

  Execute SQL Server queries against eBay Analytics from Node.js.

• Connect to OData Services from AWS Glue

  Use CData Connect Cloud to gain access to live OData from your AWS Glue jobs.

• Using the CData Software ODBC Driver for eBay Analytics in PyCharm

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

• Build MVC Applications with Connectivity to Amazon S3

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Amazon S3 from an ASP.NET MVC application.

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

• How to create Dynamics GP federated tables in MySQL

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

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

  Use CData Power BI Connectors to visualize Active Directory in Power BI.

• Creating Snapchat Ads-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Snapchat Ads to Unqork and build custom business apps.

• How to connect and process SAP Fieldglass from Azure Databricks

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

• How to use SQLAlchemy ORM to access Oracle Financials Cloud in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Financials Cloud.

• Use Dash to Build to Web Apps on Sage 50 UK

  Create Python applications that use pandas and Dash to build Sage 50 UK-connected web apps.

• Replicate Spark to Multiple Databases

  Replicate Apache Spark SQL to disparate databases with a single configuration.

• Automated Odoo Replication to Teradata

  Use CData Sync to Customize and automate Odoo ERP replication to Teradata.

• Automated Continuous Printful Replication to Google BigQuery

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

• Access Azure Table from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Azure Table Storage from HeidiSQL.

• Access SAS xpt 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 SAS XPORT.

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

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

• Import Real-Time Pipedrive in ColdFusion to Build Applications

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

• Automated Continuous DocuSign Replication to Databricks

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

• Automate Cloudant Replication to Azure Synapse

  Use CData Sync to customize and automate IBM Cloudant replication to Azure Synapse.

• Using AngularJS to Build Dynamic Web Pages with Adobe Commerce

  Use the CData Connect Server to create Adobe Commerce OData feeds and build single-page applications with live Adobe Commerce.

• How to use SQLAlchemy ORM to access Square in Python

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

• Use the CData ODBC Driver for Splunk in SAS JMP

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

• Visualize Live Act-On of Power BI Report Builder in Power BI Service

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

• Visualize Live Okta in Tableau

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

• Automate ConstantContact Replication to Azure Synapse

  Use CData Sync to customize and automate ConstantContact replication to Azure Synapse.

• Visualize Microsoft Exchange in TIBCO Spotfire through ODBC

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

• Access Todoist as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Todoist from your Oracle system.

• Replicate Multiple Sage Cloud Accounting Accounts

  Replicate multiple Sage Cloud Accounting accounts to one or many databases.

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

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Spark SQL in real time.

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

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

• Import Amazon DynamoDB Using Azure Data Factory

  Use CData Connect Cloud to connect to Amazon DynamoDB from Azure Data Factory and import live Amazon DynamoDB.

• How to connect to Outreach.io from Spring Boot

  Connect to Outreach.io in a Spring Boot Application using CData JDBC Outreach.io Driver

• Connect to Slack from AWS Glue

  Use CData Connect Cloud to gain access to live Slack from your AWS Glue jobs.

• Access Elasticsearch in PHP through Connect Server

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

• Enable the SQL Analysis Services JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with SQL Analysis Services.

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

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

• Bidirectional Access to Azure Data Catalog from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Azure Data Catalog in Filemaker Pro for Mac or Windows.

• Analyze YouTube Analytics in R

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

• How to work with Google Sheets in Apache Spark using SQL

  Access and process Google Sheets in Apache Spark using the CData Software JDBC Driver.

• How to connect to Pipedrive from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Pipedrive and work with Pipedrive in Microsoft Excel on Mac OS X.

• Build Charts with Authorize.Net in Clear Analytics

  Create dynamic charts and perform analytics based on Authorize.Net in Clear Analytics.

• Visualize Wave Financial in TIBCO Spotfire through ODBC

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

• Build Clio-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for Clio and build visualizations and dashbaords from Clio in Redash.

• Use Dash to Build to Web Apps on Monday.com

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

• Automated SAP Concur Replication to Teradata

  Use CData Sync to Customize and automate SAP Concur replication to Teradata.

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