I am running a single node cluster called "maprdemo", which i have downloaded from mapr wesbiste.
Question: - Is there a way i can set up a ETL job using sql server integration services (SSIS) to be able to transfer SQL Server Tables to Mapr-fs.?
I am well aware that sqoop can assist me in importing data from any relational database to Mapr-fs. but i would like to setup a ETL job using SSIS.
SSIS (2014) or above has native hadoop connection manager which takes in
- WebHDFS connection with default port : 50070
- WebHCat connection with default port : 50111
Is there a way i can use any of the above connections to transfer data from SQL to Mapr-fs.
Link to the Hadoop connection manager is as follow.
The following video contains a reference to what i would like to achieve.
Any suggestions will be appreciated.....
Thanks in advance....