CData Software - Knowledge Base

Recent Articles

• «
• 560
• 561
• 562
• 563
• 564
• 565
• 566
• 567
• 568
• 569
• »

• Use JayDeBeApi to access SharePoint Excel Services in Python

  Use standard Python scripting and the development environment of your choice to access live SharePoint Excel Services.

• Analyze Oracle Eloqua in Slingshot with CData API Server

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

• Building Dynamic Web Pages with FHIR Using AngularJS

  Create single-page applications with live connectivity to FHIR using the CData API Server.

• Create Datasets from Vault CRM in Domo Workbench and Build Visualizations of Vault CRM in Domo

  Use the CData Software ODBC Driver for Vault CRM to create datasets from Veeva Vault & Vault CRM in Domo Workbench and then build visualizations in the Domo service.

• Analyze BigQuery in Infragistics Reveal

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

• Query Microsoft Teams as a MySQL Database in Node.js

  Execute MySQL queries against Microsoft Teams from Node.js.

• Connect to IBM Cloud Object Storage from a Connection Pool in WebLogic

  Use the CData JDBC Driver for IBM Cloud Object Storage to connect to IBM Cloud Object Storage from Web applications running on WebLogic.

• Trigger Databricks 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 Phoenix to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Apache Phoenix using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Choosing the Best Method to Connect Cosmos DB to SQL Server: 5 Options Explained

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

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

  Connect to Adobe Commerce from a connection pool in Tomcat.

• DataBind Controls to ClickUp in Delphi

  DataBind to ClickUp in Delphi with standard data access components and controls.

• Connect to Amazon DynamoDB from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Amazon DynamoDB from Filemaker Pro on Mac.

• Create Informatica Mappings From/To a JDBC Data Source for xBase

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

• Import Amazon Marketplace Using Azure Data Factory

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

• Create Raisers Edge NXT-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Raisers Edge NXT from Nintex Workflow Cloud and build custom workflows using live Raisers Edge NXT.

• Natively Connect to MongoDB in PHP

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

• Add DocuSign to Informatica Enterprise Data Catalog

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

• Feed Databricks into FineReport

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

• Automated Continuous Highrise Replication to Apache Cassandra

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

• Import and Visualize Salesforce Marketing in Power View

  Create data visualizations based on Salesforce Marketing Cloud in Excel.

• Automated Continuous Oracle Service Cloud Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to PostgreSQL.

• Connect to Excel from a Connection Pool in Jetty

  The Excel JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Excel from Web apps in Jetty.

• Analyze Oracle HCM Cloud in SAP Analytics Cloud

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

• Build Dashboards with Twilio in DBxtra

  Create dynamic dashboards and perform analytics based on Twilio in DBxtra.

• Connect to SAP HANA in RazorSQL

  Connect to SAP HANA from wizards and query SAP HANA from the GUI in the RazorSQL database management tool.

• Connect to SAP Netweaver Gateway in RazorSQL

  Connect to SAP Netweaver Gateway from wizards and query SAP Netweaver Gateway from the GUI in the RazorSQL database management tool.

• Build Dashboards with Box in DBxtra

  Create dynamic dashboards and perform analytics based on Box in DBxtra.

• Connect to SharePoint in RapidMiner

  Integrate Microsoft SharePoint with standard components and data source configuration wizards in RapidMiner Studio.

• Use Dash to Build to Web Apps on Box

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

• Build Data Flows from SQL Server to OData through SSIS

  Easily push SQL Server data to OData using the CData SSIS Tasks for OData.

• How to connect to Redshift from Spring Boot

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

• DataBind Controls to HBase in Delphi

  DataBind to Apache HBase in Delphi with standard data access components and controls.

• Build Apps with Live Oracle SCM in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Oracle SCM into the Adalo platform and build custom mobile and web applications with real-time Oracle SCM.

• Access Live SurveyMonkey Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live SurveyMonkey data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• How to use SQLAlchemy ORM to access Jira Assets in Python

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

• Use Biml to Build SSIS Tasks to Replicate Monday.com to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Monday.com to SQL Server.

• How to connect and process Microsoft OneNote from Azure Databricks

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

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

• Enable the SAP BusinessObjects BI JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with SAP BusinessObjects BI.

• Creating Workday-Connected Applications in Unqork

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

• Analyze Azure Synapse in Cognos Analytics

  Use CData Connect Cloud to connect to Azure Synapse from Cognos Analytics and analyze live Azure Synapse.

• Integrate Live Google Calendar into Custom Business Apps Built in Power Apps

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

• Using the CData Software ODBC Driver for Google Drive in PyCharm

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

• Connect to Sage Cloud Accounting from Excel & GoogleSheets!

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

• Create Amazon DynamoDB-Connected Business Apps in AppSheet

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

• Create Google Ads Reports on JasperReports Server

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

• Automated Continuous Parquet Replication to MongoDB

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

• How to import Office 365 into Apache Solr

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

• How to connect to Drift from Spring Boot

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

