Forum Discussion

Kashinath's avatar
Kashinath
New Contributor II
11 months ago

Load Excel File from FileShare to Cube through a Workflow Profile

Hi, I have a (.csv) file in my File Share Folder that I want to read and load into the cube using a Workflow Profile. I have written an extensibility rule for getting that file and reading the file...
Connectors
Extenders
JackLacava's avatar
JackLacava
Honored Contributor
11 months ago

Look at the "Connector Rule" section in this page https://documentation.onestream.com/release_8.1/Content/Design%20and%20Reference/Application%20Tools/Business%20Rule%20Types.html

As mentioned by MarcusH  though, this is not a great approach for the simple case. I'd try to set it up as a Delimited File source instead, and use Batch Processing to automate the actual collection. Connectors are really for situations where Delimited/Fixed/Matrix file loads are not possible - e.g. direct db or ERP connections.