Forum Discussion

Sergey's avatar
Sergey
Contributor III
5 months ago

Business Rule to Connect and send SQL table data without configuring external tables ?

Dear community,

I need to send data over another external Azure SQL table. What are the ways (and possible business rules ?) to do so especially if this external table hasn't been configured as a regular "external table" by onestream ?

Regards,

Extenders
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    5 months ago

    I'm pretty sure one of the brapi.database.Create* methods accepts a full ODBC connection string, so as long as you can use that, you should be ok. Use intellisense to find it, it's a generic one.

    If you're on v8+, it may be easier to do this sort of thing from a Smart Integration Connector rule - it depends on your network configuration.