Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

com.informatica.powercenter.sdk.mapfwk.core
Class ConnectionPropsConstants

java.lang.Object
  extended by com.informatica.powercenter.sdk.mapfwk.core.ConnectionPropsConstants

public class ConnectionPropsConstants
extends java.lang.Object

Defines constants for various connection and session extension properties. These constants are used to populate various connection properties in a ConnectionInfo object

Following is a code example of using ConnectionPropsConstants while working with a flat file source 

         // create a connection info object for flat file source
          ConnectionInfo ffConn = new ConnectionInfo( SourceTargetTypes.FLATFILE_TYPE );
          // gets the connection properties for flat file
          ConnectionProperties ffConnProp = ffConn.getConnProps();
          // set the connection properties for flat file
          ffConnProp.setProperty(ConnectionPropsConstants.FLATFILE_DELIMITERS,";");
          ffConnProp.setProperty(ConnectionPropsConstants.DATETIME_FORMAT,"A  21 yyyy/mm/dd hh24:mi:ss");
          ffConnProp.setProperty(ConnectionPropsConstants.FLATFILE_QUOTE_CHARACTER,"DOUBLE");
          ffConnProp.setProperty(ConnectionPropsConstants.SOURCE_FILENAME,"employee.txt");
          // create a flat file source using this connection info
          Source src = new Source( "Employee", "Employee", "This is a flat file source Employee", "Employee", ffConn);

          // get the connection info from flat file source
          ConnectionInfo ffConnReturned = src.getConnInfo();
          // get the connection properties from flat file source connection
          ConnectionProperties ffConnPropReturned = ffConnReturned.getConnProps();

See Also:
ConnectionInfo, ConnectionProperties

Field Summary
static java.lang.String APPEND_IF_EXISTS
           
static java.lang.String BASE_TABLENAME
           
static java.lang.String CODEPAGE_PARAMETER
           
static java.lang.String COMMAND
           
static java.lang.String CONNECTIONNAME
          Property for the value of connection used in session extension for a source or target instance in a session.
static java.lang.String CONNECTIONNUMBER
           
static java.lang.String CONNECTIONSUBTYPE
          Property for sub-type of the connection used in session extension.
static java.lang.String CONNECTIONTYPE
          Property for type of the connection used in session extension.
static java.lang.String CREATE_DIRECTORY_IF_NOT_EXITS
           
static java.lang.String DATETIME_FORMAT
           
static java.lang.String DBNAME
           
static java.lang.String DECIMAL_SEPARATOR
           
static java.lang.String FLATFILE_CODEPAGE
           
static java.lang.String FLATFILE_CONSECDELIMITERSASONE
           
static java.lang.String FLATFILE_DELIMITED
           
static java.lang.String FLATFILE_DELIMITERS
           
static java.lang.String FLATFILE_ESCAPE_CHARACTER
           
static java.lang.String FLATFILE_KEEPESCAPECHAR
           
static java.lang.String FLATFILE_LINESEQUENTIAL
           
static java.lang.String FLATFILE_NULL_CHARACTER
           
static java.lang.String FLATFILE_NULLCHARTYPE
           
static java.lang.String FLATFILE_PADBYTES
           
static java.lang.String FLATFILE_QUOTE_CHARACTER
           
static java.lang.String FLATFILE_REPEATABLE
           
static java.lang.String FLATFILE_SHIFTSENSITIVEDATA
           
static java.lang.String FLATFILE_SKIPROWS
           
static java.lang.String FLATFILE_STRIPTRAILINGBLANKS
           
static java.lang.String FOOTER_COMMAND
           
static java.lang.String HEADER_COMMAND
           
static java.lang.String HEADER_OPTIONS
           
static java.lang.String MERGE_COMMAND
           
static java.lang.String MERGE_FILE_DIRECTORY
           
static java.lang.String MERGE_FILE_NAME
           
static java.lang.String MERGE_PARTITIONED_FILES
           
static java.lang.String MERGE_TYPE
           
static java.lang.String OUTPUT_FILE_DIRECTORY
           
static java.lang.String OUTPUT_FILENAME
           
static java.lang.String OUTPUT_TYPE
           
static java.lang.String OWNERNAME
           
static java.lang.String REJECT_FILE_DIRECTORY
           
static java.lang.String REJECT_FILENAME
           
static java.lang.String RELATIONAL_DELETE
           
static java.lang.String RELATIONAL_INSERT
           
static java.lang.String RELATIONAL_TARGET_LOADTYPE
           
static java.lang.String RELATIONAL_TRUNCATE_TRG_TABLE_OPTION
           
static java.lang.String RELATIONAL_UPDATE_AS_INSERT
           
static java.lang.String RELATIONAL_UPDATE_AS_UPDATE
           
static java.lang.String RELATIONAL_UPDATE_ELSE_INSERT
           
