7/8/2023 0 Comments Etl processes oracle![]() You can execute this query directly in SQL developer or you can use the python script sqlexec.py that I have in my repository. Here is the SQL query for the above table, create table Bill ( It's easy to follow if I too worked along with you guys, right? So, I have created a table in my database □ Once you have all what you need and created your database, it is time to create some tables for loading the data. ![]() Once you have loaded the data you can use this platform to view your tables and see if the transaction made was right or wrong before committing it. This IDE will help you to connect to the database and perform SQL queries. There are tons of videos and tutorials out there on how to install and setup a oracle database. Since, we will be working on the oracle database you should have it installed in your system. I recommend to have your python directory added to environment variables, you may need that later in this blog. Python:Īs it's pretty clear, you should have a python environment setup. I highly recommend you of having some basic knowledge in python and databases for easy understanding What you need ? 1. We will be talking all of these here so, let's dive in, shall we? ![]() Since, it's simple and easy to understand for the beginners. but I thought of giving some love to this tool. There are other tools that are more popular for this process like pandas, Mara, etc. Here, we will have thatĭone by a package/tool called ' Petl'. ETL process can be done by many methods, one of them is by using Python. This blog is to show or give you guys an idea of how to do Extraction, Transformation and Load a dataset into an Oracle Database. ![]()
0 Comments
Leave a Reply. |