ScriptRunner - Setup Local Database Connection

[Preston Warden]

Hello,

I am completely new to Script Runner and need assistance with how to set up a local database connection. 

I am trying to learn how to connect to a Microsoft Access Database using ScriptRunner. The Documentation from Script  Runner isn't extremely helpful in starting this process. I would like to get it started and see where I can get from there, but just have no experience in working on this. 

Can anyone help?

[Aiden Marriott]

I would start by thinking about how you would achieve this in Java (which jar files, drivers etc would be needed), what does the code look like. 

Scriptrunner uses groovy which works in the Java VM... its not quite the same as Java but you often can directly re-use your java code.  If you arent comfortable with coding you will probably struggle to do much with ScriptRunner outside of its off the peg scripts and should maybe consider a lower code solution - maybe automation for jira or nfeed depending on what you are trying to achieve.

[Julie d_Antin _Elements_]

@Aiden MarriottThanks for the recommendation. nFeed is now called Elements Connect.

@Preston WardenYou can connect your Access Database to a custom field with Elements Connect in two steps:

• Download and install a JDBC driver for Access

• Configure a JNDI datasource in the Elements Connect admin

To get some practice configuring Elements Connect, I recommend following the 15 minute Getting Started Guide. After you've done that you can connect your Access database.