sqlpower / power-architect Goto Github PK

View Code? Open in Web Editor NEW

169.0 169.0 64.0 221.7 MB

Automatically exported from code.google.com/p/power-architect

License: GNU General Public License v3.0

Batchfile 0.02% Java 47.06% XSLT 0.79% CSS 0.01% HTML 51.90% R 0.16% Makefile 0.01% Shell 0.05%

power-architect's People

Contributors

Stargazers

Watchers

power-architect's Issues

File Save appears to forget the first time a file is opened

1. Open a Power Architect file.
2. Click Save (not Save As)
3. It prompts you for a location.

I think that if you just click "Save" it shouldn't ask you for a file location.

Original issue reported on code.google.com by [email protected] on 22 Oct 2007 at 8:23

Architect should be able to write to a Kettle file based repository

When generating Kettle jobs, Architect has the option to write the files to a database repository or to the file system. There should also be an option to save the Kettle files to a file based repository.

Unusable on Windows 10 with 4K Display

Just Installed Lastest Version and lines in left menu tree are vertically overlapping, making the app unusable. The icons on the right of the UI are too small as well. Attaching screenshot here.

Maximized to full screen it looks like this:

Cannot delete Index

When I try to delete an index on a table in the tree view I get the following error message :

No items to delete!

Website down: sqlpower.ca has an invalid SSL certificate and error 400

Dead Project ?

Hello is it a dead project ?

Improve support to mondrian schema : view as sql code

What steps will reproduce the problem?
Power-architect will be a very good mondrian schema designer when we can 
create, and manage view 

as that

<Dimension name="ProductFood" primaryKey="product_id" primaryKeyTable="product">

                      <Hierarchy hasAll="true" allMemberName="All Products" primaryKey="product_id">

                        <View alias="Product">

                          <SQL dialect="generic">

                            select 

                                  pc.product_family as product_family,

                                  p.product_id as product_id,

                                  p.product_name as product_name,

                                  p.brand_name as brand_name,

                                  pc.product_subcategory as product_subcategory,

                                  pc.product_category as product_category,

                                  pc.product_department as product_department

                            from 

                                  product as p, product_class as pc

                            where 

                                  p.product_class_id = pc.product_class_id

                                  and pc.product_family = 'food'
                          </SQL>

                        </View>

                        <Level name="Product Family" column="product_family" uniqueMembers="false"/>

                        <Level name="Product Department" column="product_department" uniqueMembers="false"/>

                        <Level name="Product Category" column="product_category" uniqueMembers="false"/>

                        <Level name="Product Subcategory" column="product_subcategory" uniqueMembers="false"/>

                        <Level name="Brand Name" column="brand_name" uniqueMembers="false"/>

                        <Level name="Product Name" column="product_name" uniqueMembers="true"/>

                      </Hierarchy>

                    </Dimension>

Original issue reported on code.google.com by [email protected] on 22 Aug 2010 at 9:36

Ability to turn on & off the info displayed for table in playpen

This is more of an enhancement

It would be nice if these features can be added.
Show/hide 
1. Columns 
2. Column Data Types

Also if Remarks on a table, relationship link if can be shown on the 
playpen it would be nice. That would enable to describe on the roles that 
a table plays in a relation or any implementation notes that developers 
can share between them

Original issue reported on code.google.com by [email protected] on 23 Apr 2008 at 11:12

Please read this before posting a bug

Hi!

Thanks for your interest in filing a bug report or enhancement request
against the Power*Architect.

We don't currently use this issue tracker provided by Google Code
Hosting--we have our own issue tracker that we've been using since before
moving the Architect here. You can access it at:

http://trillian.sqlpower.ca/bugzilla/

We also have a user support forum, which you can access at:

http://www.sqlpower.ca/forum

Once again, please don't post bugs here. We do not monitor this issue
tracker. Use one of the above resources instead.

-Jonathan

Original issue reported on code.google.com by [email protected] on 29 Jul 2008 at 9:07

Split the kettle job into multiple inner job

The issue was reported earlier in bugzilla with bug id: Bug 3172

