CData Software - Knowledge Base

Recent Articles

• «
• 57
• 58
• 59
• 60
• 61
• 62
• 63
• 64
• 65
• 66
• »

• Connect to Live Google Cloud Storage in MicroStrategy through CData Software Connect Server

  Create a virtual database for Google Cloud Storage in CData Software Connect Server and connect to it from MicroStrategy.

• Create Google Ad Manager Dataflows on PowerBI.com

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

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

  Use CData Power BI Connectors to visualize Jira Assets in Power BI.

• Stream Snowflake into Apache Kafka Topics

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

• How to Connect to SAP SuccessFactors in Using Python: 6 Steps

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

• Import Gmail into FileMaker Pro

  Create reports that integrate Gmail in Filemaker Pro.

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

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

• Query Dynamics GP in ColdFusion

  Write standard ColdFusion data access code to connect to Microsoft Dynamics GP.

• DataBind Charts to Workday

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Workday 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.

• Visualize TigerGraph in TIBCO Spotfire through ODBC

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

• Automate Coinbase Replication to SAP HANA

  Use CData Sync to customize and automate Coinbase replication to SAP HANA.

• How to create Highrise federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Highrise CRM in MySQL .

• Build MVC Applications with Connectivity to LinkedIn

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

• Publish Crystal Reports on Clio

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Clio.

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

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

• Visualize Oracle Eloqua in Sisense

  Create an ElastiCube in Sisense app with access to Oracle Eloqua.

• DataBind Controls to Google Contacts in C++Builder

  DataBind to Google Contacts in C++Builder with standard components and controls.

• Feed Typeform into FineReport

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

• Prepare, Blend, and Analyze Salesforce Marketing in Alteryx Designer

  Build workflows to access live Salesforce Marketing Cloud for self-service data analytics.

• Using the CData Software ODBC Driver for Amazon Athena in PyCharm

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

• Automated Continuous Workday Replication to IBM DB2

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

• Automated Continuous Coinbase Replication to PostgreSQL

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

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

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

• Automated Continuous Redis Replication to Databricks

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

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

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

• Operational Reporting on SAP Business One from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote SAP Business One.

• Build Dashboards with Harvest in Dundas BI

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

• Process & Analyze FHIR in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live FHIR .

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

  Use the CData Connector for Klipfolio in APOS Live Data Gateway to build Semantic Layer Views for Klipfolio.

• Access Live Outreach.io in AWS Lambda (with IntelliJ IDEA)

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

• Replicate Azure Data Catalog from PowerShell

  Write a quick PowerShell script to query Azure Data Catalog. Use connectivity to the live data to replicate Azure Data Catalog to SQL Server.

• LINQ to Microsoft Planner

  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 Microsoft Planner Data Provider.

• How to connect to XML from Spring Boot

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

• How to Connect to & Open Facebook Ads in Microsoft Excel

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

• Use the CData Software JDBC Driver for NetSuite in MicroStrategy

  Connect to NetSuite CRM & ERP in MicroStrategy Developer using the CData Software JDBC Driver for NetSuite.

• How to connect Amazon QuickSight to Google Calendar

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

• Create Cassandra-Connected Visualizations in Klipfolio

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

• Automate Salesforce Marketing Replication to Azure Synapse

  Use CData Sync to customize and automate Salesforce Marketing Cloud replication to Azure Synapse.

• Automated Continuous SQL Server Replication to Google BigQuery

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

• Integrate with Live Bullhorn CRM in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Bullhorn CRM from the MuleSoft Anypoint Platform to integrate live Bullhorn CRM into custom reports and dashboards.

• Connect to ServiceNow in JRuby

  Create a simple JRuby app with access to live ServiceNow.

• Dynamics 365 Business Central Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Dynamics 365 Business Central facts in real time.

• Replicate Multiple Greenplum Accounts

  Replicate multiple Greenplum accounts to one or many databases.

• Use the CData Software ODBC Driver for Power BI XMLA in MicroStrategy Web

  Connect to Power BI XMLA in MicroStrategy Web using the CData Software ODBC Driver for Power BI XMLA.

• Process & Analyze Tableau CRM Analytics in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Tableau CRM Analytics .

• Create Apps from Snapchat Ads in Qlik Sense Cloud

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

• Create Reports with Typeform in SAP Crystal Reports

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

• Connect to SendGrid in Ruby

  Connect to SendGrid in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Use the CData ODBC Driver for SQL Server in Microsoft Power Query

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

• Build ConstantContact-Connected Web Apps in Servoy

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

