{"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":"User data from an SQL database can be synchronized via the ","type":"text"},{"text":"SqlSyncSource","type":"text","marks":[{"type":"code"}]},{"text":". The connection is established via the ","type":"text"},{"text":"ConnectionString","type":"text","marks":[{"type":"code"}]},{"text":" element, which can also be stored ","type":"text"},{"text":"encrypted","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"The following database types are supported via the ","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":"The query is defined using the ","type":"text"},{"text":"Query","type":"text","marks":[{"type":"code"}]},{"text":" element. The ","type":"text"},{"text":"queryKey","type":"text","marks":[{"type":"code"}]},{"text":" is required as a parameter. The syntax in the ","type":"text"},{"text":"Query","type":"text","marks":[{"type":"code"}]},{"text":" element must correspond to the SQL database system:","type":"text"}]},{"type":"paragraph","content":[{"text":"Example: 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":"Mapping","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/PDTEN/pages/61410858"}}]},{"text":" is supported as well.","type":"text"}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Configuration","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