SubmitImportNonAIR Method

Imports exposure data in a non-AIR format into Touchstone®.

The Touchstone Data Import APIs enable you to import an Exposure Data Module (EDM) database into the Touchstone application. For EDM imports, the SubmitImportNonAIR() method imports all portfolios, and the Touchstone application creates the Exposure Data Sets implicitly.

Note: The EDM database must be on the same server as the Touchstone Database Server.

Syntax

Visual Basic (Declaration)
Visual Basic (Usage)
C#

Public Function SubmitImportNonAIR( _
   ByVal request As SubmitImportNonAIRRequest _
) As SubmitImportNonAIRResponse

Dim instance As DataImportServiceClient
Dim request As SubmitImportNonAIRRequest
Dim value As SubmitImportNonAIRResponse
 
value = instance.SubmitImportNonAIR(request)

public SubmitImportNonAIRResponse SubmitImportNonAIR( 
   SubmitImportNonAIRRequest request
)

Parameters

request: Contains a SubmitImportNonAIRRequest that identifies the Import Options associated with the non-AIR-formatted data that you want to import, along with the associated Business Unit SID and SQL Instance SID.

Return Value

A SubmitImportNonAIRResponse containing the Activity SID that uniquely identifies the asynchronous web service call that you made to import the specified non-AIR-formatted data.

Remarks

To find the Business Unit SID to pass into this method, call the GetBusinessUnits() method.

To find the SQL Instance SID to pass into this method, call the GetSqlInstances() method.

Example

The following example shows how to import EDM data into Touchstone using the SubmitImportNonAIR() method:

using System;
using AIR.Services.DataImport.Api;
using AIR.Services.DataImport.Data;
using AIR.Services.Common.Data;
            
class SnippetSubmitImportNonAIRRequest
{
    private static void ImportEDM(int businessUnitSid, int sqlInstanceSid, string sourceEDMDatabaseServerName, string sourceEDMDatabaseName, int dataSourceSid)
    {
        DataImportServiceClient importClient = new DataImportServiceClient();
        SubmitImportNonAIRRequest request = new SubmitImportNonAIRRequest();
        request.BusinessUnitSid = businessUnitSid;
        request.SqlInstanceSid = sqlInstanceSid;
        request.ImportOptions = new ImportOptionsNonAIR()
        {
            Currency = "USD",
            CurrencyExchangeRateSid = 1,
            DataSourceSid = dataSourceSid,
            SourceServer = sourceEDMDatabaseServerName,
            SourceDatabase = sourceEDMDatabaseName,
            TargetSuffix = "API",
            DuplicateContractBehaviour = DuplicateContractsOption.Replace,
            Geocoder = BaseGeocoder.AIRGeocoder,
            PreserveGeocode = true
        };
            
        SubmitImportNonAIRResponse response = importClient.SubmitImportNonAIR(request);
        if (response.Status.Code == StatusCode.Success)
        {
            foreach (int activitySid in response.ActivitySids)
                Console.WriteLine("Submitted successfully to HPC with Activity SID: " + activitySid);
        }
    }
}

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

DataImportServiceClient Class
DataImportServiceClient Members