import data from another SQL server database
Hi David,
Do you think it would be possible or do you see any issue if we import data from another SQL server database and input this information into the RDM database? We have another application we are using that already tracks customer and asset information using a SQL Server database. A lot of this information is the same information you provide fields for in RDM. If we could import this into RDM then we could consolidate most of this information into one application. I am thinking this would be done on the SQL Server level just populating the tables which would then be available when you open RDM.
Thanks,
Larry
All Comments (6)
Hi,
I don't see any problem as long as you write the Xml correctly. RDM save most of his information in an Xml structure. the next version will support Powershell, maybe you could synchronize it with our CmdLet?
David Hervieux
Hi
We are now facing the same question. We want to import data from another SQL database. The goal would be to import automatically once a week.
We were wondering if there is a function to do so? Or to use an addon or something like that?
Maybe there is an interface for this? Or a workaround?
Kind regards
Steffi
Hello,
@Stefanie, is it another SQL database created with RDM?
If so, you could use the PowerShell cmdlets to create a script to import them automatically.
Best regards,
Érica Poirier
I think that the only way to make sure that everything is good it's by using our PowerShell.
Regards
David Hervieux
Hi Erica
No it isn't a database created with RDM. We want to Import data from our CRM (navision) directly into RDM.
Hello,
The RDM PowerShell module could be helpful to create new entries in RDM from your data.
If you can generate .CSV file from your CRM, you can also use the CSV Synchronizer to automatically import the information into RDM.
Here is online help page about CSV file format to import the data in RDM.
Best regards,
Érica Poirier