ETL and Data Integration tools - Modern ETL software for everyone

Is there a possibility that a connection to SQL CE databases is on your roadmap?

Well...

This complicated question.

There no odbc driver for it
Ole DB driver sort of exists but it is not enabled by default
The reason that SQL Server Compact 3.5 OLEDB provider is not enabled is that it does not conform completely to the OLEDB standard.

It can be enabled by modifying registry

I was able to enable it on win 32 but not win64.

I personally will not recommend using it

Mike

Thanks.

At the moment if I want to get a data in a SQL CE sdf file I have to attach the sdf to a MSSQL database instance using Management Studio. This usually requires conversion from CE3 to CE3.5. From there I can transfer data to a regular MSSQL DB and integrate with ETL Processor. I was looking for a method like your support for SQLite instead so that I could avoid the manual steps outlined above.

This should enable Ole DB Provider

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{F49C559D-E9E5-467C-8C18-3326AAE4EBCC}\OLE DB Provider]
@="SQL CE OleDB Provider"

Than you should be able to pull data via OLE DB connection

you would need to type select * from your table because the drive is not able to return the list of tables

social.msdn.microsoft.com/Forums/en/sqlc...69-a573-b58ad10595e5

Mike

Just letting you know that we have just introduced support for SQL Server compact edition in database browser
Can you check it with your database please,

Advanced ETL processor and Visual Importer ETL will follow.
(2-3 weeks)

Mike

Does this show up as a node in the connections container the same way the SQLite node does?