ETL and Data Integration tools - Modern ETL software for everyone

Hello

I have just updated Advanced ETL processor Pro to the latest version.
The user manual is saying that AETL support SQLite and MS SQL Server CE
However I am not able to create these connections.

Awaiting your suggestions,
Adrian

You can create new repository using wizard provided or
just upgrade the repository by running following SQL against your repository

INSERT INTO OBJECT_TYPES (OBJECT_TYPE,OBJECT_TYPE_NAME)
VALUES (348,'SQLite')
GO
INSERT INTO OBJECT_TYPES (OBJECT_TYPE,OBJECT_TYPE_NAME)
VALUES (349,'SQLite Connection')
GO
Insert into OBJECTS_TREE
(OBJECT_ID,PARENT_ID,NAME,OBJECT_TYPE)
Select
-OBJECTS_TREE.OBJECT_ID as OBJECT_ID,
OBJECTS_TREE.OBJECT_ID as PARENT_ID,
'SQLite' as NAME,
348 as OBJECT_TYPE
From
OBJECTS_TREE
Where
OBJECTS_TREE.OBJECT_TYPE = 300
GO

INSERT INTO OBJECT_TYPES (OBJECT_TYPE,OBJECT_TYPE_NAME)
VALUES (322,'MS SQL Server CE Connections')
GO
INSERT INTO OBJECT_TYPES (OBJECT_TYPE,OBJECT_TYPE_NAME)
VALUES (323,'MS SQL Server CE Connection')
GO
Insert into OBJECTS_TREE
(OBJECT_ID,PARENT_ID,NAME,OBJECT_TYPE)
Select
-OBJECTS_TREE.OBJECT_ID+1 as OBJECT_ID,
OBJECTS_TREE.OBJECT_ID as PARENT_ID,
'MS SQL Server CE' as NAME,
322 as OBJECT_TYPE
From
OBJECTS_TREE
Where
OBJECTS_TREE.OBJECT_TYPE = 300
GO

Peter