Connecting to Database such as Oracle, SQL etc.

[shaji_chandran]

Hi ,

I would like to know is there any action block in MII version 12.1 through we can connect to a database such as Oracle, SQL.

Currently I am connecting to this database using a custom action block. I would like to know is there any inbuilt component in MII which through we can connect to any database using JDBC driver.

Thanks in advance

Shaji

[Former Member · Accepted solution]

Shajikc,

to query databases you can use the MII action under [Data Queries|http://help.sap.com/saphelp_mii121/helpdata/en/43/e80b59ad40719ae10000000a1553f6/frameset.htm].

In the MII Data Services > Data Servers you configure the connections to the databases. Then you implement a [MII query|http://help.sap.com/saphelp_mii121/helpdata/en/43/e80b59ad40719ae10000000a1553f6/frameset.htm], which you can use with the Data Query actions.

Is that what you are looking for?

Michael

[shaji_chandran · Accepted solution]

Hi Michael,

Thanks for your quick response. Actually I would like to insert some data in database. So this data queries won't be sufficient for that. I am looking for any inbuilt action block using JDBC/ODBC driver through we can connect the database and insert some records to a table

Thanks

Shaji

[Former Member · Accepted solution]

You can use this actions with a Command mode.

For example, if you have defined a connection to an Oracle DB, you can create a MII SQL query with this connection and define Query Mode "Command". With this, you can execute a Update/Insert/Delete command. MII does not get a response from this command.

This new query can be used in a BLT with the SQL Query action.

Michael

[shaji_chandran · Accepted solution]

Thanks very much Michael

Your answer has been resolved our problem

Thanks again

Shaji