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

Hortonworks Sandbox for HDP and HDF is your chance to get started on learning, developing, testing and trying out new features. Each download comes preconfigured with interactive tutorials, sample data and developments from the Apache community.

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!

Hortonworks Community Connection (HCC) is an online collaboration destination for developers, DevOps, customers and partners to get answers to questions, collaborate on technical articles and share code examples from GitHub.  Join the discussion.

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 }}