Working with ArcSDE data

In this topic

• ArcSDE data connections
• Creating a connection file
  • Using the Create ArcSDE Connection File tool
• Using a connection file

ArcSDE data connections

Creating a connection file

• Use the Spatial Database Connection wizard from the Database Connections node in the Catalog tree. Follow the instruction in Adding a database server to ArcGIS for Desktop to make a direct connection.
• Use the Create ArcSDE Connection File tool (in the Data Management toolbox).

Using the Create ArcSDE Connection File tool

public void createSDEConnectionFile(IGeoProcessor2 gp)
{
    IVariantArray parameters=new VarArrayClass();
    parameters.Add(@"C:\temp");
    parameters.Add("flames.sde");
    parameters.Add("wilma4");
    parameters.Add("5940");
    parameters.Add("vtest");
    parameters.Add("true");
    parameters.Add("toolbox");
    parameters.Add("toolbox");
    parameters.Add("true");
    parameters.Add("sde.DEFAULT");

    IGeoProcessorResult result=null;

    try
    {
        result=(IGeoProcessorResult)gp.Execute(
            "CreateArcSDEConnectionFile_management", parameters, null);
        string conn_file=result.GetOutput(0).GetAsText();
        // Use the connection file for further geoprocessing.
        // ...
    }
    catch (Exception ex)
    {
        // Print exception and error messages.
    }
}

Public Sub createSDEConnectionFile(IGeoProcessor2 gp)
    
    Dim parameters As IVariantArray=New VarArray
    parameters.Add("C:\temp")
    parameters.Add("flames.sde")
    parameters.Add("wilma4")
    parameters.Add("5940")
    parameters.Add("vtest")
    parameters.Add("true")
    parameters.Add("toolbox")
    parameters.Add("toolbox")
    parameters.Add("true")
    parameters.Add("sde.DEFAULT")
    
    Dim result As IGeoProcessorResult=Nothing
    
    Try
    
    result=CType(gp.Execute("CreateArcSDEConnectionFile_management", parameters, null), IGeoProcessorResult)
    Dim conn_file As String=result.GetOutput(0).GetAsText()
    ' Use the connection file for further geoprocessing.
    ' ...
    Catch(ex As Exception)
    ' Print exception and error messages.
    End Try
    
End Sub

Using a connection file

public void SDEConnectionFile(IGeoProcessor2 gp)
{
    gp.SetEnvironmentValue("workspace", @"C:\St_Johns");
    IGpEnumList fcs=gp.ListFeatureClasses("*", "", "");

    // Set the workspace to SDE for ValidateTableName.
    gp.ResetEnvironments();
    string wks=@"Database Connections\Bluestar.sde";
    gp.SetEnvironmentValue("workspace", wks);

    string fc=fcs.Next();
    string outfc="";
    IVariantArray parameters=new VarArrayClass();

    while (fc != "")
    {
        // Validate the output name.
        outfc=gp.ValidateTableName(fc, wks);

        // Copy the features from D:/St_Johns to the SDE workspace.
        parameters.Add(fc);
        parameters.Add(outfc);
        gp.Execute("CopyFeatures_management", parameters, null);
        fc=fcs.Next();
    }
}

Public Sub SDEConnectionFile(ByVal gp As IGeoProcessor2)
    
    gp.SetEnvironmentValue("workspace", "D:\St_Johns")
    Dim fcs As IGpEnumList=gp.ListFeatureClasses("*", "", "")
    
    ' Set the workspace to SDE for ValidateTableName.
    gp.ResetEnvironments()
    Dim wks As String="Database Connections\Bluestar.sde"
    gp.SetEnvironmentValue("workspace", wks)
    
    Dim fc As String=fcs.Next
    Dim outfc As String=""
    Dim parameters As IVariantArray=New VarArray
    
    While Not fc Is ""
        
        ' Validate the output name.
        outfc=gp.ValidateTableName(fc, wks)
        
        ' Copy the feature classes from D:/St_Johns to the SDE workspace.
        parameters.Add(fc)
        parameters.Add(outfc)
        gp.Execute("CopyFeatures_management", parameters, Nothing)
        
        fc=fcs.Next
        
    End While
    
End Sub

See Also:

• ESRI.ArcGIS.DataSourcesGDB
• ESRI.ArcGIS.Geoprocessing
• ESRI.ArcGIS.System (ESRI.ArcGIS.esriSystem)