Data extraction involves working with your existing software systems to retrieve the maximum amount of useful data. This not only avoids the manual entry of data but maximizes the usefulness of your currently known data so that employees are assigned to the correct pay policies, schedules and rules from the beginning of your implementation. Examples of data extraction are:
- Connecting directly to your existing software’s database where export functionality is not natively available
- Manipulating data from disparate sources based on common key fields such as employee identifiers or SSN to build up a complete employee profile
- Importing of manipulated data directly into the SBV software through the native import functionality
- Importing data using SQL Management Studio where a native import is not available
- Database manipulation of SBV data through either custom SQL scripts, or export, manipulation and re-importing of Excel based data
- Custom programming to connect to your existing data, manipulate and import. Updating is used when parallel processing is required and your existing data is still live and being maintained as you switch over to the SBV software
- Parallel punch processing of data that is retrieved by your existing time management software while transitioning to your new software, This also allows you to review the calculations in your new software while maintaining your existing software allowing you to switch over seamslessly from one pay period to the next
SBV has experience with transitioning clients from the following time management softwares:
- ADP
- Infinitime
- Infotronics (Attendance on Demand)
- Jantek
- Jupiter
- Kronos
- Novatime
- SmartLinx
- TCS
SBV has worked with the following types of legacy and current databases and data formats
- Access
- Btrieve
- DBF
- SQL Server (2000 to 2016)
- Sybase
- Text (Fixed Width, CSV)
- Topscan