Source
If you want to;
- Import / migrate data from an ODBC data source into a SharePoint list.
- Import / migrate documents / files to SharePoint where the meta data is held in an ODBC data source
- Import / migrate pages to SharePoint where the web page content is stored in an ODBC data source.
- Bulk create items in SharePoint from an ODBC data source
Then you can specify an ODBC data source.
Configuration
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<Source> <!-- The source used is ODBCSelect meaning that Import for SharePoint expects to run a SQL select statement against an ODBC data source. This will ignore columns like importstatus --> <SourceDataSetType>ODBCSelect</SourceDataSetType> <ODBCSourceDataSetSettings> <!-- So a system DSN has been created called WordPress, this has in fact been pointed to a MySQL database hosting WordPress --> <ConnectionString>DSN=WordPress;Uid=root;Pwd=password;</ConnectionString> </ODBCSourceDataSetSettings> <ODBCTableSourceDataSetSettings /> <ODBCSelectSourceDataSetSettings> <!-- The select statement to run to obtain the rows for import. This one actually gets all wordpress blog posts --> <SelectStatement>select *, concat(post_name,'.aspx') as DestinationFileName, replace(post_content,'\n','<br/>') as PageContent, 'True' as Publish from wp_posts where post_type = 'post' and post_status = 'publish'</SelectStatement> </ODBCSelectSourceDataSetSettings> </Source> |
Further Thoughts
The database behind the ODBC source could be;
- Oracle
- FoxPro
- Visual FoxPro
- MySQL
- MongoDB
- Postgre
- DataFlex
- Ingres
- Progress
- Sybase
- IBM DB2
- Azure Table
- JDBC
- Microsoft Dynamics
32 / 64 bit
To use a 32bit ODBC Driver you must be running 32bit Import for SharePoint
To use a 64bit ODBC Driver you must be running 32bit Import for SharePoint
Contact us if you are having problems.