static java.lang.String SEARCH_SPECIFICATION
           
static java.lang.String SESSION_EXTENSION_NAME
          Property for name of the session extension.
static java.lang.String SORT_SPECIFICATION
           
static java.lang.String SOURCE_FILE_DIRECTORY
           
static java.lang.String SOURCE_FILENAME
           
static java.lang.String SOURCE_FILETYPE
           
static java.lang.String THOUSAND_SEPARATOR
           
 
Method Summary
static java.lang.String generateXML()
          Generates a XML string from the properties of a connection
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

FLATFILE_CODEPAGE

public static final java.lang.String FLATFILE_CODEPAGE
See Also:
Constant Field Values

FLATFILE_DELIMITERS

public static final java.lang.String FLATFILE_DELIMITERS
See Also:
Constant Field Values

FLATFILE_CONSECDELIMITERSASONE

public static final java.lang.String FLATFILE_CONSECDELIMITERSASONE
See Also:
Constant Field Values

FLATFILE_DELIMITED

public static final java.lang.String FLATFILE_DELIMITED
See Also:
Constant Field Values

FLATFILE_ESCAPE_CHARACTER

public static final java.lang.String FLATFILE_ESCAPE_CHARACTER
See Also:
Constant Field Values

FLATFILE_KEEPESCAPECHAR

public static final java.lang.String FLATFILE_KEEPESCAPECHAR
See Also:
Constant Field Values

FLATFILE_LINESEQUENTIAL

public static final java.lang.String FLATFILE_LINESEQUENTIAL
See Also:
Constant Field Values

FLATFILE_NULLCHARTYPE

public static final java.lang.String FLATFILE_NULLCHARTYPE
See Also:
Constant Field Values

FLATFILE_NULL_CHARACTER

public static final java.lang.String FLATFILE_NULL_CHARACTER
See Also:
Constant Field Values

FLATFILE_PADBYTES

public static final java.lang.String FLATFILE_PADBYTES
See Also:
Constant Field Values

FLATFILE_QUOTE_CHARACTER

public static final java.lang.String FLATFILE_QUOTE_CHARACTER
See Also:
Constant Field Values

FLATFILE_REPEATABLE

public static final java.lang.String FLATFILE_REPEATABLE
See Also:
Constant Field Values

FLATFILE_SKIPROWS

public static final java.lang.String FLATFILE_SKIPROWS
See Also:
Constant Field Values

FLATFILE_STRIPTRAILINGBLANKS

public static final java.lang.String FLATFILE_STRIPTRAILINGBLANKS
See Also:
Constant Field Values

FLATFILE_SHIFTSENSITIVEDATA

public static final java.lang.String FLATFILE_SHIFTSENSITIVEDATA
See Also:
Constant Field Values

DBNAME

public static final java.lang.String DBNAME
See Also:
Constant Field Values

CONNECTIONNUMBER

public static final java.lang.String CONNECTIONNUMBER
See Also:
Constant Field Values

OWNERNAME

public static final java.lang.String OWNERNAME
See Also:
Constant Field Values

BASE_TABLENAME

public static final java.lang.String BASE_TABLENAME
See Also:
Constant Field Values

SEARCH_SPECIFICATION

public static final java.lang.String SEARCH_SPECIFICATION
See Also:
Constant Field Values

SORT_SPECIFICATION

public static final java.lang.String SORT_SPECIFICATION
See Also:
Constant Field Values

DATETIME_FORMAT

public static final java.lang.String DATETIME_FORMAT
See Also:
Constant Field Values

DECIMAL_SEPARATOR

public static final java.lang.String DECIMAL_SEPARATOR
See Also:
Constant Field Values

THOUSAND_SEPARATOR

public static final java.lang.String THOUSAND_SEPARATOR
See Also:
Constant Field Values

MERGE_PARTITIONED_FILES

public static final java.lang.String MERGE_PARTITIONED_FILES
See Also:
Constant Field Values

MERGE_FILE_DIRECTORY

public static final java.lang.String MERGE_FILE_DIRECTORY
See Also:
Constant Field Values

MERGE_FILE_NAME

public static final java.lang.String MERGE_FILE_NAME
See Also:
Constant Field Values

OUTPUT_FILE_DIRECTORY

public static final java.lang.String OUTPUT_FILE_DIRECTORY
See Also:
Constant Field Values

OUTPUT_FILENAME

public static final java.lang.String OUTPUT_FILENAME
See Also:
Constant Field Values

REJECT_FILE_DIRECTORY

public static final java.lang.String REJECT_FILE_DIRECTORY
See Also:
Constant Field Values

REJECT_FILENAME

public static final java.lang.String REJECT_FILENAME
See Also:
Constant Field Values

SOURCE_FILE_DIRECTORY

public static final java.lang.String SOURCE_FILE_DIRECTORY
See Also:
Constant Field Values

