1. [+ Add Parameter]
2. Add the following 4 parameters' Names and Types:
   1. Name: APIURL Type: String
   2. Name: BIURL Type: String
   3. Name: REFRESHTOKEN Type: Password
   4. Name: USERID Type: String

Leave Default Value and Available Values fields empty.

1. [+ Add Parameter Set] to populate parameters created in Step 1.2 Add Parameters
2. Enter a Parameter Set Name
   • Make sure the BI name is included in the Parameter Set Name to make it user-friendly
3. APIURL: Enter the following URL https://<Alation Server URL>/integration/v2 replacing <Alation Server URL> with the URL of your Alation server
4. BIURL: Enter the following URL https://<Alation Server URL>/integration/v2/bi/server/<Server Number>/ replacing <Alation Server URL> with the URL of your Alation server and <Server Number> with the number of Alation server with the needed data
5. REFRESHTOKEN: Enter Alation Refresh Token value
6. USERID: Enter ID of the User who created the Refresh Token
7. Is Default: "Yes"
8. [Save]

Access the Editor tab

1. [Choose the parameter set] if you have multiple Parameter Sets
2. Paste the following code:

var returnResult = function(custom_field, custom_field_value, reports){
    var result = [["element name"]]
      , txt = ''
      , elements = {}
      , fields = []
      ;
    for (var i = 0; i < custom_field_value.length; i++) {
        var field = ''
            , name = '';
        for (var j = 0; j < reports.length; j++)
            if(custom_field_value[i].oid==reports[j].id){
                name = reports[j].name;
                break;
            }
        if('undefined'===typeof(elements[name])) elements[name] = {"fields": []};
        for (var j = 0; j < custom_field.length; j++)
            if(custom_field_value[i].field_id==custom_field[j].id){
                field = custom_field[j].name_singular;
                if(-1===fields.indexOf(field)) fields.push(field);
                break;
            }
        if(field>'' && name>'')
            elements[name]['fields'][field] = custom_field_value[i].value;
    }
    for (var i = 0; i < fields.length; i++)
        result[0].push(fields[i]);
    for (var name in elements) if(name>'' && elements.hasOwnProperty(name)){
        var tmp = [name];
        for (var i = 0; i < fields.length; i++)
            tmp.push(elements[name]['fields'][fields[i]]);
        result.push(tmp);
    }
    for (var i = 0; i < result.length; i++) {
        var tmp = [];
        if(0==i)
            for (var j = 0; j < result[i].length; j++)
                tmp.push('string'==typeof(result[i][j])?result[i][j].split("\n").join('').split("<p>").join('').split("</p>").join(''):'');
        else
            for (var j = 0; j < result[i].length; j++)
                tmp.push(JSON.stringify('string'==typeof(result[i][j])?result[i][j].split("\n").join('').split("<p>").join('').split("</p>").join(''):''));
        txt += tmp.join(',')+"\n";
    }
    customScript.result(txt);
    setTimeout(function(){ customScript.close(); },5000);
};
$.ajax({
    "url": customScript.parameters.APIURL.replace('/v2/','/v1/')+"createAPIAccessToken/"
    ,"data":{"refresh_token":customScript.parameters.REFRESHTOKEN, "user_id":customScript.parameters.USERID}
    ,"type":"POST"
    ,"error":function(jqXHR, textStatus, errorThrown){
        customScript.log(JSON.stringify(errorThrown));
        customScript.close();
    }
    ,"success":function(response){
    
        var apiToken = response.api_access_token;
        $.ajax({
            "url":customScript.parameters.APIURL+"custom_field"
            ,"headers":{"TOKEN":apiToken}
            ,"error":function(jqXHR, textStatus, errorThrown){
                customScript.log(JSON.stringify(errorThrown));
                customScript.close();
            }
            ,"success":function(custom_field){
                $.ajax({
                    "url":customScript.parameters.APIURL+"custom_field_value/?otype=bi_report&limit=10000"
                    ,"headers":{"TOKEN":apiToken}
                    ,"error":function(jqXHR, textStatus, errorThrown){
                        customScript.log(JSON.stringify(errorThrown));
                        customScript.close();
                    }
                    ,"success":function(custom_field_value){
                        $.ajax({
                            "url":customScript.parameters.BIURL+"report/"
                            ,"headers":{"TOKEN":apiToken}
                            ,"error":function(jqXHR, textStatus, errorThrown){
                                customScript.log(JSON.stringify(errorThrown));
                                customScript.close();
                            }
                            ,"success":function(reports){
                                returnResult(custom_field, custom_field_value, reports);
                            }
                        });
                    }
                });
            }
        });
    }
});
setTimeout(function(){ customScript.close(); }, 145000);

3. [Run Script], the script will fetch data from the Alation BI server to your Metric Insights' database
4. See Script Output to check whether the Custom Script has been executed successfully

Access Admin > Distribution > Notification Schedules

1. [+ New Notification Schedule]
2. Frequency: "Every few minutes"
3. Send every: "10 minutes"
4. [Save]

For more details on Notification Schedules see Create or Modify a Notification Schedule (via Notification Schedule Editor).

1. Access the Run Scripts tab
2. [+ Add Script]
3. Script name: Select the previously created Custom Script
4. Select a Parameter set
5. [Save]

1. Enter Data Source Name
   • If you use several Alation scripts, make sure the Data Source name contains BI tool name
2. Directory (absolute path): "Custom Scripts"
3. Select an Object List Refresh Trigger
   • It is recommended to select an Object List Refresh Trigger that runs daily
4. [Save]

1. Access Autosync
2. [+ Custom Field Autosync]

1. Enter a Name for Custom Field Autosync
2. Dataset & View: Select the previously created Dataset
3. Match On: "Name"
4. Name Column: Select a column with elements' names
5. Field Mapping: Match Dataset columns with previously created Custom Fields
6. [Save]
7. [Sync Now]

Custom Field Autosync will update the Custom Fields every 10 minutes, each time the Dataset is updated.