CData Software - Knowledge Base

Recent Articles

• «
• 353
• 354
• 355
• 356
• 357
• 358
• 359
• 360
• 361
• 362
• »

• How to Design Salesloft Power Apps with Database-Like Connectivity

  This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.

• Create Reports with SurveyMonkey in SAP Crystal Reports

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

• Feed Spark into FineReport

  How to set Apache Spark SQL as a JDBC data source in FineReport.

• Connect to YouTube Analytics in SpagoBI

  Create reports featuring live YouTube Analytics in SpagoBI Studio. Host YouTube Analytics reports on SpagoBI Server.

• Configuring Clustering for CData Sync

  Configure CData Sync to use the built-in high-availability and failover features across several clustered instances.

• Automated Continuous Sage Cloud Accounting Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to SQL Server.

• Visualize Live Reckon in Power BI (via CData Connect Cloud)

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

• Connect to Azure Data Catalog from PowerBuilder via JDBC

  This article demonstrates how to access Azure Data Catalog from PowerBuilder using the Azure Data Catalog JDBC Driver.

• How to pipe Parquet to CSV in PowerShell

  Use standard PowerShell cmdlets to access Parquet tables.

• Access Paylocity from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Paylocity from HeidiSQL.

• Build Pinterest-Connected ETL Processes in Google Data Fusion

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

• Work with Live SAP BusinessObjects BI in Power Query

  Use CData Connect Cloud to connect to SAP BusinessObjects BI and work with live SAP BusinessObjects BI in Microsoft Power Query.

• Use the CData ODBC Driver for Acumatica from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Acumatica to connect to Acumatica ERP from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Acumatica ERP in Excel.

• Prepare, Blend, and Analyze Reckon Accounts Hosted in Alteryx Designer (Connect Cloud)

  Build workflows to access live Reckon Accounts Hosted for self-service data analytics.

• How to create an RPA flow for SAS Data Sets in UiPath Studio

  Use the SAS Data Sets ODBC Driver to create workflows that access real-time SAS Data Sets without any coding.

• Automated Continuous Coinbase Replication to MongoDB

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

• Automated Continuous Drift Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Drift replication to PostgreSQL.

• Replicate Smartsheet in Heroku for Use in Salesforce Connect

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

• Connect to CouchDB in RazorSQL

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

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

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

• Create Power BI Reports on Real-Time Sybase IQ

  Use the CData ODBC Driver for Sybase IQ to visualize Sybase IQ in Power BI Desktop.

• Query, Visualize, and Share live Smaregi in Redash

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

• Trigger SAP SuccessFactors IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

• Connect to and Visualize Live Jira Service Management in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Atlassian Jira Service Management.

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

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

• Integrate with Live Azure Table in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Azure Table from the MuleSoft Anypoint Platform to integrate live Azure Table Storage into custom reports and dashboards.

• Automate Aha Replication to Couchbase

  Use CData Sync to Customize and automate Aha! replication to Couchbase.

• How to connect to ActiveCampaign from Spring Boot

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

• Connect to Sage 200 in RazorSQL

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

• Connect to CockroachDB in ACL Analytics

  Connect to CockroachDB via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to CockroachDB.

• Using the CData Software ODBC Driver for OData in PyCharm

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

• Automated Continuous Zoom Replication to Amazon S3

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

• Use the CData Software JDBC Driver for Marketo in MicroStrategy Web

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

• Automated Continuous LinkedIn Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable LinkedIn replication to AlloyDB.

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

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

• Establish a Live Connection with Klaviyo using Tableau Bridge

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

• Consume Amazon S3 OData Feeds in PowerBuilder

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

• Easily Integrate Oracle Service Cloud in Lazarus Pascal IDE

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Power BI XMLA

  Provide connectivity to Power BI XMLA through an SAP BusinessObjects universe.

• Analyze Live Salesforce in SAS Viya

  Use CData Connect Cloud to connect to Salesforce & Force.com from SAS Viya and deploy self-service analytics using live Salesforce & Force.com.

• Analyze Azure Active Directory in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Azure Active Directory and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• Visualize Sage Intacct in TIBCO Spotfire through ODBC

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

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

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

• Create Apps from Epicor Kinetic in Qlik Sense Cloud

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

• Connect to and Query Okta in QlikView over ODBC

  Create data visualizations with Okta in QlikView.

• Build Dashboards with Avro in DBxtra

  Create dynamic dashboards and perform analytics based on Apache Avro in DBxtra.

• Creating Zoho Inventory-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Zoho Inventory to Unqork and build custom business apps.

• Use the CData Software ODBC Driver for DocuSign in MicroStrategy

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

• How to import Sage Intacct into Apache Solr

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

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

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

