The service enables you to view all of your external connections.
The result is an array of ExternalConnection objects with the connection id, connection name, database type and connection string for each connection.
*Please note that the information contains a clear text of the connection strings.
Parameters:
Java Code:
//get a reference to the service InwiseWebServices ws = new InwiseWebServices();
InwiseWebServicesSoap inwiseWebServicesSoap = ws.getInwiseWebServicesSoap();
//fill the security header
HeaderHandler hh = new HeaderHandler("myusername", "myPassword");
hh.setHeader(inwiseWebServicesSoap);
//call the operation
inwise.ArrayOfExternalConnection result = inwiseWebServicesSoap.groupsExternalGetRemoteConnectionsDetails();
List<ExternalConnection> connections=result.getExternalConnection();
Iterator<ExternalConnection> it=connections.iterator();
while(it.hasNext())
{
ExternalConnection ec = it.next();
String connectionString = ec.getConnectionString();
String connectionID = ec.getDbId();
String connectionName = ec.getConnectionName();
int databaseType = ec.getDbType();
}
C# Code:
//get a reference to the service
InwiseWebServices.InwiseWebServices ws = new InwiseWebServices.InwiseWebServices();
//fill the security header
InwiseWebServices.SecHeader header = new InwiseWebServices.SecHeader();
header.username = "username";
header.pass = "myPassword";
ws.SecHeaderValue = header;//set credentials
//call the operation
InwiseWebServices.ExternalConnection[] connections = ws.Groups_External_GetRemoteConnectionsDetails();
for (int i = 0; i < connections.Length; i++)
{
InwiseWebServices.ExternalConnection ec = connections[i];
string connectionString = ec.ConnectionString;
string connectionID = ec.DbId;
string connectionName = ec.ConnectionName;
int databaseType = ec.DbType;
}
VB Code:
'get a reference to the service
Dim ws As InwiseWebServices.InwiseWebServices = New InwiseWebServices.InwiseWebServices()
'fill the security header
Dim header As InwiseWebServices.SecHeader = New InwiseWebServices.SecHeader()
header.username = "username"
header.pass = "myPassword"
ws.SecHeaderValue = header 'set credentials
'call the operation
Dim connections() As InwiseWebServices.ExternalConnection = ws.Groups_External_GetRemoteConnectionsDetails()
Dim i As Integer
For i = 0 To connections.Length - 1 Step i + 1
Dim ec As InwiseWebServices.ExternalConnection = connections(i)
Dim connectionString As String = ec.ConnectionString
Dim connectionID As String = ec.DbId
Dim connectionName As String = ec.ConnectionName
Dim databaseType As Integer = ec.DbType
Next