Connector Management

You are looking at an older version of the documentation. The latest version is found here.

SYSADMIN.getSchemaTmpValue

This procedure gets stored data for the specified connector's schema.

SQL

SYSADMIN.getSchemaTmpValue(IN name string NOT NULL, OUT val string NOT NULL RESULT)

Example

SQL

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.

SQL

SYSADMIN.setSchemaTmpValue(IN name string NOT NULL, IN val string NOT NULL)

Example

SQL

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 may be used in modular connector code.

SQL

SYSADMIN.getClientSecret(IN suffix string, OUT val string RESULT)

SYSADMIN.getConnProp

This procedure gets a connector's property and may be used only in modular connector code, within or outside initializeMetadata().

SQL

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.

SQL

SYSADMIN.writeConnProp(IN pkey string NOT NULL, IN val string NOT NULL)

Using SYSADMIN.getConnProp() and SYSADMIN.writeConnProp() outside the initializeMetadata() procedure in modular connector code is available since v2.4.30