How to use Login Information Parser Plugin?

As you have added an extra column loginpk, do not add any extra column.

CREATE TABLE IF NOT EXISTS `logins` (
`date` date NOT NULL,
`time` time NOT NULL,
`lineNumber` int(11) NOT NULL,
`isValidLogin` tinyint(1) NOT NULL,
`username` varchar(100) NOT NULL,
`ipaddress` varchar(20) NOT NULL,
UNIQUE KEY `unique` (`date`,`lineNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

modify the above script as per the oracle syntax as you are using oracle as backend.
Once this is done create CDT as Appian has provided feature to create CDT from table in 17.1 version (If you are working on 17.1 version), otherwise create CDT manually and make sure you make linenumber as primary key and autogenerated. add entity in your datastore and publish the datastore. make sure the mapping should be done properly and provide datasource name either "java:/jdbc/pocTestingOracleDS" or "/jdbc/pocTestingOracleDS" then try it once.

As you have added an extra column loginpk, do not add any extra column.

CREATE TABLE IF NOT EXISTS `logins` (
`date` date NOT NULL,
`time` time NOT NULL,
`lineNumber` int(11) NOT NULL,
`isValidLogin` tinyint(1) NOT NULL,
`username` varchar(100) NOT NULL,
`ipaddress` varchar(20) NOT NULL,
UNIQUE KEY `unique` (`date`,`lineNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

modify the above script as per the oracle syntax as you are using oracle as backend.
Once this is done create CDT as Appian has provided feature to create CDT from table in 17.1 version (If you are working on 17.1 version), otherwise create CDT manually and make sure you make linenumber as primary key and autogenerated. add entity in your datastore and publish the datastore. make sure the mapping should be done properly and provide datasource name either "java:/jdbc/pocTestingOracleDS" or "/jdbc/pocTestingOracleDS" then try it once.