Account Connection Settings

Enter the connection information to allow Identity Security Cloud to locate and connect to the SQL Loader server to load account information, as well as for any account-related functions.

  1. Enter the service account user name making the connection to the data files into the User Name field.

  2. Enter the service account password into the Password field.

  3. Enter the URL to the data files into the Data Files URL field. For more information, refer to Data Files URL Formatting.

    The address should be in the following formats, depending on the data file type:

    • CSV files – jdbc:csv:ftp://<host/ server IP>/<directory path>

    • Text files – jdbc:text:ftp://<host/ server IP>/<directory path>

    CSV file example:

    jdbc:csv:ftp://myhost/home/testdata,

    jdbc:csv:ftp://000.00.00.00/home/testdata

  4. Enter the HXTT text driver used to communicate to the CSV or text file into the Driver Class field.

    For example:

    com.hxtt.sql.text.TextDriver

  5. Add any additional parameters into the Additional Connection Parameters field in the form of a key value pair. If multiple parameters need to be specified, they need to be passed in a new line.

    For example:

    _CSV_Header=true

    _CSV_Separator=,

    Note

    If you set the _CSV_Header= parameter to true, the first row of the CSV or text file is treated as a column header. If you set it to false, then the first row is treated as the account record.

    The value you set for the _CSV_Separator= parameter is used to separate the values of the fields in the CSV and text files.

  6. Select Save.