pasTransfer Integrates with OnQ
Written By Jennifer Gatling
The pasTransfer ETL tool has the ability to consume a wide variety of data sources from the OnQ application suite using a variety of custom sources located in the Ledger Wizard. This data can then be easily transformed, aggregated, mapped, and exported to a wide range of destination systems (including back office ledger and BI tools).
We commonly integrate with the following types of OnQ reports:
There are many benefits associated using pasTransfer to integrate with OnQ but here are some of our biggest benefits:
pasTransfer works directly in conjunction with other products in the pasUNITY Enterprise Suite to fully automate the OnQ integrations. There are many options as to how the report gets exported from OnQ and processed by pasTransfer. A few of the common delivery methods we offer are receiving reports through FTP, email, direct upload to the matrix or even dropping the OnQ reports in a specific folder on the server for processing. We also provide an audit trail that shows exactly what data was processed in the destination system which is useful for compliance purposes.
In closing, integrating with OnQ can be extremely useful to any company (regardless of size) who deal with report/data generation for multiple properties on a daily basis. pasTransfer can help to improve both time and efficiency on normal reporting related OnQ tasks.
TagsBirchStreetChoiceExcelFintechFTPFTPSMacrosMappingODBCOLEDBOnQOperapasTransferpasUnityPMSSFTPSQL ServerSQLServerUniversal ConnectionsValidationXML