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

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