Java Runtime Engine (JRE) is required for PolyBase installations. SQL Server PolyBase is the technology that allows data integration from other sources other than SQL Server tables. PolyBase is used to access data stored in Hadoop File System (HFS) or Windows Azure Storage Blob (WASB).
As you will see later in this book, SSIS can now interact with these types of storage natively but having PolyBase handy can save us valuable time in our ETL.
For this recipe you will need to have access to the internet and have administrative rights on your PC to install JRE.
- To download JRE, follow this link: http://www.oracle.com/technetwork/java/javase/downloads/index.html . You will see the screen shown in the following screenshot:
This directs you to the Java SE Download
at Oracle.
- Click the download link in the JRE section as shown in the following screenshot:
- You must accept the license agreement to be able to select a file to download. Select
Accept License Agreement
as indicated in the following screenshot:
- Since SQL Server 2016 only exists in a 64-bit version, download the 64-bit JRE. The version of Java SE runtime environment might be different from the one show in the screenshot, which is the one available at the time this book was written:.
- Once downloaded, launch the installer. Click on
Run
as shown in Edge browser. Otherwise, go to yourDownloads
folder and double-click on the file you just downloaded (jre-8U102-windows-x64.exe
in our case); you will see the following window:
- The Oracle JRE installation starts. Click on
Install
. The following screen appears. It indicates the progress of the JRE installation.
- Once the installation is completed, click on
Close
to quit the installer:
You are now ready to proceed to install SQL Server 2016. We'll do that in the next section.
Microsoft integrated PolyBase in SQL Server 2016 to connect almost natively to the Hadoop and NoSQL platforms. Here are the technologies it allows us to connect to:
- HDFS (Hortonworks and Cloudera)
- Azure Blob Storage
Since Hadoop is using Java technology, JRE is used to interact with its functionalities.