[Cloud release: 2025.05.27]
[On-prem release: n/a]
[On-prem build: n/a]
This is a Cloud-only feature.
From an InMemory ETL project, you can import files that have been stored in the TARGIT Servers virtual file system (VFS).
The supported file types that can be imported in this way, are:
- CSV
- Excel
- JSON
- XML
Example: With an open TARGIT Designer client, a TARGIT user can manually drag and drop CSV files, Excel files, etc. from the PC's file system into the Shared folder or any subfolder in the VFS. Then, when setting up a new data source in an InMemory ETL project, these files can be accessed by using the new 'VFS' file type.
TARGIT Server Configuration
Your TARGIT Server needs to be configured with a new Service Account that allows access to the VFS.
Open your TARGIT Management client and go to 'Service accounts' to add a new account:
Set these properties:
- Name: Any name will work.
- Features selected:
- VFS access
- Access personal folders for all users (optional)
TARGIT Scheduler Management configuration
Open the TARGIT Scheduler Management client to create three Secrets to be used in the InMemory ETL data source.
The Key names for the three secrets can be any name. In this example, the names correspond to the screenshot below.
- VfsServerURL: In the Value field, enter the URL to the TARGIT Server. Example: https://BiDevServer.company.com
- VfsServiceAccountID: In the Value field, paste the Service account ID from the Service account you created in the TARGIT Management client.
- VfsServiceAccountKey: In the Value field, paste one of the Service account keys from the Service account you created in the TARGIT Management client.
Usage in InMemory ETL project
In the InMemory ETL project, when setting up a new data source to one of the specified file types, you will have an option to select the 'VFS' file type.
Furthermore, the Service account ID, the Service account key and the Server url can all be selected from the secrets that you created in the Scheduler Management client.
To import a file from the VFS, you add an Import task in the ETL project, an use a SELECT statement to import data.
Comments
Please sign in to leave a comment.