atlas rest api - 使用rdb类型创建实例

ye_chen_

于 2024-10-12 11:19:20 发布

阅读量680

点赞数 6

CC 4.0 BY-SA版权

分类专栏：大数据部署报错及解决文章标签：大数据

本文链接：https://blog.csdn.net/ye_chen_/article/details/142873388

大数据部署报错及解决专栏收录该内容

18 篇文章

订阅专栏

--1.创建数据源
{
"entity":{
"typeName":"rdbms_instance",
"attributes":{
"qualifiedName":"192.168.0.180@oracle",
"name":"192.168.0.180@oracle",
"rdbms_type":"ORACLE",
"platform":"Linux7.9",
"cloudOrOnPrem":"cloud",
"hostname":"192.168.0.180",
"port":"1521",
"protocol":"http",
"contact_info":"jdbc",
"comment":"oracle_db API insert test",
"description":"rdbms_instance test",
"owner":"system"
}
}
}
response：
{
"mutatedEntities": {
"CREATE": [
{
"typeName": "rdbms_instance",
"attributes": {
"qualifiedName": "192.168.0.180@oracle"
},
"guid": "8b4770ab-23ff-4536-bcb8-f590896cb5d5"
}
]
},
"guidAssignments": {
"-2026122077097162": "8b4770ab-23ff-4536-bcb8-f590896cb5d5"
}
}
--2.创建数据库
{
"entity":{
"typeName":"rdbms_db",
"attributes":{
"qualifiedName":"system@192.168.0.180@oracle",
"owner":"system",
"ownerType":"DBA",
"name":"oracle_cscm",
"emailAddress":"system",
"createdBy":"system",
"createTime":"2024-06-12 10:18:46.555Z",
"updatedBy":"root",
"updateTime":"2024-06-12 10:18:46.666Z",
"description":"oracle_db fyb API input",
"prodOrOther":"asd",
"version":0,
"contact_info":"qwe",
"instance":{
"guid":"acefd669-6178-423d-a2e3-4b371151bf26",
"typeName":"rdbms_instance"
}
}
}
}
response：
{
"mutatedEntities": {
"CREATE": [
{
"typeName": "rdbms_db",
"attributes": {
"qualifiedName": "system@192.168.0.180@oracle"
},
"guid": "69f9b620-78bb-42da-9e66-6ff9d965041e"
}
],
"UPDATE": [
{
"typeName": "rdbms_instance",
"attributes": {
"owner": "system",
"qualifiedName": "192.168.0.180@oracle",
"name": "192.168.0.180@oracle",
"description": "rdbms_instance test"
},
"guid": "8b4770ab-23ff-4536-bcb8-f590896cb5d5",
"status": "ACTIVE",
"displayText": "192.168.0.180@oracle",
"classificationNames": [],
"meaningNames": [],
"meanings": []
}
]
},
"guidAssignments": {
"-2026122077097169": "69f9b620-78bb-42da-9e66-6ff9d965041e"
}
}
--3.创建表
{
"entity":{
"typeName":"rdbms_table",
"attributes":{
"qualifiedName":"system.oracle_cscm@192.168.0.180@oracle",
"createdBy":"system",
"name":"ods_t_sys_org",
"comment":"ods_t_sys_org API insert test",
"description":"ods_t_sys_org",
"owner":"system",
"type":"rdbms_table",
"contact_info":"org",
"db":{
"guid":"69f9b620-78bb-42da-9e66-6ff9d965041e",
"typeName":"rdbms_db"
}
}
}
}
response：
{
"mutatedEntities": {
"CREATE": [
{
"typeName": "rdbms_table",
"attributes": {
"qualifiedName": "system.oracle_cscm@192.168.0.180@oracle"
},
"guid": "035293b3-48da-4c2c-b0e8-bbc267fe1977"
}
],
"UPDATE": [
{
"typeName": "rdbms_db",
"attributes": {
"owner": "system",
"qualifiedName": "system@192.168.0.180@oracle",
"name": "oracle_cscm",
"description": "oracle_db fyb API input"
},
"guid": "63ede120-0f86-49eb-9c8e-59c55852b979",
"status": "ACTIVE",
"displayText": "oracle_cscm",
"classificationNames": [],
"meaningNames": [],
"meanings": []
}
]
},
"guidAssignments": {
"-1988551048214900": "035293b3-48da-4c2c-b0e8-bbc267fe1977"
}
}
--4.创建字段
{
"entity":{
"typeName":"rdbms_column",
"attributes":{
"qualifiedName":"oracle_cscm.ods_t_sys_org@192.168.0.180@oracle",
"createdBy":"system",
"name":"id",
"comment":"主键id",
"description":"ods_t_sys_org API insert test",
"owner":"system",
"data_type":"string",
"length":64,
"default_value":0,
"isNullable":false,
"isPrimaryKey":true,
"contact_info":"id_info",
           "table":{
               "guid":"035293b3-48da-4c2c-b0e8-bbc267fe1977",
               "typeName":"rdbms_table"
           }
}
}
}
--创建血缘关系
{
   "entity":{
       "typeName": "Process",
       "attributes": {
           "name": "rdbms_process_sale",
           "qualifiedName": "rdbms_process_sale",
           "description": "ods_sga_saleorder 的数据来自 oracle_cscm",
           "inputs": [{
               "typeName": "rdbms_instance",
               //rdbms_db的guid，创建实体从返回的信息中获取
               "guid": "69f9b620-78bb-42da-9e66-6ff9d965041e"
           }],
           "outputs": [{
               "typeName": "rdbms_table",
               //rdbms_instance的guid，创建实体从返回的信息中获取
               "guid": "268523ad-8b90-40dd-b42a-96afef27a937"
           },{
               "typeName": "rdbms_table",
               //rdbms_instance的guid，创建实体从返回的信息中获取
               "guid": "313fde7f-f4b7-4a1b-823f-2124c79dc916"
           },{
               "typeName": "rdbms_table",
               //rdbms_instance的guid，创建实体从返回的信息中获取
               "guid": "c54c5d27-1e14-48d9-ae6d-c171a7b71183"
           },{
               "typeName": "rdbms_table",
               //rdbms_instance的guid，创建实体从返回的信息中获取
               "guid": "e412f21c-fed8-4c4a-8fdd-20d1dee86ff3"
           }]
       }
   }
}

