.hdbcds without namespace

[former_member429355]

Hi!

In our project we

• store data in hana
• create services from node (XSA)
• analyze, print and display data with ArcGis

One of our problem is that we would like to use design time artifacts but tables with namespace are not coming up in the ArcGis desktop. I saw that in XSA .hdbcds it is only optional to use the namespaces but I get an error if I try to build the table without it.

To be more straightforward, I would like to create the following:

• schema name: "MY_SCHEMA"
• table name: "MY_TABLE"
• resulting table name "MY_SCHEMA"."MY_TABLE"

If I make the following .hdbcds file:

context test {
@Schema: 'MY_SCHEMA'
entity MY_TABLE {
key id : Integer;
field1 : Integer not null;
};
};

...I get the following error: HDI1310031 Namespace "PackageName.db.data" must be specified for root artifact or via namespace declaration. Please advise!

Thanks in advance,
David Szatmari

Hana version: 2.00.020.00.1500920972
WebIDE version: SP02 patch 3 (Build 4.2.20)

[lsubatin · Accepted solution]

Hi,

If you enable seeing hidden files on Web IDE (View-> Show hidden files), you should see a file called ".hdinamespace", you can try deleting it and deleting namespace declarations everywhere else.

Cheers,

Lucia.

[former_member429355 · Accepted solution]

Hi.

Thanks for the answer!

It works, but it led to another problem:
We are not able to create tables (from the design time object) in a schema that was previously made in SAP Hana.
Even if we set the schema name in the HDI container, it only uses it as a prefix (like MY_SCHEMA_1).

(Basically we would like to use .hdbcds the same way as XS Classic .hdbdd. - just without namespaces...)

Thanks, and best regards,

David.

[former_member429355 · Accepted solution]

Hi Lucia!

Thanks for the answer! We tried your solution but it led to another problem...

We cannot create run time objects in the previously created (in SAP Hana Studio) schema. Even if I use in the HDI "MY_SCHEMA", a new schema MY_SCHEMA_1 will be created. To be absolutely straightforward: Is there anyway that we could use .hdbcds as hdbdd?

Our requirement would be:

• creation and modification of design-time object would be available to all developers
• run time object would be created in the same given schema
• run time objects would be without name space
• design time objects could be transportable

Really appreciate any thoughts!

Best regards,
David.

[lsubatin · Accepted solution]

Hi, David,

If I'm getting your comments right, you want to access a plain schema you created from HANA studio, for example. That will not just happen by naming the schema in your HDI container with the same name as your plain schema. The HDI container is a new service that adds a level of abstraction to the database, including some technical users that will access the schema for you. It's not related to your existing schema in any way. You can use CDS there. These will be transported within an mtar file.I strongly suggest you review these concepts before moving on with development.

If you want to access the objects in a plain schema from your hdi container the steps are described in steps 3, 7 and 8 here: https://www.sap.com/developer/tutorials/xsa-create-user-provided-anonymous-service.html

Best,

Lucia.