SOURCE_FILENAME

public static final java.lang.String SOURCE_FILENAME
See Also:
Constant Field Values

SOURCE_FILETYPE

public static final java.lang.String SOURCE_FILETYPE
See Also:
Constant Field Values

RELATIONAL_TARGET_LOADTYPE

public static final java.lang.String RELATIONAL_TARGET_LOADTYPE
See Also:
Constant Field Values

RELATIONAL_INSERT

public static final java.lang.String RELATIONAL_INSERT
See Also:
Constant Field Values

RELATIONAL_UPDATE_AS_UPDATE

public static final java.lang.String RELATIONAL_UPDATE_AS_UPDATE
See Also:
Constant Field Values

RELATIONAL_UPDATE_AS_INSERT

public static final java.lang.String RELATIONAL_UPDATE_AS_INSERT
See Also:
Constant Field Values

RELATIONAL_UPDATE_ELSE_INSERT

public static final java.lang.String RELATIONAL_UPDATE_ELSE_INSERT
See Also:
Constant Field Values

RELATIONAL_DELETE

public static final java.lang.String RELATIONAL_DELETE
See Also:
Constant Field Values

RELATIONAL_TRUNCATE_TRG_TABLE_OPTION

public static final java.lang.String RELATIONAL_TRUNCATE_TRG_TABLE_OPTION
See Also:
Constant Field Values

HEADER_OPTIONS

public static final java.lang.String HEADER_OPTIONS
See Also:
Constant Field Values

HEADER_COMMAND

public static final java.lang.String HEADER_COMMAND
See Also:
Constant Field Values

FOOTER_COMMAND

public static final java.lang.String FOOTER_COMMAND
See Also:
Constant Field Values

CODEPAGE_PARAMETER

public static final java.lang.String CODEPAGE_PARAMETER
See Also:
Constant Field Values

COMMAND

public static final java.lang.String COMMAND
See Also:
Constant Field Values

MERGE_COMMAND

public static final java.lang.String MERGE_COMMAND
See Also:
Constant Field Values

CREATE_DIRECTORY_IF_NOT_EXITS

public static final java.lang.String CREATE_DIRECTORY_IF_NOT_EXITS
See Also:
Constant Field Values

APPEND_IF_EXISTS

public static final java.lang.String APPEND_IF_EXISTS
See Also:
Constant Field Values

MERGE_TYPE

public static final java.lang.String MERGE_TYPE
See Also:
Constant Field Values

OUTPUT_TYPE

public static final java.lang.String OUTPUT_TYPE
See Also:
Constant Field Values

CONNECTIONNAME

public static final java.lang.String CONNECTIONNAME
Property for the value of connection used in session extension for a source or target instance in a session.

Note you can also set connection variable for a connection using ConnectionInfo.setConnectionVariable(String). However, only one of connection name or connection variable can be used at one point of time. If both connection name and connection variable are set, then connection variable will be used.

See Also:
ConnectionInfo.setConnectionVariable(String), ConnectionInfo.getConnectionVariable(), Constant Field Values

CONNECTIONTYPE

public static final java.lang.String CONNECTIONTYPE
Property for type of the connection used in session extension. This property is set by default for relational and flat file connection. This can be used to override the connection type at session level. For example 1. It can be used to change the connection type to 'Application' if reader is set to to 'Teradata FastExport Reader' for a teradata source instance in a session 2. It can be used to change the connection type to 'External Loader' for a teradata target instance in order to use various teradata loaders in a session

See Also:
Constant Field Values

CONNECTIONSUBTYPE

public static final java.lang.String CONNECTIONSUBTYPE
Property for sub-type of the connection used in session extension. This property is set by default for relational and flat file connection. This can be used to override the sub connection type at session level. For example 1. It can be used to change the connection sub-type to 'Teradata FastExport Connection' if reader is set to 'Teradata FastExport Reader' and connection type is set to 'Application' for a teradata source in a session 2. It can be used to change the connection sub-type to one of the teradata loaders (say 'Teradata FastLoad External Loader') if writer is to 'File Writer' and connection type is set to 'External Loader' for a teradata target instance in a session

Since:
@since 8.6.1
See Also:
Constant Field Values

SESSION_EXTENSION_NAME

public static final java.lang.String SESSION_EXTENSION_NAME
Property for name of the session extension. This can be used for overriding the default reader/writer for a source/target instance in the session. For example 1. It can be used to change the reader to 'Teradata FastExport Reader' for a teradata source instance in a session 2. It can be used to change the writer to 'File Writer' for a teradata target instance in order to use various teradata loaders in a session

Since:
8.6.1
See Also:
Constant Field Values
Method Detail

generateXML

public static java.lang.String generateXML()
Generates a XML string from the properties of a connection

Returns:
XML string containing properties of a connection
Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD