Data Migration Survey - Service Provider Questionnaire

Question Title

* 1. NB: your personal details and answers will be kept strictly confidential and only used with your explicit permission to contact you in the context of this TM Forum study and iPod Touch prize.

Name:

Company:

Title:

Email Address:

Question Title

* 2. Which of the following factors do you feel make the biggest contribution to success of data migration projects in your company? Please rank your top 3 items.

	1	2	3
Business engagement	Business engagement 1	Business engagement 2	Business engagement 3
Technical expertise in data migration	Technical expertise in data migration 1	Technical expertise in data migration 2	Technical expertise in data migration 3
Choice of strategy	Choice of strategy 1	Choice of strategy 2	Choice of strategy 3
Knowledge of our data	Knowledge of our data 1	Knowledge of our data 2	Knowledge of our data 3
Data quality	Data quality 1	Data quality 2	Data quality 3
Scope change control	Scope change control 1	Scope change control 2	Scope change control 3
Program governance	Program governance 1	Program governance 2	Program governance 3
Migration method	Migration method 1	Migration method 2	Migration method 3
Migration technology	Migration technology 1	Migration technology 2	Migration technology 3

Other (please specify)

Question Title

* 3. Which of the following factors do you feel make the biggest contribution to failure of data migration projects in your company? Please rank your top 3 items.

	1	2	3
Business engagement	Business engagement 1	Business engagement 2	Business engagement 3
Technical expertise in data migration	Technical expertise in data migration 1	Technical expertise in data migration 2	Technical expertise in data migration 3
Choice of strategy	Choice of strategy 1	Choice of strategy 2	Choice of strategy 3
Knowledge of our data	Knowledge of our data 1	Knowledge of our data 2	Knowledge of our data 3
Data quality	Data quality 1	Data quality 2	Data quality 3
Scope change control	Scope change control 1	Scope change control 2	Scope change control 3
Program governance	Program governance 1	Program governance 2	Program governance 3
Migration method	Migration method 1	Migration method 2	Migration method 3
Migration technology	Migration technology 1	Migration technology 2	Migration technology 3

Other (please specify)

Question Title

* 4. Data migration expertise – how much data migration expertise do you have in your business?

None, we use a systems integrator

None, we hire contract staff as required

Some, but we mainly rely on a systems integrator / contract staff

Quite a lot, but we also use a systems integrator / contract staff

A lot, we deliver our own projects

Question Title

* 5. Data migration method – your business

Does not use a formal method for data migration

Has a method, but does not always use it

Has a method and usually uses it

Always uses a formal method for data migration

Question Title

* 6. Service disruption – in general, how important is maintaining your services throughout the duration of a data migration?

Not very - a multi-day outage is acceptable

Quite important - we can only afford some downtime, overnight and weekends

Very important – we can only afford downtime during short periods overnight

Essential / business critical – we cannot afford any downtime - our service is 24/7

Question Title

* 7. Please characterize your company’s experience with application data migrations.

	Never	Sometimes	Often	Always
Deliver within the original project timescale	Deliver within the original project timescale Never	Deliver within the original project timescale Sometimes	Deliver within the original project timescale Often	Deliver within the original project timescale Always
Are delivered within budget	Are delivered within budget Never	Are delivered within budget Sometimes	Are delivered within budget Often	Are delivered within budget Always
Deliver the intended business benefits	Deliver the intended business benefits Never	Deliver the intended business benefits Sometimes	Deliver the intended business benefits Often	Deliver the intended business benefits Always

Question Title

* 8. For current applications data migrations do you mostly:

Use internal development resources to generate migration scripts

Use a 3rd party ETL (Extract, Transform, Load) tool

Use a specialist Real-time data migration software platform

Question Title

* 9. Migration approach – when considering a data migration, which of the following strategies has your company employed?

	Have used	Plan to use	Indicate most common approach	Indicate most successful approach
Don’t migrate (Greenfield build)	Don’t migrate (Greenfield build) Have used	Don’t migrate (Greenfield build) Plan to use	Don’t migrate (Greenfield build) Indicate most common approach	Don’t migrate (Greenfield build) Indicate most successful approach
Big bang	Big bang Have used	Big bang Plan to use	Big bang Indicate most common approach	Big bang Indicate most successful approach
Incremental (by business process)	Incremental (by business process) Have used	Incremental (by business process) Plan to use	Incremental (by business process) Indicate most common approach	Incremental (by business process) Indicate most successful approach
Parallel running trickle (zero downtime)	Parallel running trickle (zero downtime) Have used	Parallel running trickle (zero downtime) Plan to use	Parallel running trickle (zero downtime) Indicate most common approach	Parallel running trickle (zero downtime) Indicate most successful approach
Phased migration (by Line of Business/Business Unit or similar)	Phased migration (by Line of Business/Business Unit or similar) Have used	Phased migration (by Line of Business/Business Unit or similar) Plan to use	Phased migration (by Line of Business/Business Unit or similar) Indicate most common approach	Phased migration (by Line of Business/Business Unit or similar) Indicate most successful approach
Initial big-bang plus deltas	Initial big-bang plus deltas Have used	Initial big-bang plus deltas Plan to use	Initial big-bang plus deltas Indicate most common approach	Initial big-bang plus deltas Indicate most successful approach
Other	Other Have used	Other Plan to use	Other Indicate most common approach	Other Indicate most successful approach

Question Title

* 10. Migration activities – when running a data migration, please prioritize the following in order of importance to you:

	irrelevant 0	helpful 1	important 2	critical 3
Program governance	Program governance irrelevant 0	Program governance helpful 1	Program governance important 2	Program governance critical 3
Migration budgeting	Migration budgeting irrelevant 0	Migration budgeting helpful 1	Migration budgeting important 2	Migration budgeting critical 3
Migration planning	Migration planning irrelevant 0	Migration planning helpful 1	Migration planning important 2	Migration planning critical 3
Program initiation	Program initiation irrelevant 0	Program initiation helpful 1	Program initiation important 2	Program initiation critical 3
Orchestration with business processes	Orchestration with business processes irrelevant 0	Orchestration with business processes helpful 1	Orchestration with business processes important 2	Orchestration with business processes critical 3
Data profiling	Data profiling irrelevant 0	Data profiling helpful 1	Data profiling important 2	Data profiling critical 3
Data cleanse	Data cleanse irrelevant 0	Data cleanse helpful 1	Data cleanse important 2	Data cleanse critical 3
Data mapping	Data mapping irrelevant 0	Data mapping helpful 1	Data mapping important 2	Data mapping critical 3
Migration scheduling	Migration scheduling irrelevant 0	Migration scheduling helpful 1	Migration scheduling important 2	Migration scheduling critical 3
Migration dashboards and status	Migration dashboards and status irrelevant 0	Migration dashboards and status helpful 1	Migration dashboards and status important 2	Migration dashboards and status critical 3
Stakeholder reporting	Stakeholder reporting irrelevant 0	Stakeholder reporting helpful 1	Stakeholder reporting important 2	Stakeholder reporting critical 3
Change Data Capture (CDC)	Change Data Capture (CDC) irrelevant 0	Change Data Capture (CDC) helpful 1	Change Data Capture (CDC) important 2	Change Data Capture (CDC) critical 3
Error management	Error management irrelevant 0	Error management helpful 1	Error management important 2	Error management critical 3
Audit trail	Audit trail irrelevant 0	Audit trail helpful 1	Audit trail important 2	Audit trail critical 3
Data Migration software: Flexibility	Data Migration software: Flexibility irrelevant 0	Data Migration software: Flexibility helpful 1	Data Migration software: Flexibility important 2	Data Migration software: Flexibility critical 3
Reliability	Reliability irrelevant 0	Reliability helpful 1	Reliability important 2	Reliability critical 3
Reusability	Reusability irrelevant 0	Reusability helpful 1	Reusability important 2	Reusability critical 3

Others (please specify activity and rank)

Question Title

* 11. How well does your current solution support this activity?

	not at all 0	poorly 1	adequately 2	well 3	completely 4
