PostgreSQL¶
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being free and open source, PostgreSQL is highly extensible. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database!
Connecting to the Database¶
Mammoth allows you to connect to your Database and get the data into Mammoth.
Once the connection is established, you will be presented with a list of tables and views in that database.
Select the desired table to get a preview.
Write your own SQL query or run a test query and preview the result.
Click on Next
After you have selected the table you want to work on, you get options to configure it as follows -
Scheduling your Data Pulls¶
You can start retrieving the data now or at a specific time according to your choice. You can also schedule the data pull in order to get the latest data from your Database at a certain time interval - every few minutes, daily, weekly or monthly.
On every data pull from your Database, you also have an option to either replace the older data or combine with older data.
On choosing Combine with older data option, you will get an option to choose a unique sequence column. Using this column, on refresh, Mammoth will pick up all the rows that have greater value in this column than the previous data pull.
Note:
Make sure that Mammoth’s public IP address is added to your whitelist.
Mammoth’s public IP is displayed on the create connection window.