Test and Production environment for Tulip tables

In our effort to connect other systems like ERP to Tulip we see that our current setup of Tulip is not suited.

The standard for our other systems is that they have minimum two different environment.
One for testing and one for production. Standard setup would then be to connect test environment to a test environment in Tulip and prod to prod.
Since we only have one environment in Tulip we need to connect the external test environment to Tulip Production environment, meaning external data pushed from both test and prod-environment will be routed to the same table in Tulip.
This in turn can, and do corrupt existing production data.

How is this to be solved?

How do you realize the connection of your ERP to TULIP?
The connectors in TULIP actually do have up to thee environments:

image

Or have I misunderstood you?

Thank you for your respond.
We use a middleware to set up the endpoints to be used in Tulip connector function.
The middleware use some services at the ERP side. (This is not something I do, I just use the endpoint)

Back to my concern.
It is the other way around. Pushing data in to tulip table and not triggered from within Tulip.

The setup you refere to is to connect to external sources and request data.
By requesting you always know what you connect to, and I do use this function to connect to other systems when requesting data during Dev, Test and Prod.

We decide to use external database to use 2 environments instead of tables due to the fact to have same table for all environnements. Have tables by environments with version Control (same as connector) can be great to think again use table at scale.

Thank you for your info.

So this means that Tulip does not support test environment and a deployment process from e.g. Test to Production!

I will go for your solution @youri.regnaud , and if data from test environment should be needed in Prod I will export/import via csv.

Edit:
We use Boomi as middleware and whatever is set up in dev/test will be deployed to prod when approved. This inlcudes mapping to table and table fields.
If I set up an external table this needs to have the same unique IDs as the Tulip prod table.
It is only the base URL that is changed between dev/test/prod.

In Tulip we can not set the unique tabel IDs. Is that possible in other DB systems?