Some remarks:
Within DB2 you can run "export " using a select statement, you can also join the tables, use a view if needed. You export to a delimited file (choose "schema-name.table/view-name" as filename) Recently I exported data from SQLserver database, same approach, BUT check the character set db2, check if you have unexpected values in fields ( I had \n in Varchars), even in key fields. Decide how you want show NULL values in the generated XML (as NULL is not the same as empty) Then use mlcp to load these delimited files into marklogic. (column header will become the element name). Let MLCP generate the "collection = filename" I converted my SQLserver tables (100th) and 20M rows into marklogic, using the above, and loaded these within 1 hour. Depending on the rows, and forests, you might want to disable the 'balance option' Van: [email protected] [mailto:[email protected]] Namens Manoj Viswanadha Verzonden: woensdag 1 februari 2017 16:09 Aan: [email protected] Onderwerp: [MarkLogic Dev General] How to load data from DB2 RDBMS to Marklogic Hi Team, I have a requirement to load the data from DB2 into Marklogic server. I need to do data modelling with table data in DB2 to xml files and load in Marklogic. Please suggest me how i can achieve this. Thanks in advance. Thanks Manoj Viswanadha Sr. Marklogic Developer <https://mail2.v2soft.com/WorldClient.dll?Session=IEPECM0MKBZ2L&View=Attachm ent&Number=3&Part=2> +91-80-4082-6800 Extn: 3460 <https://mail2.v2soft.com/WorldClient.dll?Session=IEPECM0MKBZ2L&View=Attachm ent&Number=3&Part=3> <http://www.facebook.com/v2soft> V2Soft Pvt. Ltd <https://mail2.v2soft.com/WorldClient.dll?Session=IEPECM0MKBZ2L&View=Attachm ent&Number=3&Part=5> 9989370776 <http://www.twitter.com/v2soft> No. 55 Divyasree Towers, 5th Floor <https://mail2.v2soft.com/WorldClient.dll?Session=IEPECM0MKBZ2L&View=Attachm ent&Number=3&Part=7> [email protected] <javascript:top.$WC.parent.openWin('%2FWorldClient.dll%3FSession%3DIEPECM0MK BZ2L%26View%3DCompose%26New%3DYes%26To%3Dbvenkatesan%2540v2soft.com','Compos e',800,600,'yes');> <https://www.linkedin.com/company/v2soft> Bannerghatta Main Road, <https://mail2.v2soft.com/WorldClient.dll?Session=IEPECM0MKBZ2L&View=Attachm ent&Number=3&Part=9> www.v2soft.com <http://www.v2soft.com/> Bangalore 560 076 Karnataka, India ____________________________________________________________________________ _________ Global Offices: US | India | China | Germany | Italy | Mexico ____________________________________________________________________________ _________ <https://mail2.v2soft.com/WorldClient.dll?Session=IEPECM0MKBZ2L&View=Attachm ent&Number=3&Part=10> <https://mail2.v2soft.com/WorldClient.dll?Session=IEPECM0MKBZ2L&View=Attachm ent&Number=3&Part=11> <https://mail2.v2soft.com/WorldClient.dll?Session=IEPECM0MKBZ2L&View=Attachm ent&Number=3&Part=12>
_______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
