Skip to main content
Solved

Mapping Saving

  • November 27, 2020
  • 4 replies
  • 41 views

where the mappings saved in timextender??

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

Best answer by Thomas Lind

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.
 

 

View original
Did this topic help you find an answer to your question?

4 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • November 27, 2020

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
  • Starter
  • 2 replies
  • November 27, 2020

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??


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • Answer
  • November 27, 2020

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.
 

 


  • Author
  • Starter
  • 2 replies
  • November 27, 2020

yes got it. Thanks Thomas


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings