Home >

AX1057

Managing remote data connections

Remote data connections provide a way for the Axiom Cloud Service to communicate with the client's local network environment. This connection can be used to support the following features:

• Importing data to the cloud from a local file or database
• Exporting data from the cloud to a local database.
• Authenticating users for access into Axiom Software (Windows Authentication)
• Saving output files for file processing to a local file system (snapshot or export)

For a full-process discussion of how to set up and use remote data connections with the Axiom Cloud Service, see the separate Cloud Service Technical Guide.

Remote data connections are managed in the Remote Data Connections screen of the Scheduler dialog. The following is required to create a remote data connection:

• The Axiom Cloud Integration Service must be already installed on a server within your local network environment, and the server must be enabled for use (on the Server screen of the Scheduler dialog).

• You must have the connection string to your system's namespace on the Axiom Cloud Service. If you do not have this information, contact Kaufman Hall Software Support.

NOTE: Only administrators can create and edit remote data connections. Users with the Scheduled Jobs User permission cannot see the Remote Data Connections tab in the Scheduler dialog.

To create a remote data connection:

1. On the Service tab of the Scheduler dialog, click Remote Data Connections.

2. At the bottom of the dialog, click New Connection.

   A set of empty fields displays in the Configuration details section.

3. Complete the following settings:

   Item	Description
   Name	The name of the remote data connection. If your system has multiple remote data connections, the name may determine which connection is used for the {DefaultRemoteDataConnection} variable in imports. The first connection is selected alphabetically among all connections that are not enabled for authentication. If all connections are enabled for authentication, the selection is simply alphabetical.
   Description	Optional. The description of the remote data connection.
   Connection String (SAS)	The connection string to the namespace that was created by Kaufman Hall Software Support in the Microsoft Azure environment for your cloud system. If you do not have this connection string, contact Kaufman Hall Software Support.
   Use for authentication service	Specifies whether the remote data connection is used for Windows Authentication. This only applies if Windows Authentication is enabled for your cloud system. If enabled, this remote data connection will also be used for any Active Directory Import tasks set up for your system.
   Cloud Integration Server	The name of the Cloud Integration Service installed in the local network environment. The name of this server is ServerName-CIS.

4. Click Save Connection.

The connection now displays in the list of remote data connections. You can now use this connection when setting up import and export utilities.

Editing or deleting remote data connections

• To edit a connection, select the connection in the list and then make the necessary edits in the Configuration details. Click Save Connection to save the changes.
• To delete a connection that you no longer need, select the connection in the list and then click Delete Connection.