A.E. Hellar / Archives / Contributors / Pt. 9 / Technology

Technology — Livestockcity App: Connecting Android & MS Server | The District Nerd

Articles by A.E. Hellar

Earlier this fall, I took a remote internship working on the first Android app for an early stage start-up, LivestockCity. The mobile team consists of two Android and iOS engineers. For the moment, I am the only Android engineer.

The first step was connecting to the data. Early on we learned that there were issues with the APIs. Not only was the documentation incomplete, but no one had any answers regarding how the APIs worked. With that knowledge, I decided to try an alternative approach and connect directly to the MS server.

Never having used a Microsoft server or any .Net product I visited the Microsoft website to gain a better insight into their servers. Quickly, I learned that Microsoft and Java are good friends. Microsoft and Android provide documentation and tutorials. However, the information provided was more documentation than tutorial. So, I decided to take a different approach and conducted an internet query “Connect Android to SQL.”

The internet query produced numerous results. However, the “all” results did not answer my question so, I tried the “video” tab. There I found two helpful videos: Connect Android App with SQL Server and Android Login Application with MSSQL Server Using JDBC. As a rule, I review several online tutorials to see the core concept implemented in several ways. The common thread between these two videos was using the internet protocol (IP) address and the database name to connect to the server.

Gathering requirements
First, I started by gathering the Internet Protocol (IP) address. There are five ways to discover the IP address of a website. For my purposes the online method is more efficient because it involves only three steps: One visit ipinfo.info. Two enter the full website address ex. Google.com. Three interpret the output. Then, I requested the database name from the back-end developer. With the IP address and database name, I was ready to create my Android project.

IP Checker

Android Studio comes with a login template that comes fitted with everything, plus you could need. However, Android Studio templates can be problematic. Also, the app needs to have a tablet layout, so I’m creating the associated XML simultaneously.

Full Stop

Implementing the code went smoothly. The online videos and tutorials were clear and effective in guiding me. However, I realized there was information missing. I needed an outline of the database structure to write my SQL query. When I queried the back-end developer for the database outline, I was informed that there was business logic preventing me from connecting directly to the database. This was devastating news that put a halt to all app development.

Next Steps

Without a working API, there is no way to get or post data to the database. For the time being I’ll work with the iOS team on the documentation and consider other areas of the app to develop.

The District Nerd: DC, Wine, & Apps

Tech + Brew: About A.E. Hellar

Adrienne is a DMV native with an interest in homebrewing (beer and wine), app development, and most things science fiction/fantasy.

On The District Nerd YouTube channel:

BL | Black Lion Journal | Black Lion Article by A.E. Hellar of The District Nerd | The Black Lion is a humble interdisciplinary journal that values your voice. For contribution opportunities, Join As A Contributor; to learn more about submitting to the journal’s creative magazine, visit the The Wire’s Dream Magazine: Submit. | Copyright Policy


Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.