Skip to main content
R
Ricardo_Mil
Newcomer
December 9, 2022
Solved

Import files from FTP Connection

  • December 9, 2022
  • 3 replies
  • 0 views

Hello,

I'am newly at OneStream and now I have a requirement from a client:

- They want to import, automatically, files that will be data source of a Workflow Profile = import;

1. Those files are on FTP (FTP connection), that means that I need to add on the current application server, a connector type = gateway, right?  Also, what I need to define on the connection string?

Ricardo_Mil_0-1670591780953.png

2. Then I need to create a BR for the connector;

3. Since the files are "delimited files", so on the Data Sources menu, I need to create a new Data source - delimited file and map the columns to the correspondent dimensions that exists in OneStream right? Also, on the connector setting option, I need to assign the delimited file to the BR connector that I created previously, right?  

connector type.PNG

 4. On the Workflow Profile, I will assign it to the new delimited file.

 

Are these the correct steps?

Thank you all.

Ricardo

 

 

Best answer by JoakimK

Hello Ricardo,

Unfortunately you cannot setup a SFTP in that manner, by leveraging the connectors.

1. Since you are using flatfiles, the import type (and datasource) will first and foremost be setup as a Flat File (not a connector)

2. This means the Workflow will now be enabled to manually import files. Now you need to setup a process to automate this from the SFTP, and for this you would need a Business Rule that will contain all the connection details as well as file copy process from the SFTP.

3. Once that Business Rule is in place, you can setup a DataManagement job to schedule this for automation, or you can setup a dashboard with a button to the same DataManagement job, that will allow you to attach the dashboard to the Workflow and have the user themselves kick off the file retrieval process.

 

The overall process described here is very high level, and there are many further factors to consider, such as how to identify each file for each workflow, do you need to move the files or just copy, do you need to archive the files etc.

If you are working with an implementation partner, they should be able to assist you with all this, but if you want help from us directly you can reach out to our support team who will forward the request to our Advanced Application Solutions team who can then discuss with you how we could assist.

 

Joakim

3 replies

J
OneStream Employee
JoakimKOneStream EmployeeAnswer
OneStream Employee
December 9, 2022

Hello Ricardo,

Unfortunately you cannot setup a SFTP in that manner, by leveraging the connectors.

1. Since you are using flatfiles, the import type (and datasource) will first and foremost be setup as a Flat File (not a connector)

2. This means the Workflow will now be enabled to manually import files. Now you need to setup a process to automate this from the SFTP, and for this you would need a Business Rule that will contain all the connection details as well as file copy process from the SFTP.

3. Once that Business Rule is in place, you can setup a DataManagement job to schedule this for automation, or you can setup a dashboard with a button to the same DataManagement job, that will allow you to attach the dashboard to the Workflow and have the user themselves kick off the file retrieval process.

 

The overall process described here is very high level, and there are many further factors to consider, such as how to identify each file for each workflow, do you need to move the files or just copy, do you need to archive the files etc.

If you are working with an implementation partner, they should be able to assist you with all this, but if you want help from us directly you can reach out to our support team who will forward the request to our Advanced Application Solutions team who can then discuss with you how we could assist.

 

Joakim

    R
    Ricardo_MilAuthor
    Newcomer
    December 15, 2022

    Hi Joakim,

    Thanks for your reply!

    Best regards,

    Ricardo

    D
    DanielWillis
    Contributor
    February 11, 2023

    I'd recommend checking out the new Smart Integration Connector to see if it's a fit. I think there's a webcast about it next week if it wasn't this week and there is also a training course already out on the training platform which goes into a lot of detail. 

    V
    vmanojrc30
    Contributor
    February 13, 2023

    Hi Daniel

    I believe SIC is applicable only for cloud OS applications. We are using On premise OS apps.

    Thanks

    Manoj

    Terms & ConditionsAccessibility statement