CData Software - Knowledge Base
Recent Articles
-
Build Data Flows from Sugar CRM to SQL Server using SSIS
Easily back up Sugar CRM to SQL Server using the SSIS components for Sugar CRM.
-
Analyze SQL Analysis Services in R via JDBC
Use standard R functions and the development environment of your choice to analyze SQL Analysis Services with the CData JDBC Driver for SQL Analysis Services.
-
Build Semantic Layer Views for Aha! in APOS Live Data Gateway
Use the CData Connector for Aha! in APOS Live Data Gateway to build Semantic Layer Views for Aha!.
-
How to Query Live Dynamics CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Dynamics CRM data in natural language using Python.
-
Query Parquet using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Parquet entities in PHP by modeling them as objects.
-
Integrate GraphQL in Pentaho Data Integration
Build ETL pipelines based on GraphQL in the Pentaho Data Integration tool.
-
Add WooCommerce to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for WooCommerce with the Informatica Enterprise Data Catalog to classify and organize data.
-
Import Splunk into the Power BI Service for Visualizations
Use CData Connect AI to connect to Splunk and provide access to live Splunk for custom reports in the Power BI Service.
-
How to Work with Access in AWS Glue Jobs Using JDBC
Connect to Access from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
PowerShell Scripting to Replicate Google Spanner to MySQL
Write a simple PowerShell script to replicate Google Spanner to a MySQL database.
-
Connect to Lakebase from PowerBuilder via ADO.NET
This article demonstrates how to access Lakebase from Appeon PowerBuilder using the CData ADO.NET Provider for Lakebase.
-
Access Microsoft Exchange from MySQL in Amazon QuickSight
Connect to Microsoft Exchange and build visualizations of Microsoft Exchange using a MySQL Connection in Amazon QuickSight.
-
Connect to Zoom as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoom.
-
How to connect to Zoho Projects in DBVisualizer
Integrate Zoho Projects with visual data analysis tools and data connection wizards in DBVisualizer
-
Azure Table Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure Table facts in real time.
-
Build HubSpot-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for HubSpot and create custom apps in Mendix.
-
Visualize ShipStation in Sisense
Create an ElastiCube in Sisense app with access to ShipStation.
-
Integrate ActiveCampaign with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ActiveCampaign with External Services.
-
Automated Continuous HCL Domino Replication to Databricks
Use CData Sync for automated, continuous, customizable HCL Domino replication to Databricks.
-
Create Informatica Mappings From/To a JDBC Data Source for ClickUp
Create ClickUp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Create Power BI Visual Reports with Real-Time Drip
Use CData Power BI Connectors to visualize Drip in Power BI.
-
Query Redshift from Node.js
Use the OData endpoint of the CData API Server to connect to your Amazon Redshift and perform CRUD operations on Redshift from Node.js.
-
Access Live Acumatica in TIBCO Data Virtualization
-