Kettle Job won't execute - Java Heap space exception

To resolve the issue 3172decision was made to break big kettle job in batch.

The solution committed in comfit # 7403975

MySQL indexes not created

What steps will reproduce the problem?
1. Create a model
2. Sync the model with the MySQL database
3. Add an index
4. Use tools compare DM to update the database to the most recent model

What is the expected output? What do you see instead?
I would expect a create index statement, however the compare DM tool reports no 
differences


What version of the product are you using? On what operating system?
1.0.7 on OSX 10.9.4

Please provide any additional information below.
Using MySQL 5.5.21

Original issue reported on code.google.com by [email protected] on 21 Aug 2014 at 10:08

Issue in transformation job. Unable to find [JOIN_KEY] field in a reference stream.

This issue occurred due to not specifying the [JOIN_KEY] in a Select statement.
Transformation generated from Architect doesn't include a join key in a Select statement.

Remote DB Table/s refresh

What is the expected output? What do you see instead?
I can't find a way to update remote database table structure.

What version of the product are you using? On what operating system?
0.9.10 on Leopard OSX

Please provide any additional information below.
If I create a db connection (to MySQL in my case), and then I edit tables via 
Power Architect 
submitting new fields/tables via Compare tool, I don't get remote structure 
updated.
Same problem if I update something on DB not via Power Architect, it doesn't 
see any modification 
and the only way is creating a new project reimporting all data in the new 
project.

Original issue reported on code.google.com by [email protected] on 29 May 2008 at 1:23

Enhance for Java8

Update the project for Java8

olap designer, create normal dimension, not only shared

It will be very interessting to allow the creation and the manipulation of 
normal dimension. That is to say dimension directly available in a cube. Fow 
now only shared dimension is supported.

Best regards.

Original issue reported on code.google.com by [email protected] on 22 Aug 2010 at 9:41

SQL Server Description fields are not imported

What steps will reproduce the problem?
1. connect to a SQL Server Database
2. create a table and document its fields using MS SQL Server Management Studio 
(via the Description Field)
3. import the table into SQL Power Architect

What is the expected output? What do you see instead?

The column descriptions should be imported as "remarks". Instead there are no 
remarks imported but everything is empty.

What version of the product are you using? On what operating system?

MS Sql server 2008 R2 on Windows, SQL Power Architect on Mac OSX 10.8 (dont 
think it matters though).

Please provide any additional information below.

Original issue reported on code.google.com by [email protected] on 26 Jul 2013 at 4:43

Save the Transformation output to different type like 'Insert/Update'.

This is a new requirement to export the transformation job which allow to save the out put to a different types like "Output Table or "Insert/Update'.
Currently Architect by default save the transformation output to the 'Table output' type.

Need to add an option to select the different type of out put for transformation job.

Data Model List

What steps will reproduce the problem?
1. Create a new project 
2. Connect to a database
3. Import tables from a database to the new model

What is the expected output? What do you see instead?
Would be interesting a ordering option in the Data Model List, so we could 
order the tables that was imported by name for example.

For me the order of the list is the one that the table was imported 

What version of the product are you using? On what operating system?
SQL-Power-Architect-Setup-Windows-jdbc-1.0.6

Please provide any additional information below.

Original issue reported on code.google.com by [email protected] on 16 Nov 2011 at 10:52

Add sort step before a MergeJoin step in a generated transformation of a kettle job.

Kettle job generated from Architect when open in Petaho it gives message to add sort before merge join for both tables.
So before merge join sorting of incoming rows is required to produce proper output result, In auto generated kettle transformation sorting is not performed

PROBLEM ON DESIGN WITH POSTGRESQL 9.X , dont support data type "text"

What steps will reproduce the problem?

I have a connection with POSTGRESQL and database with tables, and many tables 
have on data type   = "TEXT"

So if I

1. Open design table
2. Sayme Choose a type for xcolumn, but I dont want change data type, because 
postgresql 9.1 support type text.


What is the expected output? What do you see instead?

Open design table with type "TEXT"

What version of the product are you using? On what operating system?
1.06

