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

From a technical perspective, SIC adds a layer of abstraction to the communication between OS and external system, but from a .NET perspective there should not be a difference, as long as the Gateway configuration allows write-back. That being said, I just read that the specific .SaveCustomDataTable is NOT supported, so you would need a different approach, but you have a lot of options, eg, create INSERT/UPDATE sql statement. More info on SIC can be found here: SIC Info 

  • MP2's avatar
    MP2
    New Contributor II
    4 months ago

    I want to create a table and columns in SIC, but only the table name is being created. I want to know how to fix this problem. Below is my sample query and code :

    Dim sql as new text.stringbuilder 

    Sql.appendline(“Create Table employee(Name varchar(255) not null ,age int null);”

    using dbconnap as dbconninfo = brapi.database.createexternaldbconninfo(si,”SICconnectionname”)

    Brapi.database.executesql(dbconnapp,sql.tostring,true)

    end using