Database Reference
In-Depth Information
Figure 10-10.
Testing the SQL connection
■
In this example, I chose oLe DB to connect to sQL. You can also choose to use aDo .net or an oDBC
connection to do the same. also, a sQL database hiveDemo is pre-created using sQL server Management studio.
Note
Creating the Hive Source Component
Next, you need to configure a source component that will connect to Hive and fetch the data. After the connection is
successfully created, double-click to place an ADO NET source on the Data Flow canvas as shown in Figure
10-11
.