Connector Management
SYSADMIN.getSchemaTmpValue
This procedure gets stored data for the specified connector's schema.
SYSADMIN.getSchemaTmpValue(IN name string NOT NULL, OUT val string NOT NULL RESULT)
Example
CALL "SYSADMIN.setSchemaTmpValue"(
"name" => 'asdas',
"val" => CAST( {ts'1970-01-01 00:00:00.000'} AS timestamp )
);
SELECT * FROM ( CALL SYSADMIN.getSchemaTmpValue( 'asdas') )a ;
SYSADMIN.setSchemaTmpValue
This procedure sets stored data for the specified connector's schema.
SYSADMIN.setSchemaTmpValue(IN name string NOT NULL, IN val string NOT NULL)
Example
CALL "SYSADMIN.setSchemaTmpValue"(
"name" => 'asdas',
"val" => CAST ( {ts'1970-01-01 00:00:00.000'} AS timestamp )
);
SELECT * FROM ( CALL SYSADMIN.getSchemaTmpValue( 'asdas') )a ;
SYSADMIN.getClientSecret
This procedure gets the client secret and decrypts it if the value is encrypted. May be used only in modular connector code.
SYSADMIN.getClientSecret(IN suffix string, OUT val string RESULT)
Decryption of values using SYSADMIN.getClientSecret is available since v4.2
SYSADMIN.getConnProp
This procedure gets a connector's property and may be used only in modular connector code, within or outside initializeMetadata()
.
SYSADMIN.getConnProp(IN pkey string NOT NULL, OUT val string RESULT)
SYSADMIN.writeConnProp
This procedure writes a connector property and may be used within initializeMetadata()
procedure or outside of it in modular connector code. Using procedure outside initializeMetadata() is
applicable for running connectors and stores property only in the configuration database.
SYSADMIN.writeConnProp(IN pkey string NOT NULL, IN val string NOT NULL)