ETL and Data Integration tools - Modern ETL software for everyone

This is a pretty cool program.

I have written my own query tool but does not have some of the features this has. One such item is the table view - very cool. Another is the field grouping - that is awesome.

Some items that would be nice to have:

In the SQL editor, can have multiple SQLs. To run a section of SQL, highlight that section and run. In other words, if SQL text is highlighted, then run execute what is highlighted, otherwise execute all the SQL text.

Another item would be able to export to Excel without saving. In the program I created, every time I export, it goes to a new tab (without saving).

My final suggestion (and maybe this already exists) - is a way to force fetching all records.
Or an indication when all records have been fetched. Seems to be slow. When scrolling, the scrollable area keeps growing. Need to be able to jump to the end. If I hit preview, then this accomplishes this.

1. In the SQL editor, can have multiple SQLs. To run a section of SQL, highlight that section and run. In other words, if SQL text is highlighted, then run execute what is highlighted, otherwise execute all the SQL text.

We will have a look at this one for you

2 Another item would be able to export to Excel without saving. In the program I created, every time I export, it goes to a new tab (without saving).

So it opens excel creates new tab and inserts data into this tab?

3. My final suggestion (and maybe this already exists) - is a way to force fetching all records.
Or an indication when all records have been fetched. Seems to be slow. When scrolling, the scrollable area keeps growing. Need to be able to jump to the end. If I hit preview, then this accomplishes this.

I think if you click ctrl + end it should fetch everything

We used to fetch everything by default but it was making application work very slow so we disabled it.

Mike

2. Actually for the Excel, if it does not have the reference to Excel, it creates a new Workbook. Then with each export, it uses existing tabs (Sheet1, Sheet2, Sheet3). If it gets past the number of sheets in the workbook then it adds a new sheet (to the end). Also, it changes the tab color (to green).

Other things: apply a freeze after the first row, apply filters, gray the header.

Some code similar to VBA code below:

Private Sub SheetFomat()
Dim wb As Excel.Workbook
Dim ws As Excel.Worksheet
Dim r1 As Range

Set ws = Me 'For example purposes, I placed this code in a Sheet Object

Set r1 = ws.Cells(1, 1).CurrentRegion
Set r1 = r1.Resize(1, r1.Columns.Count)
r1.AutoFilter
ws.Columns.AutoFit
r1.Replace " ", Chr(10)
ws.Columns.AutoFit
r1.Replace Chr(10), " "
r1.Interior.Color = "&HC0C0C0"
ws.Activate
ws.Cells(2, 1).Select
ActiveWindow.FreezePanes = True
ws.Tab.Color = vbGreen
End Sub

3. The CTRL END works (so does CTRL HOME).

Thanks

Hello

We have implemented some of your suggestions

www.dbsoftlab.com/dmdocuments/DatabaseBr...3.2.2.15_English.paf

Exports Data directly into Excel (via ole)
Works correctly with mixed case objects in PostgreSQL
Executes selected SQL

Mike