Automic Workload Automation

Expand all | Collapse all

How to use one DB Service agent for different Databases

  • 1.  How to use one DB Service agent for different Databases

    Posted Feb 17, 2017 07:16 AM
    The documentation on installing a DB service agent for database variables does not explicitly state this. 

    So for clarification, if you already have a DB service agent installed for eg MS SQL Server and you would like to use it also for eg Oracle Databases there are two simple steps:

    - add the JDBC driver as specified in the documentation under Step 3. into the already existing JDBC directory
    - restart your agent

    Some additional steps may be necessary for example for enabling windows authentication with SQL Server, this is described in detail on the documentation page, here:

    https://docs.automic.com/documentation/webhelp/english/ALL/components/AE/11/All%20Guides/help.htm#ucacvk.htm?


  • 2.  How to use one DB Service agent for different Databases

    Posted Feb 20, 2017 02:48 AM
    uuuhh that saved me a lot of time to reverse-engineer ;-)

    Thx for this info!!