Forum Discussion

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
2 years 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 r...
Extenders
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years 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.