Hi Andre, 

I have only seen ModScript accessing SBM database tables, but you can get the data through other options. 

I believe that Oracle has a REST data service that can be used to create a REST service that you can access by creating a REST data source in Composer.

On the SBM side, you can recreate an Advanced XML report that will query your Oracle database.  With this type of report, SBM sees the data as an auxiliary table even though it is not stored in the SBM database.  See KB https://knowledgebase.serena.com/InfoCenter/index?page=content&id=S141342.

David

Thanks for your response!

I was hoping to handle this directly through ModScript.

Unfortunately, the Oracle Rest service is not an option here at this time. We have no control over this database and the team responsible has no idea what Rest even means. They can only provide a DB table.

I checked your hint with the knowledge base article. We need to set also a status in the other database after submitting the new SBM item. If I understand correctly, I can only view the data as a read-only auxiliary table.

Anyway, At the moment I plan to do this with a C++ DLL, which implements the ODBC handling and call this DLL from a ModScript. Hope that works for me.

Thanks again!

Andre

As long as you are creating a C++ DLL, you may consider creating a ASP or ASP.NET on your IIS server to return data from your ODBC as JSON.  Of course, you would want to protect access to this service by making it reachable only from the IIS/Modscript.

Hi Andre,

with SQL Server Databases, I know it is possible to execute queries against an external database directly, using Modscript methods like ReadDynaSql(...).
The key to this functionality is a SQL Server feature called 'Linked Servers'.

A quick Google search showed that Oracle has a similar feature called 'DBLinks'.
While I cannot guarantee that this will work, I think it is worth taking a look into.
Under the precondition that your SBM AE schema database user has read access to the linked database, you should be able to execute arbitrary queries against the linked database. Maybe it is a good idea to discuss this with your Oracle DBA? If it works, if would be much easier than using an external DLL.

Thanks again for your help! I will check this with ASP and IIS.

Thanks for your answer! I will check this DBLinks feature.