Connect to an ArcSDE database

[Cadguru42]

How do I go about connecting to an ArcSDE database? I know how to do it in Map (C3D) by copying the 3 DLL files, but I can't find anything about how to do this in InfraWorks. I copied the 3 DLLs to the InfraWorks install folder, but that doesn't seem to do much. The help files are useless as it doesn't mention anything specifically about the generic imports.  I see this dialog box, which has no input for server address, username, password, or datastore. 

I don't know what to use for the connection string. I tried using just the IP address of the ArcSDE server, but that didn't work. I also tried using the IP address with the port number and that didn't work either. Any help would be great.

[jason_eggen]

Did you ever figure out how to connect to SDE Data sets?

[c4az57b]

Also waiting for an answer to this one

[lippola]

Hi there, 

we just found a bug in Infraworks which refers to the wrong FDO version. So this might help:

ArcSDE connection

With infraworks 2014 R4 ArcSDE fdo version 3.7 is installed, which does not work to connect to ArcSDE 10

Connect to ArcSDE to get data from Gis directly

Copy 3 Esri components dlls into pe.dll, sde.dll and sg.dll C:\Program Files\Autodesk\InfraWorks 2014 R4

Copy 3 ArcSDE FDO dlls from AutoCAD map to Infraworks

• ArcSDEMessage.dll
• ArcSDEProvider.dll
• ArcSDEProvider92.dll

Copy from here C:\Program Files\Autodesk\Autodesk AutoCAD Map 3D 2014\bin\FDO

Paste here C:\Program Files\Autodesk\InfraWorks 2014 R4 (make backup of existing dlls)

Change providers.xml file

<FeatureProvider>

    <Name>OSGeo.ArcSDE.3.8</Name>

    <DisplayName>OSGeo FDO Provider for ArcSDE </DisplayName>

    <Description>Read/write access to an ESRI ArcSDE-based data store, using Oracle and SQL Server. </Description>

    <IsManaged>False</IsManaged>

    <Version>3.8.0.0</Version>

    <FeatureDataObjectsVersion>3.8.0.0</FeatureDataObjectsVersion>

    <LibraryPath>ArcSDEProvider.dll</LibraryPath>

  </FeatureProvider>

·        server=10.20.0.79; instance=5151; datastore=sde; username=qrgis; password=***

Hope this helps...

[daniel.jurado]

Where it says to change the .xml file

I backed up and copied the .dll files (and also the .xml file) I added the text below to the front of the file:

   Are there specific things that I need to change for my system.

      If so, which things are they? - How do I find out.

After doing this, I can no longer create a new file in InfraWorks.

   Restoring older files for now.

<FeatureProvider>

    <Name>OSGeo.ArcSDE.3.8</Name>

    <DisplayName>OSGeo FDO Provider for ArcSDE </DisplayName>

    <Description>Read/write access to an ESRI ArcSDE-based data store, using Oracle and SQL Server. </Description>

    <IsManaged>False</IsManaged>

    <Version>3.8.0.0</Version>

    <FeatureDataObjectsVersion>3.8.0.0</FeatureDataObjectsVersion>

    <LibraryPath>ArcSDEProvider.dll</LibraryPath>

  </FeatureProvider>

·        server=10.20.0.79; instance=5151; datastore=sde; username=qrgis; password=***