Automate data from GCS to Oracle and push to line notify

Inspiration

1 ใช้ python ในการโหลด automate แทนด้วยการ export import แบบ manual

2 ใช้ line bot ช่วยในการ interactive กับ user แทนคน

What it does

How we built it

. Setting environment , Tool, Authorize, config environment variable. . Connect to CGS . Connect to Oracle . Developed reports . Push to line notify

Challenges we ran into

. Setting environment , Tool, Authorize, config environment variable. .

Accomplishments that we're proud of

. Python can help automate job instead manual job

What we learned

. Python can help your better job.

What's next for Automate data from GCS to Oracle and push to line notify

. Notification when job has fail problem.

Built With

• flask
• flaskalchemy
• flaskmarshmallow
• line
• ngrok
• oracleclient
• postman
• pycharm
• python
• windowtask