Skip to Content

Starting up with Services Designer

1)      Logging in with local repository by entering the corresponding details about the user and repository.

                Loggin in Repository.jpg                            

2)      Creating new Project,

Project creation.jpg

3)      Creating new Data stores for Source, target in the corresponding Project.

      New Datastore.jpg

               New DS.jpg

                 New DS1.jpg

                    

                   New DS2.jpg

                      New DS3.jpg

Various Sources of data in Data Services

There can be various sources of data for DS and these are some of the sources.

1)      Flat file

FF1.jpg

The root directory and the filename is selected and other parameters such as Delimiters, format are also entered.

In the root directory, select the folder where our flat file have been saved and in File name, select the flat file.

Once we save this, our flat file will saved and this can be used as Source for transformations.

To select the already existing file format, we can select the existing file and select Replicate.

FF2.jpg

2)      Excel worksheet

In the root directory, select the folder where our excel file have been saved and in File name, select the excel file.

Once we save this, our excel file will saved and this can be used as Source for transformations.

Excel.jpg

3)      XML source

The filename/ URL are selected and the root element is entered.

Once this is saved, this XML file can be used as a source for the transformations.

XML.jpgrav

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply