Right-click on the
Datasources
folder in the Project Explorer and select
New -
> Data Source Model.
Note:
The Data Sources special folder can be created if it is not available in project.
To create new Data Source special folder do the following:
Right click on project, Select
New- > Folder
Provide a name for the folder and Click
Finish
Right click on newly created folder and Select
Special Folders - > Use as Datasource Folder.
The New Data Source Wizard is displayed.
.
Specify a name for the Data Source Model file in the
File Name field.
Click
Next.
The data source property page is displayed.
Enter the Data Source Name and Description in the
Name and
Description fields.
Select the
Data Source Format. The available options are:
Delimited
Fixed Length
Database
The rest of the fields vary depending on the format selected. For example, if you have selected the
Database format, only
Name, and
Description fields are displayed.
Delimiter Character. Select the appropriate delimiter character from the drop-down. The delimiter character can be a Comma, Pipe, Semicolon, Colon, Space, Tab, or Other character.
Text Qualifier. Select the appropriate Text Qualifier from the drop-down. The text qualifies can be a double quote, Single quote, or any other qualifier.
Click
Next.
Note:
Data field may contain Delimiter character. In such case data field should be enclosed with Text Qualifier.
The backslash (\) is not supported as delimiter.
The data source file selection page is displayed.
Select the
Copy data source file in the project checkbox to include the data files in the project. Browse to the folder where the data source file is saved and select the data file. Click
Finish.
Note: You can create a data source without selecting the
Copy data source file in the project checkbox. The data source is created without the data file in the project folder.
When Data Source Format selected is
Fixed Length.The
Data Source Attributes section is displayed. Create the Data Source attributes for the Fixed Length Data Source.
