Data Integration & Migration Strategies
This section addresses the needs and challenges of today's Systems Integrators.Technologists working in the system integration space need a practical roadmap that facilitates efficient decision making. OpenLink staff are experts in the complex realm of data integration and data migration and provide Technical Support and Professional Services products aimed at architecting your integration-based solution. We provide the following strategies fact sheet to jumpstart and guide your project from the planning to deployment phases.
1. Access all legacy holdings. Know the Operating Systems, DBMSs, Networking Protocols, Client Applications, Data Access Middleware, Coding Languages, and other components that compose the background of your data infrastructure.
2. Define and rank the Objectives driving your data migration or integration project. Objectives are not limited but may include:
- Consolidation of Heterogeneous Systems & Processes
- Core Component Reusability
- Enhanced and/or Integrated Security
- Enterprise Performance & Reliability
- Replacement of EOL, Proprietary Components
- Standards Based Solution
- Support for Web Services, SOA, RDF, etc.
3. Fully-familiarize yourself with the use and limitations of popular tools such as Microsoft SQL Server Linked Servers and Oracle HSODBC. Hear OpenLink technical staff discuss use cases associated with these technologies.
|
|
|
5. Choose your solution.
6. Finalize your deployment architecture using OpenLink's architectural planning resources for UDA or Virtuoso.
7. Download and install your software.
8. Review OpenLink's extensive library of data integration & migration articles to locate installation & configuration instructions for your chosen solution.
- Configure HP/UX HSODBC for ODBC Data Acces (8i)
- Configure HSODBC for ODBC Data Access (8.1.x)
- Configure HSODBC for ODBC Data Access (9i+)
- Configure Microsoft SQL Server DTS Imports using the OpenLink OLE DB Provider
- Configure Microsoft SQL Server DTS Imports using the Microsoft OLE DB Provider
- Configure Microsoft SQL Server 2005 Linked Servers using the OpenLink OLE DB Provider
- Configure Microsoft SQL Server 2005 Linked Servers using the Microsoft OLE DB Provider
- Configure Microsoft SQL Server 2000 Linked Server using the OpenLink OLE DB Provider
- Configure Microsoft SQL Server 2000 Linked Server using the Microsoft OLE DB Provider


