Skip to Content

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

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

select-source.png (59.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Feb 05, 2019 at 10:28 AM

    Do you see the same message in the search box if you don't select the grantor service? Because the virtual table is local to your project, you don't have to select that service. Also, please turn on the "developer tools" in chrome and check the console log for more specific messages.

    If you haven't done so yet, I would advise you to log an incident with SAP support.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 01, 2019 at 08:08 PM

    It seems that this has nothing to do with the virtual table or the flowgraph, but with the search box (which runs via DB explorer / hrtt) not being able to find your CF space. If in the Web IDE, you go to the DB explorer section, are you able to see or add your HDI container there?

    Are your NEO and CF subaccount running in the same global account?

    Add a comment
    10|10000 characters needed characters exceeded

    • Thanks for your reply, Stefan. The answers to your questions are mentioned below:

      If in the Web IDE, you go to the DB explorer section, are you able to see or add your HDI container there?

      Yes, I can add my HDI container here.

      Are your NEO and CF subaccount running in the same global account?

      Yes, they are under same global account.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.