type: com.sap.xs.hdi-container
type: org.cloudfoundry.existing-service
-------------------------Syntax Difference in MTA --------------------------------------------------------
parameters:
service-name: pp.purmdb-container --- container name
properties:
cross-service-service: '${service-name}'
type: org.cloudfoundry.existing-service --- Type is different
Early case within HDI container -
properties:
user-container-name: '${service-name}'
type: com.sap.xs.hdi-container
----------------------------------------------------------------------------------------------------------
parameters:
service-name: plb_schema (Schema Name)
properties
cross-schema-service: '${service-name}'
type: org.cloudfoundry.existing-service.
-------------------------------------------------------------------------------------------------------
role1#.hdbrole
-------------------------------------------------------------------------------------------------------
{
"role":
{
"name": "role1#",
"object_privileges": [
{
"name": "TRGT_DB",
"type":"TABLE",
"privileges_with_grant_option": ["SELECT"]
}
]
}
}
-------------------------------------------------------------------------------------------------------
role.hdbrole
-------------------------------------------------------------------------------------------------------
{
"role":
{
"name": "role",
"schema_privileges": [
{
"privileges": ["SELECT METADATA"]
}
]
}
}
-------------------------------------------------------------------------------------------------------
CDS Artifacts
-------------------------------------------------------------------------------------------------------
** Below CDS Artifacts will create following database table ****************************
namespace data.model;
context TireShop {
entity Tire{
key id : Integer;
Name : String(100);
Stock : Integer;
DealerID : Integer;
Tire : Association to one TireDealer;
}
entity TireDealer {
key DealerID : Integer;
DealerName : String(111);
}
}
** Below CDS Artifacts will create following database table *******************************************
** Similar to the DDL of Create two column Table*******************************************************
COLUMN TABLE "data.model::TireShop.Tire" (
ID integer,
NAME nvarchar(100),
Stock integer,
DealerID integer,
primary key ( ID )
)
COLUMN TABLE "data.model::TireShop.TireDealer" (
DealerID integer,
DealerName nvarchar(111),
primary key ( DealerID)
)
-------------------------------------------------------------------------------------------------------
HDB Table
.hdbtabledata file
-------------------------------------------------------------------------------------------------------
{
"format_version": 1,
"imports": [{
"target_table" : "PLB_PPROJECT.DB_PLB::EMPLOYEE",
"source_data": {
"data_type" : "CSV",
"file_name" : ""PLB_PPROJECT.DB_PLB::EMPLOYEE.CSV",
"has_header" : true,
"no_data_import": false,
"delete_existing_foreign_data": false,
"dialect" : "HANA",
"type_config" : {
"delimiter" : ","
}
},
"import_settings" : {
"import_columns" : [
"EMP_ID",
"EMP_NAME",
"EMAIL_ID",
"ADDRESS",
],
"include_filter" : [ ]
} ,
"column_mappings" : {
"EMP_ID" : 1, "EMP_NAME" : 1, "EMAIL_ID" : 1, "ADDRESS" : 1
}
}]
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
8 | |
7 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 |