PAR FILE EXTRACTOR HOW TO
For more information on how to patch option, you can refer to GoldenGate REST API documentation ( here). The process to do this would be to use the Update (PATCH) cURL commands to modify the parameter file.
In the traditional process, I would have to access AdminClient and perform an edit params IEXTTPC however, you want to do this without touching the server. This table needs to be added to the bottom of the parameter file. Let’s take the example of the requirement to add a new table to the parameter file. The contents of this parameter file is quite simple. Useridalias CGGATE domain OracleGoldenGate If I was to do a cat on the the IEXTTPC.prm file, you would see contents like: extract IEXTTPC When you look at the above image, you can see that I have a few parameter files. Depending on your environment, this would be found in $DEPLOYMENT_HOME/etc/conf/ogg. The first thing you need to do is fine the contents of the parameter file for the extract/replicat. If not, refer to a tutorial that can be easily found on the internet.
Note: I’m assuming you have some basic understand of how cURL works.
In this post, I want to show you how quickly you can update your parameter files by using REST API and JSON. Being able to build extracts/replicats by using a REST API and JSON is a huge step forward with how administration of the Oracle GoldenGate environment is done. In a previous post ( here), I showed you have to build an Extract using the associated REST API end-point and JSON. This process has improved a good bit and can be a bit more dynamic in my opinion. In the past, this required you to access GGSCI and run commands like: GGSCI> edit params Īfter which, you then had to bounce the process group for the changes to take effect. One of the most important and time consuming things to do with Oracle GoldenGate is to build parameter files for the GoldenGate processes.
0 kommentar(er)