• Use the CData Software ODBC Driver for Google Drive in MicroStrategy Web

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

• How to connect PolyBase to BambooHR

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

• Access RSS Feeds from MySQL in PHP

  Connect to RSS through the standard MySQL libraries in PHP.

• Visualize Adobe Analytics in Sisense

  Create an ElastiCube in Sisense app with access to Adobe Analytics.

• Automated Continuous SAP Hybris C4C Replication to MySQL

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to MySQL.

• Create SSAS Tabular Models from Spark

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

• Automated Continuous Oracle Sales Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Oracle Sales replication to Azure SQL.

• Access Live Epicor Kinetic in AWS Lambda

  Connect to live Epicor Kinetic in AWS Lambda using the CData JDBC Driver.

• Integrate SAP HANA in the Pentaho Report Designer

  Publish reports based on SAP HANA in the Pentaho BI tool.

• How to integrate Freshdesk with Apache Airflow

  Access and process Freshdesk in Apache Airflow using the CData JDBC Driver.

• Analyze Live IBM Informix in SAS Viya

  Use CData Connect Cloud to connect to IBM Informix from SAS Viya and deploy self-service analytics using live IBM Informix.

• Integrate with live Azure DevOps in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Azure DevOps in Jitterbit.

• Use JayDeBeApi to access Microsoft Teams in Python

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

• Zoho Books Cloud Connectivity

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

• Automated Continuous Greenplum Replication to AlloyDB

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

• Import Email into the Power BI Service for Visualizations

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

• Integrate SAP SuccessFactors into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to SAP SuccessFactors and integrate live SAP SuccessFactors into your Power Automate tasks.

• Connect to ClickUp from PowerBuilder

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

• Replicate Reckon to Multiple Databases

  Replicate Reckon to disparate databases with a single configuration.

• Connect to Zuora through External Services in Salesforce

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

• How to import Workday into Apache Solr

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

• PowerShell Scripting to Replicate Sage 300 to MySQL

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

• Integrate with Klipfolio using Apache Camel2

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

• Connect to Printful in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for Printful and connect to Printful in Akorbi Digital RunMyProcess.

• Replicate Multiple Airtable Accounts

  Replicate multiple Airtable accounts to one or many databases.

• Automated Continuous Reckon Replication to Oracle

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

• How to create Sybase federated tables in MySQL

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

• Visualize SAS xpt in Sisense

  Create an ElastiCube in Sisense app with access to SAS XPORT.

• Viewing SQL Server in RAD Studio Data Explorer

  How to view Microsoft SQL Server in RAD Studio Data Explorer using the CData ODBC Driver for SQL Server.

• How to connect to Asana from Spring Boot

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

• How to Import HCL Domino into SQL Server using SSIS

  Easily back up HCL Domino to SQL Server using the SSIS components for HCL Domino.

• Automated Continuous Bing Search Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Bing Search replication to Snowflake.

• Automated Continuous Dynamics 365 Replication to MongoDB

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

• Prepare, Blend, and Analyze Outreach.io in Alteryx Designer

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

• Use the CData Software ODBC Driver for Amazon S3 in MicroStrategy

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

• Analyze Marketo in R

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

• Automated Continuous Dynamics 365 Replication to Oracle

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

• Create Todoist Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Todoist to build custom dashboards in Bold BI.

• Access Databricks from MySQL in PHP

  Connect to Databricks through the standard MySQL libraries in PHP.

• How to work with Microsoft Project in Apache Spark using SQL

  Access and process Microsoft Project in Apache Spark using the CData Software JDBC Driver.

• Use the CData SSIS Components to Insert New or Update Existing Acumatica Records from SQL Server

  Easily push SQL Server data to Acumatica using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Acumatica or update existing records with data from a SQL Server database.

• Connect to Bing Ads in Aqua Data Studio

  Access Bing Ads from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Create Apps from Asana in Qlik Sense Cloud

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

• Query Phoenix through ODBC in Node.js

  Use node-odbc to execute SQL queries against Apache Phoenix from Node.js.

• Integrate Real-Time Access to Monday.com in SAPUI5 MVC Apps

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

• How to integrate Azure Active Directory with Apache Airflow

  Access and process Azure Active Directory in Apache Airflow using the CData JDBC Driver.

• Replicate Bing Ads to Multiple Databases

  Replicate Bing Ads to disparate databases with a single configuration.

• Connect to SAP HANA in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

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

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

  Connect to SingleStore from a connection pool in Tomcat.

• «
• 57
• 58
• 59
• 60
• 61
• 62
• 63
• 64
• 65
• 66
• »