Forum Discussion

jkim's avatar
jkim
New Contributor
2 years ago

Can we copy OS internal table data to external DB using SIC?

Hello, Our environment is OS Cloud 7.4 version. I am trying to explore if it is possible to copy OS internal App table data to external DB thru SIC?  I know there is way to extract OS app table da...
Data Integration
FrankDK's avatar
FrankDK
Contributor
2 years ago

If you already have a connection to an external DB, from where you can read (Select) data, I don't see why you then not should be able to push data (INSERT/UPDATE). A quick test could be done creating an extender business rule and do something like:

'' Code to get custom table data
Dim dt As DataTable = BRApi.Database.GetCustomDataTable(si, "Application", "some-name-of-a-table")
'' Code to write that data back to some matching datatable on an external database
Brapi.Database.SaveCustomDataTable(si, "some-external-db-connection-name",dt,True)

 

  • jkim's avatar
    jkim
    New Contributor
    2 years ago

    Thank you, Frank.

    I know you can do that for External DB directly connected to Cloud Environment, but I was asking External DB(or Custom DB) connected thru Smart Integration Connector (SIC).