Create database connections within ESBIn this instruction, we are going to explain how to make a database connection that you can use in ESB.
Step 1: Goto APPDIR\DMESB\Data\DbConnection*
Step 2: Create a new text file and name it to something appropriate (Don't use spaces in the filename! Use underscores instead e.g. this_is_my_name.xml). The extension must be .xml!
Step 3: Copy the following XML Structure and paste it into the the file you just created:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <DbConnection Name="db1" ID="3832e0d4-3f0f-4712-8caf-204c0c75851f" Type="MSSQL" ConnectionString="data source=S4MDEV-CODE4;initial catalog=GenericWS;Uid=dmuser;Pwd=dmuser" />
*APPDIR = C:\S4M_DM\ (This is the default directory of Data Manager)
Step 4: Give the Name attribute the same value as the filename. So if your filename is GenWSConn.xml, the Name attribute would look like this: Name="GenWSConn".
Step 5: Change the ID (you can generate one below and paste it in the file): Generate GUID The ConnectionString attribute needs some more explanation, because it exists out of more variables. data source: This is the machine where the database is running on. It can either be a hostname or an IP Address. initial catalog: This is the database name. Uid: This is the username that you use to login to the database. Pwd: This is the password corresponding to the Uid.
Step 6: Fill in the information that fits your environment.
Step 7: Save the XML file and refresh ESB in the browser (You might have to login to ESB again). The database connection should now be showing up in ESB. Once the database connection file is loaded, the connection string will be encrypted.