Dela via


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
Email 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'.