Hi team,
Currently I have set up Atlas 2.6.0 and webapi 2.6.0 with on a local computer and configured the source and source daimon tables as seen in localhost:8080/webapi/source/sources:
output from localhost:8080/webapi/source/sources:
[{"sourceId":1,"sourceName":"My Cdm","sourceDialect":"sql server","sourceKey":"MY_CDM","daimons":[{"sourceDaimonId":1,"daimonType":"CDM","tableQualifier":"dbo","priority":0},{"sourceDaimonId":2,"daimonType":"Vocabulary","tableQualifier":"dbo","priority":0},{"sourceDaimonId":3,"daimonType":"Results","tableQualifier":"results","priority":0}]},{"sourceId":2,"sourceName":"Default vocabulary","sourceDialect":"sql server","sourceKey":"vocab","daimons":[{"sourceDaimonId":4,"daimonType":"Vocabulary","tableQualifier":"dbo","priority":1}]}]
SQL insert statements for source and source_daimon tables:
SET IDENTITY_INSERT ohdsi.dbo.source ON
INSERT INTO ohdsi.dbo.source( source_id, source_name, source_key, source_connection, source_dialect)
VALUES (1, 'My Cdm', 'MY_CDM','jdbc:sqlserver://localhost:1434;databaseName=CDM;user=****;password=****', 'sql server');
INSERT INTO ohdsi.dbo.source( source_id, source_name, source_key, source_connection, source_dialect)
VALUES (2, 'Default vocabulary', 'vocab', 'jdbc:sqlserver://localhost:1434;databaseName=CDM;user=****;password=****', 'sql server');
SET IDENTITY_INSERT ohdsi.dbo.source OFF
SET IDENTITY_INSERT ohdsi.dbo.source_daimon ON
-- CDM daimon
INSERT INTO ohdsi.dbo.source_daimon( source_daimon_id, source_id, daimon_type, table_qualifier, priority) VALUES (1,1,0,'dbo',0);
-- VOCABULARY daimon
INSERT INTO ohdsi.dbo.source_daimon( source_daimon_id, source_id, daimon_type, table_qualifier, priority) VALUES (2,1,1,'dbo',0);
-- RESULTS daimon
INSERT INTO ohdsi.dbo.source_daimon( source_daimon_id, source_id, daimon_type, table_qualifier, priority) VALUES (3,1,2,'results',0);
-- DEFAULT VOCABULARY daimon
INSERT INTO ohdsi.dbo.source_daimon( source_daimon_id, source_id, daimon_type, table_qualifier, priority) VALUES (4,2,1,'dbo',1);
SET IDENTITY_INSERT ohdsi.dbo.source_daimon OFF
However there is some issue with configuration on localhost:8080/Atlas
Please advise and thank you.
