hdbreplicationtasks can create Virtual Tables and Remote Subscriptions. ' ORCLCDB false false database 1000 false false 1521 1000 false false oracle true false 5 false ORCLCDB.localdomdpagent false 10 oracle999 false false 15 '
NOTE: If you decided to call your data provisioining agent name something besides dpagent_dpagent or your password or user something else, modify those pieces in the XML below.ĬREATE REMOTE SOURCE "oracle " ADAPTER "OracleLogReaderAdapter " AT LOCATION AGENT "dpagent_dpagent " CONFIGURATION In the HXE HANA Tenant DB as SYSTEM, run the following SQL in HANA Studio or hdbsql: If you run through that option, note that the Remote Source script that the tool creates will be located in the /tmp directory in the filesystem of the Data Provisioning Agent container. If you have deviated from this example, you may wish to run option 5 ( Create Oracle Log Reader Adapter Remote Source) yourself. Option 1: Connecting to Oracle DB Container's ORCLCDB (pluggable DB) in sqlplus as sysdba Therefore, for sake of this use case, we will cover primarily the container database. The Oracle Docker image comes with a container database ( ORCLCDB) and a pluggable database ( ORCLPDB1.) Data Provisioning Agent can communicate with either, however if you wish to use realtime replication, you must connect to the container database ( ORCLCDB), as Oracle's LogMiner does not work with pluggable databases. Name: oracle-db Connecting to your Oracle Container's DB Image: store/oracle/database-enterprise:12.2.0.1-slim container_name: oracle hostname: oracle ports:
You have a Docker Hub login and have subscribed to the Oracle DB image (Simply run docker volume create oracle-db if you have not) You have a pre-existing docker volume named oracle-db. (Simply run docker volume create hana-db if you have not) You are running an existing HANA Express (2.0 SP4 in this case) with a hostname of hxe and a pre-existing docker volume named hana-db. (After all, this example Docker Compose stack is not a complete self-contained working example if it did not contain an example Data Source, right?) This next example illustrates a similar Docker Compose stack with the addition of an Oracle 12 Database that can be used by the DP Agent and HANA Express Containers for an end-to-end sandbox to play with Data Provisioning Agent and SDA. Running Example in Docker Compose with Oracle DB To configure the DP Agent via the CLI Tool, read instructions here. Name: hana-db Configuring Data Provisioning Agent and Adapter(s) from CLI in this Docker Compose Stack Image: store/saplabs/hanaexpress:3.1 container_name: hxe hostname: hxe volumes: Image: dpagent-image container_name: dpagent hostname: dpagent hxe: You have a bootstrapped HANA Express container. You built your Docker Image called dpagent-image Docker Compose makes this simple and easy for the 2 containers to communicate internally. Realistically in a containerized scenario, you'll simply just want to have DP Agent and HXE running in same Docker network. Start a container in Dockerĭocker run -d -p 5050:5050 -rm -name dpagent dpagent-image Accessing the Data Provisioning Agent CLI configuration menuĭocker exec -ti dpagent bash -c "/home/dpagent/dataprovagent/bin/agentcli.sh -configAgent" Simple Running Example in Docker Compose In this example, the container is removed after it is stopped and no data, configuration files, or logs are persisted.
The following is a very bare-bones simple example of how to run the Data Provisioning Agent in a single docker container. Copy the files mentioned in the prerequisites to the correct folders.īare Bones example of just running Data Provisioning Image.(Google them or find on Microsoft/Oracle/etc sites) i.e: In /files/sdi-libs copy your database JDBC JARs. In /files copy HXEDownloadManager_linux.bin - Follow the tutorial here or Google for it. I technically cannot redistribute them in the repo, and they are large binaries anyway. Prerequisitesĭownload and place the following files in the files directory. If you are playing with SAP HANA Express Docker container and want to quickly spin up a Data Provisioning Agent without bothering with a VM and copying JARs and installing DP Agent, the following build will result in a Data Provisioning Agent which you can then use with HANA Express.
Since HXEDownloadManager_linux.bin is used to actually download the software, it will pull whatever the latest is available from SAP (for instance, 2.0 SP3 or SP4 etc) So tag your builds with something appropriate if needed. HANA Data Provisioning Agent Docker Imageīuilds a Docker Image with Data Provisioning Agent pre-installed with some common JAR files included.