Original issue reported on code.google.com by [email protected] on 15 Aug 2012 at 2:06

In Pentaho transformation generated from Architect in some cases, The initial step(Table input) includes the target table as well

In Pentaho transformation generated from Architect in some cases, The initial step(Table input) includes the target table as well.
i.e. It include target(output) table as an Input table.

Architect doesn't show up reporting schema for XBRL_DM_PX_PROD database

When create a database(SQL Server) connection in Architect with specific data base which has a tables start with reporting and dbo.
Table start with dbo imported but the table start with reporting doesn't import to database connection tree.

java.lang.IllegalArgumentException while trying to drop table ( OE.Action_Table) into PlayPen

What steps will reproduce the problem?
1. Launch test_environment database
2. explore OE schema
3. select & drop ACTION_TABLE

it draw Action_Table into playpen with following error message.

java.lang.IllegalArgumentException: Table ACTION_TABLE is not in this rowset
    at ca.sqlpower.sql.jdbcwrapper.IndexedCachedRowSet.extractSingleTable(IndexedCachedRowSet.java:87)
    at ca.sqlpower.sql.jdbcwrapper.OracleDatabaseMetaDataDecorator.getColumns(OracleDatabaseMetaDataDecorator.java:661)
    at ca.sqlpower.sqlobject.SQLColumn.fetchColumnsForTable(SQLColumn.java:482)
    at ca.sqlpower.sqlobject.SQLTable.populateAllColumns(SQLTable.java:407)
    at ca.sqlpower.sqlobject.SQLTable.populateColumns(SQLTable.java:365)
    at ca.sqlpower.sqlobject.SQLTable.populateImpl(SQLTable.java:1335)
    at ca.sqlpower.sqlobject.SQLObject.populate(SQLObject.java:186)
    at ca.sqlpower.sqlobject.SQLTable.getChildren(SQLTable.java:1963)
    at ca.sqlpower.sqlobject.SQLObject.getChildren(SQLObject.java:285)
    at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.ensurePopulated(PlayPen.java:1577)
    at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.doStuff(PlayPen.java:1552)
    at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)
    at java.lang.Thread.run(Thread.java:680)



Please use labels and text to provide additional information.

Original issue reported on code.google.com by [email protected] on 16 May 2013 at 9:03

NullPointerException while trying to drag a table into PlayPen

What steps will reproduce the problem?
1. Launch architect from Eclipse
2. Load test environment connection 
3. select HR database
4. select either Employees or Location table

What is the expected output? What do you see instead?
The expected out out is Employees or Location table is in PlayPen. But instead 
it displays 'NullPointerException' as below:

java.lang.RuntimeException: java.lang.RuntimeException: 
java.lang.NullPointerException
    at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.cleanup(PlayPen.java:1700)
    at ca.sqlpower.swingui.SPSwingWorker$1.run(SPSwingWorker.java:114)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:702)
    at java.awt.EventQueue.access$400(EventQueue.java:82)
    at java.awt.EventQueue$2.run(EventQueue.java:663)
    at java.awt.EventQueue$2.run(EventQueue.java:661)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:672)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.lang.RuntimeException: java.lang.NullPointerException
    at ca.sqlpower.sqlobject.SQLTable.populateRelationshipsWithList(SQLTable.java:820)
    at ca.sqlpower.sqlobject.SQLTable$5.run(SQLTable.java:737)
    at ca.sqlpower.architect.swingui.ArchitectSwingSessionImpl.runInForeground(ArchitectSwingSessionImpl.java:1166)
    at ca.sqlpower.object.AbstractSPObject.runInForeground(AbstractSPObject.java:669)
    at ca.sqlpower.sqlobject.SQLTable.populateRelationships(SQLTable.java:732)
    at ca.sqlpower.sqlobject.SQLTable.createTableFromSource(SQLTable.java:300)
    at ca.sqlpower.sqlobject.SQLTable.createInheritingInstance(SQLTable.java:287)
    at ca.sqlpower.architect.swingui.PlayPen.importTableCopy(PlayPen.java:1258)
    at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.cleanup(PlayPen.java:1621)
    ... 15 more