Program governance	Program governance not at all 0	Program governance poorly 1	Program governance adequately 2	Program governance well 3	Program governance completely 4
Migration budgeting	Migration budgeting not at all 0	Migration budgeting poorly 1	Migration budgeting adequately 2	Migration budgeting well 3	Migration budgeting completely 4
Migration planning	Migration planning not at all 0	Migration planning poorly 1	Migration planning adequately 2	Migration planning well 3	Migration planning completely 4
Program initiation	Program initiation not at all 0	Program initiation poorly 1	Program initiation adequately 2	Program initiation well 3	Program initiation completely 4
Orchestration with business processes	Orchestration with business processes not at all 0	Orchestration with business processes poorly 1	Orchestration with business processes adequately 2	Orchestration with business processes well 3	Orchestration with business processes completely 4
Data profiling	Data profiling not at all 0	Data profiling poorly 1	Data profiling adequately 2	Data profiling well 3	Data profiling completely 4
Data cleanse	Data cleanse not at all 0	Data cleanse poorly 1	Data cleanse adequately 2	Data cleanse well 3	Data cleanse completely 4
Data mapping	Data mapping not at all 0	Data mapping poorly 1	Data mapping adequately 2	Data mapping well 3	Data mapping completely 4
Migration scheduling	Migration scheduling not at all 0	Migration scheduling poorly 1	Migration scheduling adequately 2	Migration scheduling well 3	Migration scheduling completely 4
Migration dashboards and status	Migration dashboards and status not at all 0	Migration dashboards and status poorly 1	Migration dashboards and status adequately 2	Migration dashboards and status well 3	Migration dashboards and status completely 4
Stakeholder reporting	Stakeholder reporting not at all 0	Stakeholder reporting poorly 1	Stakeholder reporting adequately 2	Stakeholder reporting well 3	Stakeholder reporting completely 4
Change Data Capture (CDC)	Change Data Capture (CDC) not at all 0	Change Data Capture (CDC) poorly 1	Change Data Capture (CDC) adequately 2	Change Data Capture (CDC) well 3	Change Data Capture (CDC) completely 4
Error management	Error management not at all 0	Error management poorly 1	Error management adequately 2	Error management well 3	Error management completely 4
Audit trail	Audit trail not at all 0	Audit trail poorly 1	Audit trail adequately 2	Audit trail well 3	Audit trail completely 4
Data Migration software: Flexibility	Data Migration software: Flexibility not at all 0	Data Migration software: Flexibility poorly 1	Data Migration software: Flexibility adequately 2	Data Migration software: Flexibility well 3	Data Migration software: Flexibility completely 4
Reliability	Reliability not at all 0	Reliability poorly 1	Reliability adequately 2	Reliability well 3	Reliability completely 4
Reusability	Reusability not at all 0	Reusability poorly 1	Reusability adequately 2	Reusability well 3	Reusability completely 4

Others (please specify activity and rank)

Question Title

* 12. Please estimate the number of data migration projects your company executes each year. Please include programs where data migration forms a significant part (>15%) of the total budget.

None

1-5

6-10

10-20

More than 20

Question Title

* 13. What average proportion of IT project budgets would you estimate your company spends on data migration?

Less than 15%

15-25%

25-35%

More than 35%

Question Title

* 14. Which TM FORUM materials/components has your company made use of in data migration projects?

	Yes	No
Business Process Framework (e-TOM)	Business Process Framework (e-TOM) Yes	Business Process Framework (e-TOM) No
Information Framework (SID)	Information Framework (SID) Yes	Information Framework (SID) No
Integration Framework (Business Services [NGOSS Contracts])	Integration Framework (Business Services [NGOSS Contracts]) Yes	Integration Framework (Business Services [NGOSS Contracts]) No
Application Framework (TAM)	Application Framework (TAM) Yes	Application Framework (TAM) No

Question Title

* 15. If you have further thoughts and experiences you feel would be relevant to the study, please enter them here or ask us to contact you to discuss further.

Thank you for taking the time to complete this survey.

Question Title

* 16. Would you like to participate in the TM Forum Data Migration Community to address hot data migration issues?

Yes

Question Title

* 17. Are you happy to be contacted to discuss your answers to this survey further?

Yes