CData Software - Knowledge Base

Recent Articles

• «
• 152
• 153
• 154
• 155
• 156
• 157
• 158
• 159
• 160
• 161
• »

• Author and Share Power BI Reports on Real-Time Cosmos DB

  Use the CData ODBC Driver for Cosmos DB to visualize Azure Cosmos DB in Power BI Desktop and then upload to the Power BI service.

• Build Marketo-Connected Web Apps in Servoy

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

• How to Work with Klipfolio in AWS Glue Jobs Using JDBC

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

• Connect to Basecamp in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Basecamp and the SQL Gateway to access Basecamp from Google Apps Script.

• Add CouchDB to Informatica Enterprise Data Catalog

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

• Automated Continuous Vertica Replication to MongoDB

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

• Access Live Bullhorn CRM in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Bullhorn CRM from your Google Sheets.

• Integrate Zoho Projects in the Pentaho Report Designer

  Publish reports based on Zoho Projects in the Pentaho BI tool.

• Build GMO MakeShop-Connected Apps in Choreo

  Use CData Connect Cloud to connect to GMO MakeShop from Choreo and build custom apps using live GMO MakeShop.

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

• How to Connect to Greenhouse in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Greenhouse. Leverage the pyodbc module for ODBC in Python.

• Integrate Live Amazon S3 into Amazon SageMaker Canvas with RDS

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

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

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

• Natively Connect to Stripe in PHP

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

• Analyze MarkLogic with Power Pivot

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

• Create Excel Reports on JasperReports Server

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

• Automated Continuous Azure Data Lake Storage Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to MongoDB.

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

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zuora

  Provide connectivity to Zuora through an SAP BusinessObjects universe.

• Automated Continuous Trello Replication to MySQL

  Use CData Sync for automated, continuous, customizable Trello replication to MySQL.

• Integrate Live BigQuery into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Google BigQuery and integrate live Google BigQuery into apps built in Microsoft Power Apps.

• How to Connect to & Open Microsoft Dataverse in Microsoft Excel

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

• Automated Continuous Microsoft Exchange Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to OneLake in Microsoft Fabric.

• Query Salesloft as a SQL Server in Node.js

  Execute SQL Server queries against Salesloft from Node.js.

• Publish Cloudant-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live IBM Cloudant.

• How to Connect the Power BI Service to Access: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Build a PostgreSQL Interface for AlloyDB using the CData JDBC Driver

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

• Automated Continuous Shippo Replication to Google Cloud SQL

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

• Visualize Oracle HCM Cloud in Tableau

  The CData ODBC driver for Oracle HCM Cloud enables you integrate Oracle HCM Cloud into Tableau dashboards.

• Bidirectional Access to Coinbase from FileMaker Pro

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

• Visualize Live Odoo in the Power BI Service

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

• How to create Visio diagrams from SAP Business One

  Automatically update SAP Business One with the changes you make to Visio master shapes.

• MailChimp Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to MailChimp through CData Connect Cloud using different applications and tools.

• How to pipe Redis to CSV in PowerShell

  Use standard PowerShell cmdlets to access Redis tables.

• Using the CData Software ODBC Driver for PayPal in PyCharm

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

• Automated Continuous Google Campaign Manager 360 Replication to Snowflake

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

• Analyze OneNote in Looker

  Use CData Connect Cloud to connect to OneNote from Looker and build custom apps using live Microsoft OneNote.

• Query Dynamics 365 in MySQL Workbench

  Create a virtual MySQL database for Microsoft Dynamics 365 in CData Software Connect (or Connect Server) and work with live Microsoft Dynamics 365 in MySQL Workbench.

• Visualize Live QuickBooks Online in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live QuickBooks Online.

• Access Live Dynamics CRM in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Microsoft Dynamics CRM from your Excel spreadsheets.

• Object-Relational Mapping (ORM) with Microsoft OneDrive Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Microsoft OneDrive into a Java-based ORM framework, Hibernate.

• How to load SendGrid data into Elasticsearch via Logstash

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

• Feed Greenhouse into FineReport

  How to set Greenhouse as a JDBC data source in FineReport.

• Build Sage 300-Connected ETL Processes in Google Data Fusion

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

• How to Use a Microsoft Access Database to Update Email in Real Time

  Update Email data by creating a linked table in Microsoft Access with the CData Email ODBC Driver.

• How to connect to BambooHR from Google Apps Script

  Use CData Software Connect Server to access BambooHR in Google Apps Script.

• PowerShell Scripting to Replicate Sage 300 to MySQL

  Write a simple PowerShell script to replicate Sage 300 to a MySQL database.

• Access Live Smaregi in Excel 365 Online (Excel for the web)

  Connect to Smaregi from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• How to connect PolyBase to Okta

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

• Automated Continuous SAS xpt Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable SAS xpt replication to Apache Kafka.

• Replicate SAP BusinessObjects BI from PowerShell

  Write a quick PowerShell script to query SAP BusinessObjects BI. Use connectivity to the live data to replicate SAP BusinessObjects BI to SQL Server.

