It works by exporting files from GP and putting them to a shared directory or SFTP site where it is then consumed by Vena.
Providing the bridge between Vena & Dynamics GP
Vena provides business intelligence reporting and data reconciliation.
What is Opal’s Vena Connector?
Opal’s Vena Connector is an application that bridges data in Dynamics GP and Vena
FAQ
How does the Vena connector work?
The OBS Vena Connector Tool is configured with user credentials that runs a Windows Scheduled Task that then executes a procedure to create the extract files on a desired frequency. The procedure can be adapted for each customer, in order to provide the required data to Vena accordingly to the template.
Where should it be installed?
It can be installed on a terminal server, the SQL Server machine, or even a workstation. Normally, the processes are somewhat transparent to the staff because it runs automatically. It can only be installed on one machine and the machine MUST have internet access; FTP ports on the firewall must be open for this machine.
What happens when GP is upgraded?
This depends on the modules licensed for Vena. For extracts going from GP to the Vena FTP site, there will probably be no changes. For extracts going from the Vena FTP site to GP, eConnect will need upgraded and it may require an update to the import module.
What modules do you currently support?
AP Sub ledger Extract, AR Sub Ledger Extract, Cash Sub Ledger Extract, GL Beginning Balances Extract, GL Transactions Extract
Who will install and configure it and how long will it take?
The implementation team will work remotely with your IT group to install and configure the OBS Vena Connector Tool. The IT group will need to supply credentials for SQL Server, Windows account credentials for the task scheduler, and Vena login credentials. The setup usually takes about an hour to complete.
How will the period end dates be determined?
The Account Reconciliations and Subledger Reconciliations requires that a period end date be used to pull balances. To determine the period end date, use the oldest open period in the within the Fiscal Period Setup window in GP.
CURRENTLY SUPPORTED
Vena Connector Pricing
- VENA CONNECTOR
- Custom Connector per Quote
- 20% Annual Enhancement Fee
- $1,495
Connector Core Engine - +$495 per Module