{
   "entity":{
       "typeName": "Process",
       "attributes": {
           "name": "rdbms_process_d1",
           "qualifiedName": "rdbms_dwd_process",
           "description": "dwd_sale_saleorderd_i的数据来自ods_sga_saleorderdtl,ods_sga_saleorder, ods_bd_customer,ods_t_sys_org",
           "inputs": [{
               "typeName": "rdbms_table",
               //rdbms_instance的guid，创建实体从返回的信息中获取
               "guid": "268523ad-8b90-40dd-b42a-96afef27a937"
           },{
               "typeName": "rdbms_table",
               //rdbms_instance的guid，创建实体从返回的信息中获取
               "guid": "313fde7f-f4b7-4a1b-823f-2124c79dc916"
           },{
               "typeName": "rdbms_table",
               //rdbms_instance的guid，创建实体从返回的信息中获取
               "guid": "c54c5d27-1e14-48d9-ae6d-c171a7b71183"
           },{
               "typeName": "rdbms_table",
               //rdbms_instance的guid，创建实体从返回的信息中获取
               "guid": "e412f21c-fed8-4c4a-8fdd-20d1dee86ff3"
           }],
           "outputs": [{
               "typeName": "rdbms_table",
               //dwd_sale_saleorderd_i的guid，创建实体从返回的信息中获取
               "guid": "ee867c74-7ae7-4726-a9bc-2bf4c0cf69b3"
           }]
       }
   }
}
response：
{
"mutatedEntities": {
"CREATE": [
{
"typeName": "Process",
"attributes": {
"qualifiedName": "rdbms_process"
},
"guid": "6bbbe3a4-f2be-489f-b84f-b49efaf25c6e"
}
],
"UPDATE": [
{
"typeName": "rdbms_instance",
"attributes": {
"owner": "system",
"qualifiedName": "192.168.0.180@oracle",
"name": "192.168.0.180@oracle",
"description": "rdbms_instance test"
},
"guid": "acefd669-6178-423d-a2e3-4b371151bf26",
"status": "ACTIVE",
"displayText": "192.168.0.180@oracle",
"classificationNames": [],
"meaningNames": [],
"meanings": []
},
{
"typeName": "rdbms_table",
"attributes": {
"owner": "system",
"createTime": 0,
"qualifiedName": "system.oracle_cscm@192.168.0.180@oracle",
"name": "ods_t_sys_org",
"description": "ods_t_sys_org"
},
"guid": "035293b3-48da-4c2c-b0e8-bbc267fe1977",
"status": "ACTIVE",
"displayText": "ods_t_sys_org",
"classificationNames": [],
"meaningNames": [],
"meanings": []
}
]
},
"guidAssignments": {
"-1988551048215094": "6bbbe3a4-f2be-489f-b84f-b49efaf25c6e"
}
}