Packt+ | Advance your knowledge in tech

You're reading from SQL Server 2017 Integration Services Cookbook

Product type Book

Published in Jun 2017

Publisher Packt

ISBN-13 9781786461827

Pages 558 pages

Edition 1st Edition

Languages

SQL

Concepts

Database Administration

Authors (6):

Christian Cote

Dejan Sarka

David Peter Hansen

Matija Lah

Samuel Lester

Christo Olivier

View More author details

Table of Contents (18) Chapters

Title Page

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Customer Feedback

Preface

1. SSIS Setup

2. What Is New in SSIS 2016

3. Key Components of a Modern ETL Solution

4. Data Warehouse Loading Techniques

5. Dealing with Data Quality

6. SSIS Performance and Scalability

7. Unleash the Power of SSIS Script Task and Component

8. SSIS and Advanced Analytics

9. On-Premises and Azure Big Data Integration

10. Extending SSIS Custom Tasks and Transformations

11. Scale Out with SSIS 2017

Installing JRE for PolyBase

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.

Getting ready

For this recipe you will need to have access to the internet and have administrative rights on your PC to install JRE.

How to do it...

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 your Downloads 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.

How it works...

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: