Поделиться через

Vena Solutions (Preview)

  • Reference

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 [email protected]
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

Operation ID:
ExportAttributes

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

Operation ID:
ExportHierarchies

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

Operation ID:
ExportLIDs

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

Operation ID:
ExportValues

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

Operation ID:
ETLUpload

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