Move pictures in Jpg from a server to SAP (Oracle database) in BLOB

[niranjan_yerraguntla]

Hi SAP Friends,

We would like to know if this is possible.

We have pics in jpg/jpeg format in one server. We want to move these pics automatically once every hour to SAP Oracle database in BLOB format. The server has the capability to push these jpg files into BLOB format of Oracle database. We need to know if it is possible to send to SAP's Oracle database and store in BLOB format. If so, pl let us know how.

Pl let us know.

Niranjan

[markus_doehr2 · Accepted solution]

You are facing two things here:

a) Licensing issue

Check Note 581312 - Oracle database: licensing restrictions:

As of point 3, it follows that direct access to the Oracle database is only allowed for tools from the areas of system administration and monitoring. If other software is used, the following actions, among other things, are therefore forbidden at database level:

• Creating database users

• Create database objects

• Querying/changing/creating data in the database

• Using ODBC or other SAP external access methods

This depends on the contract and where you bought which licenses for Oracle.

b) Technical issues

It´s not a good idea to insert data into a SAP database without using SAP tools. Even if it´s a separate table(space) or "isolated" in a SAP understanding. You never know, how upgrades behave with that table, you may see the table in sense of SAP-DDIC consistency (Table without DDIC reference) etc.

If you want to insert JPEGs easily, you can use transaction CSADMIN, create a repository and write a small program, that uploads the data to the database using SAP standard interfaces. This will insure DATA integrity and will make sure, the data is accessible even after database/SAP system upgrades.

--

Markus