{"type":"doc","content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"Introduction","type":"text"}]},{"type":"paragraph","content":[{"text":"The OleDbConnection Data Provider allows you to import Core Identities all available entities over a OleDbConnection. Such a connection can be used to access various sources such as CSV files and others.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Connection Info","type":"text"}]},{"type":"paragraph","content":[{"text":"For all entity parts you need to specify the connection information which contains the following parameters.","type":"text"}]},{"type":"table","attrs":{"layout":"default","width":1800.0,"localId":"21760bbb-7c3e-4f51-987d-33700bf73821"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"Parameter","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"Mandatory","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"CustomConnectionString","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"2705","text":"✅","shortName":":white_check_mark:"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=\"{filepath}\";Extended Properties=\"Text;HDR=YES;FMT=Delimited\"","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"The OleDB Connection String","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"ParametersReadMode","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"2705","text":"✅","shortName":":white_check_mark:"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"SingleLineWithHeaderAsKey","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"The appropriate read mode ","type":"text"}]},{"type":"paragraph","content":[{"text":"SingleLineWithHeaderAsKey","type":"text","marks":[{"type":"code"}]},{"text":",","type":"text"},{"type":"hardBreak"},{"text":"MultiLineKeyValue","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"GetForeignIdsCommand","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"2705","text":"✅","shortName":":white_check_mark:"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"select [unit] from [{csvFilename}]","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"A Ole DB conform query to select all foreign ids","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"GetParametersByForeignIdCommand","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"2705","text":"✅","shortName":":white_check_mark:"}},{"text":" ","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"SELECT [unit] FROM [{csvFilename}] WHERE [unit] = '{{0}}'","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[190.0]},"content":[{"type":"paragraph","content":[{"text":"A Ole DB conform query to select all needed properties of a given entitz","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Sample configuration","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Git\\Moving\\CustomerProjects\\DEV\\DEV.Import.Test\\OleDbTestData;Extended Properties=\"Text;HDR=YES;Format=Delimited(;);characterset=65001\"\n\nSELECT [description] FROM [orgUnits.csv] WHERE [id] = '{0}'\nSingleLineWithHeaderAsKey\nSELECT [id] FROM [orgUnits.csv]","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Example files","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Core Identities","type":"text"}]},{"type":"codeBlock","content":[{"text":"email;id;first_name;last_name;manager_short_name;short_name;valid_from;language;meal\nww@ww.ww;ci1222;Wiww;Waww;wiwa;Wiwaww;01-01-2010;22;28\nnn@mm.ll;ci7787;Tes;Ter;wiwa;Tetetete;01-01-2010;22;29","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Employments","type":"text"}]},{"type":"codeBlock","content":[{"text":"id;ciid;valid_from;valid_to;meal;address;e_number\ne23232;ci1222;01-01-2010;01-01-2030;28;testAddress2;1001","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Organization Units","type":"text"}]},{"type":"codeBlock","content":[{"text":"id;name;parent_id;description\norg1;Glorious Enterprise CSV-Maniac;;Small company that processes a lot of CSVs\norg2;Ride-a-taxi-with-CSV;;Great taxi service with comma separated vehicles\norg3;Pierogi u babuszki;;Babuszka i pierogi, złap życie za rogi!\norg4;沒人知道;;\norg5;Parent;;This is parent\norg6;Child;org5;And this is child","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Schema.ini","type":"text"}]},{"type":"paragraph","content":[{"text":"Note that you have to configure the schema.ini in the directory where the files are stored. A complete how-to can be found here:","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineCard","attrs":{"url":"https://itsense.atlassian.net/wiki/x/GgDyQ"}},{"text":" ","type":"text"}]}],"version":1}

Browser not supported