How to install Jar files for SQL Server
Install Jar files for SQL Server
In this blog, we will see how to install Jar files for SQL Server and deploy them to the atom.
Step 1: Let us begin with the steps.
Step 1: Search for SQL jars and choose 2nd option as shown.
Step 2: Once we open the link, click on download 8.4 Jar as highlighted and we see that jars gets downloaded.
Now, we will upload the downloaded jar files in Account Library to the Boomi Account.
Step 1: Log on to Boomi platform (https://platform.boomi.com/) with required credentials i.e. Email Address and Password.
Step 2: Once logged into Boomi platform, we will be able to view Home page.
Step 3: Go to Settings > Account Information > Setup > Account Libraries and upload the jar file which we have downloaded by choosing Upload a File.
Step 4: Now, choose the downloaded jar and upload it. Here, we are uploading mssql-jdbc-8.4.1.jre8.jar.
Step 5: Now, create a custom library component and add the uploaded JAR file in the account library to the component. Navigate to Build tab and click on New as shown.
Step 6: Choose Type as Custom Library. Component Name and Folder can be given based on your choice. Click on create.
Step 7: Choose Custom Library Type as Connector from the drop down.
Step 8: Choose the Connector Type as Database.
- Select the Jar which we have uploaded in Account Library. Click save.
Step 9: After uploading the jar, overall custom library looks like,
Step 10: Deploy the Custom Library component to an atom because these are not explicitly referenced by a process or any other component, we must deploy them independently. Click on create packaged component.
Step 11: The process gets selected automatically. Click Add Details.
- Next, select the version and write notes if you have any. Click on create packaged component.
- Now, we see that the package has been created successfully and click on deploy.
- We will then have to select the environment. Choose production and click select version and review.
- We will be asked to cross check the environment which we have configured in deployment tab.
- Once, we click on deploy we will be able to see that deployment is done successfully. Click save and close.
For handling UTF-8 Character Encoding Error, we will follow the below steps
Step 1: Go to <Local Atom Install>/bin/atom.vmoptions file i.e. (if the atom is running as service)
Step 2: Open atom.vmoptions file and add the code -Dfile.encoding=utf-8. Save it.
Step 3: If Atom is running as Desktop, we will go to <Local Atom Install>/bin/atomw.vmoptions file.
Step 4: Open atomw.vmoptions file and add the code -Dfile.encoding=utf-8. Save it.
NOTE: After saving the file, restart the atom.
