Vena Solutions (Preview)
Vena’s interface pairs the best parts of Excel and the power of a full finance-led planning solution so you can streamline your workflows without upending your processes. Connect to Vena to import data from a file into your cube, or to export data from your cube to a file.
This connector is available in the following products and regions:
| Service | Class | Regions |
|---|---|---|
| Logic Apps | Standard | All Logic Apps regions except the following: - Azure Government regions - Azure China regions - US Department of Defense (DoD) |
| Power Automate | Premium | All Power Automate regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Power Apps | Premium | All Power Apps regions except the following: - US Government (GCC) - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
| Contact | |
|---|---|
| Name | Vena Customer Support |
| URL | https://www.venasolutions.com/contact-support |
| support@venacorp.com |
| Connector Metadata | |
|---|---|
| Publisher | Vena Solutions |
| Website | https://venasolutions.com/ |
| Privacy policy | https://venasolutions.com/privacy-policy/ |
| Categories | Finance |
Vena's Power Automate connector allows you to connect with external source systems that are not currently available through Vena's traditional integration methods, and may be used to import data on an ongoing basis. For example, when a new file is added to Dropbox, an automated workflow can instantly bring a copy of the file into the Vena cube. Vena's connector lets you execute an ETL job to import data from a file into the cube, or to export hierarchies, attributes, values, or LIDs from a model to a file.
Prerequisites
You will need a vena.io account with Admin permissions, and if Data Permissions are set up for your environment, you will also need the appropriate permissions for the data that you are working with.
How to get credentials?
- Log into vena.io as an Admin user
- Navigate to the Admin tab
- Navigate to the 'Application Tokens' tab under Admin
- Select 'Add Application Token'
- Enter a name for the new Application Token and click 'Save'
- Once the token is created, it will be added to the Application Token list. Click on the newly created token and select 'Show Token''
- This will display your newly created application token credentials.
- Use 'apiUser' as the username, and 'apiKey' as the password in the Microsoft Power Automate Connector.
For more detailed instructions, please see this Vena Solutions help article.
Creating a connection
The connector supports the following authentication types:
| Default | Parameters for creating connection. | All regions | Not shareable |
Default
Applicable: All regions
Parameters for creating connection.
This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.
| Name | Type | Description | Required |
|---|---|---|---|
| username | securestring | The username for this api | True |
| password | securestring | The password for this api | True |
Throttling Limits
| Name | Calls | Renewal Period |
|---|---|---|
| API calls per connection | 100 | 60 seconds |
Actions
| Export attributes from a model |
Export attributes from a model |
| Export hierarchies from a model |
Exports hierarchies from a model |
| Export LIDs from a model |
Export LIDs from a model |
| Export values from a model |
Export values from a model |
| Trigger an ETL job to import data into Vena |
Upload hierarchy, intersections, lids, or attributes to a model |
Export attributes from a model
Export attributes from a model
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Data Model
|
modelIdPath | True | string |
Select the Vena data model |
|
Show Header
|
showHeaders | boolean |
Show headers in the export |
|
|
MQL Query String
|
queryString | string |
MQL Query |
|
|
File Format
|
format | string |
Select the file format |
|
|
File Encoding
|
encoding | string |
Select the file encoding |
Returns
- response
- string
Export hierarchies from a model
Exports hierarchies from a model
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Data Model
|
modelIdPath | True | string |
Select the Vena data model |
|
Show Header
|
showHeaders | boolean |
Show headers in the export |
|
|
MQL Query String
|
queryString | string |
MQL Query |
|
|
File Format
|
format | string |
Select the file format |
|
|
File Encoding
|
encoding | string |
Select the file encoding |
|
|
Export Member IDs
|
exportMemberIds | boolean |
Include member IDs in the export |
Returns
- response
- string
Export LIDs from a model
Export LIDs from a model
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Data Model
|
modelIdPath | True | string |
Select the Vena data model |
|
Show Header
|
showHeaders | boolean |
Show headers in the export |
|
|
MQL Query String
|
queryString | string |
MQL Query |
|
|
File Format
|
format | string |
Select the file format |
|
|
File Encoding
|
encoding | string |
Select the file encoding |
Returns
- response
- string
Export values from a model
Export values from a model
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Data Model
|
modelIdPath | True | string |
Select the Vena data model |
|
Show Header
|
showHeaders | boolean |
Show headers in the export |
|
|
MQL Query String
|
queryString | string |
MQL Query |
|
|
File Format
|
format | string |
Select the file format |
|
|
File Encoding
|
encoding | string |
Select the file encoding |
|
|
Include External IDs
|
includeExternalId | boolean |
Include the External IDs in the export |
|
|
Named Dimensions
|
isNamedHeader | boolean |
Include named dimensions in the header |
Returns
- response
- string
Trigger an ETL job to import data into Vena
Upload hierarchy, intersections, lids, or attributes to a model
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Data Model
|
modelIdPath | True | string |
Select the Vena data model |
|
ETL template
|
templateId | True | string |
Select an ETL template |
|
File name
|
fileName | True | string |
Select the file name |
|
File content to upload
|
file | True | string |
Select the file content to upload |
|
File type
|
fileType | True | string |
Select the file type |
|
File encoding
|
fileEncoding | string |
Select the file encoding |
Returns
- Body
- ETLJob
Definitions
ETLMetadata
| Name | Path | Type | Description |
|---|---|---|---|
|
schemaVersion
|
schemaVersion | integer | |
|
steps
|
steps | array of ETLStep | |
|
name
|
name | string |
ETLJob
| Name | Path | Type | Description |
|---|---|---|---|
|
status
|
status | string | |
|
pauseRequested
|
pauseRequested | boolean | |
|
templateId
|
templateId | string | |
|
errorMessage
|
errorMessage | string | |
|
userId
|
userId | string | |
|
lockProperty
|
lockProperty | string | |
|
resumable
|
resumable | boolean | |
|
user
|
user | object | |
|
createdDate
|
createdDate | integer | |
|
phase
|
phase | string | |
|
id
|
id | string | |
|
shortMessage
|
shortMessage | string | |
|
saveJob
|
saveJob | boolean | |
|
log
|
log | array of object | |
|
date
|
log.date | integer | |
|
message
|
log.message | string | |
|
lockId
|
lockId | string | |
|
rollbackRequired
|
rollbackRequired | boolean | |
|
cancelRequested
|
cancelRequested | boolean | |
|
updatedDate
|
updatedDate | integer | |
|
version
|
version | integer | |
|
requestId
|
requestId | string | |
|
error
|
error | boolean | |
|
validationResults
|
validationResults | string | |
|
attributes
|
attributes | array of string | |
|
currentStepNumber
|
currentStepNumber | integer | |
|
numCalcOverwrite
|
numCalcOverwrite | integer | |
|
metadata
|
metadata | ETLMetadata |
ETLStep
| Name | Path | Type | Description |
|---|---|---|---|
|
dataType
|
dataType | string | |
|
stepType
|
stepType | string |
string
This is the basic data type 'string'.