Skip to main content
Question

Mapping Saving

  • Nov 27, 2020 4:58 AM UTC
  • 4 replies
  • 5 views

where the mappings saved in timextender??

Is there any chance to store the Mapping details in SQL Server?

4 replies

Forum|alt.badge.img
  • Community Manager
  • Nov 27, 2020 7:57 AM UTC

Hi Venkata

All info about the project is stored in the repository.

What do you need the info for?

We have a TX Dictionary project you can download from the cubestore that can be used to get info about your repository.


  • Author
  • New Participant
  • Nov 27, 2020 9:18 AM UTC

we are using 2 Sql server databases. In Timextender we call through those databases using business units & Demo as project repository. So what are given the mapping between those tables . is this mappings created in which place?? Is it created in sql server Or only in cube store?? We are not using anu cube store.

Where the mapping saved for migration??


Forum|alt.badge.img
  • Community Manager
  • Nov 27, 2020 10:04 AM UTC

It is all stored in the repository database you create when you start developing an project.

If you decide to export a project all this info will now be stored in an XML document that you can import to another repository.

So you can look at the repository database in SQL Management Studio and see what tables and such it contains. Don't delete or rename anything in there though, as you can make your projects stop working.

I have copied an image from my DWH Incremental load guide that shows an query that shows the mappings.
l_f9nAvmlsvtMFuSraCcBA.png


  • Author
  • New Participant
  • Nov 27, 2020 10:11 AM UTC

yes got it. Thanks Thomas