Caused by: java.lang.NullPointerException
    at ca.sqlpower.sqlobject.SQLRelationship.attachRelationship(SQLRelationship.java:578)
    at ca.sqlpower.sqlobject.SQLRelationship.attachRelationship(SQLRelationship.java:531)
    at ca.sqlpower.sqlobject.SQLTable.populateRelationshipsWithList(SQLTable.java:796)
    ... 23 more
19341 [AWT-EventQueue-0] ERROR ca.sqlpower.swingui.SPSUtils  - dialog parent 
component null is neither JFrame nor JDialog

Original issue reported on code.google.com by [email protected] on 9 Apr 2013 at 5:57

Split the big kettle job in multiple jobs by selecting desired tables for each job.

This is an enhancement to split the job into multiple jobs by selecting the table for each sub job.
So the output of kettle job will have a job with a multiple jobs inside it.

Window is too small to choose DB and table and its columns for mapping.

Steps to recreate issue.

create a new Table from right panel or use existing table from you playpen
add new column.
right click on column > select Column Properties
Click on 'source for ETL mapping"
This will display drop down, which is populated for data base that you have in your project.

This populated dropdown's width is less. you have to use scroll to select the any column. Its little hard and not user friendly.

Requirements:
width of dropdown needs to increase.

Pentaho job creation does not store database connection name in connection settings

I tried creating a Kettle job with Architect. Architect did not save the database name in the Kettle connection settings. (Kettle has been renamed to Penaho Data Integration, PDI)

How to reproduce:

Create new project in Power Architect
Create source connection
Create target connection
Drag one table from source to playpen
Verify ETL mapping for one of the columns
Go to ETL -> Create Kettle job
Save Kettle job to file
Open Kettle transformation in Pentaho Data Integration
Open the database connections for source and target
Both connections miss the database name

Issue related to export merge join keys to exported kettle job.

Steps to recreate the issue

Connect two different database connections (one for source database and second for target database)
Drag any 2 tables(tables which are related i.e. have SQLRelationship)from source database connection to playpen.
If tables are not related setup relationship using button to create a RelationShip from left panel.
Create a new table from the button from the left panel.
Create columns (as per requirements) (e.g at least 2 or 3 new columns)

Right click on newly created column and select "Column Properties.." option and click on "source for ETL mapping" button" to map form source tables in your playpen.

Make sure that the new column must have the same datatype as the mapped column.
Click on ETL > Create Kettle Job option in menu.
Select Target Database
Select 'Save a job to File' option and specify the path where you want to save the job. and click on OK.

This will create the kettle job at specified location.

Go to Pentaho open the job that you just created.

Right click on your output table( e.g std_detail2) click on 'Open Referenced Object' > 'Transformation;

This will open Transformation for your output table (e.g std_detail2). double click on merge join as shown in below image.

You will see Kets for step1 and 'keys for step2' missing.

The expected behaviour should be:
Keys for 1st step should be the (primary key from your First Step ( e.g Student Table)
Keys for 2nd step should be the (Foreign key from your second Step ( e.g address2Table)

Expected output should be as below:

When a new column is added to a table, in the play pen the scale value is 
displayed for all types. 

It would be nice if 
1. Precision is alone displayed for character types
2. For int types none of precision or scale are displayed. 
3. For numeric types both the precision and scale are displayed 

Version being used: 0.9.10

Original issue reported on code.google.com by [email protected] on 23 Apr 2008 at 11:08

Need true "alter" script style for forward databases

So far, I can only "forward a database" by recreating it. Would be nice if 
possible to just apply the changes to existing schema.

For example, if user rename a column, when generating forward script, if the 
column already exists in the old name, then it shall provide the 

alter table XXXX rename column YYYY to PPPP

etc.

Regards,

Edson

Original issue reported on code.google.com by [email protected] on 6 May 2014 at 11:02

sqlpower / power-architect Goto Github PK

power-architect's People

Contributors

Stargazers

Watchers

Forkers

power-architect's Issues

Recommend Projects

Recommend Topics

Recommend Org