• Extend Google Sheets with Azure Analysis Services

  Make calls to the API Server from Google Apps Script.

• Visualize Live Google Analytics of Power BI Report Builder in Power BI Service

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

• Explore Geographical Relationships in Neo4J with Power Map

  Create data visualizations with Neo4J in Power Map.

• How to import ServiceNow into Apache Solr

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

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

  Connect to Google Ads 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.

• Automated Continuous Sybase IQ Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Sybase IQ replication to IBM DB2.

• How to connect PolyBase to Stripe

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

• Use JayDeBeApi to access Sugar CRM in Python

  Use standard Python scripting and the development environment of your choice to access live Sugar CRM.

• How to Access Twitter Ads Using Entity Framework

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

• How to Access SAP Using Entity Framework

  This article shows how to access SAP ERP/NetWeaver using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Automate Calendly Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Calendly and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Extract, Transform, and Load Azure Synapse in Informatica PowerCenter

  Create a simple Workflow for Azure Synapse in Informatica PowerCenter.

• Connect and Query Live Backlog Data in Databricks with CData Connect Cloud

  Use CData Connect Cloud to integrate live Backlog into Databricks

• Analyze Yahoo! Ads in Infragistics Reveal

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

• Publish Raisers Edge NXT-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Raisers Edge NXT.

• Add Azure Synapse to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Azure Synapse with the Informatica Enterprise Data Catalog to classify and organize data.

• Use the CData ODBC Driver for Oracle Eloqua in Microsoft Power Query

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

• Analyze Oracle in Infragistics Reveal

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

• Validate Google Analytics with QuerySurge

  Access and validate Google Analytics in QuerySurge using the CData JDBC Driver.

• Automated Continuous SingleStore Replication to SQLite

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

• How to connect Amazon QuickSight to Amazon DynamoDB

  Create a connection to Amazon DynamoDB in CData Connect Cloud and insert Amazon DynamoDB into Amazon QuickSight SPICE to build interactive dashboards.

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

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

• Visualize Live PayPal in the Power BI Service

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

• Easily Integrate Act-On in Lazarus Pascal IDE

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

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

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

• How to Query Act CRM in MySQL Workbench

  Execute MySQL queries against live Act CRM from MySQL Workbench.

• How to connect to Zoho CRM with Squirrel SQL client

  Connect to Zoho CRM and execute queries in the Squirrel SQL Client.

• Automated Continuous SAP Concur Replication to Google BigQuery

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

• Use the CData Software JDBC Driver for Snapchat Ads in MicroStrategy Web

  Connect to Snapchat Ads in MicroStrategy Web using the CData Software JDBC Driver for Snapchat Ads.

• Create Data Visualizations Based On Act-On in Mode

  Use CData Connect Cloud to connect to Act-On from Mode and build visualizations using live

• Configure the CData JDBC Driver for Amazon S3 in a Connection Pool in Tomcat

  Connect to Amazon S3 from a connection pool in Tomcat.

• How to connect to eBay in DBVisualizer

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

• Connect to Shopify in DBArtisan

  Use wizards in DBArtisan to configure Shopify as a data source.

• How to Connect to & Open Amazon Athena in Microsoft Excel

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

• Analyze Zendesk in Infragistics Reveal

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

• Build Azure Table-Connected ETL Processes in Google Data Fusion

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

• How to Access Live Unbounce in Power Automate Desktop via ODBC

  The CData ODBC Driver for Unbounce enables you to integrate Unbounce into workflows built using Microsoft Power Automate Desktop.

• Use the CData Software JDBC Driver for DB2 in MicroStrategy Web

  Connect to IBM DB2 in MicroStrategy Web using the CData Software JDBC Driver for DB2.

• Build Zuora-Connected ETL Processes in Google Data Fusion

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

• Analyze Zoho Books in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Zoho Books and visualize Zoho Books in SAP Analytics Cloud.

• Automated Continuous Google Ads Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Google Ads replication to SQL Server.

• How to connect PolyBase to Google Ads

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

• Consume Azure Synapse OData Feeds in SAP Lumira

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

• Connect to MySQL from PowerBuilder via ADO.NET

  This article demonstrates how to access MySQL from Appeon PowerBuilder using the CData ADO.NET Provider for MySQL.

• Integrate FHIR into Power Automate Desktop using CData Connect

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

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

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

• Build a Simple VCL Application for SAP Netweaver Gateway

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

• Build Pipelines with Live IBM Informix in Google Cloud Data Fusion (via CData Connect Cloud)

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

• Integrate with HarperDB using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy HarperDB to a JSON file on disk.

• Connect to GitHub from PowerBuilder via JDBC

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

• «
• 353
• 354
• 355
• 356
• 357
• 358
• 359
• 360
• 361
• 362
• »