Define the datasource in the Source tab.
Select Database or File as the datasource type.
Select Materialization with Replication Server to use Replication Server® materialization methods for loading data. Using Sybase IQIP with Replication Server materialization allows you to coordinate initial data loading into Sybase IQ with auto-correction of source transactions during migration, and transform replicated data in Sybase IQ.
See Replication Server Administration Guide Volume 1 > Manage Subscriptions for details on materialization.
Connection Profile – to apply or subscribe to a previously defined database connection profile, select it from this list.
Interface – select the method or driver to use to connect to the source database.
The Interface list includes an Insert Location option, which requires a valid destination database connection to be configured. When the Insert Location interface is selected, it displays a list of remote servers defined in the target IQ database (if the destination database has been defined), in the Host list. If there are no remote servers defined in the destination IQ database, configure a remote server and the necessary external logins on the IQ server.
Host – select the source database. The options that appear in this list depend on the selected interface.
User – specify the authorized database user name.
Password – specify the authorized database user password. The password value is encrypted by default.
(Optional) Database – specify the database to be used as the source database. This option is not applicable for Oracle.
(Optional) Schema – specify schema or owner of the source tables.
(Optional) Click Profiles to save the entered connection details as a connection profile. Enter a profile name and description before saving the profile in the repository. Once the profile is saved, you can subscribe to it. See Database Connection Profiles in EL and SQL Transformation Projects.
The connection is automatically tested when you switch to another tab. If you want to manually test the connection, click Test Logon.
Files – add one or more source files to the EL project.
Click the Edit icon next to a selected file to open the Edit File dialog. You can edit the file path or browse to a different file. Multiple file paths and empty file paths are not allowed in the Edit File dialog.
The Source File Path field supports Square Bracket Notation (SBN) expressions.
Click Add Pattern to create a file name pattern to match the file names in a specific directory. To add a file pattern, select a directory and enter a GLOB expression (patterns with * and ? wildcards) to match the source file names.
You can enter Square Bracket Notation expressions in the Directory and Pattern fields. The value in the Directory field must evaluate to a directory path. Directory paths containing * or ? characters are not supported.
File format – define a format for all the files and the files that match patterns, using the File Format editor. To open the File Format editor, click the Define the File Format icon.
All files in an EL project must conform to a single file format. Separate EL projects are required if sources with different file formats need to be loaded.
The File Format Summary pane shows a summary of the format specified in the format editor. For example, Byte Order appears if you selected IQ Binary as the file format. If there is an error in the file format definition, the File Format Summary pane displays the error instead.
Archive path – specify where to archive the data files after the data has been successfully loaded into Sybase IQ. This can be a directory path or a path to a zip file. If you do not want to archive the source files, leave this field empty.
Select Delete source files to remove source files after successfully loading the source data into Sybase IQ (after archiving, if an archive path is set).