数据库类型分类划分20220804

发布

数据库：DB2、DAMENG、MONGODB、MYSQL、ORACLE、POSTGRESQL、SQLSERVER、SYBASE、UDAL、OCEANBASE-MYSQL
ZCBUS：ZCBUS、SERVER、
API：FILE、API_KAFKA、KAFKA、FILE_BATCH
其他：NETGATE、EXP_SERVICE、GoldenGate

select id,moduletype,pngpath,valid,ifdistributed from bus_parameter_module_image where moduletype in (select moduletype from bus_parameter_module where module = 'bus_push_db_parameter' and role = 0 group by moduletype)

订阅

数据库：DB2、DAMENG、MONGODB、MYSQL、ORACLE、POSTGRESQL、REDIS、SQLSERVER、SYBASE、TIDB、SYBASEIQ、OCEANBASE-MYSQL、UDAL、HANA、YASHANDB、GBASE、GREENPLUM
大数据：HIVE、HBASE、ROCKETMQ、RABBITMQ
ZCBUS：ZCBUS_KFSYNC
API：RESTAPI_KAFKA、RESTAPI_FILE、KAFKA_JSON、client-service
其他：NETGATE
KAFKA_CONSUMER_ETL忽略，可能用不到了

select id,moduletype,pngpath from bus_parameter_module_image where moduletype in (select moduletype from bus_parameter_module where module like 'bus_client_db_parameter' and role=1 group by moduletype)