Skip to main content

AnyID_CSV Job

The AnyID_CSV job imports a list of identities and attributes from a CSV file. Use this when a native integration may not be available, or an export is the best option.

RECOMMENDED: Copy the CSV file to the Access Analyzer Console for the best import performance.

AnyID_CSV Job in the Jobs Tree

The AnyID_CSV job is located in the Jobs > AnyID Connectors job group.

The following are recommended configurations for the AnyID_CSV job:

Dependencies

None

Targeted Host

Local Host

Connection Profile

The AnyID_CSV job does not require a connection profile.

History Retention

Default Retention Period. See the History topic for additional information.

Multi-Console Support

Not supported

Schedule Frequency

Schedule the job as required.

Query Configuration

This job contains configurable queries. See the Configure the AnyID_CSV Query topic for additional information.

Analysis Configuration

See the Analysis Tasks for the AnyID_CSV Job topic for additional information.

Workflow

Step 1 – Prepare a CSV file for import.

Step 2 – Configure the configurable query parameters.

Step 3 – Run the job.

Step 4 – Review the report generated by the job.

Queries for the AnyID_CSV Job​

The AnyID_CSV query uses the PowerShell Data Collector.

Queries for the AnyID_CSV Job

The query is:

Configure the AnyID_CSV Query​

Follow the steps to configure the AnyID_CSV query.

The name of the source repository parameter on the job Overview page

Step 1 – Navigate to and select the AnyID Connectors > AnyID_CSV node. In the Configuration section of the job's Overview page, click the configure button for the The name of the source repository parameter. In the Configure Window, enter the name of the source repository where the list of identities and related attributes were retrieved from.

Step 2 – Navigate to the AnyID Connectors > AnyID_CSV > Configure node and select Queries.

Step 3 – In the Query Selection view, select the CSV Import query and click Query Properties. The Query Properties window opens.

Step 4 – Select the Data Source tab, and click Configure. The PowerShell Data Collector Wizard opens.

Edit Query Page

Step 5 – Navigate to the Edit Query page. Click the Parameters tab on the right-hand side of the page to expand the Parameters window. Configure the following attributes:

CAUTION: The following attributes must be configured in order for the job to execute properly.

  • $inputfile – File path to the CSV file which contains the identity and attribute information

  • $RequiredAttributes – The list of attributes that need to be found in the document in order to trigger a match

    • An attribute in the Attributes list will not be considered a match (in reporting and AIC) unless an attribute in the RequiredAttributes list is also found in the same file

  • $Attributes – The list of attributes that will be scanned for during sensitive data scanning

    • An attribute in the Attributes list will not be considered a match (in reporting and AIC) unless an attribute in the RequiredAttributes list is also found in the same file

  • $ID – Column which uniquely identifies each subject

  • $SubjectType – Either a reference to a column in the CSV file or a string which indicates the type of subjects being imported

  • $batchSize – (Optional) The number of rows to process in a batch. Leave at default unless otherwise required.

  • $debugMode – (Optional) When set to true, stores unhashed attribute values for troubleshooting purposes

Step 6 – Click Next. Continue to the Sample server page and click Finish to save changes. Click Cancel to exit the wizard without saving changes.

The query is now ready to run.

Analysis Tasks for the AnyID_CSV Job​

Navigate to the Jobs > AnyID Connectors > AnyID_CSV > Configure node and select Analysis to view the analysis tasks.

CAUTION: Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Tasks for the AnyID_CSV Job

The default analysis tasks are:

  • Create Subject Profile Type – Creates subject profile type
  • Create Subject Profile Stored Procedure – Creates subject profile stored procedure
  • Merge into Subject Profile schema – Merges into subject profile schema
  • Calculate completion details – Calculates attribute completion for imported subjects

In addition to the tables created by the analysis tasks, the AnyID_CSV job produces the following preconfigured report:

ReportDescriptionDefault TagsReport Elements
CSV ImportsThis report highlights subjects imported from the provided CSV file, and summarizes attribute completion.NoneThis report is comprised of four elements: - Table – Contains information on imported subjects - Bar Chart – Provides information on subject types - Table – Contains information on the attributes summary - Table – Contains information on subject details