• Use the CData Software ODBC Driver for Pipedrive in MicroStrategy Web

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

• Load LDAP Objects to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load LDAP to a database.

• Connect to EnterpriseDB from PowerBuilder via JDBC

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

• Access Impala from MySQL in Amazon QuickSight

  Connect to Impala and build visualizations of Apache Impala using a MySQL Connection in Amazon QuickSight.

• Automated Continuous Oracle Replication to SingleStore

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

• How to use SQLAlchemy ORM to access Act CRM in Python

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

• How to Connect to Active Directory in Using Python: 6 Steps

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

• How to pipe ActiveCampaign to CSV in PowerShell

  Use standard PowerShell cmdlets to access ActiveCampaign tables.

• Connect to SAP ByDesign from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live SAP Business ByDesign from Filemaker Pro on Mac.

• Add Azure DevOps to Informatica Enterprise Data Catalog

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

• Create Dynamic Pipedrive Grids Using the Infragistics XamDataGrid

  Learn how you can connect Pipedrive to Infragistics XamDataGrid to build dynamic grids.

• Query CSV in DataGrip

  Create a Data Source for CSV in DataGrip and use SQL to query live CSV/TSV Files.

• How to update Jira Assets from Excel

  This article explains how to transfer data from Excel to Jira Assets using the Excel Add-In for Jira Assets.

• Access Power BI XMLA from MySQL in PHP

  Connect to Power BI XMLA through the standard MySQL libraries in PHP.

• Automated Continuous Phoenix Replication to Azure SQL Database

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

• Create Xero Reports on JasperReports Server

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

• Build MVC Applications with Connectivity to Amazon DynamoDB

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

• Integrate with Oracle in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Oracle Database in SnapLogic.

• Manage SAP Business One in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for SAP Business One.

• Create a Data Access Object for Box using JDBI

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

• How to import Outreach.io into Apache Solr

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

• Integrate Real-Time Access to SAP SuccessFactors in SAPUI5 MVC Apps

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

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

  Connect to Google AlloyDB from a connection pool in Tomcat.

• Manage Kintone in DBArtisan as a JDBC Source

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

• Replicate ClickUp to Multiple Databases

  Replicate ClickUp to disparate databases with a point-and-click configuration.

• Connect to Amazon S3 in NetBeans

  Connect to Amazon S3 in NetBeans with the data source configuration wizard.

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

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

• Replicate Multiple Hive Accounts

  Replicate multiple Hive accounts to one or many databases.

• Perform Batch Operations with Xero in Apache NiFi

  Connect to Xero Accounting and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Build Dashboards with FTP in DBxtra

  Create dynamic dashboards and perform analytics based on FTP Servers in DBxtra.

• Add Epicor Kinetic to Informatica Enterprise Data Catalog

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

• Natively Connect to Trello in PHP via ODBC (Linux)

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

• Query Bullhorn CRM in ColdFusion

  Write standard ColdFusion data access code to connect to Bullhorn CRM.

• Connect to Azure Table in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Use the CData Software JDBC Driver for SAS Data Sets in MicroStrategy Web

  Connect to SAS Data Sets in MicroStrategy Web using the CData Software JDBC Driver for SAS Data Sets.

• Connect to Microsoft Dataverse from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Microsoft Dataverse to connect to Microsoft Dataverse (CDS) from Web applications running on WebLogic.

• A PostgreSQL Interface for BambooHR using the CData ODBC Driver

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

• Build Dashboards with Gmail in DBxtra

  Create dynamic dashboards and perform analytics based on Gmail in DBxtra.

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

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

• Analyze Sage Cloud Accounting in Cognos Analytics

  Use CData Connect Cloud to connect to Sage Cloud Accounting from Cognos Analytics and analyze live Sage Business Cloud Accounting.

• Publish PostgreSQL-Connected Dashboards in Tableau Server via JDBC

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

• Easily Integrate HDFS in Lazarus Pascal IDE

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

• Use Dash to Build to Web Apps on Exact Online

  Create Python applications that use pandas and Dash to build Exact Online-connected web apps.

• How to Seamlessly Import Tally Data into IBM SPSS Modeler

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

• Excel Spreadsheet Automation on Slack with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Create Dashboards and Visualize Live Tableau CRM Analytics in Geckoboard

  Use CData Connect Cloud to connect to live Tableau CRM Analytics and create dashboards for real-time monitoring and visualization in Geckoboard.

• Integrate with live Azure Synapse in Jitterbit

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

• How to Connect DBeaver to Amazon Athena via a JDBC Driver

  Manage Amazon Athena with visual tools in DBeaver like the query browser.

• Object-Relational Mapping (ORM) with SAP Hybris C4C 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 SAP Hybris C4C into a Java-based ORM framework, Hibernate.

• Import HCL Domino into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access HCL Domino. In this article, you will use the OData format to import HCL Domino into Microsoft Power Query.

• «
• 560
• 561
• 562
• 563
• 564
• 565
• 566
• 567
• 568
• 569
• »