{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"4f4e0431-4c49-4d0c-b498-c8aff67d8ee8"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"1de37421-2b6e-4b17-ab1e-6d1e1aed5636"}},{"type":"rule"},{"type":"paragraph","content":[{"text":"Benutzerdaten aus einer SQL-Datenbank können über die ","type":"text"},{"text":"SqlSyncSource","type":"text","marks":[{"type":"code"}]},{"text":" synchronisiert werden. Die Verbindung wird über das ","type":"text"},{"text":"ConnectionString","type":"text","marks":[{"type":"code"}]},{"text":"-Element aufgebaut, welche auch ","type":"text"},{"text":"verschlüsselt","type":"text","marks":[{"type":"strong"}]},{"text":" abgelegt werden kann.","type":"text"}]},{"type":"paragraph","content":[{"text":"Unterstützt werden folgende Datenbank Typen über das ","type":"text"},{"text":"ConnectionProvider","type":"text","marks":[{"type":"code"}]},{"text":"-Element:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"System.Data.Odbc","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"System.Data.SqlClient","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"MySql.Data.MySqlClient","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Oracle.ManagedDataAccess.Client","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Die Abfrage wird über das ","type":"text"},{"text":"Query","type":"text","marks":[{"type":"code"}]},{"text":"-Element definiert. Als Parameter wird der ","type":"text"},{"text":"queryKey","type":"text","marks":[{"type":"code"}]},{"text":" benötigt. Der Syntax im ","type":"text"},{"text":"Query","type":"text","marks":[{"type":"code"}]},{"text":"-Element muss dem SQL Datenbanksystem entsprechen:","type":"text"}]},{"type":"paragraph","content":[{"text":"Beispiel: MS SQL","type":"text","marks":[{"type":"strong"},{"type":"em"}]}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"SELECT FirstName, LastName FROM Users WHERE Email = @queryKey","type":"text"}]},{"type":"panel","attrs":{"panelType":"info"},"content":[{"type":"paragraph","content":[{"text":"Das ","type":"text"},{"text":"Mapping","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/PDT/pages/32571621"}}]},{"text":" wird ebenfalls unterstützt.","type":"text"}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Konfiguration","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\n \n Data Source=sqlserver.local;Initial Catalog=SampleData;User ID=user;Password=pw;Encrypt=False\n System.Data.SqlClient\n SELECT [givenname],[surname], [email] FROM [Table] WHERE UserId = @queryKey\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n","type":"text"}]},{"type":"paragraph"}],"version":1}

Browser not supported