1. 登陆进入SAP Business Objects Data Services Designer中
2. 创建Data store SAP HANA（SAP HANA的连接)
SAP HANA http://www.cnblogs.com/omygod/archive/2013/05/23/3094306.html
3. 源数据准备
无需准备数据
4. 新建project， batch job及data flow
![[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9pbWdzLzEvNy8yLzcvNDQvNmRiNzFjY2I2YTM4NjM5NzQyZjIzZTcyMWQxNjAyMjEuanBl.jpe?w=700 "[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）")
5. 在左下角选择Row Generation，并拖动到data flow中
![[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9pbWdzLzIvOC81LzcvNDQvNDk1Njk5MzNiYmM4NWQ1N2ExMDUxNmFjM2MxNzgxNzIuanBl.jpe?w=700 "[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）")
双击
![[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9pbWdzLzcvNi85LzkvNTgvMWExOTgwYjk3ODdjYzg2ZTM4MTE2NjFiM2VhZWMzMDQuanBl.jpe?w=700 "[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）")
6 创建query，并连接
![[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9pbWdzLzMvNC8yLzAvOTMvMzQ0ZGE0ZmY0YmI2NjMxNTM5NDU0YTllNDE4MmQzYzUuanBl.jpe?w=700 "[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）")
双击query
![[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9pbWdzLzAvNS8wLzcvMTkvNjFmOWU4NTQ4YWMxNWU3YjdiMGMyYTY4NDI0OWQyMjMuanBl.jpe?w=700 "[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）")
设置主键信息
7 创建template table，并连接
![[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9pbWdzLzkvNy8zLzUvMzUvZTI0MThlMTliNmMzZDhhYTczYTg1Y2Y3ZmRhYTZlYzYuanBl.jpe?w=700 "[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）")
8 运行job
![[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9pbWdzLzgvOC8yLzQvMS9kZTZkYjQ0NjYxYzg2YTc2MDYzNDMyY2VhZmQyMmI0NS5qcGU%3D.jpe?w=700 "[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）")
![[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9pbWdzLzkvNC84LzYvMTgvODIyZjAzNmFjNDE1YjY3YjJjMjk1YWY5MmU1NDUyMDMuanBl.jpe?w=700 "[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）")
9 在data flow中查看数据
![[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）](https://image.shishitao.com:8440/aHR0cHM6Ly93d3cuaXRkYWFuLmNvbS9pbWdzLzUvMi81LzIvOTgvOWNlYTNmNWYxMTVlNzhlOGMxYjg0NjQ0YzQ5YTgwYWYuanBl.jpe?w=700 "[Step By Step]在SAP Business Objects Data Services中使用Row Generation Transform数据生成并导入到SAP HANA中（Row Generation Transform）")