You can simply run the windows service under an appropriate active
directory user account and any connection to a relational database with
a connection string using integrated or trusted security. Here's an
example sql server connection string you wo...
Using SIC as a pathway to interact/extract data from on-prem hosted
instances of SAP is a supported scenario. We support this using a remote
business rule in SIC and have a new Marketplace solution coming soon to
automate the build-out of all of the ...
This is in fact a supported scenario to help with this situation. The
option for the connection string you would use is called 'integrated
security' and would allow the user-account the SIC service is running
under to be used as the credential. This ...
Apologizes for the delay in a response! SIC Would work for this scenario
using Smart Integration Functions. You can invoke these to pick-up
remote data from file shares up to 500-600mb or so and retrieve them
from a OneStream BR. (Simple example belo...
SIC has a couple of integration options for connections back to on-prem
resources. One is the ability to tunnel specific endpoints (Web-APIs,
SFTP servers, etc.) back to OneStream allowing them to be interfaced in
a very similar manner to VPN. This w...