CData Software - Knowledge Base

Recent Articles

• «
• 344
• 345
• 346
• 347
• 348
• 349
• 350
• 351
• 352
• 353
• »

• Create a Data Access Object for Tableau CRM Analytics using JDBI

  A brief overview of creating a SQL Object API for Tableau CRM Analytics in JDBI.

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

  Use LlamaIndex to query live Highrise CRM data in natural language using Python.

• Visualize Salesloft in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Salesloft in CData Software Connect (or Connect Server) and build visualizations from live Salesloft in Tableau Desktop.

• Edit and Search External PayPal Objects in Salesforce Connect

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

• Use the CData Software ODBC Driver for Todoist in MicroStrategy

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

• Manage Phoenix in DBArtisan as a JDBC Source

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

• Access PayPal as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PayPal from your Oracle system.

• Build MVC Applications with Connectivity to Zendesk

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

• Automated Continuous Azure Data Catalog Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Azure SQL.

• Access Live Microsoft Planner in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Microsoft Planner into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Planner in the Graph Builder and Query Builder.

• Integrate Quickbase in Pentaho Data Integration

  Build ETL pipelines based on Quickbase in the Pentaho Data Integration tool.

• Connect to Redshift in JRuby

  Create a simple JRuby app with access to live Amazon Redshift.

• Process & Analyze Parquet in Databricks (AWS)

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

• Connect to Salesloft from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Salesloft to connect to Salesloft from Web applications running on WebLogic.

• Create a Data Access Object for Dynamics CRM using JDBI

  A brief overview of creating a SQL Object API for Microsoft Dynamics CRM in JDBI.

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

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

• Bridge Act CRM Connectivity with Apache NiFi

  Access and process Act CRM in Apache NiFi using the CData JDBC Driver.

• How to Connect DBeaver to Spark via a JDBC Driver

  Manage Apache Spark SQL with visual tools in DBeaver like the query browser.

• Connect to BigQuery from PowerBuilder via JDBC

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

• Work with Epicor Kinetic in FoxPro

  Load Epicor Kinetic into a FoxPro database. This article includes full code and a walk-through of the process.

• Create Apps from IBM Informix in Qlik Sense Cloud

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

• How to import FHIR into Apache Solr

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

• How to use SQLAlchemy ORM to access eBay Analytics in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of eBay Analytics.

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

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

• Automated Continuous Sugar CRM Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Sugar CRM replication to Azure SQL.

• Easily Integrate Teradata in Lazarus Pascal IDE

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

• Access Greenhouse from MySQL in HeidiSQL

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

• How to connect to Act CRM from IntelliJ

  Integrate connectivity to Act CRM with wizards in IntelliJ.

• Connect to Cassandra from a Connection Pool in Jetty

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

• How to connect to eBay Analytics from IntelliJ

  Integrate connectivity to eBay Analytics with wizards in IntelliJ.

• Automated Continuous Databricks Replication to Oracle

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

• Connect to Zoho Inventory from PowerBuilder via ADO.NET

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

• Analyze Active Directory in Looker

  Use CData Connect Cloud to connect to Active Directory from Looker and build custom apps using live Active Directory.

• Query Printify in DataGrip

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

• Query OneNote in MySQL Workbench

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

• Connect to Avalara AvaTax in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Avalara AvaTax in Google Apps Script.

• Connect to Azure Active Directory as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Azure Active Directory.

• Use CData Connect Cloud to Access SAP BusinessObjects BI in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live SAP BusinessObjects BI in the Power Pivot business intelligence tool.

• Import Real-Time Bing Search Results via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Bing Search in ColdFusion.

• Build Elasticsearch-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Elasticsearch.

• Explore Geographical Relationships in Zoom with Power Map

  Create data visualizations with Zoom in Power Map.

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

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

• Access Live Sage 50 UK in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Sage 50 UK into the statistical analysis tools available in SAS JMP. This article shows how to use Sage 50 UK in the Graph Builder and Query Builder.

• Access CSV from MySQL in Amazon QuickSight

  Connect to CSV and build visualizations of CSV/TSV Files using a MySQL Connection in Amazon QuickSight.

• Connect to BigQuery from a Connection Pool in JBoss

  Integrate Google BigQuery into Java servlets: Use the Management Console in JBoss to install the BigQuery JDBC Driver.

• Analyze Excel in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of Microsoft Excel and visualize Microsoft Excel in SAP Analytics Cloud.

• Automate Marketo Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Marketo from PowerShell? This article demonstrates how to utilize the Marketo Cmdlets for tasks like connecting to Marketo, automating operations, downloading data, and more.

