I try to connect mapr hadoop hdfs from SSIS 2016. Please show me how. Thanks.
*SSIS=SQL Server Integration Services
Hi there, can you please share your system's specifications and what's your use case? Please check this document s a reference on what to include in your question: What Information Should be Shared in a Question in the Community
Also, Victor, suggest you to check out Mathieu's answer Migrate SQL tables to Mapr-fs using SSIS(SQL Server Integration Services).
Are you able to connect MapR Hadoop Hdfs from SSIS 2016? Was Mathieu's answer helpful. If you need further assistance, please provide more details on your system's specifications and use case.
Hi Mathieu Dumoulin,
Could you please show detail how to get File -> Mapr DB? Any screen shot showing step by step?
I have a hard time to set it up.
Are you trying to get data from SSIS and land to Hive tables on HDFS? If that is your plan, please read how to get data from Hive tables to MapR DB - Hive and MapR-DB Integration.
If you are trying to get data from SSIS to MapR-DB, then please follow Mathieu's suggestion and use the import tool ImportFiles: Loading Data into Binary Tables
Currently there isn't screen shot showing step by step how to load data into binary table, but if you encounter any issue, please post screenshots for us to further assist you.
Please keep us updated on your progress. Thank you.
I can also add using Streamsets data collector as a possibility. www.streamsets.com
Its a super nice GUI and supports your use case and many others in data flows based around Kafka/MapR Streams. It's a really nice tool and I recommend you try it!
Inviting Pat Patterson & Craig Warman in case they know an example in streamsets that can be useful
Retrieving data ...