Database Reference
In-Depth Information
WARNING
If you attempt to save a File DSN that does not test successfully, you
will get a warning message. You can choose to save anyway, but the
resulting File DSN will be missing most of the parameters, so it is wise
to make sure that your File DSN can be validated while still in the
ODBC Administrator interface.
This is the connection string that will be used in the SSIS packages. The
next section covers how to set up the package and use this connection string
inside it.
Configuring Your Packages
This section assumes that you have some familiarity with SSIS. If you are
new to SSIS, you may find the topic
Professional Microsoft SQL Server
2012 Integration Services
(Wrox 2012 byBrian Knight and others) ahelpful
reference. For the most part, working with Hive through ODBC drivers
makes it much like working with any other data source in SSIS.
The exception to this, as noted already, is writing data to Hive. Because the
ODBC driver doesn't support writing to the Hive database, you must insert
dataintoHivebyaccessingtheHadoopDistributedFileSystem(HDFS)and
moving files in the appropriate format to the appropriate directory.
