Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

What About Data Access? [Video]

DZone's Guide to

What About Data Access? [Video]

Can KNIME connect to MySQL databases? What about Microsoft SQL Server? Oracle? Excel Files? MongoDB? So many questions - and so many answers!

· Big Data Zone ·
Free Resource

The open source HPCC Systems platform is a proven, easy to use solution for managing data at scale. Visit our Easy Guide to learn more about this completely free platform, test drive some code in the online Playground, and get started today.

Check out a little Q&A session about connecting KNIME with different data sources, followed by a video with more details!

Can KNIME connect to MySQL databases?

KNIME Analytics Platform has dedicated connectors for a number of databases and MySQL is one of them. We also have a generic connector for many other databases. Provided the JDBC driver file, KNIME can connect to most databases through this generic database connector node. 

What about Microsoft SQL Server?

KNIME Analytics Platform has dedicated connectors for a number of databases, including MS SQL Server. Also, provided the JDBC driver file, KNIME can connect to other databases through a generic database connector node. 

What about Oracle?

Provided the JDBC driver file, KNIME can connect to an Oracle database through the generic database connector node. 

What about MongoDB?

KNIME Analytics Platform has a dedicated connector for MongoDB. 

What about Google Geocoding REST service?

KNIME Analytics Platform has dedicated nodes to connect to REST services. 

What about YouTube REST service?

KNIME Analytics Platform has dedicated nodes to connect to REST services, YouTube API included. 

What about Google Translate REST service?

KNIME Analytics Platform has dedicated nodes to connect to REST services, Google Translate API included. 

And Excel files?

Yes, of course... But, how about just watching this video?

In this video, learn about using KNIME to access data in MySQL Database, Microsoft SQL Server, Oracle, MongoDB, Google Geocoding REST services, YouTube REST services, Google Translate REST services, Microsoft Excel files, and more!

Managing data at scale doesn’t have to be hard. Find out how the completely free, open source HPCC Systems platform makes it easier to update, easier to program, easier to integrate data, and easier to manage clusters. Download and get started today.

Topics:
big data ,data access ,sql ,knime

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}