Skip to Content

XMII enforce security of the jdbc connection to Oracle

Hi XMII expert,

I am connecting to an external Oracle database using Oracle JDBC thin driver from XMII.

I wanted to know if the user/password connection is crypted or if you can see it in plain text on the network (with a sniffing tool).

If it is in plain text, is it possible to crypt the communication threw SSL or some other stuff.

Regards

Jean-Louis

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 11, 2008 at 11:07 AM

    Hi,

    In either 11.5 or 12.0 version of xMII you can configure an Oracle server through "Data Services" tab. Under this there is one link named "Data Servers" where you can configure any data server other than SAP server.

    While creating a new data server we have to provide following details.

    Connector

    ConnectorType = Oracle

    DatePrefix

    DateSuffix

    Description

    Enabled = True

    InitCommand

    InternalDateFormat = yyyy-MM-dd HH:mm:ss

    JDBCDriver

    Name

    PoolMax = 256 (Maximum connection)

    PoolSize

    ServerPackage

    ServerURL

    Timeout

    UseCount

    UserName

    ValidationQuery

    WaitTime

    You can mention the user name and password over there.

    Password will come in encrypted form.

    Thanks,

    Rajesh Sivaprakasam

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 11, 2008 at 12:05 PM

    Hi Jean-Louis,

    if you would like to encrypt the entire JDBC session, you could try SSH tunneling. Assuming both the MII and Oracle servers are running Windows, you can use PuTTY ( > Google) on the MII server and SSHwindows ( > http://sshwindows.sourceforge.net/) on the Oracle server.

    SSH supports tunneling TCP ports through the encrypted session. If you set up a tunnel from the MII server to the Oracle server, and set the tunnel's exit port to point to the port Oracle is listening on (e.g. localhost:1433), you should be able to set MII's JDBC connection string to the tunnel's entry port on the MII and server and connect to the DB.

    This might be a little tricky to set up at first, but the help files should help you out a bit. If not, come back here and ask.

    Hope this helps,

    Sascha

    Add comment
    10|10000 characters needed characters exceeded