Help with Dsource CLI in Powershell

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered

   I have looked through the CLI cookbook, but it seems to be out of date.  I am trying to stand up a dsource via powershell using the following:
  1. Invoke-SSHCommand -SessionId 16 -Command "/database;
  2. link;
  3. set name=""Jefftest"";
  4. set group=""Jefftest"";
  5. set description=""TEST"";
  6. set linkData.type=MSSqlLinkData;
  7. set linkData.config=""DevTest"";
  8. set linkData.dbUser=""SVC-DPXSQL"";
  9. set linkData.dbCredentials.type=PasswordCredential;
  10. set linkData.dbCredentials.password=""Passwordhere"";
  11. set linkData.pptRepository=""/MSSQLSERVER"";
  12. set linkData.syncParameters.type=MSSqlExistingMostRecentBackupSyncParameters;
  13. set linkData.ingestionStrategy.type=DelphixManagedBackupIngestionStrategy;
  14. set linkData.sharedBackupLocations=""\\backups\"";
  15. commit;"

I get the following error 
Output     : {The following validation errors are present:, ,     linkData.syncParameters The field "{0}" is required., ...}
ExitStatus : 1

I have included what i think is needed on line 12.  Anyone have any ideas?

Photo of Jeff Zieleniuk

Jeff Zieleniuk

  • 82 Points 75 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Photo of Jatinder Luthra

Jatinder Luthra, Employee

  • 3,058 Points 3k badge 2x thumb
Hello Jeff,
              Are you familiar with dxtoolkit, ?

DxToolkit script dx_ctl_dsource can help you create MSSQL dSources without any external development.

Photo of Neal Stack

Neal Stack, Employee

  • 3,422 Points 3k badge 2x thumb
Official Response

I will file a documentation bug for this. There is already a low priority product bug for this. To get past this error you would need to fake a change like this:

unset linkData.syncParameters;edit linkData.syncParameters; back


Photo of Jeff Zieleniuk

Jeff Zieleniuk

  • 82 Points 75 badge 2x thumb
That did the trick.  Thank you.  Is there a more up to data source of CLI example somewhere?  The examples are pretty far off in some cases.