NDS Support Portal

Welcome to our support portal. Below are different areas of content around our product and services.

 

Additionally, you may contact the NDS Help Desk toll free at (866) 789-7590 or via e-mail at: NDSHelpDesk@usa.childcareaware.org. The Help Desk is available to 8 am to 6 pm Eastern Time, Monday through Friday.

 

If you are looking for program details around NDS, they can be found here: http://usa.childcareaware.org/programs-services/naccrra-data-services.

 

Visit our NDS blog here: http://nds.naccrra.org/blogs

 

In order to post a question or comment, please Login or Register.




Index Database Merge
Previous  |  Next

 1      NDS Quarterly Newsletter Volume 1: Spring 2013
 1.1        NDS Quarterly Newsletter Volume 2: Summer 2013
 1.2        NDS Quarterly Newsletter: Volume 3 Fall 2013
 2      NDS Quarterly Newsletter Volume 4: Spring 2014
 3      KIDS MATTER App- Data Export Instructions
 4      Quality Indicators-Description and Access
 5      Child Care Online Webinar-Indiana's Child Care Programs
 6      Best Practices for Configuring Online Provider Services
 7      Quick Search Tips
 8      Best Practices for Configuring the Online Referral Module (ORM)
 9      Using NACCRRAware Standard Reports for Data Checking
 10       Database Merge
 11       Database Maintenance - Purging Old Records
 12       Quality Indicators Focus Group Expectations
 13       OPS Help Screens
 13.1         OPS Announcements
 13.1.1           OPS Announcement Overview
 13.1.2           Create a New OPS Announcement
 13.2         OPS Agency Attachments
 13.2.1           OPS Agency Attachment Overview
 13.2.2           Create a New OPS Agency Attachment
 13.3         OPS Field Configuration
 13.3.1           OPS Field Configuration Overview
 13.3.2           OPS Field Configuration - General Fields
 13.3.3           OPS Field Configuration - Provider Fields
 13.4         OPS Profile Configuration
 13.4.1           OPS Profile Configuration Overview
 13.4.2           OPS Profile Configuration - Profile Settings
 13.4.3           OPS Profile Configuration - Page Configuration
 13.4.4           OPS Profile Configuration - Section Settings
 13.4.5           OPS Profile Configuration - Profile Header and Footer
 13.4.6           OPS Profile Configuration - Previewing Your Profile(s)
 13.5         OPS Provider Profile Management
 13.5.1           OPS Provider Profile Management Overview
 13.5.2           OPS Provider Profile Management - Creating OPS Access for a Provider
 13.5.3           OPS Provider Profile Management - Viewing an Existing OPS Provider Record
 13.5.4           OPS Provider Profile Management - Provider Summary Screen
 13.5.5           OPS Provider Profile Management - Provider Attachments
 13.5.6           OPS Provider Profile Management - Questions and Answers
 13.5.7           OPS Provider Profile Management - Provider Update Log
 13.6         OPS Provider Change Review and Approval
 13.6.1           OPS Provider Change Review and Approval - Overview
 13.6.2           OPS Provider Change Review and Approval - Viewing and Managing Provider Changes
 14       Quality Indicators Overview
 15       OPS Profile Tool Tip and Profile Worksheet
View  |  Print  |  PDF

45 documents found.


Database Merge

database
Agency-Merge

 

Overview

The most common reason we receive request for database merges and occasioally a split across several databases is consolidation of services. When service delivery areas in a region or state change, database records may need to be moved (merged) from one or more existing databases to another. Merging databases involves transferring a set of records from one database to another.  Once two databases are merged, the users from each original database have access to all merged records in one database. “Unmerging” a database is tedious, time-consuming and expensive therefore agencies are cautioned to consider the implications of such merge prior to making the request.

Configurable Field Synchronization

Prior to a database merge, all configurable fields must be synchronized. This means that the values in the configurable fields must match exactly as far as spelling, case of letters, spacing, and punctuation. This can be done manually by a user with administrator access to both databases. The administrator must log in to both databases and compare the values in each configurable field (General, Provider, Client and Community sections). The order of the values is not important but the field values must be exact. For example, the following values DO NOT MATCH: Outdoor Play Equipment, Outside Play Equipment, Outdoor play equipment, Out-door Play Equipment, and Outdoor  Play  Equipment (double spacing between words). Any differences found must be corrected to the desired or right configuration.

NACCRRA Data Services (NDS) offers an optional synchronization (sync) report that does the comparison of the configurable field values of the databases. If requested by the agency, three (3) reports can be requested in a 30 day period allowing the administrator to modify the configuration and verify that the new configuration matches. The cost for this set of reports (3 reports in a 30 day period) is $250 and can be requested using the Advanced Support Request form available also on the NDS Forms page from the organization webiste http://www.naccrra.org/programs-services/naccrras-suite-of-data-services/forms

Merge Process

Once the configurable fields in the two merging databases are synchronized, the process can begin. The NDS team will schedule the time to begin the merge with both agencies. A database specialist from each agency is required to be available to review the merged data and report any issues.

1. Merge in Test Environment

The merge is first scheduled in a test environment. In a test environment, no live data is merged and agency users are able to continue working in their live database as usual. The database specialists will receive confirmation once the merge test is complete and will have a couple of days to conduct a thourough testing. During the testing phase, comparisons should be made between the merged database and the live production databases. Scanning existing records and running reports are the best ways to complete this step. We provide agencies with an outline of testing steps they can follow.

If any issues are reported with the test merge, the Help Desk team will work with the database specialists to identify the issue and help correct it. Once corrected, a second test merge is run for review and approval.

2. Merge in Production: "Going Live"

Once the test merge is approved, the merge of the live databases is scheduled. During this time, we require all users from both agencies to log out of the databases and the online referrals turned off (IMM or ORM). Following the merge the database specialists will need to review and sign off before using the newly merged database for referrals, updates, or any other functions.

Database Merge Cost

The cost for the database merge process is $125/hour. Merges generally require anywhere from 2-6 hours to complete. Merging two or more databases can be requested using the Advanced Support Request form. Once the form is received and the requirements of the merge reviewed, an estimate of cost and timeline can be provided to the agency.


Previous  |  Next