• Use the CData Software ODBC Driver for Klaviyo in MicroStrategy

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

• Build Jira Assets-Connected ETL Processes in Google Data Fusion

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

• How to Access Live Veeva Vault in Power Automate Desktop via ODBC

  The CData ODBC Driver for Veeva Vault enables you to integrate Veeva Vault & Vault CRM into workflows built using Microsoft Power Automate Desktop.

• Stream Highrise into Apache Kafka Topics

  Access and stream Highrise CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Create Informatica Mappings From/To a JDBC Data Source for Google Ad Manager

  Create Google Ad Manager data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Prepare, Blend, and Analyze SharePoint in Alteryx Designer (Connect Cloud)

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

• Query Zoho Books in DataGrip

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

• Automated Continuous Google Directory Replication to Amazon S3

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

• Connect to Zoho Creator from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Zoho Creator from Filemaker Pro on Mac.

• Visualize MailChimp in Sisense

  Create an ElastiCube in Sisense app with access to MailChimp.

• Model MYOB AccountRight Using Azure Analysis Services

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

• Prepare, Blend, and Analyze Google Ad Manager in Alteryx Designer (ODBC)

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

• Integrate Reckon Accounts Hosted into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Reckon Accounts Hosted and integrate live Reckon Accounts Hosted into your Power Automate tasks.

• CData AWS Glue Connector for Salesforce Deployment Guide

  A detailed deployment and usage guide for the CData AWS Glue Connector for Salesforce

• Automated Continuous xBase Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable xBase replication to Apache Cassandra.

• Connect to Dynamics 365 Business Central through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Dynamics 365 Business Central using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Use the CData Software JDBC Driver for Bitbucket in MicroStrategy

  Connect to Bitbucket in MicroStrategy Developer using the CData Software JDBC Driver for Bitbucket.

• Build Act-On Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Act-On and build visualizations in Tableau.

• Create Dashboards and Visualize Live Monday.com in Geckoboard

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

• Connect to Square through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Square using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Replicate Microsoft Planner from PowerShell

  Write a quick PowerShell script to query Microsoft Planner. Use connectivity to the live data to replicate Microsoft Planner to SQL Server.

• Access Live Google Spanner in AWS Lambda

  Connect to live Google Spanner in AWS Lambda using the CData JDBC Driver.

• How to connect to Zoho Inventory from Spring Boot

  Connect to Zoho Inventory in a Spring Boot Application using CData JDBC Zoho Inventory Driver

• How to Connect to & Open MYOB AccountRight in Microsoft Excel

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

• Impala Reporting in OBIEE with the Impala JDBC Driver

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

• Integrate Live REST into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for REST and integrate live REST into apps built in Microsoft Power Apps.

• Visualize Live TaxJar in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for TaxJar and create custom reports in the Power BI Service.

• Query Google Cloud Storage as a SQL Server in Node.js

  Execute SQL Server queries against Google Cloud Storage from Node.js.

• How to Build Dynamic React Apps with Tableau CRM Analytics

  Use the CData Connect and React to Build Dynamic Web Apps with Live Tableau CRM Analytics .

• Create Datasets from Azure Table in Domo Workbench and Build Visualizations of Azure Table in Domo

  Use the CData Software ODBC Driver for Azure Table to create datasets from Azure Table Storage in Domo Workbench and then build visualizations in the Domo service.

• Automated Continuous Cassandra Replication to Databricks

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

• Create CData Connect Cloud-Connected Visualizations in Klipfolio

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

• Automated Continuous Elasticsearch Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Elasticsearch replication to Apache Kafka.

• Connect to Google Directory through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Google Directory using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Build MVC Applications with Connectivity to Microsoft Project

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

• Automated Continuous Azure DevOps Replication to PostgreSQL

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

• DataBind Charts to Microsoft Project

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Project from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Automate SQL Server Replication to Couchbase

  Use CData Sync to Customize and automate Microsoft SQL Server replication to Couchbase.

• Edit and Search External ConstantContact Objects in Salesforce Connect

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

• Connect to Exact Online in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Exact Online in Airbyte.

• Using the CData Software ODBC Driver for Printful in PyCharm

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

• Connect to Oracle from Excel & GoogleSheets!

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

• A PostgreSQL Interface for SAP Netweaver Gateway using the CData ODBC Driver

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

• Use JayDeBeApi to access OData Services in Python

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

• Visualize ADP in Sisense

  Create an ElastiCube in Sisense app with access to ADP.

• Validate Neo4J with QuerySurge

  Access and validate Neo4J in QuerySurge using the CData JDBC Driver.

• Build Automated Workflows with Live Act CRM in Workato

  Use CData Connect Cloud to connect to live Act CRM and build automated workflows in Workato.

• Analyze Bing Search Results in R via ODBC

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

• Create a Data Access Object for Workday using JDBI

  A brief overview of creating a SQL Object API for Workday in JDBI.

• «
• 152
• 153
• 154
• 155
• 156
• 157
• 158
• 159
• 160
• 161
• »