Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+1
person also asked this
people also asked this
Replies
30 replies
Answers
1 answer
Subscribers
8 subscribers
Views
16007 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
How to use Login Information Parser Plugin?
brindas1
over 7 years ago
Hi all,
How to use "Login Information Parser" plugin? I have added this plug in so that now it can be used as a smart service. I have created "logins" table which now exists in the data source. How can I get the login details of the users using this smart service and table? Can someone please explain the steps?
OriginalPostID-267857
Discussion posts and replies are publicly visible
0
mayureshs7821
over 7 years ago
Can you prefix "java:" to your data source name and try it once "java:/jdbc/pocTestingOracleDS"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mayureshs7821
over 7 years ago
@brindas I tried it on on-premise environment and it is working fine for me. I think there is issue with your datasource name . Just try "java:/jdbc/pocTestingOracleDS" or "/jdbc/pocTestingOracleDS" once
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mayureshs7821
over 7 years ago
And one more thing, make sure while publishing data store mapping should be done properly. It means when you create cdt from table(17.1 version) make sure you make linenumber as primary key and auto generated then configure in your data store and publish the data store
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brindas1
over 7 years ago
No. It's empty again. I am using Oracle SQL developer. For "logins" table, I have used the following fields and data types:
COLUMN_NAME DATA_TYPE NULLABLE
loginpk NUMBER(10,0) No
date DATE Yes
time TIMESTAMP(6) Yes
lineNumber NUMBER(10,0) Yes
isValidLogin NUMBER(10,0) Yes
username VARCHAR2(255 CHAR) Yes
ipaddress VARCHAR2(255 CHAR) Yes
Am I going wrong in the above definition?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mayureshs7821
over 7 years ago
I think you should not add any extra column just use the definition as given in shared component.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mayureshs7821
over 7 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brindas1
over 7 years ago
@mayureshs I tried giving the datasource name in both the ways, but "logins" table is empty.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brindas1
over 7 years ago
I used the same "Login Information Parser" plugin earlier in "My SQL" . It was working fine. I don't know why the "logins" table in empty when I use it in "Oracle" DS.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mayureshs7821
over 7 years ago
Have you changed your script?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
brindas1
over 7 years ago
Ya I have changed my script. I am using only the fields and the respective data types mentioned.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<
>