• How to Create Power BI Visual Reports with Real-Time Microsoft Planner

  Use CData Power BI Connectors to visualize Microsoft Planner in Power BI.

• Query Phoenix as a SQL Server in Node.js

  Execute SQL Server queries against Apache Phoenix from Node.js.

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

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

• Connect to Jira Assets in CloverDX (formerly CloverETL)

  Transfer Jira Assets using the visual workflow in the CloverDX data integration tool.

• Connect to Shopify in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Shopify and connect to Shopify in Akorbi Digital RunMyProcess.

• How to connect and process Cloudant from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Cloudant

• Connect to eBay from PowerBuilder via ADO.NET

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

• How to connect to Parquet from IntelliJ

  Integrate connectivity to Apache Parquet with wizards in IntelliJ.

• How to pipe Authorize.Net to CSV in PowerShell

  Use standard PowerShell cmdlets to access Authorize.Net tables.

• Stream IBM Cloud Object Storage into Apache Kafka Topics

  Access and stream IBM Cloud Object Storage in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Build Visualizations of HubDB in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of HubDB in Birst.

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

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

• Seamlessly Bring Xero into Retool Using CData Connect Cloud

  Integrate Xero data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• How to create an RPA flow for Sage Intacct in UiPath Studio

  Use the Sage Intacct ODBC Driver to create workflows that access real-time Sage Intacct without any coding.

• Analyze Procore in R via JDBC

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

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

  Connect to Apache Spark SQL in MicroStrategy Web using the CData Software ODBC Driver for Spark.

• Publish Reports with Microsoft Dataverse in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft Dataverse (CDS).

• Integrate SAP Ariba Source in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Ariba Source from Informatica Cloud.

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

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

• Query Amazon DynamoDB through ODBC in Node.js

  Use node-odbc to execute SQL queries against Amazon DynamoDB from Node.js.

• Connect to OData Services as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live OData.

• Build an OLAP Cube in SSAS from ServiceNow

  Establish a connection to ServiceNow data from SQL Server Analysis Services, and use the ServiceNow Data Provider to build OLAP cubes for use in analytics and reporting.

• Analyze Oracle Service Cloud in R via JDBC

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

• Stream Cassandra into Apache Kafka Topics

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

• Connect to Azure Active Directory in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Azure Active Directory and connect to Azure Active Directory in Akorbi Digital RunMyProcess.

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

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

• Connect to Facebook Ads from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Facebook Ads from Crystal Reports.

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

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

• Access Live SAP HANA in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live SAP HANA from your Google Sheets.

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

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

• Build Oracle Financials Cloud-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Oracle Financials Cloud from Zoho Analytics and import live Oracle Financials Cloud.

• Create Datasets from Teradata in Domo Workbench and Build Visualizations of Teradata in Domo

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

• How to connect to Jira in DBVisualizer

  Integrate Atlassian Jira with visual data analysis tools and data connection wizards in DBVisualizer

• Automated Continuous OneNote Replication to Apache Cassandra

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

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

  Provide connectivity to SAP ERP/NetWeaver through an SAP BusinessObjects universe.

• Analyze Monday.com in Looker

  Use CData Connect Cloud to connect to Monday.com from Looker and build custom apps using live Monday.com.

• Publish Stripe-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Stripe.

• Using AngularJS to Build Dynamic Web Pages with NetSuite

  Use the CData Connect Server to create NetSuite OData feeds and build single-page applications with live NetSuite CRM & ERP.

• Add Greenplum to Informatica Enterprise Data Catalog

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

• Replicate Multiple Cassandra Accounts

  Replicate multiple Cassandra accounts to one or many databases.

• Integrate MariaDB in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MariaDB from Informatica Cloud.

• Explore Geographical Relationships in SFTP with Power Map

  Create data visualizations with SFTP in Power Map.

• Automated Continuous SendGrid Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable SendGrid replication to Microsoft Access.

• Use JayDeBeApi to access Blackbaud FE NXT in Python

  Use standard Python scripting and the development environment of your choice to access live Blackbaud FE NXT.

• Build Excel Online-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Microsoft Excel Online and build Excel Online-connected web apps with Axios.

• Working with SAP Ariba Procurement in LINQPad

  Execute LINQ queries to SAP Ariba Procurement in LINQPad.

• Integrate Live SAS xpt into Blue Prism for Intelligent Robotic Process Automation (RPA)

• «
• 344
• 345
• 346
• 347
• 348
• 349
• 350
• 351
• 352
• 353
• »