Database Reference
In-Depth Information
Figure 10-8.
Test the connection to Hive
Creating the Destination SQL Connection
You need to configure a connection to point to the SQL Server instance and the database table where you will import
data from Hive. For this, you need to create a connection manager to the destination SQL as you did for the source
Hive. Right-click in the Connection Managers section of the project again, and this time, choose New OLE DB
Connection as shown in Figure
10-9
.
