Skip to Content
1
Jan 31, 2019 at 04:02 PM

How to create Flowgraph for Smart Data Integration for SAP HANA service on SCP Cloud Foundry?

555 Views Last edit Feb 01, 2019 at 07:20 AM 3 rev

We are trying to set up Smart Data Integration for the SAP HANA Service on SCP Cloud Foundry by installing the Data Provisioning Agent on a Windows PC in order to register the FileAdapter to upload CSV files.

We followed steps as mentioned in this blog series to setup Virtual Table. Now, when we are trying to create the Flowgraph, the virtual table does not appear and an error is seen:

We followed the steps in the blog to successfully create the virtual table.

Created roles:

CREATE ROLE "SCHEMA_HDI_FIN_DB_1::virttable_access_g";
GRANT CREATE VIRTUAL TABLE ON REMOTE SOURCE "MyFileadapter" TO "SCHEMA_HDI_FIN_DB_1::virttable_access_g" WITH GRANT OPTION;
GRANT DROP ON REMOTE SOURCE "MyFileadapter" TO "SCHEMA_HDI_FIN_DB_1::virttable_access_g" WITH GRANT OPTION;

Created hdbgrant file:

{
	"grantor_service": {
		"object_owner": {
			"roles": [
				"SCHEMA_HDI_FIN_DB_1::virttable_access_g"
			]
		},
		"application_user": {
			"roles": [
				"SCHEMA_HDI_FIN_DB_1::virttable_access_g"
			]
		}
	}
}

Here, SCHEMA_HDI_FI_DB_1 is the schema of the HDI Container where the MTA is being built. Should it be something else? What does it actually represent?

The MTA does get built successfully. The Virtual Table is also seen under the HDI Container schema under Tables.

Thanks

Attachments

select-source.png (59.4 kB)