It is sometime useful to be able to create a data connector or other Nathean Schedule Service object directly in the database. This is normally useful from other systems which need to create various data connector.

The following SQL can be used to create, first the data connector, and secondly the permission to this for the publisher user. Remember to replace the SYSTEM_CODE with your system code.

INSERT INTO TBL_DB_CONNECTION
           (SYSTEM_CODE
           ,CONNECTION_ID
           ,ALIAS_NAME
           ,DRIVER_NAME
           ,SERVER_NAME
           ,INSTANCE_NAME
           ,USER_NAME
           ,PASSWORD
           ,SERVER_IP
           ,PORT_NUMBER
           ,DATABASE_TYPE
           ,ISACTIVE
           ,CLIENT_ID
           ,CLIENT_SECRET
           ,IsDatamart
           ,NOTES
           ,ISREMOTESITE
           ,DATACONNECTOR_LIST
           ,SOURCE_CONNECTION_ID
           ,PUBLIC_DOMAIN_NAME
           ,PUBLIC_IP_ADDRESS)
     VALUES
           ('*SYSTEM_CODE*'
           ,1
           ,'Dummy Alias'
           ,null
           ,''
           ,''
           ,''
           ,''
           ,''
           ,''
           ,'SQLSERVER'
           ,1
           ,null
           ,null
           ,0
           ,null
           ,0
           ,null
           ,null
           ,null
           ,null)
GO
INSERT INTO TBL_DATA_CONNECTOR_USER_PERMISSIONS
           (SYSTEM_CODE
           ,CONNECTION_ID
           ,LOGIN_NAME
           ,PERMISSION_GROUP_ID
           ,READ_FLAG
           ,WRITE_FLAG
           ,DELETE_FLAG)
     VALUES
           ('*SYSTEM_CODE*'
           ,1
           ,'PUBLISHER'
           ,1
           ,1
           ,1
           ,1)
GO
Revision: 3
Last modified: Jun 22, 2020

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment