In Progress

Python script to read data from Sql server and check connectivity

Hello,

I'm looking for a Python script do following:

we have one inventory table in the Mysql server

Table_Name: Inventory

Mysql server address: 1.1.5.1

username: user_name

password: password

1. Read inventory table data from python script

The table schema is as follows:

Ip address Server tech port cluster name

1.2.3.4 cassandra 9042 testcluster

1.2.3.4 cassandra 9042 testcluster

2. Save all the data into one CSV file.

3. for each IP in the inventory we need to make sure the 9042 port is up and connectable.

4. If the 9042 port is connectable save the list of IPs to one file if not other files.

After the script is completed, we can join the zoom meeting and show the demo.

Once we run the script it should create three CSV files:

1. all the table data

2. rows which are connectable

3. rows that are not connectable

Skills: Python

See more: read data sql using vbnet web service, python script extract data web page, python script crape data, read data sql, upload read data sql using aspnet, python script extract data, python script extract data website, read data sql export excel using aspnet, python script rs232 data, python script retrieve data website, read data sql flash, read data sql ms project, read data sql required jquery, python script scrape data, python script automate data entry website, write script extract data sql, python script extract data emails, script import data sql server xml file, read data sql server android, python script to run sql server query

About the Employer:
( 3 reviews ) Santa Clara, United States

Project ID: #29965061

Awarded to:

b14d35

Hey, I'm experienced in Python and automation, I've dealt with MySQL connection through Python as well as checking open ports, message me to discuss more details.

$30 USD in 1 day
(20 Reviews)
5.2

10 freelancers are bidding on average $26 for this job

mirzaahamza

Heyy I am expert in python and I can do your [login to view URL] me to discss.......................................

$20 USD in 1 day
(22 Reviews)
4.2
(17 Reviews)
3.6
ElenaKhod

ello, Hope you're doing well. I am a professional Python developer with 5 years and can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am con More

$50 USD in 1 day
(10 Reviews)
3.5
ArabianExpert

Hi, dear client. I have read the descriptions and I am an associate degree holder and an expert in Machine learning, Python, Java, Matlab with skills over 7 years, and also an expert in applied mathematics Analysis. I More

$20 USD in 1 day
(2 Reviews)
2.7
d1master

Dear Sir. I am David Micevski, a professional Python developer from Macedonia. I have already mastered several Python libraries. My main skills: - python: numpy, python-opencv, python-ffmpeg - Backend: Flask, Dja More

$20 USD in 7 days
(1 Review)
1.4
poalrcoding12

Hi I am expert at python 3. I can do this without problems I've worked on many SQL project before. about creating websites and similar. so I can create this checker and understand if port it's open. with a simple get, More

$35 USD in 1 day
(0 Reviews)
0.0
ViktorBell

***Python expert*** ✌ Hello Client! I have read your post and image carefully and I think it is good fit for me. ➤Really looking forward to discussing details in a friendly chat, when are you available to talk❓✌ Be More

$20 USD in 1 day
(0 Reviews)
0.0
Wanngming

==== Able to start work right away ==== Hi, bro! I have read your job specification very carefully. I have rich experiences with Python. As a talented and skillful software developer, I am 100% sure to complete this j More

$20 USD in 1 day
(0 Reviews)
0.8
fourd30

I can deliver this project quickly and at minimal cost. I am comfortable with multiple database adapters for Python as well as the networking required. Please find examples of my work at [login to view URL]

$10 USD in 2 days
(0 Reviews)
0.0