Course : Semarchy xDI Data IntegrationThe high-performance Extract Transform Load
Practical course - 3d
- 21h00 - Ref. SXD
|
Download in PDF format
Share this course by email
 | Be able to build ELT/ETL flows with Semarchy's data integration tool |
| Understand how Semarchy xDI is organized and set up in its environment |
| Getting to grips with Semarchy's graphical interface under Eclipse |
| Manage different data access connectors |
| Exploiting data flow projects |
Intended audience
Anyone in the IT department in charge of processing business intelligence or big data.
Prerequisites
Knowledge of SQL language or database data manipulation.
Practical details
Teaching methods
Active
Course schedule
1 Installation and architecture of the Semarchy xDI Data Integration solution
- Semarchy xDI organization
- Semarchy xDI and cloud computing
- How to deploy and install Semarchy Data Integration
- Advanced settings
2 Semarchy's graphical integration with Eclipse: how to get your bearings?
- Where do we stand in terms of job referencing and development?
- Workspace
- Organization of data processing projects and files within the repository
- Management of development versions and backtracking on history
- Eclipse (Java) and Semarchy xDI views
3 Management of connectors to various data sources (RDBMS, NoSQL, CSV, XML)
- Database connection and reverse (cloud on premise)
- Connecting and organizing flat-file data
- Connecting and obtaining the XML file schema
Hands-on work
Identify the various data sources and apply the appropriate connections.
4 Development of data flow projects in Semarchy xDI
- Development of data mappings from A to Z: sources, filters, joins, staging, reject management...
- Process development: links, files, variables and session variables
- Testing and execution
Hands-on work
Execute a project with full mapping and in-depth process.
5 Creation of XML-generating data flows and implementation of web services
- XML file generation with Semarchy xDI
- Interrogation of web services (HTTP Rest, SOAP)
- Creation of a middleware-type web services exhibition system
Hands-on work
Create a data flow with XML and create a web service.
6 Advanced development
- Templates
- Technologies and the associated XPath language
- Advanced processes
Hands-on work
Apply advanced workflows to a project.
7 Implementation of Semarchy xDI jobs and web services from the web interface (and Stambia analytics)
- The administration panel
- Session Reports
- Packages
- Log
- Deliveries
- Running data replications
- Scheduling, automating processing
Hands-on work
Configure a project from A to Z and put it into operation.
PARTICIPANTS
Anyone in the IT department in charge of processing business intelligence or big data.
PREREQUISITES
Knowledge of SQL language or database data manipulation.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
Anyone in the IT department in charge of processing business intelligence or big data.
PREREQUISITES
Knowledge of SQL language or database data manipulation.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TEACHING AIDS AND TECHNICAL RESOURCES
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.