Cloud Data Warehousing
Store and integrate data from multiple sources into a common format using the cloud data warehouse.
- Does the solution support multiple business units with different plans, pay schedules, and calendars in a single instance?
- Does the solution support unlimited user-defined time units?
- What types of APIs and Web Services are available?
- Is reloading a data file supported?
- Are historical data loads supported?
- Does the system support data loads like flat-files, i.e. CSV, database, SFTP, and API, for different sources and with field mapping?
- Are integrations with Salesforce, Microsoft Dynamics 365, and Oracle available?
- Are integrations (both incoming and outgoing) like CRM, ERP, HRIS, and payrolls included?
- What out-of-the-box integrations are available for systems such as CRM, HRIS, ERP etc.?
- Does the system accept and process updates from a legacy source system in real-time batch mode, as required by the user, such as nightly, weekly, or twice daily?
- Does the system include out-of-the-box integrations with other reporting tools, such as Tableau or Microsoft Power BI, etc.?
- Does data movement between Optymyze and CRM include API connections and SSO?
- Does the system support mass update (bulk) loads?
- Does the solution support importing data based on user-defined timing (hourly, nightly, weekly, monthly, real-time)?
- Are there any restrictions on how much data can be stored on the servers?
- Does the solution support an entire period of data or partial period to be removed and reloaded?
- Is future-dated data excluded from production calculations?
- Is transformation supported natively within the solution for data on input?
- How is cloud data warehousing better than on-premise?
- What are the advantages of using cloud computing?
- Are data structures and data relationships editable?
- Does the solution allow hierarchies to be imported from another source system?
- Does the solution allow a single payee to be assigned to multiple positions at the same time with a single ID?
- Are there limits to the number of hierarchies or levels within those hierarchies?
- Are there limits to the number of hierarchies the system will support?
- Are rules supported to automatically assign payees into a hierarchy?
- Are account, geography, and product hierarchies supported? Does this include alternate hierarchies for other attributes as needed, to define the territory structure?
- How are hierarchies modified?
- Are hierarchies effective dated and visible to the user with date selection available?