Linking Remote Agent with DATABASICS

Steps to Take in DATABASICS' Admin:

You need to access Admin by logging in to the DATABASICS application as someone with Admin rights.

Click on Admin
Click on Data Piping
Click on Remote
Click on Remote Job Agent
Once you are in the Remote Job Age:
1. Click on Add.
2. Enter an Agent ID and a Name for the Remote Job Agent (Please note that the Remote Agent Will be used in the setting up the remote agent at the client server)
3. Click on Save.
4. Once you click Save, a Remote Trust Key will be generated in the field that you cannot. Copy that Remote Trust Key in to the section above called Remote Trust ID. (Please note that the Remote Trust Key Will be used in the setting up the remote agent at the client server)
After you have finished creating the Remote Job Agent, go to All Profile Task.
Click on a profile that you have set up to have [Import From a Table/View].
Click on Parameters
Where it says Remote Job Agent, select the Remote Job Agent you created above.
Click Save.

Steps Taken at the client Server

You need to Install DBRemoteAgent first (Please make sure you have JDK 1.6 installed first.).

To Install it, you need to:

Unzip DBRemoteAgent.zip to a C: or D: drive
Move agent.properties from /DBRemoteAgent/template to /DBRemoteAgent/
Edit agent.properties and provide the following information:

Remote Attributes

Remote URL to DATABASICS Site.
remoteUrl=https://prsitenn.data-basics.net/adminsitexxxx; (Test)
where nn is the site number and xxxx is the Tomcat's service number.
remoteUrl=https://sitenn.data-basics.net/adminsitexxxx; (Live)
where nn is the site number and xxxx is the Tomcat's service number.
Agent ID. Created in the DATABASICS Admin under Remote Job Agent
agentID=
Remote Trust ID (Generated by Remote Data Piping Agent in DATABASICS) . remoteTrustId which will be created in DATABASICS in Remote Data Piping Agent.
RemoteTrustId=

Output Generated Data's location.

pipingFolder=c:/DBRemoteAgent/Data-Output; piping folder the drive location currently is c but it is other than c please change it.

Remote Agent Service that is created on the client server.

port=xxxx; to be defined by client
serviceId=DBRemoteAgent; When creating the service, use the name ID.
serviceName=DBRemoteAgent; when creating the service, use the Service Name.
serviceDescription=DATABASICS Data Piping Remote Agent; This is the description of the Service that is created on the client server.

DATABASE access for the back end such as Solomon, Great Plains, Oracle, you would need to provide the JDBC configuration and user id and password.

localDbUrl=jdbc:sqlserver://localhost[;instanceName=cccccc]:1433;DatabaseName=clientdb. Sometimes when logging into the DB server, you might need to add instance name; if the server name is localhost\cccccc
localDbUser=
localDbPassword=

Logging errors/Trace. You need to define its location in the log attributes
logLevel=debug
logFile=c:/DBRemoteAgent/Log/dbremoteagent.log
logFileSize=2000KB
logBackupCount=5

To install the service (DBRemoteAgent] you would only need to type the following: AgentServer.bat install
Then run the service.

Please note that you can create multiple Remote Agents. Each would then need to have its own directory and its properties file defined. You might need it in case you want to have the Profiles to have a dedicated remote agent. Thus, you need to also create new Remote Agents in DATABASICS's Admin.

To uninstall Remote Agent:

Stop the DBRemoteAgent.
<drive>:\DBremoteAgent\AgentServer.bat uninstall or AgentServer.bat remove

Browser not supported